Question Details

(Solved) Given Purchases(%of Sales) Cash Collected(% of Sales) Cash Collecteds one month after sales Cash Collections two monthes after sales Salaries...


Hi, I need help with the assignment below. This is a team assignment and the only portion I need to write on is " explain two market forces that will impact the financial plan of this company".  Please include the references. I have attached the reading to complete this assignment as well as the cash budget. Thank you!


Review the "Precision Machines" document and spreadsheet.

Prepare a cash budget for Precision Machines in Microsoft® Excel®.

Create a 1,225-word strategic analysis and include the following:

  • Recommend a cash management strategy for the company that will minimize the financing cost and increase the cash flows for the company.
  • Explain two economic and market forces that will impact the financial plan of this company.
  • Format your documents consistent with APA guidelines.

Given
Purchases(%of Sales)
Cash Collected(% of Sales)
Cash Collecteds one month after sales
Cash Collections two monthes after sales
Salaries
Quarterly Dividends
Yearly Interest Rate
Minium Cash Balance
Other Expenditures 50%
30%
35%
35%
$6,000
$1,000
10%
$5,000
$45,000 Precision Machines
Student Note: Fill in the light yellow cells
Data:
Annual Cost of borrowing
Minimum Cash Balance
Beginning Cash Balance
Revenues (Sales) Cash Collections
First Month (30%)
Second Month (35%)
Third Month (35%)
Total Collections
Cash Disbursements
Material Purchases
Salaries
Wages
Other Expenses
Capital Expenditure
Dividends November December January February March April May $40,000.00 $50,000.00 $48,000.00 $55,000.00 $35,000.00 $50,000.00 $65,000.00 November
$12,000.00 December
$15,000.00
14,000.00 January
$14,400.00
14,000.00
17,500.00
$45,900.00 February
$16,500.00
17,500.00
16,800.00
$50,800.00 March
$10,500.00
16,800.00
19,250.00
$46,550.00 April
$15,000.00
19,250.00
12,250.00
$46,500.00 May
$19,500.00
12,250.00
17,500.00
$49,250.00 $25,000.00 $24,000.00
6,000.00
3,000.00 $27,500.00
6,000.00
3,500.00 $17,500.00
6,000.00
3,000.00 $25,000.00
6,000.00
3,200.00 $32,500.00
6,000.00
3,500.00 10.00%
$5,000.00
$7,500.00 45,000.00
1,000.00 Interest
Total Disbursements $33,000.00 $37,000.00 $72,500.00 4,500.00
$38,700.00 $42,000.00 Cash flows
Net cash flows
Cumulative cash flows
Minimum Cash Balance
Cash Surplus or (Deficit) $12,900.00
$36,400.00
$5,000.00
$12,895.00 $13,800.00 ($25,950.00)
$50,200.00 $24,250.00
$5,000.00
$5,000.00
$8,800.00 ($30,950.00) $7,800.00
$32,050.00
$5,000.00
$2,800.00 $7,250.00
$39,300.00
$5,000.00
$2,250.00 Recommendations: June $40,000.00 June
$12,000.00
17,500.00
22,750.00
$52,250.00 $20,000.00
6,000.00
3,000.00 1,000.00 $30,000.00 $22,250.00
$61,550.00
$5,000.00
$17,250.00

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $18

Solution~000200018934.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now