Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ottawa Corporation Instructions: Financial Statements, 2013 and Projected 2014 ($ millions) Use the pro forma financial statements to answer the questions below. Change the assumptions

Ottawa Corporation Instructions:
Financial Statements, 2013 and Projected 2014 ($ millions) Use the pro forma financial statements to answer the questions below. Change the assumptions in the assumptions box as needed to answer the questions. In addition to the assumptions listed on the spreadsheet, also assume that all asset accounts will grow at the same rate as sales, and that no new equity will be issued in 2014.
INCOME STATEMENT BALANCE SHEET Questions:
Actual Projected Actual Projected a. Enter a formula for external funding required in the first green box. How much external financing does Ottawa need in 2014?
2013 2014 2013 2014 b. Given your answer from (a), do you expect the sustainable growth rate to be greater than, less than, or equal to the sales growth rate for 2014? Enter a formula for the sustainable growth rate in the second green box. What is Ottawas sustainable growth rate?
Sales $ 3,500 $ 4,025 Cash $ 150 $ 173 c. At what rate does the actual sales growth rate equal the sustainable growth rate? How much external financing is required at this growth rate? (This can be determined by trial and error.)
COGS 2,775 3,019 Accounts receivable 540 621 d. Return the sales growth rate to 15%. Suppose Ottawa wants to solve the financing shortfall by increasing profit margin. How low would the ratio of COGS/Sales have to go in order to make up the shortfall? With COGS/Sales at this lower level, what is the sustainable growth rate? (Hint: The Goal Seek tool can help you find this quickly. Consult Excel Help if you are unfamiliar with the Goal Seek tool.)
Operating expense 360 403 Inventory 1,050 1,208 e. Return COGS/Sales to 75%. Now suppose Ottawa wants to solve the shortfall by increasing the retention ratio. How low would the dividend payout ratio have to be in order to eliminate the financing shortfall?
EBIT 365 604 Total current assets 1,740 2,001 f. Return the dividend payout ratio to 40%. Now suppose Ottawa wants to make up any financing shortfall with increased debt. How high would the debt/equity ratio have to be to make up the difference?
Interest expense 68 80 Property, plant, & equipment 1,578 1,815 g. Given the above options, and any other options that you can find, make a recommendation for a reasonable and practical solution to Ottawas financing shortfall. Your solution can involve changing multiple variables.
EBT 297 524 Total assets 3,318 3,816
Tax 102 183
Net income $ 195 $ 341 Total debt 1,106 1,208
Shareholders' equity 2,212 2,416
Assumptions for 2014 Total liabilities & equity $ 3,318 $ 3,625

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

Step: 3

blur-text-image

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

Accounting For Managers Interpreting Accounting Information For Decision Making

Authors: Paul M. Collier

5th Edition

111900294X, 978-1119002949

More Books

Students also viewed these Accounting questions

Question

2. What impact did the strategy have on internal customers?

Answered: 1 week ago

Question

What is the confidence level associated with a confidence interval?

Answered: 1 week ago