24 24 25 Question E Rate Franchise L NPV Franchise S NPV Difference in NPV 26...

Transcribed Image Text:

24 24 25 Question E Rate Franchise L NPV Franchise S NPV Difference in NPV 26 0.00% $50 $40 $10.00 27 1.00% $46 $37.73 $8.27 28 2.00% $43 $35.53 $7.47 29 29 3.00% $39 $33.39 $5.61 30 4.00% $36 $31.32 $4.68 31 5.00% $33 $29.29 $3.71 32 6.00% $30 $27.33 $2.67 33 7.00% $27 $25.42 $1.58 34 8.00% $24.21 $23.56 $0.65 35 9.00% $21 $21.75 -$0.75 36 10.00% $19 $19.98 -$0.98 37 11.00% $16 $18.27 -$2.27 38 12.00% $14 $16.60 -$2.60 39 13.00% $11 $14.97 -$3.97 40 10 14.00% $9 $13.38 -$4.38 41 15.00% $7 $11.83 -$4.83 42 22 16.00% $4 $10.32 -$6.32 43 33 17.00% $2 $8.84 -$6.84 44 18.00% $0.26 $7.40 -$7.14 45 19.00% ($2) $6.00 -$8.00 46 20.00% ($4) $4.63 -$8.63 #NUM! 47 Expected Net Cash Flows Year Franchise L Franchise S 0 -$100 - $100 1 10 70 2 60 50 3 80 20 20 Depreciation, salvage values, net working capital requirements, and tax effects are all included in these cash flows. You also have made subjective risk assessments of each franchise and concluded that both franchises have risk characteristics that require a return of 10%. You must now determine whether one or both of the franchises should be accepted. 1. Draw NPV profiles for Franchises L and S. At what discount rate do the profiles cross? 2. Look at your NPV profile graph without referring to the actual NPVs and IRRs. Which franchise or franchises should be accepted if they are independent? Mutually exclusive? Explain. Are your answers correct at any cost of capital less than 23.6%? 24 24 25 Question E Rate Franchise L NPV Franchise S NPV Difference in NPV 26 0.00% $50 $40 $10.00 27 1.00% $46 $37.73 $8.27 28 2.00% $43 $35.53 $7.47 29 29 3.00% $39 $33.39 $5.61 30 4.00% $36 $31.32 $4.68 31 5.00% $33 $29.29 $3.71 32 6.00% $30 $27.33 $2.67 33 7.00% $27 $25.42 $1.58 34 8.00% $24.21 $23.56 $0.65 35 9.00% $21 $21.75 -$0.75 36 10.00% $19 $19.98 -$0.98 37 11.00% $16 $18.27 -$2.27 38 12.00% $14 $16.60 -$2.60 39 13.00% $11 $14.97 -$3.97 40 10 14.00% $9 $13.38 -$4.38 41 15.00% $7 $11.83 -$4.83 42 22 16.00% $4 $10.32 -$6.32 43 33 17.00% $2 $8.84 -$6.84 44 18.00% $0.26 $7.40 -$7.14 45 19.00% ($2) $6.00 -$8.00 46 20.00% ($4) $4.63 -$8.63 #NUM! 47 Expected Net Cash Flows Year Franchise L Franchise S 0 -$100 - $100 1 10 70 2 60 50 3 80 20 20 Depreciation, salvage values, net working capital requirements, and tax effects are all included in these cash flows. You also have made subjective risk assessments of each franchise and concluded that both franchises have risk characteristics that require a return of 10%. You must now determine whether one or both of the franchises should be accepted. 1. Draw NPV profiles for Franchises L and S. At what discount rate do the profiles cross? 2. Look at your NPV profile graph without referring to the actual NPVs and IRRs. Which franchise or franchises should be accepted if they are independent? Mutually exclusive? Explain. Are your answers correct at any cost of capital less than 23.6%?