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 forCan 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

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!