Lab03-3210-F13-HW2-Support

A 2b 2c total project cost 30412500 initial

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: dm 3210 – Homework #2 – Fall 2013 Table A Base Case Interest Rate Cost Increase Rent Decrease Linked to Increase Spreadsheet (2.a.) (2.b.) (2.c.) Total Project Cost $ (30,412,500) Initial Loan Amount (including financing costs) $ (15,054,188) Equity Investment $ (15,358,313) Cash Flow From Operations in Year 1 and Year 6 $ 2,478,533 $ 3,268,631 Annual Debt Service in Year 1 and $ Year 5 $ 1,281,104 $ 980,997 $ 1,334,893 After-Tax Equity Cash Flow in Year 1 and Year 5 NOI Margin in Year 1 and 5 1,281,104 65.1% Year 67.6% 1.93 Debt Coverage Ratio in Year 1 and Year 5 2.40 Net Sales Proceeds of the Project $ at the End of the Holding Period 37,300,850 Remaining Mortgage Balance at the End of the Holding Period $ 1 3,696,588 A-T Sales Proceeds to Equity at the End of the Holding Period $ 21,515,042 $ 729,481 Overall Property NPV & IRR 12.62% $ 665,832 After-Tax Equity NPV & IRR 13.58% Lender Yield (IRR) 6.94% 3 Exit Cap Increase (2.d.) No Eighth Floor (2.e.)...
View Full Document

This note was uploaded on 10/22/2013 for the course HADM 3210 taught by Professor Peterliu during the Fall '13 term at Cornell.

Ask a homework question - tutors are online