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/
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
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/
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...