Question

Previous Page Next Page Page 11 of 30 Question 11 (3.3 points) You have just taken out an installment loan for $100,000. Assu
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Interest rate =RATE(12,-9456,100000) =2%

Beg amount Monthly payment Int. Pricipal paid 100000 19456 =A2*2% I=B2-C2 =A2-D2 9456 =A3*2%=B3-C3 =A3-D3 9456 =A4*2% =B4-C4

Beg amount Monthly payment Int. $ 100,000.00 $ 9,456.00 $2,000.00 $ 92,544.00 $ 9,456.00 $ 1,850.88 $ 84.938.88 $ 9.456.00 $

The answer is a)

Add a comment
Know the answer?
Add Answer to:
Previous Page Next Page Page 11 of 30 Question 11 (3.3 points) You have just taken...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • QUESTION 6 You have just obtained home financing from a bank. The principal amount is RM750,000...

    QUESTION 6 You have just obtained home financing from a bank. The principal amount is RM750,000 and the loan is to be repaid over a period of 20 years via equal end-of-the-month monthly installment payments. The bank charges an annual nominal rate of 6.6%. The calculations are based on the concept of amortization. Required: i. Calculate the monthly installment payment amount. ii. How much of the third monthly installment payment will go towards the repayment of principal? iii. How much...

  • Your company has just taken out a 1-year installment loan for $72,500 at a nominal rate...

    Your company has just taken out a 1-year installment loan for $72,500 at a nominal rate of 11.0% but with equal end-of-month payments. What percentage of the 2nd monthly payment will go toward the repayment of principal?

  • you have just taken out a 30 year, $120,000 mortgage on your new home. this mortggage...

    you have just taken out a 30 year, $120,000 mortgage on your new home. this mortggage is to be repaid in 360 equal monthly installments. if the stated (nominal) annual interest rate is 13.95 %, what is the amount of the INTEREST PORTION od the FIRST monthly installment?

  • you have just taken out a 30 year $120,000 mortgage on your new home. This mortgage...

    you have just taken out a 30 year $120,000 mortgage on your new home. This mortgage is to be repaid in 360 equal monthly installments. if the stated (nominal) annual interest rate is 15.73 percent, what is the amount of interest portion of the FIRST installment?

  • You have just taken out a $26,000 car loan with a 5% APR, compounded monthly. The...

    You have just taken out a $26,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 will...

  • You have just taken out a $18,000 car loan with a 5% APR, compounded monthly. The...

    You have just taken out a $18,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 will...

  • You have just taken out a $19,000 car loan with a 4% APR, compounded monthly. The...

    You have just taken out a $19,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? (Note: Be careful not to round any intermediate stops 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 $22,000 car loan with a 8% APR, compounded monthly. The...

    You have just taken out a $22,000 car loan with a 8% 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 $16,000 car loan with a 6% APR, compounded monthly. The...

    You have just taken out a $16,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 $...

  • You have just taken out a $28,000 car loan with a 7 % ​APR, compounded monthly....

    You have just taken out a $28,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 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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT