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