TITLE – FINANCIAL FUNCTIONS AND ABSOLUTE FORMULAS IN EXCELOBJECTIVE Development of the formulas…

TITLE – FINANCIAL FUNCTIONS AND ABSOLUTE FORMULAS IN EXCELOBJECTIVE Development of the formulas for the basic financial functions in Excel (amortization table).LABORATORY CONTENTInstructions:Calculate the amortization tables for a car loan of $ 31,500 at 4.00%, 7.50%, 8.50%, 12.50%At 4, 5, 6 and 7 years the number of years of the loan.Requirements:monthly payment,principal payment,interest paymentbottom lineMake each of the amortization tables on a different sheet.On a summary sheet compare the total interest you would payData:Interest Amount Loan Years to financial Monthly Payment according to interest4%, 7.5%, 8.5% and 12.5% ??$ 31,500 4, 5, 6 and 7 ?????Make a graph for each tableIncludes Header (Title-center), (Name, Course, Teacher and date-right) and Footer (page number-center), (image-left “shop”) and (time-right).Make sure everything fits in each of the electronic sheets.