You are going to buy a house to be used as a rental property. There is a 5% down payment and annual interest rate of 3.3% for the $168,000 house. You will pay this loan in a way that after 15 years, you have fully paid off the loan.

Use the proper Excel function in cell B7 to calculate monthly Payment.

Fill in the Amortization table with the necessary information.

Start in cell A9 create the full Amortization table to show all monthly periods, the monthly interest, monthly principal, and the remaining balance each month.

Create a table to list cumulative payments of interest and principal for each year.

Reference all values and label them properly on top of your worksheet. No number typed in formulas.

Build a Cash Flow table for your house that is used as a rental property. Use the following information for the 15 years:

Closing cost of $3,800 that will only be paid in the first year

Life of the house: 50

Salvage value: $67,000

Property Value of 168000

Annual revenue will be $19,000 for the first 5 years. After 5 years there is a 10% increase each year in revenue

Operating costs (annual):

Property tax: 1.2% of the property value

Insurance: $1700

Maintenance: $1800

Tax rate is 25% of taxable income

*There is no cost of goods sold for this cash flow table as it is about a rental house.

What is the loan and future value?