This means that she did not meet her Vehicle savings goal and will also have to

This means that she did not meet her vehicle savings

This preview shows page 2 - 3 out of 3 pages.

Expenses category a -$225 and that will still leave her with a deficit. This means that she did not meet her Vehicle savings goal and will also have to borrow from her Emergency account to balance the cash flow to zero. In the next part of the case study you will examine Sarah’s budget performance for the month of March. Part IV – Sarah Hilliard’s March Budget Challenge So far we have balanced the February’s Actual cash flow to zero after we realized that Sarah had a deficit by the end of the month. In Part IV we now go on to see how Sarah’s March budget turned out. Your template has a March budget ready to go with the following transactions missing from March 23 rd and on. After you have carefully entered in these transactions as listed above, you will notice that her cash flow results in a “surplus” even after you subtract her rent from her Living Expenses. This is because Sarah was a little more careful regarding her personal expenses over the month of March and also because her “Other Income” matched her $125 goal. Make sure that she achieves her goal on the vehicle down payment and then place the remaining surplus into her “Emergency” account. This will bring the cash flow to zero. Also, don’t forget to take a moment to retitle the February labels to “March”. Ponder / Prove   __________________________________________________________________________________ You will be asked some straight-forward questions in the I-Learn spreadsheet assessment regarding your results in the March budget as well as to type a brief reflection paragraph on insights you have gained during this portion of the spreadsheet experience.
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Fall '11
  • Dumar
  • Math, Brigham Young University, Sarah Hilliard, I-Learn spreadsheet assessment

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture