Question

You get a 72 month loan. The interest rate is 6.0% APR and the loan is...

You get a 72 month loan. The interest rate is 6.0% APR and the loan is for $20,000. How much interest and principal will you pay the first month of the loan? How much interest and principal will you pay during the first year? Solve without Excel using financial calculator or formulas.

Homework Answers

Answer #1

Calculating Monthly payment,

Using TVM Calculation,

PMT = [PV = 20,000, FV = 0, N = 72, I = 0.06/12]

PMT = $331.46

Interest in 1st month = 20,000(0.06/12) = $100

Principal paid in 1st month = 331.46 - 100 = $221.46

Calculating Loan Balance at the end of Year 1,

Using TVM Calculation,

FV = [PV = 20,000, PMT = -331.46, N = 12, I = 0.06/12]

FV = $17,144.81

Principal Paid in 1st year = 20,000 - 17,144.81 = $2,855.19

Interest Paid in 1st year = 12(331.46) - 2,855.19 = $1,122.33

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Your local bank is offering an interest rate of 5.3% APR, compounded monthly, on a 60-month...
Your local bank is offering an interest rate of 5.3% APR, compounded monthly, on a 60-month loan. If all you can pay is $250 per month, what is the maximum loan you can afford to get for a new car? PLEASE TRY TO BE A SIMPLE AS POSSIBLE, preferably using excel!
Amy Phillips needs to borrow $20,000 to purchase a new car. She can get a 3...
Amy Phillips needs to borrow $20,000 to purchase a new car. She can get a 3 year loan from her bank with an interest rate of 7% (compounded monthly). Calculate Amy's monthly payment. Also how much interest (in dollars) will Amy pay over the life of the loan? Lastly, if Amy got a 5 year loan instead of a 3 year loan, how much interest (in dollars) would she pay over the life of the loan? Answer using formulas -...
You borrow $20,000 to buy a car using a 72 month, 4% loan. After two years,...
You borrow $20,000 to buy a car using a 72 month, 4% loan. After two years, how much do you owe on the loan? After two years, how much of that loan payment (the 25th payment) will go towards interest?
You have taken out a $22.000 car loan with a 7% APR, compounded monthly. The loan...
You have taken out a $22.000 car loan with a 7% APR, compounded monthly. The loan is for five years.. When you make your first payment in one month, how much of the payment will go towards the principal of the loan and how much will go towards the interest?
You decide to buy a house for a total of $242,973. To get a mortgage loan,...
You decide to buy a house for a total of $242,973. To get a mortgage loan, you make a 10% down payment, and the bank will lend you the rest. The interest rate quoted for this loan is 6% APR, and the loan will be paid (and interest compounded) every month, for the next 30 years. How much will you pay in INTEREST on your very first monthly mortgage payment? Enter your answer in dollars, rounded to the nearest cent.
Use an Excel worksheet to answer the following five car loan problems you borrowed money from...
Use an Excel worksheet to answer the following five car loan problems you borrowed money from your local bank to purchase a car. The bank requires you to repay the loan over 48 months and charges a fixed, annual interest rate of 6 percent. The amount of your loan is $25,000 a,How much will your loan payment be each month? b,How much of the first loan payment will go toward principal? c,How much interest will you pay during the 1st...
You have taken out a 6060​-month, ​$24 comma 00024,000 car loan with an APR of 66​%,...
You have taken out a 6060​-month, ​$24 comma 00024,000 car loan with an APR of 66​%, compounded monthly. The monthly payment on the loan is ​$463.99463.99. Assume that right after you make your 5050th ​payment, the balance of the loan is ​$4 comma 514.814,514.81. How much of your next payment goes toward principal and how much goes toward​ interest? Compare this with the prinicipal and interest paid in the first​ month's payment.
You have just taken out a $ 15,000 car loan with a 4 %​APR, compounded monthly....
You have just taken out a $ 15,000 car loan with a 4 %​APR, compounded monthly. The loan is for five years. When you make your first payment in one​ month, how much of the payment will go toward the principal of the loan and how much will go toward​ interest? When you make your first​ payment,......will go toward the principal of the loan and ..... will go toward the interest.  ​(Round to the nearest​ cent.)
You have just taken out a $28,000 car loan with a 6%​APR, compounded monthly. The loan...
You have just taken out a $28,000 car loan with a 6%​APR, compounded monthly. The loan is for five years. When you make your first payment in one​ month, how much of the payment will go toward the principal of the loan and how much will go toward​ interest?  ​(Note: Be careful not to round any intermediate steps less than six decimal​ places.) When you make your first​ payment,​$__will go toward the principal of the loan and​$___ will go toward...
You are borrowing $200,000 on a 30 year, 12% apr, monthly payment, mortgage loan. How much...
You are borrowing $200,000 on a 30 year, 12% apr, monthly payment, mortgage loan. How much will be your principal repayment from your monthly mortgage payment at the end of the second month?(Make a table for the mortgage loan payment schedule) Can you explain how to get interest and principle repaid please
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT