标题: Alt Inv: Real Estate DCF Model Question [打印本页] 作者: EastCoastJ 时间: 2013-4-2 11:21 标题: Alt Inv: Real Estate DCF Model Question
An investor made the following purchase:
Bought an office building for $500,000 using 90% financing.
The borrowing cost was 10%.
They received $29,000 at yearend from rentals.
They sold the building for $520,000 at the end of the year.
Assuming a flat tax rate on income and capital gains of 25% what was the return on equity?
A) +6%.
B) 3%.
C) +10%.
ATCF = (Income + Capital Gain Interest)(1 tax rate) Principal component of Mortgage Amount.
From the data provided, there is no way to calculate the Principal component of Mortgage.
Is it OK to just ignore it and assume NOI = ATCF?作者: Siddimaula 时间: 2013-4-2 11:21
The qn asks for calculations for the year end.
ROE would be after payment of entire outstanding principal. So it does not matter.
450K loan, 45K interest payment.
29K (rental income) 5K (25% of 20K capital gain) 45K (interest payment) = 21K (loss) so no income tax.
Coming to capital gains, 20K (after repayment of principal)
Net loss = 1K
Equity=50K
So its a loss of 2%, close to B)
[I am not sure where I missed 5k]作者: suyash1989 时间: 2013-4-2 11:21
I believe the correct calculation was provided as
[29K (NOI) + 20K (Capital Gain) 45K (Interest payment)] (.75) (1t)
=(49K45K)*.75 = $3000
ROE = 3000/50000 = 6%
Usually the principal amount should have been subtracted from $3000 but there are no means to calculate the principal amount here and the solution ignores it too.
