ZuoTi.Pro
Question


1. Consider these threeinde tprojects НН -$300,000 $40,000 $40,000 $40,000 $240.000 790 Year 0 -$100.000 $30,000 $30,000 $30,000 $40,000 5% -$200.000 $40,000 $40,000 $40,000 $120.000 6% 2 4 Cost of capital (a) Calculate the evaluation results based on all capital budgeting techniques we learned for all these three projects, including payback, discounted payback, NPV, PI, IRR, and MIRR. Assume 15% reinvestment rate (b) If there is no limit on the capital budget, whichproject(s) would you choose? Why? (c) If there is a limit on the capital budget of $300,000, which project(s) would you choose? Why?

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum Wrap Text aCopy a-Δ· 函Merge & Center. $, % , 弼か8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 -cear, Sort & Filter Selectマ В 1 i. Find & . Format Painter Clipboard FR64 FP Alignment Number Cells Edting FQ FR FS FT FU FV FX FY 49 PV FACTOR AT 5% PV OF CFAT CUMULATIVE DISCOUNTED CFAT (FF) 51 52 53 54 YEAR 0 100000 30000 30000 30000 1 -100000.00-100000.00 71428.57 0.907027210.88 -44217.69 18302.56 0.8227 32908.1014605.54 0.952428571.43 56 57 58 59 60 61 62 63 64 65 0.8638 25915.13 4 3 +CCFAT3/CFAT4 318302.56/32908.56 DISCOUNTED PAYBACK PERIOD- IN YEARS) 3.56 67 , トト MIRR NPV İRR REPLACEMENT S HPR GMAM EAC MACRS LEASE- RATIOCASHBUDGET / wacc . BOND EPS EBIT , REPLACEMENT (STats | NPV . BETA LEVERED 9う (4 - - erences: AJ43 福 130% 01:52 17-01-2019Home nert Page Layout Formulas Data Review View dd-Ins s Cut ta copy. Σ AutoSum Wrap Text в 1 프 .-. a-Δ. : r_一 逻锂函Merge & Center. $ % , to: conditional Format eCell Insert Delete Format Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard Alignment Number Cells Edting FT81 FP FQ FR FS FT FU FV FW FX FY 63 64 65 PV FACTOR AT 6% PV OF CFAT CUMULATIVE DISCOUNTED CFAT (FF) YEAR 200000 40000 67 68 69 70 71 72 73 74 75 76 0 1 -200000.00200000.00 0.9434 37735.85 162264.15 0.890035599.6-126664.29 93079.52 1971.72 40000 120000 0.8396 33584.77 4 .7921 95051.24 3 +CCFAT3/CFAT4 3+93079.52/95051.24 DISCOUNTED PAYBACK PERIOD- IN YEARS) 3.98 78 79 80 81 11 r MIRR NPV İRR , REPLACEMENT S HPR GMAM LEAC MACRS ET wacc ! BOND -EPS EBIT REPLACEMENT STats | NPV BETA LEVERED rences: DX15 130% 01:54 17-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum Wrap Text ta copy. в 1 프· ー· 鱼, Δ. :r-ㄧ 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Alignment Number Cells FP FQ FR FS FT FU FV FX FY 78 79 80 81 82 83 84 85 86 87 PV FACTOR AT 7% PV OF CFAT A*B CUMULATIVE DISCOUNTED CFAT (FF) YEAR 0 1 -300000.00 300000.00 0.934637383.18-262616.82 0.873434937.55 -227679.27 0.8163 32651.92 -195027.36 11932.51 40000 4 240000 0.7629 183094.85 89 90 91 92 93 94 95 96 11 r DISCOUNTED PAYBACK PERIOD IN YEARS) NOT POSSIBLE AS INVESTMENT IS NOT RECOVERED FULLY ET wacc ! BOND -EPS EBIT REPLACEMENT STats | NPV BETA LEVERED MIRR NPV İRR , erences: B46 REPLACEMENT S HPR GMAM LEAC MACRS 福 130% 01:55 17-01-2019

