Question

Deon and Keyshia wallace have been married for two years. They have been trying to save but feel that there is never anything leftover after expenses. Keyshia 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 Deon and Keyshia provided plus the additional information to fill in the missing amounts on the Wallaces cash-flow statement for the year ended December 31, 2016. Cash-Flow Statement Deon and Keyshia put together the following worksheet. Name: Deon and Keyshia wallace Date: For the year ended December 31, 2016 Cash received & income taxes: Deons salary Keyshias salary Deons bonus P&G dividend Cash payments: $26,250 Rent $1,300 113 900 410 14 Auto insurance (year) 225 150 71 Dollars Percent 24,938 School Loan INCOME Deons salary Keyshias salary Deons Bonus Interest and dividends Total Income Train pass (year) Car loan payment 3,938 17 Savings interest Income taxes: Maine Power 4,725 AT&T 4,489 EXPENDITURES Fixed Expenses Rent expense Deons income taxes Keyshias income taxes Automobile loan payment Education loan Phone Transportation Automobile insurance and registration Lof $35 per visit. They estimated that they saw the doctor (combined) Total fixed expenses Here is some additional information: For income items, they know yearly amounts. For some expenses, they know the annual amount (for example, Keyshias annual commuter-train pass). They listed those amounts and noted them as such Unfortunately, for other expenses, they provided the payment they hem as □ □D ] [ made last month, stating that the amount doesnt change much from ]1 month to month . Based on their employer-provided health insurance, they incur a copay seven times during the year. Deon 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. Keyshia estimated that she spends about $100 a week on groceries and $175 a month on clothing. She never has cash and uses her credit cards for everything They went on a Princess Cruise that cost $2,200; they took an additional $500 for spending. That was their only vacation . Variable Expenses Food Utilities Gasoline and maintenance Vacations clothing Miscellaneous (Deons withdrawals Medical expenses Total variable expenses Total Expenses SURPLUS (DEFICIT) . .

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Below attached is the image with all the calculations done the monthly expenses are multiplied by 12 and weekly expenses are multiplied by 52.

DollarsPercent of Total income Income Deons Salary Keyshias Salary Deons Bonus Interest and Dividends Total Income 26250| 24938| 3938| 31/ 55157| 47.6% 45.2% 7.1% 0.1% 100.0% Expenditures Fixed expenses Rent expense 15600 28.3% -4725 8.6% -4489 8.196 Deons income tax Keyshias income tax Automobile loan payment Education loan Phone Transportation Automobile insurance and registeratior Total fixed expenses -4920 1356 -852 -900 -225 -33067 8.9% 2.5% 1.5% 1.6% 0.4% 60.0% Variable expenses Food Utilities Gasoline and maintenance Vacations Clothing -5200 1800 -3120 -2700 -2100 -5200 -245 -20365 53432| 1725 9.4% 3.3% 5.7% 4.9% 3.8% 9.4% 0.4% 36.9% 96.9% 3.1% Miscellaneous (Deons withdrawal) Medical expenses Total variable expense Total expenses Surplus (Deficit)

Add a comment
Know the answer?
Add Answer to:
Deon and Keyshia wallace have been married for two years. They have been trying to save...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Deon and Keyshia Wallace have been married for two years. They have been trying to save...

    Deon and Keyshia Wallace have been married for two years. They have been trying to save but feel that there is never anything leftover after expenses. Keyshia 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 Deon and Keyshia provided plus the additional information to fill in the missing amounts on the Wallace's cash-flow statement for the year ended December 31,...

  • A Aa 6. Cash-flow statement Prabakar and Gta lain have been married for two years. They...

    A Aa 6. Cash-flow statement Prabakar and Gta lain have been married for two years. They have been trying to save but that there is never anything ever after expenses Gas taking right course on personalance, and she suggested that they prepare show statement for the year ended December 31, 2016 in the missing amounts on the show statement for the year Use the worksheet that Prabakar and Gta provided plus the aditional information to ended December 31, 2016 Catalog...

  • Skip and Jackie Garcia have been married for over two years. They have been trying to...

    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 $ 16 218 $ 410 3,000 4,356 68 Car payment Skip's commission Commuter train pass (year) Apple dividend Renter's Insurance...

  • Assessment activity Chapter 02- Using Financial Statements and Budgets Attention: Due to a bug in Google...

    Assessment activity Chapter 02- Using Financial Statements and Budgets Attention: Due to a bug in Google Chrome, this page may not function correctly, Click here to learn more. 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...

  • A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a...

    A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses.In addition to the cash-flow statement, Deon and May made a list of budget assumptions: . Deon's income will increase by 5%, effective January 1 . His bonus is generally 10% of his income in the previous year, and he receives it in January. . May's raise will be 3%, effective January 1, Interest and dividend...

  • A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a...

    A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses. In addition to the cash-flow statement, Deon and May made a list of budget assumptions, listed for you here: • Deon’s income will increase by 5%, effective January 1. His bonus is generally 10% of his income in the previous year, and he receives it in January. • May’s raise will be 3%, effective January...

  • 9. Preparing a budget Aa Aa A cash-flow budget uses the same format as a cash-flow...

    9. Preparing a budget Aa Aa A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses. In addition to the cash-flow statement, Dan and Lucy made a list of budget assumptions, listed for you here: Dan's income will increase by 5%, effective January 1. His bonus is generally 10% of his income in the previous year, and he receives it January • Lucy's raise will...

  • Income statement preparation Adam and Arin Adams have collected their personal income and expense information and...

    Income statement preparation Adam and Arin Adams have collected their personal income and expense information and have askad you to put togather an income and expansa statemant for the year anded December 31, 2015 The follawing information is received from the Adams family a. Create a personal income and expense statement for the period ended December 31, 2015. It should be similar to a corporate Income statement b. Did the Adams familly have a cash surplus or cash deficit? e....

  • Jamie Lee is reviewing her finances one month later. She has provided the actual amounts pald...

    Jamie Lee is reviewing her finances one month later. She has provided the actual amounts pald below. Use the cash budget table below to help her identify the variances in her budget. Each answer must have a value for the assignment to be complete. Enter any unused categories. for $2,665 $2,665 $2,110 Actual Amounts Income: Gross monthly salary Net monthly salary Savings allocation: Regular savings Ralny-day savings Entertainment Cake decorating class Movies with friends $190 $35 Monthly expenses: Rent obligation...

  • The 2017 and 2016 balance sheets of Wallace Corporation follow. The 2017 income statement is also...

    The 2017 and 2016 balance sheets of Wallace Corporation follow. The 2017 income statement is also provided. WallaceWallace had no noncash investing and financing transactions during 2017. During the​ year, the company sold equipment for $15,300​, which had originally cost $13,600 and had a book value of $11,400. The company did not issue any notes payable during the year but did issue common stock for $35,000. The company purchased plant assets and​ long-term investments with cash. Wallace Corporation Income Statement...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT