Question

Risk-adjusted discount rates-Basic Country Wallpapers is considering investing in one of three mutually exclusive projects, E, F, and G. The firms cost of capital, r is 15.2%, and the risk-free rate, RF IS 10.3%. The firm has gathered the following basic cash flow and risk index data for each project a. Find the net present value (NPV) of each project using the firms cost of capital. Which project is preferred in this situation? b. The firm uses the following equation to determine the risk-adjusted discount rate, RADR, for each project j RADRs RF + RI.* (r-RF) where RF-risk-free rate of return, R, = risk index for project j , and r = cost of capital c. Use the RADR for each project to determine its risk-adjusted NPV. Which project is preferable in this situation? d. Compare and discuss your findings in parts (a) and (c). Which project do you recommend that the firm accept? a. Find the net present value (NPV) of each project using the firms cost of capital Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Project (j) Initial investment (CFo) $14,500 $11,000 $19,600 Year (t) Cash inflows (CFt) $5,700 5,700 5,700 5,700 1.83 $6,300 4,500 4,900 2,200 0.96 $4,300 5,400 8,100 12,800 0.65 4 Risk index (RI) PrintDone

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Home Page Layout FormulasData Review View dd-Ins Trace PrecedentsShow Formulas Define Name Use in FormulaTrace DependentsError Checking ? Create from Selection Calculate Now Insert Autosum Recently Financial Logical Tet Date & Lookup & Math More Function | Evaluate Formula Watch CalculationCalculate Sheet wndow Used Time Reference ▼ & Tng Functions ▼ Manager Remove Arrows options . Function Library Defined Names Formula Auditing Calculation OA212 Formula Bar OA OC OD он 212 213 215 a 216 217 218 219 220 221 15.20% 10.30% NOTE PV FACTOR AT 15.2% PV OF CFAT FOR E PV FACTOR AT 15.4% YEAR E FOR F FOR G 14500 5700 5700 5700 5700 1/(1.152Ao) 1/1.15241) 1/(1.15242) 1/(1.15243) 11152A4) 0 11000 6300 4500 4900 2200 19600 4300 5400 8100 12800 0.8681 0.7535 0.6541 0.5678 114500.00-11000.00 -19600.00 4947.92 5468.753732.64 4295.07 3390.844069.01 3728.36 3205.085298.19 3236.42 1249.147267.75 767.59 223 224 225 226 227 228 229 230 44MRATION PBP ARRextemal rate MIRR NPV IRR NPV -- 1707.76 2313.82 SELECT PROJECT F AS IT HAS HIGHEST NPV REPLACEMENT SHPR GMAM EAC MACRS RATIOCASHBUDGETwacc BOND EPS EBIT REPLACEMENT STats erences: E147 27-01-2019Home Page Layout FormulasData Review View dd-Ins Define Name Trace Precedents Show Formulas Calculate Now 曙Trace Dependents ◆Error Checking- Insert Autosum Recently Financial Logical Tet Date & Lookup & Math More Function Watch | Calculation Calculate Sheet ? Create from Selection Defined Names Used ▼ Time Reference ▼ & Tng Functions ▼ Manager Evaluate Formula WindowOptions Function Library Formula Auditing Calculation OG231 NZ {辨 OC OD OE OF OG он οι OK 231 b 232 233 234 235 236 237 с 238 239 240 241 242 2A3 244 245 246 247 248 d 249 CALCULATION OF RADR RADR-Rf+RI(r-Rf) FOR E FOR F FOR G 19.27% 10.3% + 1.83(15.2%-10.3%) 15.00% 10.3% + 0.96(15.2%-10.3%) 13.49% 10.3% +0.65*(15.2%-10.3%) PV FACTOR AT 19.27% PV FACTOR AT 15% PV FACTOR AT 13.49% PV OF CFAT FOR E FOR F A*P YEAR E FOR G CFR 14500 5700 5700 5700 5700 19600 4300 5400 8100 2800 0.49420.5718 0.6028 2816.761257.86 7715.78 0 11000 6300 4500 4900 2200 1-14500.00 -11000.00 -19600.00 0.86960.8811 4779.075478.26 3788.88 0.8384 0.7030 0.7561 0.77644006.94 3402.65 4192.55 0.58940.6575 0.6843359.55 3221.83 5541.31 4 NPV --> 462.32 2360.59 1638.52 SELECT PROJECT F AS IT HAS HIGHER NPV ACCORDING TO COC PROJECT F IS BETTER AND ACCORDING TO RADR PROJECT F IS BETTER RADR IS A BETTER MEASURE OF SELECTING THE PROJECT SO WILL SELECT PROJECT F RATION PBP ARR extemal rate MIRR NPV IRR REPLACEMENTS HPR GMAMEAC MACRS LEASE RATIOCASHBUDGET wacc BOND EPS EBIT REPLACEMENT STats NPV D 27-01-2019

Add a comment
Know the answer?
Add Answer to:
Risk-adjusted discount rates-Basic Country Wallpapers is considering investing in one of three mutually exclusive projects, E,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • Risk-adjusted discount rates—Basic Country Wallpapers is considering investing in one of three mutually exclusive projects, E,...

    Risk-adjusted discount rates—Basic Country Wallpapers is considering investing in one of three mutually exclusive projects, E, F, and G. The firm's cost of capital, r, is 15.4%, and the risk-free rate, RF, is 9.6%. The firm has gathered the following basic cash flow and risk index data for each project a. Find the net present value (NPV) of each project using the firm's cost of capital. Which project is preferred in this situation? b. The firm uses the following equation...

  • Risk-adjusted discount rates-Basic Country Wallpapers is considering investing in one of three mu...

    Risk-adjusted discount rates-Basic Country Wallpapers is considering investing in one of three mutually exclusive projects E, F, and G. The firm's cost of capital, r, is 15.4%, and the risk-free rate, RF, is 9.8%. The firm has gathered the following basic cash flow and risk index data for each project EEB a. Find the net present value (NPV) of each project using the firm's cost of capital. Which project is preferred in this situation? b. The firm uses the following...

  • Risk-adjusted discount rates—Basic Country Wallpapers is considering investing in one of three mutually exclusive projects, E,...

    Risk-adjusted discount rates—Basic Country Wallpapers is considering investing in one of three mutually exclusive projects, E, F, and G. The firm's cost of capital, r, is 14.6%, and the risk-free rate, RF, is 10.4%. The firm has gathered the following basic cash flow and risk index data for each project 2 a. Find the net present value (NPV) of each project using the firm's cost of capital. Which project is preferred in this situation? b. The firm uses the following...

  • 11 Risk adjusted discount rates-8asic Country Wallpapers is considering nvesting in one of three mutually exclusive pro ect following basic cash flow and risk index data for each project a. Find the...

    11 Risk adjusted discount rates-8asic Country Wallpapers is considering nvesting in one of three mutually exclusive pro ect following basic cash flow and risk index data for each project a. Find the net present value (NPV) of each project using the firm's cost of capital. Which project is preferred in this situation? b. The firm uses the following equation to detemine the risk-adjusted discount rate, RADR, for each project j E, F and G. The firm's cost o capital r...

  • I need to find the risk-adjusted present value for Project E, F, and G. Please show the work in E...

    I need to find the risk-adjusted present value for Project E, F, and G. Please show the work in Excel. Risk adjusted discount rates -Basic Country Wallpapers s considering investing in one of three mutually exclusive projects, E F and G The firm's cost of capita r is 14.9%, and the risk-free rate, RF S 9.9%. The firm a. Find the net present value (NPV) of each project using the firm's cost of capital. Which project is preferred in this...

  • Risk-adjusted discount rates—Tabular After a careful evaluation of investment alternatives and opportunities, Masters School Supplies has...

    Risk-adjusted discount rates—Tabular After a careful evaluation of investment alternatives and opportunities, Masters School Supplies has developed a CAPM-type relationship linking a risk index to the required return (RADR), as shown in the table B. The firm is considering two mutually exclusive projects, A and B. Following are the data the firm has been able to gather about the projects. Project A $20,000 Initial investment (CF) Project life Annual cash inflow (CF) Risk index 8 years $8,000 0.2 Project B...

  • Risk-adjusted rates of return using CAPM Centennial Catering, Inc., is considering two mutually exclusive investments. The...

    Risk-adjusted rates of return using CAPM Centennial Catering, Inc., is considering two mutually exclusive investments. The company wishes to use a CAPM-type risk-adjusted discount rate (RADR) in its analysis. Centennial's managers believe that the appropriate market rate of return is 12.3%, and they observe that the current risk-free rate of return is 7.4%. Cash flows associated with the two projects are shown in the following table. (Click on the icon located on the top-right corner of the data table below...

  • Risk-adjusted rates of return using CAPM Centennial Catering, Inc., is considering two mutually exclusive investments. The...

    Risk-adjusted rates of return using CAPM Centennial Catering, Inc., is considering two mutually exclusive investments. The company wishes to use a CAPM-type risk- adjusted discount rate (RADR) in its analysis. Centennial's managers believe that the appropriate market rate of return is 12%, and they observe that the current risk-free rate of return is 7%. Cash flows associated with the two projects are shown in the following table. Initial investment (CF) Year (t) Project X Project Y -$70,000 -$78,000 Cash inflows...

  • please answer all parts a-d X P11-24 (similar to) . The firm's cost of it ....

    please answer all parts a-d X P11-24 (similar to) . The firm's cost of it . 15.25, and the streer, Reis 10.2% Risk-adjusted discount rates Basic Country Wi e rs is considering investing in one of three mutually exclusive projects, EFand The firm has gathered the following basic cash flow and index data for each project Find the NPV) of each project using the cost of capital which project is preferred in this situation? b. The uses the towing equation...

  • Risk classes and RADR Moses Manufacturing is attempting to select the best of three mutually exclusive...

    Risk classes and RADR Moses Manufacturing is attempting to select the best of three mutually exclusive projects, X, Y, and Z. Although all the projects have 5-year lives, they possess differing degrees of risk. Project X is in class V, the highest-risk class; project Y is in class II, the below-average-risk class; and project Z is in class III, the average-risk class. The basic cash flow data for each project and the risk classes and risk-adjusted discount rates (RADRs) used...

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