0 0
Add a comment
Know the answer?
Add Answer to:
1. Consider these threeinde tprojects НН -$300,000 $40,000 $40,000 $40,000 $240.000 790 Year 0 -$100.000 $30,000...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 11-7 CAPITAL BUDGETING CRITERIA A firm with a 14% WACC is evaluating two projects for this...

    11-7 CAPITAL BUDGETING CRITERIA A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 3 Project M Project N - $30,000 - $90,000 $10,000 $28,000 $10,000 $28,000 $10,000 $28,000 $10,000 $28,000 $10,000 $28,000 a. Calculate NPV, IRR, MIRR, payback, and discounted payback for each project. b. Assuming the projects are independent, which one(s) would you recommend? c. If the projects are mutually exclusive, which would you recommend?...

  • IL.Cupi D . Provide an evaluation of two proposed projects, both with 5-year expected identical initial...

    IL.Cupi D . Provide an evaluation of two proposed projects, both with 5-year expected identical initial outlays of $110,000. Both of these projects involve additions donia's highly successful Avalon product line, and as a result, the require return on both projects has been established at 12 percent. The expected fre flows from each project are as follows: ected lives and additions to Cale- required rate of xpected free cash Initial outlay Inflow year 1 Inflow year 2 Inflow year 3...

  • Your first assignment in your new position as assistant financial analyst at Caledonia Products is to...

    Your first assignment in your new position as assistant financial analyst at Caledonia Products is to evaluate two new​ capital-budgeting proposals. Because this is your first​ assignment, you have been asked not only to provide a recommendation but also to respond to a number of questions aimed at assessing your understanding of the​ capital-budgeting process. This is a standard procedure for all new financial analysts at​ Caledonia, and it will serve to determine whether you are moved directly into the​...

  • CAPITAL BUDGETING CRITERIA A firm with a 14% WACC is evaluating two projects for this year's...

    CAPITAL BUDGETING CRITERIA A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 1 2 5 Project M Project N - $30,000 $10,000 $10,000 $10,000 $10,000 $10,000 $90,000 $28,000 $28,000 $28,000 $28,000 $28,000 a. Calculate NPV for each project. Round your answers to the nearest cent. Do not round your intermediate calculations. Project M $ Project N $ Calculate IRR for each project. Round your answers...

  • o Relum (TR the book Mood Internal Rate of Return (MIR) ) Click here to read...

    o Relum (TR the book Mood Internal Rate of Return (MIR) ) Click here to read the book: Payback Period CAPITAL BUDGETING CRITERIA Afirm with a 14%. WACC is evaluating two projects for this year's capital budget hows, including Project M Project N 530,000 $10,000 $10,000 $10,000 $10,000 $10,000 -390,000 $28,000 $28,000 $28,000 $28,000 $28,000 3. Calculate NPV for each project. Round your answers to the nearest cent. De Project M $ Project NS tround your intermediate actions Calculate TR...

  • udicates problems in Excel Study Problems All Study Problems are available in MyLab Finance. The X...

    udicates problems in Excel Study Problems All Study Problems are available in MyLab Finance. The X icon indicates problems Mylab format available in MyLab Finance. LO2 10-1. (Payback Period) What is the payback period for the following set of cash flowe YEAR CASH FLOWS --- $11,300 3,400 4,300 3,600 4,500 3,500 x 10-2. (IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $10,000 resulting in a single free cash flow of $17,182 after 8 years...

  • CAPITAL BUDGETING CRITERIA 1. A firm with a 13% WACC is evaluating two projects for this...

    CAPITAL BUDGETING CRITERIA 1. A firm with a 13% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 1 2 3 4 5 Project M -$18,000 $6,000 $6,000 $6,000 $6,000 $6,000 Project N -$54,000 $16,800 $16,800 $16,800 $16,800 $16,800 Calculate NPV for each project. Round your answers to the nearest cent. Do not round your intermediate calculations. Project M    $ Project N    $ Calculate IRR for each project. Round your answers to...

  • 24. Which of the following costs are variable? 10,000 Units 30,000 Units $100,000 40,000 90,000 50,000 Cost $300,000 240,000 90,000 150,000 2. 4. A) only 2 B) only 1 C) 1 and 2 D) 1 and4 25. Ed...

    24. Which of the following costs are variable? 10,000 Units 30,000 Units $100,000 40,000 90,000 50,000 Cost $300,000 240,000 90,000 150,000 2. 4. A) only 2 B) only 1 C) 1 and 2 D) 1 and4 25. Eddy Company is starting business and is unsure of whether to sell its product assembled or unassembled. The unit cost of the unassembled product is $60 and Eddy Company would sell it for $135. The cost to assemble the product is estimated at...

  • 1. LL Incorporated's currently outstanding 10% coupon bonds have a yield to maturity of 13%. LL...

    1. LL Incorporated's currently outstanding 10% coupon bonds have a yield to maturity of 13%. LL believes it could issue new bonds at par that would provide a similar yield to maturity. If its marginal tax rate is 35%, what is LL's after-tax cost of debt? Round your answer to two decimal places. 2. Summerdahl Resort's common stock is currently trading at $36.00 a share. The stock is expected to pay a dividend of $2.50 a share at the end...

  • 1. Alaa works for a pharmaceutical company that has developed a new drug. The patent on...

    1. Alaa works for a pharmaceutical company that has developed a new drug. The patent on the drug will last 17 years. She expects that the drug’s profits will be $2 million in its first year and that this amount will grow at a rate of 5% per year for the next 17 years. Once the patent expires, other pharmaceutical companies will be able to produce the same drug and competition will likely drive profits to zero. What is the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT