7 Calculating number of periods - Excel FORMULAS DATA REVIEW Sign in VIEW FILE HOME PAGE LAYOUT INSERT M x Cells Editing Paste BIV- 11 AA 9 DA - Alignment Number Conditional Format as Cell Formatting Table Styles Styles Font Clipboard A1 H 1 E D F B c 1 2 One of your customers is delinquent on his accounts payable balance. You've mutually agreed to a repayment schedule of $500 per month. You will charge 1.5 percent per month interest on the overdue balance. If the current balance is $18,000, how long will it take for the account to be paid off? 4 5 Monthly payment Discount rate Current balance 500 1.5% 18,000 s 7 8 9 10 11 12 13 Complete the following analysis. Do not hard code values in your calculations. Number of months until paid off search o 3 X C F10 F11 F12 * 3 % 5 6 & 7 8