You are financing a new home. The loan is for $191,000 and you are getting rate of 4.1% per year. You have decided on a 15 year mortgage and will make monthly payments (end of the month). To get the ball rollng, you are working extra hours and expect to pay an extra $410 per month to knock down the principle. You make these payments for 4 years starting on month 1. The last payment is on month 48. Build the amortization table. What month will you make your last payment? How much will the last payment be?

You are financing a new home. The loan is for $191,000 and you are getting rate of 4.1% per year. You have decided on a 15 year mortgage and will make monthly payments (end of the month). To get the ball rollng, you are working extra hours and expect to pay an extra $410 per month to knock down the principle. You make these payments for 4 years starting on month 1. The last payment is on month 48. Build the amortization table. What month will you make your last payment? How much will the last payment be?

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

You are financing a new home. The loan is for $281,000 and you are getting rate of 3.9% per year compounded monthly. You have decided on a 15 year mortgage and will make monthly payments (end of the month). To get the ball rollng, you are working extra hours and expect to pay an extra $550 per month to knock down the principle. You make these EXTRA payments for 5 years starting on month 1. The last EXTRA payment is on month 60. Build the amortization table. What month will you make your last payment? How much will the last payment be? I Need this excel sheet please!
You took a $350,000 mortgage from Truist. You term is 30 years with monthly payments, and your payment is $1,600 per month. What must be your annual quoted rate (APR)? After paying the loan for 5 years, you’re allowed to pay a “Balloon Payment”, i.e., a single amount to pay off the entirety of the loan. What is this amount?
You purchase a home and secure a 30 year equal payment loan for $200,000 at a interest rate of 5.25% APR compounded monthly. After 5 years the interest rate drops to 4.75% APR compounded monthly. The bank is charging 2 points to originate the new loan. How many months do you need to stay in the house after the refinance to make the refinance a benefit (Round to next month)?
You take out a 14-year personal loan for $13000 at rate of 8.1% which compounds 4 times per year. After 1 years, you refinance the loan and get a 13-year loan at a rate of 6.48%. a) When you first get the loan, how much is your payment? $ 390.24 Correct b) Make a spreadsheet for your loan balance, interest, and payments. After 1 years of paying, how much do you owe? $ c) Adjust your spreadsheet for the new interest rate starting when you refinance in year 1. What is your new payment? $
You lend $450 to a friend who promises to make 4 payments to you of $120 at the end of 6 months, 12 months, 18 months and 24 months. Draw a timeline from your perspective. If you can reliably earn 5% per year, what is the net present value (NPV) of this loan?
You took out a mortgage for $600,000. You need to pay $5,873 every month for 15 years. The monthly rate is 0.6999%. What is the APR?
You need to borrow $750,000 to purchase a new house. JRE bank will loan you the money at an APR of 4.3% (monthly compounding) and a 15 year term (i.e. 180 monthly payments in total). After making exactly 27 payments, what is the total amount of interest you will have paid (rounded to the nearest dollar)? The total amount of interest is closest to: A. $63,309 OB. $84,140 c. $68,709 OD. $70,734 ...
You need to borrow $750,000 to purchase a new house. JRE bank will loan you the money at an APR of 4.3% (monthly compounding) and a 15 year term (i.e. 180 monthly payments in total). After making exactly 27 payments, what is the total amount of interest you will have paid (rounded to the nearest dollar)? The total amount of interest is closest to: A. $63,309 B. $84,140 c. $68,709 O D. $70,734
You have an outstanding student loan with required payments of $600 per month for the next 4 years. The interest rate on the loan is 9.50% APR (monthly). You are considering making an extra payment of $100 today (i.e., you will pay an extra $100 that you are not required to pay). If you are required to continue to make payments of $600 per month until the loan is paid off, what is the amount of your final payment? What effective rate of return (expressed as an APR with monthly compounding) have you earned on the $100? (Note: Be careful not to round any intermediate steps less than six decimal places.) If you are required to continue to make payments of $600 per month until the loan is paid off, what is the amount of your final payment? The final payment is $ (Round to the nearest cent.)
You can afford a loan payment of $1200 a month. You have put an offer of $175,000 on a house. You are considering three different loans. Loan A. P = $175,000 at a rate of 5% with monthly payments for 30 years. Loan B. P = $175,000 at a rate of 4% with monthly payments for 15 years. Loan C. P = $175,000 at a rate of 4.5% with monthly payments for 20 years. Find the payment and total interest for each loan. Loan A: Payment = Total Interest = Loan B: Payment = Total Interest = Loan C: Payment = Total Interest =
You have just taken out a $24,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.) will go When you make your first payment, $ will go toward the principal of the loan and $ toward the interest. (Round to the nearest cent.)
You have just taken out a $16,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 $______ will go toward the interest. (Round to the nearest cent.)

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS