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:

Robyn's salary	$52,000
Reimbursement for travel expenses	2,200
Interest on:
Savings account	110
Certificates of deposit	70
Groceries	4,150
Rent	9,300
Utilities	960
Gas and auto expenses	650
Matthew's tuition, books, and supplies	3,300
Books, magazines, and periodicals	280
Clothing and other miscellaneous expenses	2,800
Cost of photographic equipment purchased with charge card	2,200
Amount paid this year on photographic equipment	1,600
Robyn's travel expenses	1,950
Purchase of a used car (cost)	9,750
Outstanding loan balance on car	7,300
Purchase of bonds in Verizon Communications Inc.	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

$

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 other major purchases	Loan payments
	Purchases and repairs
Personal care	Laundry, cosmetics, hair care
Recreation and entertainment	Vacations
	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)]

$