An amortization table has been created for a business with the following information. Use this file Module 9-Assignment File Fall 2023 Revised .xlsx Loan: $5,000,000 Annual interest rate: 6.9% Loan period: 10 years Payments: monthly, end of each month Loan will be fully paid in 10 years. A) Create a table to 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. B) Build a cash flow table for a service business using the loan information from parts "A" and "B". Calculate net cash flow for the duration of the projects. Additional information is as follows: Annual revenue: $1,200,000 fixed for all years Annual operating costs include: o Wages: $314,000 o Insurance: $15,000 o Maintenance and utility: $20,000

An amortization table has been created for a business with the following information. Use this file Module 2 -Assignment File Fall 2023 Revised xisx Loan: $5,000,000 Annual interest rate: 6.9% Loan period: 10 years Payments: monthly, end of each month Loan will be fully paid in 10 years. A) Create a table to 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. B) Build a cash flow table for a service business using the loan information from parts " A " and " B ". Calculate net cash flow for the duration of the projects. Additional information is as follows: - Annual revenue: $1,200,000 fixed for all years - Annual operating costs include: - Wages: $314,000 a. Insurance: $15,000 - Maintenance and utility: $20,000 - Wages: $314,000 - Insurance: $15,000 - Maintenance and utility: $20,000 - Income tax rate: 16%. This business does not pay any tax when there is a loss. (If taxable income is negative, tax will be zero)