WORKING MODEL GROWTH RATES WACC NPV PAYBACK DCF PAYBACK IRR MAKE INVESTMENT ADDITIONAL INVESTMENT INVESTMENT 15.0%...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
WORKING MODEL GROWTH RATES WACC NPV PAYBACK DCF PAYBACK IRR MAKE INVESTMENT ADDITIONAL INVESTMENT INVESTMENT 15.0% SALES/SAVINGS OPERATIONS 12.0% EXPENSES/OPERATION COSTS NET 21.0% TAXES NET CASH FLOWS DCF NPV CUMULATIVE CF PAYBACK CALC PAYBACK CALC DCF CUMULATIVE CF DCF PAYBACK CALC DCF PAYBACK CALC 14.5% $19,355 5.0 7.0 14.8% BEG INV (1,250,000) (250,000) (1,500,000) 1 Y1 $ $ $ 1.5 BETA 1,821 # OF 10 YEAR BONDS AT $100 FACE 10% COUPON ON THE BONDS (ANNUAL) 91.35 CURRENT PRICE OF BOND 1.9 1.0 10,000 SHARES OF STOCK ISSUED AND OUTSTANDING 50.00 CURRENT PRICE PER SHARE 5.00 CURRENT DIVIDEND 5% DIVIDEND GROWTH RATE HISTORY 3 Y3 2 Y2 250,000 310,000 381,700 (52,500) (65,100) (80,157) 197,500 244,900 (1,500,000) (1,500,000) 172,489 186,800 19,355 (1,500,000) (1,302,500) (1,057,600) 50,000 50,000 2,011,357 2,313,061 1,000,000 1,150,000 1,322,500 1,520,875 1,749,006 (750,000) (840,000) (940,800) (1,053,696) (1,180,140) (1,321,756) (1,480,367) 467,179 (98,108) 1.7 1.0 (1,500,000) (1,327,511) (1,140,711) 1.9 1.8 1.0 1.0 301,543 200,878 (756,057) 1.5 1.0 4 Y4 (939,832) 1.6 1.0 369,071 214,728 (386,986) 1.3 1.0 5 Y5 (725,104) 1.5 1.0 6 Y6 568,867 689,601 (119,462) (144,816) 449,405 544,785 228,355 241,764 62,419 1.0 1.0 (496,750) 1.3 1.0 607,204 0.5 7 Y7 (254,985) 1.2 1.0 832,694 (174,866) 707,828 274,340 1,315,032 (0.2) 19,355 1.0 1.0 Face COMBINED PV COUPON: ACTUAL RATE: YEAR 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 $ 100.00 10.0% 10.0% CASH FLOW $ 100 $ 10 10 10 10 10 10 9999 10 10 10 10 $ I 100.00 PRESENT VALUE 61 9 8 8 7 6 6 in in 5 5 4 =-PV($F$7,E11,0, F11,0) YEAR CASH FLOW 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 PRESENT VALUE $ 100 $ 100 39 39 Using the Excel spreadsheets: Are the firm's bonds selling at a premium or a discount? O 1. Premium. 2. Discount Clear my choice Using the Excel spreadsheets: What is the firm's current cost of debt? 1. 12.7% O 2. 8.9% 3. 11.5% 4. 10% WORKING MODEL GROWTH RATES WACC NPV PAYBACK DCF PAYBACK IRR MAKE INVESTMENT ADDITIONAL INVESTMENT INVESTMENT 15.0% SALES/SAVINGS OPERATIONS 12.0% EXPENSES/OPERATION COSTS NET 21.0% TAXES NET CASH FLOWS DCF NPV CUMULATIVE CF PAYBACK CALC PAYBACK CALC DCF CUMULATIVE CF DCF PAYBACK CALC DCF PAYBACK CALC 14.5% $19,355 5.0 7.0 14.8% BEG INV (1,250,000) (250,000) (1,500,000) 1 Y1 $ $ $ 1.5 BETA 1,821 # OF 10 YEAR BONDS AT $100 FACE 10% COUPON ON THE BONDS (ANNUAL) 91.35 CURRENT PRICE OF BOND 1.9 1.0 10,000 SHARES OF STOCK ISSUED AND OUTSTANDING 50.00 CURRENT PRICE PER SHARE 5.00 CURRENT DIVIDEND 5% DIVIDEND GROWTH RATE HISTORY 3 Y3 2 Y2 250,000 310,000 381,700 (52,500) (65,100) (80,157) 197,500 244,900 (1,500,000) (1,500,000) 172,489 186,800 19,355 (1,500,000) (1,302,500) (1,057,600) 50,000 50,000 2,011,357 2,313,061 1,000,000 1,150,000 1,322,500 1,520,875 1,749,006 (750,000) (840,000) (940,800) (1,053,696) (1,180,140) (1,321,756) (1,480,367) 467,179 (98,108) 1.7 1.0 (1,500,000) (1,327,511) (1,140,711) 1.9 1.8 1.0 1.0 301,543 200,878 (756,057) 1.5 1.0 4 Y4 (939,832) 1.6 1.0 369,071 214,728 (386,986) 1.3 1.0 5 Y5 (725,104) 1.5 1.0 6 Y6 568,867 689,601 (119,462) (144,816) 449,405 544,785 228,355 241,764 62,419 1.0 1.0 (496,750) 1.3 1.0 607,204 0.5 7 Y7 (254,985) 1.2 1.0 832,694 (174,866) 707,828 274,340 1,315,032 (0.2) 19,355 1.0 1.0 Face COMBINED PV COUPON: ACTUAL RATE: YEAR 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 $ 100.00 10.0% 10.0% CASH FLOW $ 100 $ 10 10 10 10 10 10 9999 10 10 10 10 $ I 100.00 PRESENT VALUE 61 9 8 8 7 6 6 in in 5 5 4 =-PV($F$7,E11,0, F11,0) YEAR CASH FLOW 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 PRESENT VALUE $ 100 $ 100 39 39 Using the Excel spreadsheets: Are the firm's bonds selling at a premium or a discount? O 1. Premium. 2. Discount Clear my choice Using the Excel spreadsheets: What is the firm's current cost of debt? 1. 12.7% O 2. 8.9% 3. 11.5% 4. 10%
Expert Answer:
Answer rating: 100% (QA)
1 To determine if the bonds are trading at a premium or discount we compare the curren... View the full answer
Related Book For
Fundamentals of Financial Management
ISBN: 978-0324597707
12th edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Do you have convincing evidence of sufficient computer skills to engage in online discussion forums, access online library resources, engage in online videoconferencing, and utilize word processing,...
-
Birch manufacturing is considering the addition of another product line to its offerings. Equipment needed to produce the new line will cost $198,300. Birch estimates that the net cash inflows from...
-
Reiden Inc. issues $4 million, 5-year, 8% bonds at 102, with interest payable on January 1. The straight-line method is used to amortize bond premium. (a) Prepare the journal entry to record the sale...
-
LPG is predominantly a mixture of propane and: (a) Methane (b) Isopropane (c) Butane (d) Ethane
-
You have just finished preparing the management accounting report below for your division. You are very pleased with the performance of your division and show the report to your division president,...
-
A weight of 100kN is hung by means of two strings from the ceiling as shown. Find the tension in two strings 60 T 1 100 kN 30 T2
-
Pandemic Covid Bhd is buys and sells two goods, namely Astra and Zeneca. The following trial balance was extracted from nominal ledger of Pandemic Covid on 31 December 2020. Trial Balance of Pandemic...
-
A rodent starts his journey traveling at 0.01m/s with a constant 3m/s2. The rodent covers a short distance of only 5mm. Calculate the rodent's final speed
-
Watergate has a beta of 1.25. The market risk premium is 10% and the risk-free rate is 2.5%. ABC Corp. has 1 million outstanding bonds trading at $100 currently. ABC Corp. has 20 million shares...
-
Your stock is currently selling for $64.94. Assuming you plan to pay a dividend of $5 next year, and the dividends are expected to grow at a yearly rate of 3% indefinitely, what is the required...
-
Kojo and Nelson leave school at the same time. Kojo drives at an average speed of 5 5 km / h and Nelson drives at 7 0 km / h . How long does it take each person to reach a mall that is 2 5 km from...
-
b) Goldcrest Co made sales of $193,200 during the year ended 31st March 2022. Inventory decreased by $13,200 over the year and all sales were made at a mark-up of 42%. What was the cost of purchases...
-
USCO incurred $110,000 in interest expense for the current year. The tax book value of USCo's assets generating foreign-source income is $5,500,000. The tax book value of USCO's assets generating...
-
Prove the following D,(cos x) = - sin x (Hint: Apply the identity cos(A + B) = cos A cos B sin A sin B)
-
List seven reasons risk management might increase the value of a firm.
-
21st Century Educational Products (21st Century) is a rapidly growing software company; and consistent with its growth, it has a relatively large capital budget. While most of the companys projects...
-
Suppose 2-year Treasury bonds yield 4.5%, while 1-year bonds yield 3%. r* is 1%, and the maturity risk premium is zero. a. Using the expectations theory, what is the yield on a 1-year bond 1 year...
-
This chapter reports findings from a recent study by Nellie Mae. To learn more about Nellie Mae and other research findings, visit www.nelliemae.com.
-
Are the initial rates lower on a fixed-rate loan or a variable-rate loan? Why?
-
Visit the Consumer Financial Protection Bureau Web site (www.consumerfinance.gov). Based on the public information available, describe what role the bureau plays in providing consumer education,...
Study smarter with the SolutionInn App