| To complete this assignment, perform the following tasks: |
| 1. Data has been provided for you to generate a payment for each of the two products to help determine which product is feasible for you to purchase for school purposes. Click here to access the data. |
| 2. The loan parameters have been entered into the worksheet. Click in cells B8 and E8 to calculate the amount to finance as Price – down payment – rebate. |
| 3. Calculate the payment on B10 and E10. |
| Hint: Click Insert function and select PMT for payment. |
| Save the workbook as “FirstInitial_LastName_Purchase_solution.xlsx” Merge and center the titles in Cells A1:E1. Format your worksheet by including color as well as providing an appropriate clip art to accent the document. Indent the content in cells A9:A14 and show the Payment amount in font size 14. Indent the content in cells D9:D14 and show the Payment amount in font size 14. Save the School Computer Purchase Analysis spreadsheet. Submit the School Computer Purchase Analysis spreadsheet. |
Categories: