Compute the required monthly payment

Reference no: EM1347709

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.

Reference no: EM1347709

Questions Cloud

Major methods of developing advertising budge : Describe the major methods of developing the advertising budget. Make sure you take the position on which method you think is best and why.

Illustrate what effect does current supply and currently : Illustrate what effect does the current supply and currently demand have on this product.

Simulating problem for arriving for lunch at restaurant : Customers for lunch arrive into a restaurant at Exponential rate of 10 per hour for seated service and at Exponential rate of 15 per hour for buffet. Simulate this problem for 8 hours using minutes as the basic time units.

Relationship between fixed-variable costs used in flexible : Describe the relationships between fixed and variable costs employed in flexible budget and the differences between static and flexible budgets?

Compute the required monthly payment : Suppose Mr. Johnson wants to buy a new home at Sugar Land in June 2010. The sale price of the home is $580,000. He considers paying 20 percent down payments. Compute the required monthly payment.

Incentive plan, hiring and training staff : Explain how do you ensure that the new staff gets the appropriate training and How would you ensure that the new staff meets company standards after their training?

Flexible budget analysis and strategic-budget analysis : Why might managers find out a flexible budget analysis more informative than the strategic-budget analysis? Describe your rationale. How might a manager gain insight in the causes of the flexible-budget variance for direct materials?

Illustrate what is likely post- merger bargaining outcome : Suppose the two newspapers merge. Illustrate what is the likely post- merger bargaining outcome.

Relational algebra expressions for names of salespeople : Illustrate relational algebra expressions for names of all salespeople, names of all salespeople having ORDER row and names of salespeople not having ORDER row.

User Account

All Pages