Question: Please show all work in Excel with formulas - I am lost Consider a property investment that you finance with 20% down payment. For the

Please show all work in Excel with formulas - I am lost

Please show all work in Excel with formulas - I
Consider a property investment that you finance with 20% down payment. For the remaining, you borrow 2'300'000 at a 6% rate monthly amortized loan for 25 years. h This property, with 2% of EBITDA as capital reserves in any year, will return a MOI of 250'000 in year 1. E N01 is expected to grow at 2% for the following years. 82% of the property value is attributed to the building. Also, the building will have no book value after 28 years (based on straightline depreciation). TII'n'rsrrlrrl What is the cumulative depreciation in year 7, considering straight-line depreciation? 'l'lnlI What is the annual mortgage payment in year 3? What is the goingin cap rate for this property? :I If you plan to keep the property only for 6 years and the net sale proceeds at the end of year 6 is 3'400'000, what is the Before tax leveraged IRR? Ignore transaction costs at time of purchase. rn7rnII7 What will be your taxable income in year 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!