i need help to get these two amortization tables started and the scenario 2 questions. at least 15 rows to help me see how and some questions... down below are the formulas to the questions

Amount needed - 28400

total Interest - 100.58

monthly payment - 573.91

Scenario 1

You have just purchased a new car for $35,500 and you paid 20% down giving you a simple

interest amortized loan for the balance at 4.25% annual interest for 5 years.

Make a short statement using $ where needed with your answer for questions 1-4

Question 1) What is the amount you need to finance to purchase your new car? = $28400

Question 2) What is the monthly interest rate? Express in decimal form rounded to six decimal

places. = 8.91%

Question 3) What is the amount of your monthly car payment? =$573.91

Question 4) What is the total interest that you will pay if you carry the loan to term? =100.58%

then i have to do these tables thats 4 columns and 60 rows. columns say "amount toward interest, amount toward principle, balance of loan"

SCENARIO 2

You decide to pay an extra $25 per month on your car payment.

Using the information from part 1, complete the amortization with the higher monthly payment

and answer the questions below

Question 2) What is the total interest that you will pay if you pay an extra amount each month?

Hint: add the interest for each month in the amortization table.

Question 3) What was the time needed to pay the loan off with the higher monthly payment?

Question 4) What is the savings in interest by paying the extra amount each month?

An amortization sche dule is a valuable financial tool that shows the portion of _recular monthy parmeat that is appled toward prindisal, which gats equity for the loan bomower, and the portion spert in interest. This Proiect consists of three ports, - Parts 1 and 2 involve calculating two amortization scheslites, vou wil need to iste a pencil to fill in yout answers on this document for parts 1 and 2. - The amortiation for part 1 wil carry a loan to tern - The amortization for part 2 will demonstrate the effectr of acolvins ertra money toward the principal esch month. - Both parts will be used to determine the amount of equ ty a loan boerower gains each month, the time needed to pay off a losn when puttine eatra money toward the principal each month, and the athount of money that botrowers can save by wise fittancal practices, - Part 3 consists of a short narrative, one to two typed pages, dicursing what wis learned from parts 1 and 2 Formulas Note: P= Principal A= amount finaters (bonrowed) indudire imterest r= interest rate (in decimal form) n = number of times the loan is congounded arivully (Amount Firanced) in = nuatber of poyments in one vear (Monthly Payment) t = time (in veart) pme we anount of monthy payment TI= toeal interest Mr= montely interest lown. Part 2: Paying Mare than the 5tandark Payment on an A.tomable toat. Worth sp to 30 soints. Scenario 2: Tsu decide bo pay an evlta 325 per morth on your car peyme-t. Uhing the information trom part 1 , complete the anortanion with the higher northly puymevi and arwwer the puevisont below. Make a shert satement ining 5 where seeded whit your anwer for eueition 2 theouch 4. Question 1) Fillin the table below te complete the angrtization tatif aith the higter nonttly puymemL. Quention 1) What it the toted interest that pou wil pay if poo pay an exira amount wath month? thint add the interest for ewch month in the amort dalion takin. An amortization sche dule is a valuable financial tool that shows the portion of _recular monthy parmeat that is appled toward prindisal, which gats equity for the loan bomower, and the portion spert in interest. This Proiect consists of three ports, - Parts 1 and 2 involve calculating two amortization scheslites, vou wil need to iste a pencil to fill in yout answers on this document for parts 1 and 2. - The amortiation for part 1 wil carry a loan to tern - The amortization for part 2 will demonstrate the effectr of acolvins ertra money toward the principal esch month. - Both parts will be used to determine the amount of equ ty a loan boerower gains each month, the time needed to pay off a losn when puttine eatra money toward the principal each month, and the athount of money that botrowers can save by wise fittancal practices, - Part 3 consists of a short narrative, one to two typed pages, dicursing what wis learned from parts 1 and 2 Formulas Note: P= Principal A= amount finaters (bonrowed) indudire imterest r= interest rate (in decimal form) n = number of times the loan is congounded arivully (Amount Firanced) in = nuatber of poyments in one vear (Monthly Payment) t = time (in veart) pme we anount of monthy payment TI= toeal interest Mr= montely interest lown. Part 2: Paying Mare than the 5tandark Payment on an A.tomable toat. Worth sp to 30 soints. Scenario 2: Tsu decide bo pay an evlta 325 per morth on your car peyme-t. Uhing the information trom part 1 , complete the anortanion with the higher northly puymevi and arwwer the puevisont below. Make a shert satement ining 5 where seeded whit your anwer for eueition 2 theouch 4. Question 1) Fillin the table below te complete the angrtization tatif aith the higter nonttly puymemL. Quention 1) What it the toted interest that pou wil pay if poo pay an exira amount wath month? thint add the interest for ewch month in the amort dalion takin