Question: 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

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:

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

. 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 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. According to her pay schedule, April and June are five-week months. 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 and go on a vacation to Ireland in June. The vacation will cost $6,000. 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. Annual Budget Name: Deon and May Daley Cash-Flow Statement 2016 2017 Jan. Feb. Mar. Apr. May Jun. INCOME Deon's salary May's salary Deon's Bonus Interest and dividends Total Income EXPENDITURES Fixed Expenses Mortgage Deon's federal income taxes Deon's state income taxes Deon's social security taxes May's federal income taxes May's state income taxes May's social security taxes Property taxes Property insurance Medical insurance Automobile insurance and registration Savings for auto purchase Total Fixed Expenses Variable Expenses 59,000 53,100 5,000 150 117,250 14,976 12,800 3,840 4,896 10,620 3,186 4,062 4,100 1,200 2,400 700 $62,780 Entertainment Dining out Electric Water and sewer Heat 1,620 3,000 4,700 350 800 1,250 Cable TV Telephone Cell phone Gifts Personal care Medical expenses Vehicle gas and maintenance Charitable contributions Vacation Total Variable Expenses Total Expenses SURPLUS (DEFICIT) 3,000 600 900 2,000 600 3,700 2,530 1,500 $26,550 $89,330 $27,920

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!