Deon and Keyshia Wallace have been married for two years. They have been trying to save...

Transcribed Image Text:

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, 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.) Deon and Keyshia put together the following worksheet. Cash received & income taxes: Deon's salary Keyshia's salary Deon's bonus IBM dividend Savings interest Income taxes: Deon Keyshia $27,500 26,125 4,125 17 14 4,950 4,703 Cash payments: Rent School Loan Train pass (year) Car loan payment Auto insurance (year) Central Maine Power T-Mobile $1,382 218 900 315 435 290 138 Here is some additional information: • For income items, they know yearly amounts. For some expenses, they know the annual amount (for example, Keyshia'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 $30 per visit. They estimated that they saw the doctor (combined) 6 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 $200 a month on clothing. She never has cash and uses her credit cards for everything. • They went on a Norwegian Cruise that cost $1,750; they took an additional $500 for spending. That was their only vacation. Name: Deon and Keyshia Wallace Date: For the year ended December 31, 2016 INCOME Deon's salary Keyshia's salary Deon's bonus Interest and dividends Total Income EXPENDITURES Fixed Expenses Rent expense Deon's income taxes Keyshia's income taxes Automobile loan payment Education loan Phone Transportation Automobile insurance and registration Total fixed expenses Cash-Flow Statement $ $ Dollars 27,500 26,125 4,125 4,950 4,703 900 435 Variable Expenses Food Utilities Gasoline and maintenance Vacations Clothing Miscellaneous (Deon's withdrawals) Medical expenses Total variable expenses Total Expenses SURPLUS (DEFICIT) $ $ S $5,200 2,250 5,200 180 Based on this cash-flow statement, Deon and Keyshia have a cash flows in and out, their bank balance should have by for the year. This means that if they accounted for all of their cash from December 31, 2015 to December 31, 2016. Total Expenses SURPLUS (DEFICIT) $ 409 $ deficit surplus Based on this cash-flow statement, Deon and Keyshia have a cash flows in and out, their bank balance should have by for the year. This means that if they accounted for all of their cash from December 31, 2015 to December 31, 2016. SURPLUS (DEFICIT) Based on this cash-flow statement, Deon and Key flows in and out, their bank balance should have decreased increased cash by for the year. This means that if they accounted for all of their cash from December 31, 2015 to December 31, 2016. Miscellaneous (Deon's withdrawals) Medical expenses Total variable expenses Total Expenses SURPLUS (DEFICIT) OF $ 5,200 180 Based on this cash-flow statement, Deon and Keyshia have a cash flows in and out, their bank balance should have by $57,781 $31 327 $1,750 for the year. This means that if they accounted for all of their cash from December 31, 2015 to December 31, 2016. 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, 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.) Deon and Keyshia put together the following worksheet. Cash received & income taxes: Deon's salary Keyshia's salary Deon's bonus IBM dividend Savings interest Income taxes: Deon Keyshia $27,500 26,125 4,125 17 14 4,950 4,703 Cash payments: Rent School Loan Train pass (year) Car loan payment Auto insurance (year) Central Maine Power T-Mobile $1,382 218 900 315 435 290 138 Here is some additional information: • For income items, they know yearly amounts. For some expenses, they know the annual amount (for example, Keyshia'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 $30 per visit. They estimated that they saw the doctor (combined) 6 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 $200 a month on clothing. She never has cash and uses her credit cards for everything. • They went on a Norwegian Cruise that cost $1,750; they took an additional $500 for spending. That was their only vacation. Name: Deon and Keyshia Wallace Date: For the year ended December 31, 2016 INCOME Deon's salary Keyshia's salary Deon's bonus Interest and dividends Total Income EXPENDITURES Fixed Expenses Rent expense Deon's income taxes Keyshia's income taxes Automobile loan payment Education loan Phone Transportation Automobile insurance and registration Total fixed expenses Cash-Flow Statement $ $ Dollars 27,500 26,125 4,125 4,950 4,703 900 435 Variable Expenses Food Utilities Gasoline and maintenance Vacations Clothing Miscellaneous (Deon's withdrawals) Medical expenses Total variable expenses Total Expenses SURPLUS (DEFICIT) $ $ S $5,200 2,250 5,200 180 Based on this cash-flow statement, Deon and Keyshia have a cash flows in and out, their bank balance should have by for the year. This means that if they accounted for all of their cash from December 31, 2015 to December 31, 2016. Total Expenses SURPLUS (DEFICIT) $ 409 $ deficit surplus Based on this cash-flow statement, Deon and Keyshia have a cash flows in and out, their bank balance should have by for the year. This means that if they accounted for all of their cash from December 31, 2015 to December 31, 2016. SURPLUS (DEFICIT) Based on this cash-flow statement, Deon and Key flows in and out, their bank balance should have decreased increased cash by for the year. This means that if they accounted for all of their cash from December 31, 2015 to December 31, 2016. Miscellaneous (Deon's withdrawals) Medical expenses Total variable expenses Total Expenses SURPLUS (DEFICIT) OF $ 5,200 180 Based on this cash-flow statement, Deon and Keyshia have a cash flows in and out, their bank balance should have by $57,781 $31 327 $1,750 for the year. This means that if they accounted for all of their cash from December 31, 2015 to December 31, 2016.

Answer rating: 100% (QA)

ANSWER have a ... View the full answer