Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete the following problems from Chapters 3 and 4 in Principles of Managerial Finance : Financial Statement and Ratio Analysis: P3-5; P3-12; P3-13; P3-17; P3-18;

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.

image text in transcribed 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forecasting Methods And Applications

Authors: Spyros G. Makridakis, Steven C. Wheelwright, Rob J Hyndman

3rd Edition

0471532339, 9780471532330

More Books

Students also viewed these Finance questions

Question

13. Give four examples of psychological Maginot lines.

Answered: 1 week ago