Econ 223

PERSONAL FINANCE

Assignment 6

(November 2)

Purpose: Estimate your family’s expenses. Compare your family's expenses to the income that you family has available to spend & invest (from line 54 of your Prototype Summary worksheet). Decide how your family pays for things (e.g., cash, debit cards, credit cards, direct debit). Decide how your family will finance things they do not pay for in full? 

Resources: Kobliner  Chapters 2, 3, 4, 7 & 8, Gulley & Witte presentations--Purchasing I, Purchasing Insurance (in the folder with Purchasing I) & Purchasing II in the First Class conference, the Consumer Expenditure Survey and Table 706 (Cost of Living Index--Selected Metropolitan Areas) of the US Statistical Abstract. Note: Table 706 is also available in the "Purchasing I" presentation folder.

    For this assignment, you will complete all sections of the “Expenses” worksheet using the Prototype Spreadsheet Template in the "Prototype" folder in the First Class conference as a guide & draft the expenses section of your final paper.  

    Begin your spreasheet work by eliminating expenses that are not relevant to your prototype from your Expenses worksheet. Next add  expenses incurred by your family that  are not listed in the Expenses worksheet.  Next, incorporate the Expenses worksheet in the Master spreadsheet for your family.     

You will use the Consumer Expenditure Survey (CEX) and Table 706 to estimate some expenses and will actually research and make your own estimates of other expenses.

    Begin by selecting (1) one "Day-to-Day Purchase" (see Slide 4 of the "Purchasing I" presentation), (2)  the package of recurrent items to purchase (see Slide 5 of the "Purchasing I" presentation ) and (3) one type of "Occasional Purchase" (see Slide 6 "Purchasing I" presentation). You should actually do research to determine how much your prototype will pay for these three types of purchases & you are required to use Consumer Reports to help you decide on one purchase. Record these three purchases in your Prototype’s Expenses Worksheet (e.g., annualizing your “recurrent” purchases, as well as your “day-to-day” purchases and placing your “occasional" purchase in a relevant category (e.g., Dining Out, Personal Care Products & Services)).

    For each of these three purchases, you should describe the family's goals for that purchase, the family's decision-making process, including how the family decided to pay for/finance the purchase, and the final cost of the purchase in your draft write up.

    You should also do research to estimate how much your prototype will spend for housing. Enter your cost estimates for all housing items in the Expenses worksheet. Will they rent or own their own home?  What housing expenses in addition to a rent or mortgage payment will they have?  You should describe your family’s goals for housing, including how they decided to pay for or finance their housing in your draft write up. 

    To estimate all other expenses for your family’s Expenses Worksheet, you may use the Consumer Expenditure Survey and Table 706 of the Statistical Abstract. First, you will get an estimate of expenditures for typical US families with pre-tax incomes like your prototype family from the CEX. Click here to see how to do this.

    Next you will adjust these estimates to reflect the cost of living in the metropolitan area where your family lives. Click here to see how to do this.

    Finally, you should apply “common sense” to your expense estimates, and make any changes necessary to better reflect your family’s spending, noting the reason for such in the “Comments” section of your expenses worksheet (e.g., a female prototype might use spa services more frequently then estimated using CEX and Table 706)

        Compare your families expenditures to the income they have available to spend & invest. Can your family “afford” to spend the way they do? Calculate your family's "Investable Income" & put it in row 83 of your expenses worksheet.

    Add a row named "Investable Income" after the row 54 in the Prototype Summary worksheet for your family. Link column B of this new row to the  "Investable Income" number in row 83 of your expenses worksheet.

    Be sure to evaluate (using the RITE system) all websites that you use except those that are obviously the place to get the information (e.g., Verizon for Verizon telephony) or are not linked to course material (including Betty's web page for the course). You should only use high quality web sites. (Not using websites is not advisable!)