4. You are considering a luxury apartment building project that requires an inve
ID: 1126064 • Letter: 4
Question
4. You are considering a luxury apartment building project that requires an investment of $12,500,000. You expect the maintenance cost for the apartment building to be $250,000 the first year and $300,000 the second year, after which it will continue to increase by $50,000 in subsequent years. The cost to hire a manager for the building is estimated to be $80,000 per year. After five years of operation, the apartment building can be sold for $14,000,000. what is the present worth of the cash flow under MARR 15%? Assume that the building will remain fully occupied during the five years. Assume also that your tax rate is 35%. The building will be depreciated according to 39-year MACRS and will be placed in service in January during the first year of ownership and sold in December during the fifth year of ownershipExplanation / Answer
For this we have to do the NPV analysis, where
NPV = Present value (PV) of all cash inflows - PV of all cash outflows.
PV of cash outflows is $13,894,968 as per calculations below. Note that, a return on investment of 15% means that, if all the cash inflows & outflows are discounted at 15%, NPV will become 0.
Year
Cash Outflow ($)
Maintenance cost ($)
Supervisor cost ($)
Total Cash outflow ($)
Discount factor @15%
Discounted cash outflow ($)
0
125,00,000
125,00,000
1.0000
125,00,000
1
2,50,000
80,000
3,30,000
0.8696
2,86,957
2
3,00,000
80,000
3,80,000
0.7561
2,87,335
3
3,50,000
80,000
4,30,000
0.6575
2,82,732
4
4,00,000
80,000
4,80,000
0.5718
2,74,442
5
4,50,000
80,000
5,30,000
0.4972
2,63,504
PV of Cash outflow =
138,94,968
PV of cash inflow = PV of rent collected + PV of seilling price after 5 years
$13,894,968 = PV of rent collected + [$14,000,000 / (1.15)5]
PV of rent collected = $(13,894,968 - 6,960,474) = $6,934,494
If rent per year be Y, then:
YEAR
Annual Rent ($)
Discount factor @15%
1
Y
0.8696
2
Y
0.7561
3
Y
0.6575
4
Y
0.5718
5
Y
0.4972
Sum of Discount Factors =
3.3522
Therefore,
Y x 3.3522 = $6,934,494
Y = $6,934,494 / 3.3522 = $2,068,640
This is the annual rent for total 50 units in the apartment building.
Annual Rent per apartment = $2,078,640 / 50 = $41,373
Year
Cash Outflow ($)
Maintenance cost ($)
Supervisor cost ($)
Total Cash outflow ($)
Discount factor @15%
Discounted cash outflow ($)
0
125,00,000
125,00,000
1.0000
125,00,000
1
2,50,000
80,000
3,30,000
0.8696
2,86,957
2
3,00,000
80,000
3,80,000
0.7561
2,87,335
3
3,50,000
80,000
4,30,000
0.6575
2,82,732
4
4,00,000
80,000
4,80,000
0.5718
2,74,442
5
4,50,000
80,000
5,30,000
0.4972
2,63,504
PV of Cash outflow =
138,94,968
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.