Mr. Johnson plans to buy a new house at Sugar Land in October 2011. 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, 4.25% fixed-rate mortgage loan. He is expected to pay an equl MONTHLY payment starting from December 2011 for a total of 30 years.
Construct 2011-2013 amortization table (25 months) for Mr. Johnson