Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Promoted
agent_starfire
Lv 5
Total Payments on this Loan?
Interest Rate: 7.75%
Years: 18
Monthly Payment: $9,028.99
*I use Excel 2007 for this problem*
Show steps please.
1 Answer
Relevance
- 10 years agoFavorite Answer
Total payments simply equals number of years times 12. 12 payments per year for 18 years = 216 payments.
Total payments=(cell reference containing 18 years)*12
Or if you meant total of all monthly payments, that's your monthly payment times the previous.
=9,028.99 * 216
Still have questions? Get your answers by asking now.