Excel homework

Note: After 12:50 pm the assignment is considered a day late. See syllabus for late policy.

Instructions: (use formulas or functions unless otherwise noted)

1. Create a model using the 3100 Excel 3 Template Spring 2016 file from D2L.

2. A dealership has four financing scenarios. Each scenario has different down payments, payment periods, interests rates, and car prices.

3. Calculate the down payment for each scenario.

4. Calculate a total loan for each scenario.

5. Use the PMT function to find the monthly payment for each scenario. *

6. Use the PPMT function to calculate the monthly principal for the 1st month for each scenario. *

7. Calculate interest payments for the first month for each scenario.

8. Use CUMPRINC function to find total principal for every year for each scenario. **

9. Use CUMIPMT function to find total interest for every year for each scenario. **

10. Calculate total principal paid and total interest paid for the life of the loan for each scenario.

11. Create a pie chart for total principal paid and total interest paid for each scenario. Use “Scenario N” for the title and “Total Principal Paid” and “Total Interest Paid” for the legends. Data in the pie charts have to show total principal paid and total interest paid as a percentage.

12. Use Page Orientation Landscape. Create a header to include your name (center section), INFS 3100 Spring 2016 (right section), and Excel Assignment # 3 (left section). (Use the header function.)

13. Print a copy of your completed worksheet. (No row or column borders, e.g., A, B, 1, 2)

14. Print a copy of your cell formulas. (To show formulas press: Ctrl ~ OR click: Formulas: Show Formulas on the toolbar)

15. Submit hardcopies of your work. There will be 2 pages. ( Staple the pages together. )

16. Save your file. You may need to use it again for another assignment. (I may also request to see the file electronically.)

* fv = 0 and type = 0 (optional in the formulas; defaults to 0)

** type = 0