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: $40,000 2,000 Robyn's salary Reimbursement for travel expenses Interest on: Savings account Certificates of deposit 110 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 4,150 9,600 960 650 3,300 280 3,000 2,200 Amount paid this year on photographic equipment 1,600 Robyn's travel expenses Purchase of a used car (cost) 1,950 9,750 7,300 4,900 Outstanding loan balance on car Purchase of bonds in Verizon Communications Inc. 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 Utilities Food Transportation Rent/mortgage payment (include insurance and taxes, if applicable) Repairs, maintenance, improvements Gas, electric, water Phone Cable TV and other Groceries Dining out Auto loan payments License plates, fees, etc. Gas, oil, repairs, tires, maintenance Health, major medical, disability insurance (payroll deductions or not provided by employer) Doctor, dentist, hospital, medicines Clothes, shoes, and accessories Homeowner's (if not covered by mortgage payment) Life (not provided by employer) Medical Clothing Insurance Auto Taxes Income and social security Appliances, furniture, and other major purchases Property (if not included in mortgage) Loan payments Purchases and repairs Appliances, furniture, and other major purchases Loan payments Purchases and repairs Personal care Laundry, cosmetics, hair care Vacations Recreation and 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) [(1)-(II)] $ $ Grade It Now Save & Continue contin without 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: $40,000 2,000 Robyn's salary Reimbursement for travel expenses Interest on: Savings account Certificates of deposit 110 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 4,150 9,600 960 650 3,300 280 3,000 2,200 Amount paid this year on photographic equipment 1,600 Robyn's travel expenses Purchase of a used car (cost) 1,950 9,750 7,300 4,900 Outstanding loan balance on car Purchase of bonds in Verizon Communications Inc. 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 Utilities Food Transportation Rent/mortgage payment (include insurance and taxes, if applicable) Repairs, maintenance, improvements Gas, electric, water Phone Cable TV and other Groceries Dining out Auto loan payments License plates, fees, etc. Gas, oil, repairs, tires, maintenance Health, major medical, disability insurance (payroll deductions or not provided by employer) Doctor, dentist, hospital, medicines Clothes, shoes, and accessories Homeowner's (if not covered by mortgage payment) Life (not provided by employer) Medical Clothing Insurance Auto Taxes Income and social security Appliances, furniture, and other major purchases Property (if not included in mortgage) Loan payments Purchases and repairs Appliances, furniture, and other major purchases Loan payments Purchases and repairs Personal care Laundry, cosmetics, hair care Vacations Recreation and 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) [(1)-(II)] $ $ Grade It Now Save & Continue contin without