Excel 2013 Assignment 3

digital instructions steps 11-12.docx

11. Adelita’s grandmother plans to make a special gift of $750 on Adelita’s 18th birthday. Enter this value in cell H30 as a positive cash flow in place of the usual $150 contribution.

12. College tuition is projected to be due on August 15 of each year. In cell H34, calculate the value of the first year of college under the inflation rate suggested in cell B11, the year value in cell E33, and current one-year cost in cell B10. The value should appear as a negative cash flow.