Question

We entered into a 2 year loan on January 1st for $100,000 at 5% compounded monthly...

We entered into a 2 year loan on January 1st for $100,000 at 5% compounded monthly with a monthly payment of $13,397. What would the monthly interest and principal amounts for the first two months?

Homework Answers

Answer #1
Month Interest Principal
1 $ 416.67 $ 12,980.33
2 $ 362.58 $ 13,034.42
Working:
# 1 Month Interest Expense Monthly Payment Reduction in principal Ending Loan Balance
0 $        1,00,000
1 $       416.67 $ 13,397 $ 12,980.33 $     87,019.67
2 $       362.58 $ 13,397 $ 13,034.42 $     73,985.25
# 2
Monthly Interest for month of:
1 $   1,00,000 * 5% *1/12 = $       416.67
2 $       87,020 * 5% *1/12 = $       362.58
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
On 1st January 2020, a loan was issued and it was amortized over 20 years with...
On 1st January 2020, a loan was issued and it was amortized over 20 years with monthly payments at a nominal interest rate of 8.4% compounded monthly. The first payment was paid on 1st February 2020. The loan is structured in such a way that the first 120 installments will be paid in equal installments of N$6000 and the next 120 installments will be paid in such a way that each succeeding monthly payment will be 3% lower than the...
A 100,000 loan is being repaid in 360 monthly installments at a 9% nominal annual interest...
A 100,000 loan is being repaid in 360 monthly installments at a 9% nominal annual interest rate compounded monthly. The first payment is due at the end of the first month. Determine which payment is the first where the amount of principal repaid exceeds the amount of interest paid. 266th 267th 268th 269th 270th
You have just taken out a $22,000 car loan with a 5% ​APR, compounded monthly. The...
You have just taken out a $22,000 car loan with a 5% ​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...
You have just taken out a car loan for $22,000 with a 5% APR, compounded monthly....
You have just taken out a car loan for $22,000 with a 5% APR, compounded monthly. The loan is for 5 years. When you make you first payment in one month, how much of the payment will go toward the principal of the loan and how much will go towards the interest? (Note: be careful not to round any intermediate steps less than six decimal places.) When you make you first payment, $X will go towards the principal of the...
Suppose that you obtain a ten-year $ 100,000 loan to purchase a house and the annual...
Suppose that you obtain a ten-year $ 100,000 loan to purchase a house and the annual interest rate is 7 percent, what should be your monthly payment of principal and interest for the next ten years? (Hint: In the Excel PMT process, convert the annual interest rate and payment periods to the monthly rate and payment periods). Suppose the length of the loan is twenty years in Question 5, what should your monthly payment of principal and interest be for...
For a 8-year loan of $30,000 with an interest rate of 12% compounded monthly, What is...
For a 8-year loan of $30,000 with an interest rate of 12% compounded monthly, What is your monthly payment? What is the effective annual interest rate? What is the effective monthly interest rate? If I don’t make any payment for two years (assuming no penalties) and pay off the entire loan at the end of the second year, what amount do I need to pay? What is the economic equivalent value of $30,000 at this interest rate in 15 months...
A $10000 loan has an interest rate of 12% per year, compounded monthly, and 30 equal...
A $10000 loan has an interest rate of 12% per year, compounded monthly, and 30 equal monthly payments are required. a) If payments begin at the end of the first month, what is the value of each payment? b) How much interest is in the 10th payment? c) What would you enter into Excel to solve part b? d) What is the unpaid balance immediately after the 10th payment? e) If the 30 loan payments are deferred and begin at...
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 have taken a 5 year car loan of $30,000 at 3% APR with monthly compounding....
You have taken a 5 year car loan of $30,000 at 3% APR with monthly compounding. What is the amount of principal & interest payment in your first month payment? A. Principal: $464.06; Interest: $75 B. Principal: $539.06; Interest $1.35 C. Principal: $539.60; Interest: $0 D. Principal: $500.00; Interest: $39.06 E. Principal: $470.89; Interest: $75
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.)