In: Finance
A project costing $504,100 is projected to have the following before tax operating cash flows (BTCFO) for the next 5 years: $100,000 $125,000, $150,000, $160,000, and $175,000. In addition, the property is expected to be sold at the end of 5 years for a net cash amount of $600,000 (BTCFS). If you were to partition the BTIRR of this project, based on BTCFO and BTCFS, what proportions of the BTIRR would be represented by each?
66.0%/34.0%
50.3%/49.7%
40.0%/60.0%
73.5%/26.5%
| Year | cashflow | 
| 0 | -5,04,100 | 
| 1 | 1,00,000 | 
| 2 | 1,25,000 | 
| 3 | 1,50,000 | 
| 4 | 1,60,000 | 
| 5 | 7,75,000 | 
| IRR | 28.50% | 
| IRR Partition | ||||||
| Year | BTCFO | PV @28.50% | (BTCFS) | PV @28.50% | Total | PV | 
| 1 | 100000 | 77,821 | 0 | 0 | 100000 | 77,821 | 
| 2 | 125000 | 75,701 | 0 | 0 | 125000 | 75,701 | 
| 3 | 150000 | 70,694 | 0 | 0 | 150000 | 70,694 | 
| 4 | 160000 | 58,682 | 0 | 0 | 160000 | 58,682 | 
| 5 | 175000 | 49,948 | 600000 | 171252 | 775000 | 2,21,200 | 
| 3,32,847 | 171252 | 1310000 | 504099 | |||
| 66% (3,32,847/504099) | 34%(1310000/504099) | 
The corrrect answer is option A i.e. 66% from BTCFO and 35% from BTCFS
Thumbs up Please! Thank You