Problem 123A Problem 123A Brooks Clinic is considering inves
Problem 12-3A
|
Solution
1. NPV
Option A
NPV = $20538
Option B
NPV = $42225
2. Profitability index
PI = (NPV + Initial Investment) / Initial Investment
Option A:
= (20538 + 183000)/ 183000
= 1.11
Option B:
= (42225 + 281000)/ 281000
= 1.15
3. IRR
Option A:
NPV @ 7% (in the same way as calculated in point 1)
= -183000 + (42000 x 5.38929) + (-48000 x 0.76290)
= $6731
NPV @ 9%
= -183000 + (42000 x 5.03295) + (-48000 x 0.70843)
= -$5621
IRR = Lower rate + [NPV at lower rate/ (NPV at lower rate - NPV at higher rate)] x Difference in rates
= 7% + [6731/ (6731 + 5621)] x 2
= 8.09%
Option B:
NPV @ 7% (in the same way as calculated in point 1)
= -281000 + (55000 x 5.38929) + (7000 x 0.62275)
= $19770
NPV @ 9%
= -281000 + (55000 x 5.03295) + (7000 x 0.54703)
= -$359
IRR = Lower rate + [NPV at lower rate/ (NPV at lower rate - NPV at higher rate)] x Difference in rates
= 7% + [19770/ (19770 + 359)] x 2
= 8.96%
Option B should be accepted.
| Year 0 | Year 1 to 7 | Year 4 | Year 7 | |
| Initial cost | -183000 | |||
| Annual cash inflows | 70000 | |||
| Annual cash outflows | -28000 | |||
| Cost to rebuild | -48000 | |||
| Salvage value | 0 | |||
| Total cash flows | -183000 | 42000 | -48000 | 0 |
| PVF @ 5% | 1.00000 | 5.78637 | 0.82270 | 0.71068 |
| Present value | -183000 | 243027.54 | -39489.6 | 0 |

