Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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

The fed versus congress should the fed or congress decide

The Fed versus Congress: Should the Fed or Congress decide the fate of large financial institutions that are near bankruptcy?

Yan yan corp has a 5000 par value bond outstanding with a

Yan Yan Corp. has a $5,000 par value bond outstanding with a coupon rate of 5.8 percent paid semiannually and 19 years to maturity. The yield to maturity of the bond is 6.3 percent. What is the dollar price of the bond? ...

One of your classmates is working on an assignment for her

One of your classmates is working on an assignment for her statistics class. She created an online survey to collect student opinions about the college class schedule. She only has time before her engineering class to di ...

The united states exports a substantial amount of scrap

The United States exports a substantial amount of scrap iron and steel to Turkey, China, Canada, and other countries. Why do some U.S. users of scrap iron and steel support a prohibition on these exports?

What is the value of establishing confidence intervals in

What is the value of establishing confidence intervals in making business decisions? Give specific examples.

At the end of 2011 home depots total capitalization

At the end of 2011 Home Depot's total capitalization amounted to $28,992 million. In 2012 debt investors received interest income of $635 million. Net income to shareholders was $4,526 million. (Assume a tax rate of 35%. ...

Explain the changes in m1 and m2 if an individual moves

Explain the changes in M1 and M2, if an individual moves money from a small denomination time deposit to a demand deposit account?

Yur firm shows receivables building faster than sales

Your firm shows receivables building faster than sales. What actions should you take to encourage collections?

1 a 3 year-bond is paying a coupon rate of 10 per year

1. A 3 year-bond is paying a coupon rate of 10% per year semi-annually. The par value of the bond is R1000 and the annual market interest rate is 8%. a) Calculate the price of the bond today and 6 months from now after p ...

Why might a sterilized foreign exchange market intervention

Why might a sterilized foreign exchange market intervention have a greater impact on the exchange rate in times of financial stress than in times of normal market conditions?

  • 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