Question

Calculate effective costs, Loan ;$100000 Internet ; 7% Term; 180 months Upfront costs 7% A) calcu...

Calculate effective costs,
Loan ;$100000
Internet ; 7%
Term; 180 months
Upfront costs 7%
A) calculate monthly payments
B) how much still owe after repayment
C) what is effective interest given points on loan

0 0
Add a comment Improve this question Transcribed image text
Answer #1

A, M = P r(1+r)n / (1+r)n - 1

M = ?

P = $100000

r = monthly interest rate 7/12= .0058

n= 180 months

M= 100000 .0058(1+.0058)180 / (1+.0058)180 - 1

= 100000 * .0058(2.83) / (2.83) - 1

= 100000 * .016 / 1.83

M = 100000 * .008743

M = $ 874.31

B, $ 874.31 should be paid for 180 months for $100000 borrowed loan

= 874.31 * 180 = $157375.8

Interest amount = $157375.8 - $100000 = $57375.8

Upfront cost = 7% Upfront fee is collected by the bank at initial stage

= 100000* 7% = $7000

So total money owe = $157375.8 + $ 7000 = $ 164375.8

C. Effective interest

EAR = (1+r/12)n - 1

= (1+.07/12)12 - 1

= (1+ .0058)12 - 1

=1.07 - 1

=.0719

= 7.19%

Add a comment
Know the answer?
Add Answer to:
Calculate effective costs, Loan ;$100000 Internet ; 7% Term; 180 months Upfront costs 7% A) calcu...
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
  • Emile bought a car for $27,000 three years ago. The loan had a 5 year term...

    Emile bought a car for $27,000 three years ago. The loan had a 5 year term at 7% interest rate, and Emile has been making monthly payments for three years. How much does he still owe on the car? (Hint: first you will need to figure out the monthly payment on the 5 year loan.) Answer:

  • Emile bought a car for $27,000 three years ago. The loan had a 5 year term...

    Emile bought a car for $27,000 three years ago. The loan had a 5 year term at 8% interest rate, and Emile has been making monthly payments for three years. How much does he still owe on the car? (Hint: first you will need to figure out the monthly payment on the 5 year loan.)

  • Emile bought a car for 529,000 three years ago. The loan had a 5 year term...

    Emile bought a car for 529,000 three years ago. The loan had a 5 year term at 6X interest rate, and Emile has been making monthly payments for three years. How much does he still owe on the car? (Hint: first you will need to figure out the monthly payment on the 5 year loan.) Answer: Check

  • Consider a $15,000 loan with an annual interest rate of 9%, a term of four years,...

    Consider a $15,000 loan with an annual interest rate of 9%, a term of four years, anda monthly payment of A (5 points) What is the amount of the monthly payment? a. (10 points) Ifyou pay $750 per month, how many months will it take to repay the loan? b. (10 points) If you pay $750 per month on this loan, how much will the final payment C. be? Consider a $15,000 loan with an annual interest rate of 9%,...

  • • 1) A new car is purchased and a $20,000 loan is taken. The loan is...

    • 1) A new car is purchased and a $20,000 loan is taken. The loan is for 5 years (60 months) and the interest rate is 7.9% compounded monthly. What is the monthly payment? • 2)A new car is purchased and a $20,000 loan is taken. The loan is for 5 years (60 months) and the interest rate is 7.9% compounded monthly. What is the balance after 3 years? . 3) A new car is purchased and a $30,000 loan...

  • Sarah secured a bank loan of $200,000 for the purchase of a house. The mortage is...

    Sarah secured a bank loan of $200,000 for the purchase of a house. The mortage is amortized through monthly payments of $1,687.71 for a term of 15 years, at an interest rate of 6% per year compounded monthly. a. Determine the total amount of interest to be paid over the life of this loan. b. If she sells her house in 5 years, how much will Sarah still owe on her house (what is her outstanding principal in 5 years)?

  • 11 You just bought a car with loan of $80,000. You have to repay the loan...

    11 You just bought a car with loan of $80,000. You have to repay the loan in 7 years with monthly payments. The interest rate on the loan is 4%. of How much will you still owe after 3 years? Select one: a. $928.97 b. $77511.21 do o c. $48430.04 d. $1093.50 e. $37037.84 12 Janice has $5,000 invested in a bank that pays 5.2% annually. How long will it take for her funds to triple? aved of Select one:...

  • a. Show a time line of when the loans will be taken. Unsubsidized Stafford Loan Limits...

    a. Show a time line of when the loans will be taken. Unsubsidized Stafford Loan Limits Freshman $6,000 Sophomore 6,000 Junior 7.000 Senior 7,000 b. What will be the loan balance when Gavin graduates after his fourth year of school? c. What is the loan balance six months after graduation? d. Using the standard repayment plan and a 6.8 percent APR interest rate, compute the monthly payments Gavin owes after the grace period. integrated mini-case Paying on your Stafford Loan...

  • EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a...

    EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a home loan with yearly loan repayments, ie. the loan is paid by payments at the end of each year for n years, until the loan is completely paid off. Please use your spreadsheet to answer the following questions: (a) Given loan amount is $600,000, annual effective interest rate i is 11%, loan term is 20 years. Find the annual repayment amount. (b) Given annual...

  • 6) A mortgage of $180 000 is amortized over 15 y with a 5-year term. 0...

    6) A mortgage of $180 000 is amortized over 15 y with a 5-year term. 0 000 is amortized over 15 years at 6% compounded monthly a) Determine the monthly payment, (5 marks) Create an amortization schedule for the first 6 payments. (6 marks) Payment Monthly Interest Paid Principal Paid Outstanding Number Payment Principal 0 6 TOTAL c) How much of the 1st payment is interest? (1 mark) d) How much of the 3rd payment is used to reduce the...

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