Please help!! Please also include any formulas that are used and ill be sure to leave a like :) Need this by April 20th. Thanks!

Loan: $5,000,000

Annual interest rate: 2.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:

• Facility lifetime: 10 years
• Investment on the facility and equipment: $5,000,000
• Salvage value: $1,000,000
• Annual revenue: $650,000 first year, 10% increase for year 2, and 20% annual increase after that
• Annual operating costs:
• • Insurance: $13,000
  • Maintenance and utility: $18,000
  • Wages: $240,000
• Income tax rate: 20%. This business does not pay any tax when there is a loss. There is no tax credit for the future.

Home inert Draw Formulas Page Layout Comenta Data Review View Tell me G TAA , TI Car Body Wrap Text 10 ED 29-0. X 08 General $. % Son artDelete Forme FI A Pete UT - A . BE13 Me & Center Condo forma Cal Formning Table Styles 11 va 11 21 1 Ambon BOON Home Insert Draw Page Layout Formulas Data Review View Tell me X Call (Body) 11 - A A SEE lillil 29 wao Test General Paste BTU 1S Merge & Center $ % 9 Conditional Format Cel Formatting Table Styles Insert Del G36 TO 0:30 240.000 5.000.000 13.000 1.000 1.000000 Year 5 6 10 LIN income ws perty rance Men . 9 10 11 12 13 14 Menu 15 Di 16 17. ONS 18 10 er met 20 Depreciation 21 22 Therm 23 24 25 Aer Tasca 25 Aprelation 27 Principal Payments 23 29 Net Chow 30 31 12 33 3 35 36 37 39 Amonition Cash flow