This is related to excel

You are going to buy a house. There is a 5% down payment and annual interest rate of 2.94% for the $174,000 house. You will pay this loan in a way that after 15 years of equal monthly payments you still owe $15,000 to your bank. 1. Use a function in cell B7 for estimating monthly payments. 2. Create an amortization table starting from cell A9 to show all monthly interest and principal payments, and remaining balance for each month. 3. 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 if you use it as a rental property. Use the following factors and calculate net cash flow for 18 years: 1. Closing costs: $4000, paid once in year 1. 2. Life of the house: 56 years 3. Salvage value: $60,000 4. Annual revenue of the rental property: $18,000 5. Operating costs (annual): Property tax: 1.2% of the property value Insurance: $1500 Maintenance: $1300 6. 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. Create only 18 years of cash flow. Payments in year: Interest Principal APR Periods/year Years Future Value PMT Period month) interest Principal Balance ute Property tax rate Income tax Rate Closing costs Property Value Insurance Maintenance Salvage Year Revenue Operating costs Operating income Interest Payments Depreciation Taxable income Tax After Tax income Add depreciation Principal Payments Net Cash Flow