This preview shows page 1. Sign up to view the full content.
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