Please see my attachments that will explain the assignment
Precision 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