Please provide formulas used in cash flow statement.

Assignment 9 Data Use one worksheet for amortization table and one for the cash flow table. - 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 15 years by equal monthly payments. 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. - Build a cash flow table for your hquse if you use it as a rental property. Use the following factors and calculate net cash flow for all years: 1. Closing costs: $4000, paid ONCE in Year 1. 2. Property Value: $174,000 3. Life of the house: 55 years 4. Salvage value: $60,000 5. Annual revenue of the rental property: $18,000 6. Operating costs (annual): - - Property tax: 1.2% of the property value - Insurance: $1500 - Maintenance: $1300 6. Tax rate is 25% of taxable income Note: Operating costs include all expenses made during the year aside from Income Taxes. "There is no "cost of goods sold" for this cash flow table as it is about a rental house. Create only 15 years of cash flow. \begin{tabular}{|l|l|} \hline Loan & \\ \hline APR & \\ \hline Periods/vear & \\ \hline Years & \\ \hline Future Value & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline Payments in year: & Interest & Principal \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & \\ \hline & \\ \hline \end{tabular} Assignment 9 Data Use one worksheet for amortization table and one for the cash flow table. - 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 15 years by equal monthly payments. 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. - Build a cash flow table for your hquse if you use it as a rental property. Use the following factors and calculate net cash flow for all years: 1. Closing costs: $4000, paid ONCE in Year 1. 2. Property Value: $174,000 3. Life of the house: 55 years 4. Salvage value: $60,000 5. Annual revenue of the rental property: $18,000 6. Operating costs (annual): - - Property tax: 1.2% of the property value - Insurance: $1500 - Maintenance: $1300 6. Tax rate is 25% of taxable income Note: Operating costs include all expenses made during the year aside from Income Taxes. "There is no "cost of goods sold" for this cash flow table as it is about a rental house. Create only 15 years of cash flow. \begin{tabular}{|l|l|} \hline Loan & \\ \hline APR & \\ \hline Periods/vear & \\ \hline Years & \\ \hline Future Value & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline Payments in year: & Interest & Principal \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline & \\ \hline & \\ \hline \end{tabular}