Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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%,

image text in transcribedimage text in transcribedimage text in transcribed

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 1. Interest and dividend income will conservatively be the same in 2017 as it was in 2016 and will be received on a monthly basis. Mortgage payments will be the same in 2017 as they were in 2016. Federal income taxes are estimated at 20%, state income taxes at 6%, and social security taxes at 7.65% of wages, including Deon's bonus. Property insurance and property taxes are paid every six months, in June and December. The amount is expected to be the same in 2017 as it was in 2016. . May will contribute $60 per week for the employee portion of their medical insurance. Auto insurance is paid at the end of each calendar quarter and should not be more than it was in 2016. Deon and May would like to purchase a new car in the next few years and will put $500 a month away specifically for that purpose. Deon and May don't expect the amount of variable expenses to change in 2017 except that they would like to double their charitable contributions. Gift purchases are made mostly around the holidays, so Deon and May are planning to pay half of the gift expense in December and half in January when the credit card bill comes in. Water and sewer is billed quarterly, in January, April, July, and October. The cost of heat should be spread over six months from November to April. All other variable expenses can be spread evenly every month at 2016 amounts. Use the information from their cash-flow statement (listed in the first column of the following annual budget) and their budget assumptions to fill in the missing amounts for the first six months of Deon and May's monthly budget for 2017. (Note: Be sure to fill in every blank space with a value. Round each answer to the nearest dollar.) Name: Deon and May Daley Cash-Flow Statement 2017 2016 Jan. Feb. Mar. INCOME 58,000 5,075 5,075 5,075 Deon's salary May's salary 52,200 4,481 4,481 4,481 Deon's Bonus 5,000 0 0 Interest and dividends 150 13 13 13 Total Income $115,350 $9,569 $9,569 EXPENDITURES Fixed Expenses 14,208 1,184 1,184 1,184 Mortgage Deon's federal income taxes 12,600 1,015 1,015 3,780 305 305 Deon's state income taxes Deon's social security taxes 4,820 388 388 10,440 896 896 896 May's federal income taxes May's state income taxes May's social security taxes 3,132 269 269 269 3,993 343 343 343 4,600 0 0 0 Property taxes Property insurance 1,200 0 0 0 Medical insurance 2,400 240 240 240 700 0 0 Automobile insurance and registration Savings for auto purchase 500 500 500 $61,873 $5,140 Total Fixed Expenses Variable Expenses Food 1,896 158 158 158 Entertainment 3,000 250 250 250 Dining out 4,700 392 392 392 Electric 350 29 29 29 Water and sewer 800 0 0 1,250 208 208 208 Heat Cable TV 3,000 250 250250 250 Telephone 600 50 50 50 Cell phone 900 75 75 75 Gifts 2,000 Personal care 600 50 50 50 Medical expenses 3,700 308 308 308 Vehicle gas and maintenance 2,530 211 211 211 1,500 250 250 250 Charitable contributions Vacation $26,826 $2,231 $2,231 Total Variable Expenses Total Expenses SURPLUS (DEFICIT) $88,699 $7,371 $7,546 $26,651 $2,198 $2,023 Deon and may have an emergency fund of $40,000. They would like to start saving for retirement, but they have not signed up for their companies' 401(k) plans. Neither company matches 401(k) contributions. What do you suggest for Deon and May based on their goals and the budget that they have put together? The $40,000 that the Daleys have saved for an emergency is three months of expenses. They have not, however, taken advantage of the employer 401(k) plans that are available to them. If an employer does not match contributions, it is advantageous to contribute to a company-sponsored retirement savings plan because the contributions to the plan are invested with earnings. If the Daleys invest part of their surplus in their 401(k) plans, they will save the designated amount plus another of that amount because of the tax savings. 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 1. Interest and dividend income will conservatively be the same in 2017 as it was in 2016 and will be received on a monthly basis. Mortgage payments will be the same in 2017 as they were in 2016. Federal income taxes are estimated at 20%, state income taxes at 6%, and social security taxes at 7.65% of wages, including Deon's bonus. Property insurance and property taxes are paid every six months, in June and December. The amount is expected to be the same in 2017 as it was in 2016. . May will contribute $60 per week for the employee portion of their medical insurance. Auto insurance is paid at the end of each calendar quarter and should not be more than it was in 2016. Deon and May would like to purchase a new car in the next few years and will put $500 a month away specifically for that purpose. Deon and May don't expect the amount of variable expenses to change in 2017 except that they would like to double their charitable contributions. Gift purchases are made mostly around the holidays, so Deon and May are planning to pay half of the gift expense in December and half in January when the credit card bill comes in. Water and sewer is billed quarterly, in January, April, July, and October. The cost of heat should be spread over six months from November to April. All other variable expenses can be spread evenly every month at 2016 amounts. Use the information from their cash-flow statement (listed in the first column of the following annual budget) and their budget assumptions to fill in the missing amounts for the first six months of Deon and May's monthly budget for 2017. (Note: Be sure to fill in every blank space with a value. Round each answer to the nearest dollar.) Name: Deon and May Daley Cash-Flow Statement 2017 2016 Jan. Feb. Mar. INCOME 58,000 5,075 5,075 5,075 Deon's salary May's salary 52,200 4,481 4,481 4,481 Deon's Bonus 5,000 0 0 Interest and dividends 150 13 13 13 Total Income $115,350 $9,569 $9,569 EXPENDITURES Fixed Expenses 14,208 1,184 1,184 1,184 Mortgage Deon's federal income taxes 12,600 1,015 1,015 3,780 305 305 Deon's state income taxes Deon's social security taxes 4,820 388 388 10,440 896 896 896 May's federal income taxes May's state income taxes May's social security taxes 3,132 269 269 269 3,993 343 343 343 4,600 0 0 0 Property taxes Property insurance 1,200 0 0 0 Medical insurance 2,400 240 240 240 700 0 0 Automobile insurance and registration Savings for auto purchase 500 500 500 $61,873 $5,140 Total Fixed Expenses Variable Expenses Food 1,896 158 158 158 Entertainment 3,000 250 250 250 Dining out 4,700 392 392 392 Electric 350 29 29 29 Water and sewer 800 0 0 1,250 208 208 208 Heat Cable TV 3,000 250 250250 250 Telephone 600 50 50 50 Cell phone 900 75 75 75 Gifts 2,000 Personal care 600 50 50 50 Medical expenses 3,700 308 308 308 Vehicle gas and maintenance 2,530 211 211 211 1,500 250 250 250 Charitable contributions Vacation $26,826 $2,231 $2,231 Total Variable Expenses Total Expenses SURPLUS (DEFICIT) $88,699 $7,371 $7,546 $26,651 $2,198 $2,023 Deon and may have an emergency fund of $40,000. They would like to start saving for retirement, but they have not signed up for their companies' 401(k) plans. Neither company matches 401(k) contributions. What do you suggest for Deon and May based on their goals and the budget that they have put together? The $40,000 that the Daleys have saved for an emergency is three months of expenses. They have not, however, taken advantage of the employer 401(k) plans that are available to them. If an employer does not match contributions, it is advantageous to contribute to a company-sponsored retirement savings plan because the contributions to the plan are invested with earnings. If the Daleys invest part of their surplus in their 401(k) plans, they will save the designated amount plus another of that amount because of the tax savings

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 Finance questions