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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!