Question: Please show your work in excel format. Consider a property investment that you finance with 20% down payment. For the remaining, you borrow 2'300'000 at

Please show your work in excel format.

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. This property, with 2% of EBITDA as capital reserves in any year, will return a NOI of 250'000 in year 1. NOI 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 straight-line depreciation).

1) 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!

Q:

Please show your work in excel format. 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....

Q:

Please show your work in excel format. 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....

Q:

Please show your work in excel format. 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....

Q:

Please show your work in excel format. 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....

Q:

Please show your work in excel format. 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....

Q:

Please show your work in excel format. 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....

Q:

Please show your work in excel format. 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....

Q:

Please show your work in Excel format. 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...

Q:

Please show your work in excel format. 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....

Q:

Please show your work in excel format. 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....

Q:

An iron rod of susceptibility 599 is subjected to a magnetising field of 1200 Am . The permeability of the material of the rod is : ( (Ho = 4 x 10-7 Tm A-) (1) 2.4 x 10-7 Tm A- (2) 2.4 x 104 Tm A-...

Q:

Was Christopher Columbus the first person to say that the earth was round rather than flat?

Q:

P9.17 The primary objective of many control systems is to maintain the output variable at the desired or reference condition when the system is subjected to a disturbance [22]. A typical chemical...

Q:

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...