Suppose you are buying a beach house condo for $450,000.

You are planning to finance the ENTIRE amount of the condo via a mortgage for 30 years, 5% fixed, 0-points.

The HOA fees, property taxes, Annual maintenance + Upkeep of the condo = $12,000 per year.

Utilities are $150/month

You are planning to rent this condo, and your rental income is $40,000 per year (gross), which goes up by 2% per year.

Expenses to rent out the property are 30% of the gross income per year.

Since this is an investment property, you will be depreciating it under residential rental property with 27.5 years depreciation.

Assume that the condo will appreciate by 3% annually.

1. Provide a detailed calculation representing the annual schedule of income, expenses, depreciation, taxable income for this investment, and property appreciation.

2. If your MARR is 5%, determine if this is a good investment based on TAXABLE INCOME and APPRECIATION only. Find the IRR for this investment.

Please, state all assumptions and show all your work.