Question: Solve the following problems using Excel formula. Also, please show the mathematical formulas you would use to solve questions One of your customers is delinquent
Solve the following problems using Excel formula. Also, please show the mathematical formulas you would use to solve questions
One of your customers is delinquent on his accounts payable balance. Youve mutually agreed to a repayment schedule of $600 per month. You will charge 0.9 percent per month interest on the overdue balance. If the current balance is $18,400, how long will it take for the account to be paid off?
| Monthly payment | 600 | ||
| Discount rate | 0.9% | ||
| Current balance | $ 18,400 | ||
| Output area: | |||
| # of months until paid off | |||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
