Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Energy And Finance Sustainability In The Energy Industry

Authors: André Dorsman, Özgür Arslan-Ayaydin, Mehmet Baha Karan

1st Edition

3319322664, 978-3319322667

More Books

Students also viewed these Finance questions

Question

5. Describe the keys to a successful change.

Answered: 1 week ago