Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show each working properly with an explanation for each step so that I understand 9. A company has revenues of 100 million, COGS are

image text in transcribed

Please show each working properly with an explanation for each step so that I understand

9. A company has revenues of 100 million, COGS are 60% of sales, operating expenses are 10% of sales (including depreciation). Interest expense is 3 million. Tax rate is 40%, dividend payout is 1/3. Assets are 100 million, Debt is 30 million, accounts payable are 6 million. Equity is 64 million. What is external financing need if the company grows at 12%. Assume Interest Expense stays constant. Assume any surplus goes to assets and any deficit goes to debt. Revenue Costs Opex Interest Pretax Taxes Net Dividends Change in RE Year 0 100 (60) (10) (3) +27 Year 1 112 (67.2) (11.2) (3) +30.6 16.2 (5.40) 18.36 (6.12) +12.24 Assets 100 112 A/P Debt Equity 6 30 64 6.72 30 64+12.24 = 76.24 Interim 112.96 Surplus of 0.96 put into cash Assets = 112.96

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

Principles Of Financial Modelling Model Design And Best Practices Using Excel And VBA

Authors: Michael Rees

1st Edition

111890401X, 978-1118904015

More Books

Students also viewed these Finance questions