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
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