Precision Machines*****Already A++ Rated Tutorial Use as Guide Paper*****
(Not rated)
(Not rated)
| Revenues (Sales) | $40,000.00 | $50,000.00 | $48,000.00 | $55,000.00 | $35,000.00 | $50,000.00 | $65,000.00 | $40,000.00 | ||
| Cash Collections | November | December | January | February | March | April | May | June | ||
| First Month (30%) | $12,000.00 | $15,000.00 | $14,400.00 | $16,500.00 | $10,500.00 | $15,000.00 | $19,500.00 | $12,000.00 | ||
| Second Month (35%) | 14,000.00 | 17,500.00 | 16,800.00 | 19,250.00 | 12,250.00 | 17,500.00 | 22,750.00 | |||
| Third Month (35%) | 14,000.00 | 17,500.00 | 16,800.00 | 19,250.00 | 12,250.00 | 17,500.00 | ||||
| Total Collections | $45,900.00 | $50,800.00 | $46,550.00 | $46,500.00 | $49,250.00 | $52,250.00 | ||||
| Cash Disbursements | ||||||||||
| Material Purchases | ||||||||||
| Salaries | 6,000.00 | 6,000.00 | 6,000.00 | 6,000.00 | 6,000.00 | 6,000.00 | ||||
| Wages | 3,000.00 | 3,500.00 | 3,000.00 | 3,200.00 | 3,500.00 | 3,000.00 | ||||
| Other Expenses | ||||||||||
| Capital Expenditure | 45,000.00 | |||||||||
| Dividends | 1,000.00 | 1,000.00 | ||||||||
| Interest | ||||||||||
| Total Disbursements | ||||||||||
| Cash flows | ||||||||||
| Net cash flows | ||||||||||
| Cumulative cash flows | ||||||||||
| Minimum Cash Balance | ||||||||||
| Cash Surplus or (Deficit) | ||||||||||
| Recommendations: | ||||||||||
9 years ago
Precision Machines*****Already A++ Rated Tutorial Use as Guide Paper*****
NOT RATED
Purchase the answer to view it
precision_machines.xls
