Question: Can I please get the answer using the excel formulas used for the calculations? I can do it by hand I just don't know how
Can I please get the answer using the excel formulas used for the calculations? I can do it by hand I just don't know how to do the excel formulas for the problem.
Problem 5-30 You have credit card debt of $25,000 that has an APR (monthly compounding) of 15%. Each month you pay the minimum monthly payment. You are required to pay only the outstanding interest. You have received an offer in the mail for an otherwise identical credit card with an APR of 12%. After considering all your alternatives, you decide to switch cards, roll over the outstanding balance on the old card into the new card, and borrow additional money as well (assuming that the new card has sufficient debt capacity) How much can you borrow today on the new card without changing the minimum monthly payment you will be required to pay? Credit card debt APR (I) APR (2) Periods per year 25,000 15% 12% 12 Monthly interest rate 1) Interest payment Monthly interest rate (2) PV of interest payments Additional borrowing
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
