Complete the following problems from Chapters 3 and 4 inPrinciples of Managerial Finance:

1. Financial Statement and Ratio Analysis: P3-5; P3-12; P3-13; P3-17; P3-18; P3-21; P3-24; P3-26
2. CashFlowandFinancialPlanning:P4-9;P4-10

I have attached the excel document needed for these questions.

ACME Company Cash Budget July through December 2016 May June July AugustSeptemberOctoberNovember December Expected Gross Sales $300.00 $290.00 ### ### $600.00 $625.00 ### ### During month ### $34.92 $33.76 $49.47 $58.20 $69.84 $72.75 $75.66 $81.48 1 month lag 75% 225.00 217.50 318.75 375.00 450.00 468.75 487.50 2 month lag 13% 39.00 37.70 55.25 65.00 78.00 81.25 Total cash collections $34.92 $258.76 ### ### $500.09 $587.75 ### ### Purchases of Raw Material Expected Gros 60% $174.00 $255.00 Cash Payment 1 month lag $174.00 ### ### ### $375.00 $390.00 ### $360.00 $375.00 ### ### $0.00 ### Disbursements: Purchase of Raw Materials $174.00 ### ### $360.00 $375.00 ### ### Wages 6% $18.00 $17.40 $25.50 $30.00 $36.00 $37.50 $39.00 $42.00 Lease payment 2% $6.00 $5.80 $8.50 $10.00 $12.00 $12.50 $13.00 $14.00 Advertising Ex 3% $9.00 $8.70 $12.75 $15.00 $18.00 $18.75 $19.50 $21.00 R&D Expenditu 12% $60.00 $72.00 $75.00 Prepaid Insurance $24.00 Other expenses $15.00 $20.00 $25.00 $30.00 $35.00 $40.00 Taxes $40.00 $45.00 Total Disbursement Cash Budget: Beginning Balance Collections Disbursements Net Cash Balance Target Cash Balance (Deficit)/Surplus Cumulative Borrowing Surplus Cumulative Surplus $33.00 $205.90 ### $15.00 ### ### $4.22 $15.00 ($10.78) ($10.78) ### $563.00 $548.75 ### ### $15.00 $15.00 $15.00 $15.00 $15.00 ### $500.09 $587.75 ### ### ### $563.00 $548.75 ### ### ($5.35) ($47.91) $54.00 ### $59.23 $15.00 $15.00 $15.00 $15.00 $15.00 ($62.91) $39.00 ### $44.23 ($31.13) ($94.04) ($55.04) $70.87 ### ($20.35)