Question

1. You are going to pay off your credit card balance completely by making monthly payments of $100 for the next 2 years. In other words, your balance will reduce to zero when the last (the 24th) payment is made. Your lender charges your balance an interest of 4% a month. How much will your credit card balance be immediately before the 23rd payment is made?

A) $96.15

B) $97.09

C) $98.04

D) $100.00

E) $196.15

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

SOLVED WITH EXCEL. NEED FINANCIAL CALCULATOR STROKES, WILL PROVIDE. THANK YOU

- 2x ВР Я PV, FV, ANNUITY (Autosaved) - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Add-Ins % Cut Σ AutoSum : A Calibri -11AA = = = Dr Wrap Text General Ea Copy Fill Paste U E D- DA E E BI s FMerce Merge & Center - Center $ % % , 4.0 .00 :.: Conditional Format Cell Sort & Insert Delete Format Find & Format Painter Formatting as Table Styles 2 Clear Filter Select Clipboard Font Alignment Number Styles Cells Editing BO159 Fax BJBK BM BN ВО 159 PMT 100 160 YEARS 161 NO OF MONTHS 162 MONTHLY RATE 4% 163 164 EXCEL BALANCE AFTER 23 PAYMENTS 165 PAYMENTS LEFT 166 BALANCE 96.15 [=PV(BM162,BM165,-BM159)] 24 167 FINANCIAL FORMULA BALANCE WILL BE = BALANCE WILL BE = BALANCE WILL BE = BALANCE WILL BE = PMT*(1/r)*(1-(1/(1+r)^n)) 100*(1/0.04)*(1-(1/(1+0.04)^1)) 100* 0.961538462 96.15 168 169 170 171 172 173 174 175 176 177 N Rea ANS : E: SO JUST BEFORE PAYMENT OF 23RD PAYMENT BALANCE WILL BE = 196.15 [100 + 96.15] [23RD INSTALMENT + BALANCE] H CAP STRU VALUE profit margin loan with points LOCK BOX DILUTION DOLLAR COST AVG EXPONPER APR CPI ear FVA 0 LOAN OPTIONSpv, fv, annuity ferences pva 52 BO. 53 130% - 0- _ + 6. B 9 . * * ENG 29-10-2019