Suppose mr. johnson wants to buy a new home at sugar land, Ask an Expert

Finance

Mini-Project 1: Mortgage Loan Analysis: Mr. Johnson plans to buy a new house at Sugar Land in June 2010. The sale price of the house is $580,000. He plans to pay 20% down payments and borrow additional 80% from Wells Fargo Bank with a 30-year, 5.25% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from July 2010 for a total of 30 years.

(1) Calculate the required monthly payment for Mr. Johnson.
(2) Construct 2010~2011 amortization table (18 months) for Mr. Johnson.

(1) Mr. Johnson should prepare his 2010 tax filings in early 2011. Please compute the total mortgage interest payments which he can use for his 2010 tax deductions.

View complete question

Corporate Finance, Finance

Category:- Corporate Finance
Reference No.:- M9223073

Have any Question?Write your Review or question?

Related Questions in Corporate Finance

Strategic and financial decision-making referral

Strategic and Financial Decision-making Referral Assignment- The following assignment is based on HYPOTHETICAL scenarios related to Tesco plc. Task 1 - Tesco plc is contemplating introducing a new computer system which i ...

Assignment -topic - recent years have seen rapid

Assignment - Topic - Recent years have seen rapid development in Australia's housing market. The effect of high housing prices on Australian families is enormous. Despite those challenges, you would like to buy 3-bedroom ...

Questions -1 this week we discuss capital budgeting methods

Questions - 1. This week we discuss capital budgeting methods and process. Could you apply the knowledge your learn this week to make better decisions in your personal life or professional duties? Please elaborate your a ...

Question - business performanceassess how business

Question - Business Performance Assess how Business Performance is measured, financially and non-financially, in your organization* and analyze its business performance. Organization is InterContinental Hotels Group (IHG ...

Case - campar industries incthis case is about variance

Case - Campar Industries, Inc. This case is about variance analysis. The purpose of this case is to allow you to break down several different types of variance that might occur in a business. For each of the types of var ...

Assignment - pro forma financial statements external

Assignment - Pro forma financial statements, external capital needs and growth rates Pro-forma financials using percentage of sales method; 1. Obtain financial statements for a company for the last three years. The compa ...

Question - an 8 bond with remaining maturity of 8 years is

Question - An 8% Bond with remaining maturity of 8 years is quoted in the Band Market at 89.33 at current going market interest rate of 10%. If the market interest rate suddenly goes up from 10% t0 15%, the Price of this ...

Assignment -task requirements you have been randomly

Assignment - Task requirements: You have been randomly assigned an Australian publicly listed company (refer to the separate excel spreadsheet provided to identify your company). Using the financial reports for your comp ...

Investment management assignment -in this assignment you

Investment Management Assignment - In this assignment you will be computing bond prices, modified durations and holding period returns. You will also implementing a hedging strategy for a stream of liabilities. Data Desc ...

Question - develop a forecast model for sales through

Question - Develop a forecast model for sales through operating income. Create the forecast in Excel. In a Word document, describe the set of assumptions (ratios) you used, and explain how you justify them. Attachment:- ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Corporate Finance Expert