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).

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 all of your work in excel format. Consider a property investment that you finance with a down payment of 20%. For the remaining, you borrow $2,300,000 at a 6% rate MONTHLY amortized loan...

Q:

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

Q:

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

Q:

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...

Q:

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...

Q:

Please show all work in Excel with formulas - I am lost. Consider a property investment that you finance with 20% down payment. For the remaining, you borrow 2'300'000 at a 6% rate monthly amortiz...

Q:

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...

Q:

What is the beta of the following portfolio? Portfolio Stock A B C Amount Invested $7,300 $2,900 $9,600 1.47 1.29 0.79 Stock Beta

Q:

A company writes a check to replenish a $100 petty cash fund when the fund contains receipts of $94 and $4 in cash. In recording the check, the company should? a. debit Cash Over and Short for $2. b....

Q:

Which of the following is necessary for a government to be considered fiscally independent? Group of answer choices It must be able to hire its own management. It must be able to issue bonds that are...

Q:

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".