Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Skip and Jackie Garcia have been married for over two years. They have been trying to save for a down payment on a house, but
Skip and Jackie Garcia 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. Skip and Jackie put together the following worksheet. Worksheet Car payment $ 315 Savings account interest $ 16 Skip's commission 3,375 School loan 165 3,300 Taxes Commuter train pass (year) Proctor & Gamble dividend 68 Skip 4,050 Renter's Insurance (year) 330 Jackie 3,848 Rocky Mountain Power bill 110 Wages & salaries AT&T bill 105 Skip 22,500 Rent 550 Jackie 21,375 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, Jackie's commuter train pass). They listed those amounts and noted them as such. . Unfortunately, for other expenses, they provided last month's payment, stating that the amount didn't change much from month to month. Based on their employer-provided health insurance, they incur a copay of $15 per visit. They estimated that they saw the doctor (combined) 3 times during the year. Jackie estimated that she spends about $200 a month on clothing and $220 a month on groceries. They went on a Princess Cruise trip that cost $2,200. They took an additional $500 in spending money. That was their only vacation. Prepare an annual income and expense statement for the Garcias as of December 31. Round all dollar amounts to the nearest whole dollar, and do not Assignment: Chapter 02 Using Financial Statements and Budgets For income items, they knew yearly amounts. For expenses, in some cases they knew the annual amount (for example, Jackie's commuter train pass). They listed those amounts and noted them as such. . Unfortunately, for other expenses, they provided last month's payment, stating that the amount didn't change much from month to month. Based on their employer-provided health insurance, they incur a copay of $15 per visit. They estimated that they saw the doctor (combined) 3 times during the year. Jackie estimated that she spends about $200 a month on clothing and $220 a month on groceries. They went on a Princess Cruise trip that cost $2,200. They took an additional $500 in spending money. That was their only vacation. Prepare an annual income and expense statement for the Garcias 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. . Dollars $22,500 Income and Expense Statement Name(s): Skip and Jackie Garcia For the Year Ended: December 31, 20xx Income Wages and salaries Name: Skip Garcia Name: Jackie Garcia Bonuses and commissions Skip's commission Investment income Proctor & Gamble dividend received Savings account (1) Total Income: Expenses 3,375 68 S Housing 6,600 Utilities 1,260 Food 2,640 Transportation 3,300 Medical 45 Rent or mortgage payment (include insurance and taxes, if applicable) Gas, electric, water Phone Groceries Public transportation Auto loan Health, major medical, disability insurance (payroll deductions are not provided by employer) Clothes, shoes, and accessories Rental or homeowner's insurance (if not covered by mortgage payment) ) Skip's income and Social Security Jackie's income and Social Security Vacations School loan Clothing 2,400 330 Insurance Taxes 3,848 2,700 1,980 Recreation and entertainment Other (2) Total Expenses: Cash Surplus or Deficit (1- 2): $ $ Grade It Now Save & Continue Continue without saving
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started