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)
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 27M
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
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College