Can you please show me how to set this up in excel? Formulas included, thank you!

You acquired a multifamily residential property 10 years ago for $14 million. At the time of acquisition, the land value was $2.1 million.

1. How much was your annual depreciation expense?

When you purchased the property, you were able to lever your investment with a ratio of 4.5. The bank gave you a fixed-rate, zero-amortizing mortgage with an interest rate of 5.6%.

2. How much was your monthly interest payment?

This year, the property earns an NOI of $1,200,000. This is the only income that you personally earn throughout the year. You pay taxes based on the post-2017 rates and tax brackets.

3. How much do you pay in ordinary income taxes this year?