solve through excel

REAL-TIME DATA ANALYSIS ere are dozens of Web sites that provide calculators to help with personal financial isions. Two good examples are www.smartmoney.com and finance.yahoo.com. (Note: both calculators the annual rate of interest is quoted as 12 times the monthly rate.) - Amortizing loans Suppose that you take out a 30-year mortgage loan of $200,000 at an interest rate of 10%. a. What is your total monthly payment? b. How much of the first month's payment goes to reduce the size of the loan? C. How much of the payment after two years goes to reduce the size of the loan? Visit us at www.mhhe.com We've updated our read aloud featurel Give it a try here