Question: need help with this financial statement. If so please help in excel thanks Precision Machines Student Note: Fill in the light yellow cells Data: Annual

 need help with this financial statement. If so please help in

need help with this financial statement. If so please help in excel thanks

excel thanks Precision Machines Student Note: Fill in the light yellow cells

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 December January February 6,000.00 3,000.00 6,000.00 3,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 April May June 6,000.00 3,000.00 6,000.00 3,200.00 6,000.00 3,500.00 6,000.00 3,000.00 45,000.00 1,000.00 1,000.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!