Ask Question, Ask an Expert


Ask Basic Finance Expert

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.


Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M928304

Have any Question? 

Related Questions in Basic Finance

Careers in financefinance is an exciting field in need of

Careers in Finance Finance is an exciting field in need of intelligent, skilled people. The job opportunities range from corporate finance; financial planning; investment banking; insurance; and real estate from individu ...

Finance reporton the 4th of october 2016 the reserve bank

Finance Report On the 4th of October 2016, the Reserve Bank of Australia (RBA) board will meet to discuss domestic and global economic conditions and release its monetary policy statement, having decided upon the appropr ...

Stimulative monetary policy during a credit crunch explain

Stimulative Monetary Policy during a Credit Crunch : Explain why a stimulative monetary policy might not be effective during a weak economy in which there is a credit crunch.

Financial statement analysisthe following information

Financial Statement Analysis The following information relates to Harris Corporation. Account Current year Prior year Net sales (all credit) $520,125 $499,500 Cost of goods sold $375,960 $353,600 Gross profit $144,165 $1 ...

Level and structure of interest ratesplease put all of your

Level and Structure of Interest Rates Please put all of your answers and computations on a separate sheet(s). 1. Suppose that the demand and supply of loanable funds can be represented as follows. (Note the interest rate ...

Wholesale hanks hardware had beginning retained earnings of

Wholesale Hank's Hardware had beginning retained earnings of $18,670. During the year, the company paid dividends of $2,050, and reported total sales of $203,846. Their tax rate is 35 percent. For the year, costs were $8 ...

You are running a hot internet company analysts predict

You are running a hot Internet company. Analysts predict that its earnings will grow at 20 % per year for the next five years. After that, as competition increases, earnings growth is expected to slow to 6% per year and ...

You want to have an 80000 college fund in 14years how much

You want to have an$ 80,000 college fund in 14years. How much will you have to deposit now under the scenario below. Assume that you make no deposits into the account after the initial deposit. An APR of 6%compounded dai ...

Your firm needs a computerized machine tool lathe which

Your firm needs a computerized machine tool lathe which costs $60,000 and requires $13,000 in maintenance for each year of its 3-year life. After three years, this machine will be replaced. The machine falls into the MAC ...

Describe how data can be interpreted differentlyexplain how

Describe how data can be interpreted differently. Explain how and why data is scrubbed. Describe three different ways to communicate data.

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate