You plan to use a 15 year mortgage obtained from a local bank t purchase a house worth $124,000.00. The mortgage rate offered to you is 7.75%. You will make a down payment of 20% of the purchase price. a. Calculate your monthly payments on this mortgage. List in a spreadsheet the cash flow the bank expects to receive from you. Submit the spreadsheet with your answers. b. Calculate the amount of interest and principal for the 60th payment. Show your work. c. Calculate the amount of interest and principal to be paid on the 180th payment. Show your work. d. What is the amount of interest paid over the life of this mortgage?

You plan to use a 15 year mortgage obtained from a local bank t purchase a house worth $124,000.00. The mortgage rate offered to you is 7.75%. You will make a down payment of 20% of the purchase price. a. Calculate your monthly payments on this mortgage. List in a spreadsheet the cash flow the bank expects to receive from you. Submit the spreadsheet with your answers. b. Calculate the amount of interest and principal for the 60th payment. Show your work. c. Calculate the amount of interest and principal to be paid on the 180th payment. Show your work. d. What is the amount of interest paid over the life of this mortgage?

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 can afford an $800 per month mortgage payment. You found a 30-year loan at 6% interest. How big of a loan can you afford? How much will you pay the loan company? How much of that money is interest?
I. M. Greedy Mortgage Bank offers you a $60,000, eleven-year term loan at a 5% annual interest rate to help you buy a home. What will your annual loan payment be?
You purchase a home for $400,000 and make a down payment of $125,000. The balance is borrowed and financed as follows: 4 year mortgage, 5% interest, paid as an ordinary annuity. How much total interest is paid on the loan?
Please build an excel spreadsheet and show the formulas to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?
The Becker family is getting a home loan to finance a $260,000 mortgage. While looking for a mortgage, they found two alternatives: Mortgage A 30-year loan with an interest rate of 3.611% and a monthly payment of $1,184. Mortgage B 15-year loan with an interest rate of 2.7% Recall: Loan Payment Formula.png| A. Calculate the total amount paid for Mortgage A. B. Calculate the total interest paid for Mortgage A. C. Calculate the monthly payment for Mortgage B. D. Calculate the total amount paid for Mortgage B. E. Calculate the total interest paid for Mortgage B. F. Write a two or more sentences giving the Becker family some advice about which mortgage to choose. G. Why might the Becker family not take your advice from part c)? Answer in one or two sentences.
The Becker family is getting a home loan to finance a $260,000 mortgage. While looking for a mortgage, they found two alternatives: Mortgage A 30-year loan with an interest rate of 3.611% and a monthly payment of $1,184. Mortgage B 15-year loan with an interest rate of 2.7% Recall: Calculate the total amount paid for Mortgage A. Calculate the total interest paid for Mortgage A. Calculate the monthly payment for Mortgage B. Calculate the total amount paid for Mortgage B. Calculate the total interest paid for Mortgage B. Write a two or more sentences giving the Becker family some advice about which mortgage to choose. Why might the Becker family not take your advice from part c)? Answer in one or two sentences.
Tim wants to borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's monthly payments be on his mortgage? b. Amortize the loan and determine: Interest expense for the first quarter of the loan. Cash flows for the first quarter of the loan. Loan balance at the end of the first quarter of the loan. Please show your calculations, part b is very important. If you are using the TVM chart, please state whether you used PVoA, FVoA, PVoSA, FVoSA.
You plan to purchase an $80,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate offered to you is 8.00 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage.b. Calculate the amount of interest and, separately, principal paid in the 127th payment.c. Calculate the amount of interest and, separately, principal paid in the 159th payment.d. Calculate the amount of interest paid over the life of this mortgage.
Find the monthly house payment necessary to amortize the following loan. 9) In order to purchase a home, a family borrows $121,000 at 3.0% for 30 yr. What is their monthly payment? Round the answer to the nearest cent.
You plan to purchase a $160,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.5 percent. You will make a down payment of 15 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, principal paid in the 25th payment. c. Calculate the amount of interest and, separately, principal paid in the 80th payment. d. Calculate the amount of interest paid over the life of this mortgage. (For all requirements, do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) a. Monthly payment b. Amount of interest Amount of principal Amount of interest Amount of principal d. Amount of interest paid C. Amount
A friend asks to borrow $54 from you and in return will pay you $57 in one year. If your bank is offering a 5.7% interest rate on deposits and loans: a. How much would you have in one year if you deposited the $54 instead? b. How much money could you borrow today if you pay the bank $57 in one year? c. Should you loan the money to your friend or deposit it in the bank? a. How much would you have in one year if you deposited the $54 instead? If you deposit the money in the bank today you will have $ in one year. (Round to the nearest cent.)
Use an online loan calculator to determine the regular payment amount, rounded to the nearest dollar. The price of a home is $148,000. The bank requires a 20% down payment and three points at the time of closing The cost of the home is financed with a 30-year fixed rate mortgage at 85% Complete parts (a) through (e) below -CHEDD a. Find the required down payment $0 b. Find the amount of the mortgage How much must be paid for the three points at closing? (Round to the nearest dolar as needed) d. Find the monthly payment (excluding escrowed taxes and insurance) (Round to the nearest dollar as needed) e. Find the total cost of interest over 30 years (Round to the nearest dolar as needed)

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