Create a spreadsheet table that shows the monthly car payments for a loan amount

Question

Create a spreadsheet table that shows the monthly car payments for a loan amount and length of the loan in years.  That is, the resulting table should enable anyone to type in any loan amount and length of the loan and the monthly payments will automatically be shown for the APRs of 3% to 8% that have monthly compounding.

I have completed the assignment in Excel for 72 months and it calculates fine when I change the amount and years however I get an excel error about the fomular being used. (Chegg do not allow you to attach Excel) Send the Excel to noworriestom@yahoo.com and I can respond with whatmine to move am along faster.

Explanation / Answer

pls check and rate my answer

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.