Please show all the steps. If possible, do by hand.

Consider a commercial property investment opportunity with the following characteristics: Purchase Price: .... Building Value... LTV:............ Loan Term: Interest Rate:... Holding Period:.............. $750,000 .90% of purchase price ........ 75% 20 yrs. (fully amortizing, monthly payments) 7% ...... 5 Yrs. $67,000 ....... Yr. 1 NOI: ........ Annual NOI Growth: ...... Annual Prop. Appreciation: Discount Rate: 3% 2% 9% What are the before tax cash flows for each year of the project? Assume that the reversion value is based on property appreciation. | What is the Before Tax IRR for the project? What is the Before Tax NPV for the project? What is the cap rate for the project? What is the debt coverage ratio for the project? What is the terminal cap rate for the project? Consider a commercial property investment opportunity with the following characteristics: Purchase Price: .... Building Value... LTV:............ Loan Term: Interest Rate:... Holding Period:.............. $750,000 .90% of purchase price ........ 75% 20 yrs. (fully amortizing, monthly payments) 7% ...... 5 Yrs. $67,000 ....... Yr. 1 NOI: ........ Annual NOI Growth: ...... Annual Prop. Appreciation: Discount Rate: 3% 2% 9% What are the before tax cash flows for each year of the project? Assume that the reversion value is based on property appreciation. | What is the Before Tax IRR for the project? What is the Before Tax NPV for the project? What is the cap rate for the project? What is the debt coverage ratio for the project? What is the terminal cap rate for the project