What are you looking for when asking gor a reference? I have provided the spreadsheet and instructions.

An amortization table has been created for a business with the following information. Use this file Module 9-Assignment File Fall 2022. 615, Loan: $4,000,000 Annual interest rate: 4.9% Loan period: 10 years Payments: monthly, end of each month Loan will be fully paid in 10 years. In column A, create a sequence of numbers to match your loan periods. 1. A) In the Amortization sheet, show the Interest, Principal, and Balance of the loan for all periods. Create a table to show cumulative interest payments and cumulative principal payments of this loan for each year. 1. B) In the Cashflow sheet, complete the cashflow for a service business using the loan information from parts "A" and "B". Calcula duration of the projects. Additional information is as follows: 1. A) In the Amortization sheet, show the Interest, Principal, and Balance of the loan for all periods. Create a table to show cumulative interest payments and cumulative principal payments of this foan for each year. 1. B) In the Cashflow sheet, complete the cashnow for a service business using the loan information from parts "A" and "B: Calculate net cash flow for th duration of the projects. Additional information is as follows: - Annal revenue $850,000 fixed for all years - Annual operating coss include: - Wages $240,0002 - Insurance $14,000 - Maintenance and ubity. $20.000 - Income tak rate: 15\%. - This business does not pay any tax when there is a loss iit taxable inceme is nesative tax will show zerol. Amortization table: Period Interest Principal Balance Cumulative principal & interest payments: \begin{tabular}{l|l|r|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c|}{ B } & C \\ \hline 1 & Fixed Income & 850,000 \\ \hline 2 & Life & 10 \\ \hline 3 & Income tax Rate & 0.15 \\ \hline 4 & Wages & 240,000 \\ \hline 5 & Property Value (cost) & 4,000,000 \\ \hline 6 & Insurance & 14,000 \\ \hline 7 & Maintenance and utility & 20,000 \\ \hline 8 & Salvage & 1,000,000 \\ \hline & & \end{tabular}