Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

6. Cash-flow statement Skip and Jackie Parker have been married for two years. They have been trying to save but feel that there is never

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
6. Cash-flow statement Skip and Jackie Parker have been married for two years. They have been trying to save but feel that there is never anything leftover after expense Jackie is taking a night course on personal finance, and she suggested that they prepare a cash-flow statement for the year ended December 31, 2016. Use the worksheet that Skip and Jackie provided plus the additional information to fill in the missing amounts on the Parker's cash-flow statement fo the year ended December 31, 2016. (Note: Round percentages to one decimal place, and dollar amounts to the nearest whole dollar. If your answer Is negative, use a minus sign.) Skip and Jackie put together the following worksheet. E7 nited Cash received & income taxes: Cash payments: Rent $1,407 113 Skip's salary Jackie's salary Skip's bonus Apple dividend Savings interest $28,000 26,600 4,200 20 900 315 School Loan Train pass (year) Car loan payment Auto insurance (year) Puget Sound Energy Vonage 17 225 Income taxes 150 SKO Jackie 71 5,040 4,788 Here is some additional information: For income items, they know yearly amounts. For some expenses, they know the annual amount (for example, Jackie's annual commuter-train pass). They listed those amounts and noted them as such. . Unfortunately, for other expenses, they provided the payment they made last month, stating that the amount doesn'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. Skip estimated that he spends about $60 a week on gas and maintenance for their two cars, and he takes out $100 for spending money every week. Jackie estimated that she spends about $100 a week on groceries and $200 a month on clothing. She never has cash and uses her credit cares for everything. They went on a Disney Cruise that cost $1,975; they took an additional $500 for spending. That was their only vacation. Cash-Flow Statement Name: Skip and Jackie Parker Date: For the year ended December 31, 2016 Dollars Dollars INCOME bols 28,000 26,600 4,200 37 58,837 Os Skip's salary Jackie's salary Skip's bonus Interest and dividends Total Income EXPENDITURES Fixed Expenses Rent expense Skip's income taxes Jackie's income taxes Automobile ton payment Education loan os 1,407 FREE 7- Inlimited nited 5,040 4,788 315 113 Phone 71 re 900 Transportation Automobile insurance and registration Total fixed expenses Variable Expenses 225 $ 12,859 Food Utilities $5,200 150 Gasoline and maintenance 160 315 113 71 900 Automobile loan payment Education loan Phone Transportation Automobile insurance and registration Total fixed expenses Variable Expenses Food 225 $ 12,859 $5,200 Utilities 150 Gasoline and maintenance 160 2,475 200 5,200 Vacations Clothing Miscellaneous (Skip's withdrawals) Medical expenses Total variable expenses Total Expenses SURPLUS (DEFICIT) $1,975 $ $37 5 $ $58,837 4,772 Based on this cash flow statement, Skip and Jackie have a cash in and out, their bank balance should have increased by for the year. This means that if they accounted for all of the from December 31, 2015 to December 31, 2016

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions