How does r and es projected external financing required

Assignment Help Corporate Finance
Reference no: EM13892265

An Excel spreadsheet containing R&E Supplies' 2012 pro forma finan- cial forecast as shown in Table 3.5 is available for download at www.mhhe.com/higgins10e. (Select Student Edition > Choose a Chapter > Files.) Using this spreadsheet, the information presented in the following list of figures, and the modified equations determined earlier in question 6, extend the forecast for R&E Supplies contained in Table 3.5 through 2013.

R&E Supplies Assumptions for 2013 ($ thousands)

Growth rate in net sales

30.0%

Tax rate

45.0%

Cost of goods sold/net sales

86.0%

Dividend/earnings after tax

50.0%

Gen., sell., & admin.

 

Current assets/net sales

29.0%

expenses/net sales

11.0%

Net fixed assets

$270

Long-term debt

$560

Current liabilities/net sales

14.4%

Current portion long-term debt

$100

 

 

Interest rate

10.0%

 

 

a. What is R&E's projected external financing required in 2013? How does this number compare to the 2012 projection?

b. Perform a sensitivity analysis on this projection. How does R&E's projected external financing required change if the ratio of cost of goods sold to net sales declines from 86.0 percent to
84.0 percent?

c. Perform a scenario analysis on this projection. How does R&E's projected external financing required change if a severe recession occurs in 2013? Assume net sales decline 5 percent, cost of goods sold rises to 88 percent of net sales due to price cutting, and current assets increase to 35 percent of net sales as management fails to cut purchases promptly in response to declining sales.

Reference no: EM13892265

Questions Cloud

Ceo anne mulcahy implemented xerox new strategy : Xerox is a very familiar corporate name in the United States. There was a time, however, when the company was faltering and needed to adapt to foreign competition. This exercise will help you see how complex such change can be.
What led to the development of sanitary landfills : What led to the development of sanitary landfills? How do sanitary landfills differ from open dumps? Describe how a sanitary landfill is created. How does this type of landfill construction help prevent groundwater contamination, and is it always ..
Organization of a new it project : Assume that you are going to make a pitch to your CEO or the head of your organization of a new IT project. It is 2012 and you need to justify why you think such a project deserves investment. Let us know what your opinions are regarding:
Define the term moisture transfer : Municipal Solid Waste Characteristics: Define the term moisture transfer and outline how it is used in refuse management. Explain why moisture transfer is important in studies on refuse composition and materials recovery
How does r and es projected external financing required : How does R&E's projected external financing required change if a severe recession occurs in 2013? Assume net sales decline 5 percent, cost of goods sold rises to 88 percent of net sales due to price cutting.
Imf policy of a tight monetary policy : Do you think the IMF policy of a tight monetary policy and reduced government spending is the appropriate response for nations experiencing a currency crisis?
Merger and acquisition strategies : 1. How difficult is it for merger and acquisition strategies to create value and which firms benefit the most from M & A activity?
How do they affect how you feel about your workplace : Benefits to you-Multiple Questions- What benefits do YOU value? How do they affect how you feel about your workplace? Do you think the benefits you value most might change over time? why
What are the information needs at ikon : What are the information needs at Ikon and what alternatives does Ikon have to meet these needs and what are the advantages and disadvantages of ERP software in meeting these needs?

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Financial analysis assignmentthis is an individual

financial analysis assignmentthis is an individual assignment that focuses on dun and bradstreets key business ratio

  Analysing financial actions taken by westpac banking

analysing financial actions taken by westpac banking corporation in relation to its returns to shareholders in the past

  Confirm that higher exercise prices mean lower call prices

Confirm that higher exercise prices mean lower call prices and higher put prices. Confirm that longer maturity means higher prices for both puts and calls.

  What is the annual depreciation expense

What is the annual depreciation expense that Monkey Manufacturing may claim against taxable income under each of the three travel options?

  What does the aggregated total actually represent

What does the aggregated total actually represent and What alternative's would you recommend

  Find the capital structure of your firm

Find the capital structure of your firm at the end of last year and you will need to find the book value of long-term debt and the market value of equity.

  What would be the reason to pay dividends

What would be the reason to pay dividends if the company bestow US $ 2 common action? Assume that the stock is trading $ 60 per share, determine what the return on dividends if the company distributes USD 2 per share.

  What is the security market line sml

How much must be deposited in his superannuation account each year to reach his target - What is the monthly payment on this car loan and Prepare an amortisation table.

  Evaluate the amount of new funds

Evaluate additional funds needed - Determine the amount of new funds required to finance this growth. Marbell has an 8% return on sales and 70% is paid out as dividends.

  The stock valuation approach

Stock valuation method uses discounted cash flows theory to compute the theoretical value of a stock. The most popular academic method is dividend growth model.

  Find the amount of gain or loss

The Horstmeyer Company commenced operations early in 2011. A number of expneses were made during 2011 that were debited to one account called intangible asset.

  Huge impact on the cost to the homebuyer

Discuss which rate is actually the cheapest rate, what are two interesting things about the sample Web site.

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