John Doe has just been offered a home loan towards purchase of house that is being sold for $230,000. He will be required to make a 15% down payment, as well as mortgage processing fees and closing costs of $3,000. The loan has to be paid off in monthly payments over a 30-year period at a fixed interest rate of 4% per year compounded monthly. He will also be required to pay an additional $92 per month as mortgage insurance. Using Excel, answer the following questions: (a) The monthly mortgage payment is $ (enter as a positive number to the nearest dollar) (b) The total monthly payment is $. (enter as a positive number to the nearest dollar) (c) The nominal APR is % (to the nearest 2 decimal places) % (to the nearest 2 decimal places) (d) Over the 30-year period, the total amount of interest paid on the loan is $ The effective APR is (enter as a positive number to the nearest dollar). (e) The interest amount in the month 54 payment is $ (enter as a positive number to the nearest dollar) The principal amount in the month 54 payment is $ (enter as a positive number to the nearest dollar) (f) The balance on the loan immediately after making the payment at the end of month 54 is $ (enter as a positive number to the nearest dollar)
John Doe has just been offered a home loan towards purchase of house that is being sold for $230,000. He will be required to make a 15% down payment, as well as mortgage processing fees and closing costs of $3,000. The loan has to be paid off in monthly payments over a 30-year period at a fixed interest rate of 4% per year compounded monthly. He will also be required to pay an additional $92 per month as mortgage insurance. Using Excel, answer the following questions: (a) The monthly mortgage payment is $ (enter as a positive number to the nearest dollar) (b) The total monthly payment is $. (enter as a positive number to the nearest dollar) (c) The nominal APR is % (to the nearest 2 decimal places) % (to the nearest 2 decimal places) (d) Over the 30-year period, the total amount of interest paid on the loan is $ The effective APR is (enter as a positive number to the nearest dollar). (e) The interest amount in the month 54 payment is $ (enter as a positive number to the nearest dollar) The principal amount in the month 54 payment is $ (enter as a positive number to the nearest dollar) (f) The balance on the loan immediately after making the payment at the end of month 54 is $ (enter as a positive number to the nearest dollar)
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
Related questions
Concept explainers
Question
Transcribed Image Text:John Doe has just been offered a home loan towards purchase of house that is being sold for $230,000. He will be required to make a 15% down payment, as well as
mortgage processing fees and closing costs of $3,000. The loan has to be paid off in monthly payments over a 30-year period at a fixed interest rate of 4% per year
compounded monthly. He will also be required to pay an additional $92 per month as mortgage insurance. Using Excel, answer the following questions:
(a) The monthly mortgage payment is $. (enter as a positive number to the nearest dollar)
(b) The total monthly payment is $. (enter as a positive number to the nearest dollar)
(c) The nominal APR is
% (to the nearest 2 decimal places)
The effective APR is
% (to the nearest 2 decimal places)
(d) Over the 30-year period, the total amount of interest paid on the loan is $
(enter as a positive number to the nearest dollar).
(e) The interest amount in the month 54 payment is $
(enter as a positive number to the nearest dollar)
The principal amount in the month 54 payment is $
(f) The balance on the loan immediately after making the payment at the end of month 54 is $
(enter as a positive number to the nearest dollar)
(enter as a positive number to the nearest dollar)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
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