How much external financing does ottawa need

Assignment Help Finance Basics
Reference no: EM131418770

Instructions: 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.

Questions:

a. Enter a formula for external funding required in the first green box. How much external financing does Ottawa need in 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 Ottawa's sustainable growth rate?

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.)

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.)

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?

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?

g. Given the above options, and any other options that you can find, make a recommendation for a reasonable and practical solution to Ottawa's financing shortfall. Your solution can involve changing multiple variables.

Attachment:- Assignment File.rar

Reference no: EM131418770

Questions Cloud

Describe what aspect of contract law : Joan had a heart attack while walking to work and she fell down on the sidewalk in an unconscious state. Several people came rushing to her aid and someone called 911. While no actual contract was formed between Joan and the hospital, describe what a..
What hypothesis test would be used to analyze given data : How many variables are there in this study? What are the levels of any variables you identified?- What hypothesis test would be used to analyze these data? Justify your answer.
History of us labor legislation : Employers have a long history of using their power to abuse employees. Past employer practices have led to bloody conflicts. Over time, the development of Federal regulations has helped ease the tense employee/employer relationship.
Develop code for the file-oriented input or output driver : CMPSC311- The bulk of this assignment is to develop code for the file-oriented input/output driver that uses the object store. Conceptually, you are to translate each of the below file I/O function calls into calls to the previously described CRUD..
How much external financing does ottawa need : Enter a formula for external funding required in the first green box. How much external financing does Ottawa need in 2014. At what rate does the actual sales growth rate equal the sustainable growth rate? How much external financing is required at ..
What is meant by total productive maintenance : What is meant by disposability engineering and environmental engineering? How do they relate to each other? How do they differ?
Responsibilities of human resource management profession : During the past 50+ years, the responsibilities of the human resource management profession have changed.  Based on the provided resources (and others you might wish to use), share your thoughts about:
Aligned business framework : Review and read Case 2-3: Ford Motor Company: Aligned Business Framework. Based on your review and reading of Chapter 2: Supply Strategies will the proposed "Aligned Business Framework (ABF)" help to mitigate the reputational risk presently being exp..
What hypothesis test would be used to analyze given data : How many variables are there in this study? What are the levels of any variable you identified?- What hypothesis test would be used to analyze these data? Justify your answer.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Investors expectation of the price

If the stock is perceived to be fairly priced today, what must be investors' expectation of the price of the stock at the end of the year? (Do not round intermediate calculations. Round your answer to 3 decimal places.)

  Compute the book value of the machine

Compute the book value of the machine as of January 1, 2011, assuming that Burke recognizes the depreciation using straight-line.

  If output rises to 64000 units what will the percentage

at an output level of 55000 units you calculate that the degree of operating leverage is 3.25. if output rises to

  Relationship between marginal and average costs

Describe the change in average costs and the relationship between marginal and average costs under the following three conditions as quantities produced increase:

  Determining the future and present values

Write down the advantages and limitations of financial management of future and present values of money, annuities, interest rates, uneven cash flow, and amortization?

  Determine problems with boston beer production

In 1998, Boston Beer produced more than two dozen styles of beer. Then a few years later it was down to just a few. Now it’s up to more than 21 again. Do you see any problems with this?

  Probability that the subject tested negative

Among 148 subjects with positive test results, there are 20 false positive results; among 153 negative results, there are 44 false negative results. If one of the test subjects is randomly selected, find the probability that the subject tested neg..

  Develop the least-squares estimated regression equation

the management of a chain of fast-food restaurants wants to investigate the relationship between the daily sales volume

  What kind of intervention that country central bank be force

what kind of intervention would that country's central bank be forced to undertake, and what effect would it have on it's international reserves and the money supply?

  The capital structure for the firm will be maintained and

coogly company is attempting to identify its weighted average cost of capital for the coming year and has hired you to

  Discrete and continuous probability distributions

Provide some examples of discrete and continuous variables. What attributes of these variables make them discrete and continuous? Why?

  Swaps and interest rate options

A long floor has a payoff diagram similar to that of a

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd