Mini-Project 1: Mortgage Loan Analysis
Not what you're looking for?
Mini-Project 1: Mortgage Loan Analysis: Mr. and Mrs. Smith plan to buy a house in Los Angeles in October, 2010. The purchase price of the house is $580,000. They plan to pay 20% down payment and borrow the remaining 80% from ABC Bank with a 15-year, 4% fixed-rate mortgage loan. They are expected to pay an equal MONTHLY payment starting from November 1, 2010 for a total of 15 years.
(1) Calculate the required monthly payment for the Johnsons.
(2) Construct a 2010-2011 amortization table till the end of December, 2011.
(3) Compute the total mortgage interest payments which the Johnsons can use on their 2010 tax deductions.
Purchase this Solution
Solution Summary
I showed you how to complete it in Excel. I did the full amortization schedule so you can see it being paid off exactly to the penny. The formulas are in the cells.
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)