Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6. Income and expense statement Stan and Julie Wallace have been married for over two years. They have been trying to save for a down

6. Income and expense statement

Stan and Julie Wallace have been married for over two years. They have been trying to save for a down payment on a house, but they feel that there is never anything left over to save. They talked with their parents who suggested that they prepare an income and expense statement.

Stan and Julie put together the following worksheet.

Worksheet

Car payment $ 315 Savings account interest $ 28
Stans commission 3,000 School loan 165
Commuter train pass (year) 3,300 Taxes
Nike dividend 116 Stan 3,600
Renters Insurance (year) 330 Julie 3,420
Dallas Power & Light bill 110 Wages & salaries
U.S. Cellular bill 105 Stan 20,000
Rent 550 Julie 19,000

The following is some additional information.

For income items, they knew yearly amounts. For expenses, in some cases they knew the annual amount (for example, Julies commuter train pass). They listed those amounts and noted them as such.
Unfortunately, for other expenses, they provided last months payment, stating that the amount didnt change much from month to month.
Based on their employer-provided health insurance, they incur a copay of $20 per visit. They estimated that they saw the doctor (combined) 4 times during the year.
Julie estimated that she spends about $200 a month on clothing and $220 a month on groceries.
They went on a Carnival Cruise trip that cost $1,975. They took an additional $500 in spending money. That was their only vacation.

Prepare an annual income and expense statement for the Wallaces as of December 31. Round all dollar amounts to the nearest whole dollar, and do not include an item in another category if a category already exists for it. If an item does not require a balance, be sure to insert a zero to avoid a loss of credit for the particular item.

Income and Expense Statement

Name(s): Stan and Julie Wallace

For the: Year | Ended: December 31, 20XX

Income Dollars
Wages and salaries Name: Stan Wallace $20,000
Name: Julie Wallace

Bonuses and commissions Stans commission 3,000
Investment income Nike dividend received 116
Savings account

(1) Total Income:

Expenses
Housing Rent or mortgage payment (include insurance and taxes, if applicable) 6,600
Utilities Gas, electric, water

Phone 1,260
Food Groceries 2,640
Transportation Public transportation 3,300
Auto loan

Medical Health, major medical, disability insurance (payroll deductions are not provided by employer) 80
Clothing Clothes, shoes, and accessories 2,400
Insurance Rental or homeowners insurance (if not covered by mortgage payment) 330
Taxes Stans income and Social Security

Julies income and Social Security 3,420
Recreation and entertainment Vacations 2,475
Other School loan 1,980
(2) Total Expenses:

Cash Surplus or Deficit (12):

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Regulation Audit Inspection Standards And Risk A Handbook For Street Level Regulators

Authors: John E Brady, Amy J Brady

1st Edition

0993082238, 978-0993082238

More Books

Students also viewed these Accounting questions

Question

Ensure continued excellence in people management.

Answered: 1 week ago

Question

Enhance the international team by recruiting the best people.

Answered: 1 week ago