FIN 370 Week 5 Assignment Precision Machines CASH BUDGET

 FIN 370 Week 5 Assignment   Precision Machines  CASH BUDGET

                Click Link Below To Buy:

http://hwcampus.com/shop/fin-370-week-5-assignment-precision-machines-cash-budget/

Contact Us:

Hwcoursehelp@gmail.com

Review the "Precision Machines" document and spreadsheet.

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

recision Machines
Student Note: Fill in the light yellow cells
Data:
November
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
Interest
Total Disbursements
Cash flows
Net cash flows
Cumulative cash flows
Minimum Cash Balance
Cash Surplus or (Deficit)

Recommendations:

December

January

February

March

April

May

June

$40,000.00

$50,000.00

$48,000.00

$55,000.00

$35,000.00

$50,000.00

$65,000.00

$40,000.00

November

December

January

February

March

April

May

June

6,000.00
3,000.00

6,000.00
3,500.00

6,000.00
3,000.00

6,000.00
3,200.00

6,000.00
3,500.00

6,000.00
3,000.00

10.00%
$5,000.00
$7,500.00

45,000.00
1,000.00

1,000.00