Chapter 2 Financial Planning Exercise 4 Preparing personal income and expense statement Use Worksheet 2.2 Robyn and Matthew Scott are about to construct their income and expense statement for the year ending December 31, 2020. Robyn works full time while Matthew is finishing up graduate school. They have put together the following income and expense information for 2020: $49,000 1,800 110 70 4,150 9,900 960 650 Robyn's salary Reimbursement for travel expenses Interest on: Savings account Certificates of deposit Groceries Rent Utilities Gas and auto expenses Matthew's tuition, books, and supplies Books, magazines, and periodicals Clothing and other miscellaneous expenses Cost of photographic equipment purchased with charge card Amount paid this year on photographic equipment Robyn's travel expenses Purchase of a used car (cost) Outstanding loan balance on car Purchase of bonds in Verizon Communications Inc. 3,300 280 2,600 2,200 1,600 1,950 9,750 7,300 4,900 Using the information provided, prepare an income and expense statement for the Scotts for the year ending December 31, 2020 (follow the form shown in Worksheet 2.2). Enter all expense amounts as positive values. INCOME AND EXPENSE STATEMENT Name(s) Robyn and Matthew Scott For the year Ended December 31, 2020 INCOME Wages and salaries Name: Robyn $ Name: Name: Self-employment income Bonuses and commissions Investment income $ Interest received Dividends received Rents received Sale of securities -- Gain or Loss Other: Reimbursement of Robyn's travel expenses $ Pensions and annuities Other income (I) Total Income $ $ $ $ S EXPENSES Housing Rent/mortgage payment (include insurance and taxes, if applicable) Repairs, maintenance, improvements Utilities Gas, electric, water Phone Cable TV and other Food Groceries Dining out Transportation Auto loan payments License plates, fees, etc. Gas, oil, repairs, tires, maintenance Medical Health, major medical, disability insurance (payroll deductions or not provided by employer) Doctor, dentist, hospital, medicines Clothing Clothes, shoes, and accessories Insurance Homeowner's (if not covered by mortgage payment) Life (not provided by employer) Auto Taxes Income and social security Property (if not included in mortgage) Appliances, furniture, and Loan payments other major purchases Purchases and repairs Personal care Laundry, cosmetics, hair care Recreation and Vacations entertainment Other recreation and entertainment Other items Matthew's tuition, books, and supplies Photographic equipment -- amount paid Robyn's travel expenses (II) Total Expenses CASH SURPLUS (OR DEFICIT) ((I)-(II)] $ $ S S $