Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
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 to84.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.
financial analysis assignmentthis is an individual assignment that focuses on dun and bradstreets key business ratio
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 and higher put prices. Confirm that longer maturity means higher prices for both puts and calls.
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 and What alternative's would you recommend
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 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.
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 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.
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.
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.
Discuss which rate is actually the cheapest rate, what are two interesting things about the sample Web site.
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd