Unformatted text preview: b. Compute the total revenue per year i. Graph the results. c. Format, rename the worksheet “tarmart”. 3. Insert a new worksheet. a. Compute the monthly payment for a $150,000 loan at interest rates ranging from 4.25% to 8% (.25% increments), with loan periods of 24 and 36 months: i. Create the series of the interest rates in the first column. ii. Insert “Loan period” as the headings for the next two columns. iii.Compute the monthly payments (PMT) for each column. b. Format, rename worksheet “payments”. 4. Save your workbook to: your first name.your last name . GOOD LUCK!...
View Full Document
- Fall '08
- rename worksheet, Open worksheet