I need help finishing this financial statement. please finished highlighted areas

FIN/370 - Finance for Business John Wetherington Week Five Learning Team Assignment - Precision Machine Part 2 Aaron Tanley, Joshua Carpenter, Linda Tovar, Stanton Blonde 25-Jul-16 Precision Machines Student Note: Fill in the light yellow cells Data: 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: November December January February $40,000.00 $50,000.00 $48,000.00 $55,000.00 November $12,000.00 December $15,000.00 14,000.00 January $14,400.00 17,500.00 14,000.00 $45,900.00 February $16,500.00 16,800.00 17,500.00 $50,800.00 $20,000.00 $25,000.00 6,000.00 3,000.00 $24,000.00 6,000.00 3,500.00 $34,000.00 $33,500.00 10.00% $5,000.00 $7,500.00 March April May June $35,000.00 $50,000.00 $65,000.00 $40,000.00 March $10,500.00 19,250.00 16,800.00 $46,550.00 April $15,000.00 12,250.00 19,250.00 $46,500.00 May $19,500.00 17,500.00 12,250.00 $49,250.00 June $12,000.00 22,750.00 17,500.00 $52,250.00 $27,500.00 6,000.00 3,000.00 $17,500.00 6,000.00 3,200.00 $25,000.00 6,000.00 3,500.00 $32,500.00 6,000.00 3,000.00 45,000.00 1,000.00 $82,500.00 1,000.00 4,650.00 $31,350.00 $34,500.00 $42,500.00 Item # 1. 2. 3. 4. 5. 6. 7. 8. 9, 10. 11. 12. Section Cash Collections Cash Collections Cash Collections Cash Collections Cash Disbursements Cash Disbursements Cash Disbursements Cash flows Cash flows Cash flows Cash flows Recommendations: Assignment Area First Month (30%) Second Month (35%) Third Month (35%) Total Collections Material Purchases Interest Total Disbursements Net cash flows Cumulative cash flows Minimum Cash Balance Cash Surplus or (Deficit) Recommendations Contributing Team Member Aaron Tanley Aaron Tanley Aaron Tanley Aaron Tanley Aaron Tanley Stanton Blonde Stanton Blonde