Assume a property can be rented for $12,000 per year ($1,000 per month) or purchased for $150,000 with $30,000 down and financed with a fully amortizing mortgage loan of $120,000 at 7 percent interest for 30 years. Other costs associated with owning include maintenance costs of $500, insurance costs of $500, and property taxes of 2% of the purchase price. Assume the federal income tax rate is 28 percent. Growth rates for expenses (insurance, maintenance, property taxes), rents, and property value are a constant 2 percent per year. After five years, the property will be sold. Selling expenses of 7 percent would have to be paid at that time

Be sure to show your work in Excel. In other words, do not simply type values into the boxes, but reference prior cells when calculating results

Part 1: Monthly Payment

Fill in the two tables, for property information and loan information, respectively.

Part 2: CPM Loan

Fill in the loan schedules and property data.

Part 3: CAM Loan

Fill in the cash flow tables.

Excel Note: If you want to lock in a cell reference, use the $ symbol. For example, if you would like to keep the value of cell A5 constant for use in a formula, reference it as $A$5. See https://support.office.com/enus/article/Switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e- 5f0d8d0baca9.