Question
PLEASE DO IN EXCEL AND SHOW ALL FORMULAS APR=20% a. Suppose You buy that lavish home entertainment system that you always wanted for $5,000, and
PLEASE DO IN EXCEL AND SHOW ALL FORMULAS
APR=20%
a. Suppose You buy that lavish home entertainment system that you always wanted for $5,000, and you charge this amount on your new credit card. Now, assume you pay for this purchase by making $100 payments per month to the credit card company. Develop an amortization table assuming $100 payments each month for the first year (12 monthly payments). To get credit for this question #3, part a., you must show all of your work. How much of the $100 is interest and how much is being used to pay down your debt during the first 12 months? (State the amount of interest and state the amount of debt principal repayment each month; then sum those amounts to show the total amount of interest and debt repayment during the first year.) Note that you do not need to do these calculations by hand there are many websites that will calculate amortization tables and excel has an add-in feature to calculate this.
b. At a rate of $100 per month, how many months will it take to repay the entire $5,000?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started