Mortgage loan analysis mr. johnson plans to buy a new house, Ask an Expert

Finance

Please show work in Excel along with a detailed written explanation of your findings typed in word format.

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) find out 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

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M928304

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Assignment -the aim of the first assessment item is

Assignment - The aim of the first assessment item is exploratory, showing in-depth understanding and comprehension of a given topic and key concepts. It aims to test your ability to digest and explain complex issues and ...

The following data have been acquired for the sampp 500 and

The following data have been acquired for the S&P 500 and an index of Russian stocks: Year Market Return Russia 1998 27% 25% 1997 12% 5% 1996 -3% -5% 1995 12% 15% 1994 -3% -10% 1993 27% 30% Does it make sense to add an i ...

Specifically share one clearly defined financial goal along

Specifically, share one clearly defined financial goal along with several specific objectives to help you achieve it. Remember effective goals and objectives are SMART What are some resources you may need to help you ach ...

Question - phone ltd plans to open an outlet at a shopping

Question - Phone Ltd plans to open an outlet at a shopping mall. The investment requires an initial outlay of $90,000 which is expected to be financed through a bank loan. A discussion with the mall management reveals th ...

What are the steps in the typical marketing research

What are the steps in the typical marketing research design/process? Name and define each step.

Suppose that 5 years ago cisco systems sold a 15-year bond

Suppose that 5 years ago Cisco Systems sold a 15-year bond issue that had a $1,000 per value and a 7% coupon rate. Interest is paid semiannually. a. If the going interest rate has risen to 10%, at what price would the bo ...

Miletus bronze works has an outstanding bond that pays 964

Miletus Bronze Works has an outstanding bond that pays 9.64 percent interest. You are in the 37 percent tax bracket. What is your aftertax yield (in percents) on this bond?

What is marketing discipline what is most peoples

What is marketing discipline? What is most people's perception of marketing discipline? Name an organization that has done a great job marketing. What did they do to make you feel this way?

Winston and keesha have been married for a year and are

Winston and Keesha have been married for a year and are starting to establish their decision-making styles as a couple. Keesha enjoys shopping and likes to browse the grocery store aisles rather than using a list. While ...

A client has identified two annuities that are available

A client has identified two annuities that are available for purchase, The first annuity pays $1,000 at the end of each month over a 3-year period at a nominal rate of 13% p.a. The second annuity pays $3,000 at the end o ...

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 Basic Finance Expert