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 addition to the cash-flow statement, Scott and Mary made a list of budget assumptions, listed for you here:
1. scott's income will increase by 5%, effective January 1 His bonus is generally 10% of his income in the previous year, and he recerves it in January.
2. Mary's raise will be 3%, effective January 1.
3. Interest and dividend income will conservatively be the same in 2017 as it was in 2016 and will be received on a monthly basis.
4. Mortgage payments will be the same in 2017 as they were in 2016.
5. Federal income taxes are estimated at 20%, state income taxes at 6%, and social security taxes at 7.65% of wages, including Scotts bonus.
6. 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.
7. Mary 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.
8. Scott and Mary would like to purchase a new car in the next few years and will put $500 a month away specifically for that purpose.
9 Scott and Mary 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.
10. Gift purchases are made mostly around the holidays, so Scott and Mary are planning to pay half of the gift expense in December and half in January when the credit card bill comes in.
11. 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.
12. 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 Scott and Mary's monthly budget for 2017.
Cash Flow Statement 2017
2016 Jan. Feb Mar Apr May June.\

Answer 1

Answer:

Surplus/Deficit

2016 27920

January 4980.20

February 2265.55

March 2090.55

April 2005.55

May 2473.89

June-9061.11

Explanation:

Annual Budget

Scott and Mary Cash-Flow Statement

2017

2016 Jan. Feb. Mar. Apr. May June

Income

Deon'

Scott s salary 59,000 5162.5 5162.5 5162.5 5162.5 5162.5 5162.5

(59000/12*1.05)

Marys salary 53,1004557.75 4557.75 4557.75 4557.75 4557.75 4557.75

(53100/12*1.03)

Scott bonus 2016 5000 Jan 5900

Interest & Dividends 150 12.5 12.5 12.5 12.5 12.5 12.5

(150/12)

1.

Total Income 117250 15632.75 9732.75 9732.75 9732.75 9732.75 9732.75

Expenditures

Fixed expenses

Mortgage 14976 1248 1248 1248 1248 1248 1248

(14976/12)

Sott's Federal Income Tax 12800 2212.5 1032.5 1032.5 1032.5 1032.5 1032.5 [(salary+Bonus)*20%]

Scott's State Income Tax 3840 663.75 309.75 309.75 309.75 309.75 309.75 [(salary+Bonus)*6%]

Scott's Social Security Taxes4896 846.28 394.93 394.93 394.93 394.93 394.93

[(salary+Bonus)*7.65%]

Mary's Federal Income Tax 10620 911.55 911.55 911.55 911.55 911.55 911.55 (Salary*20%)

Mary's State Income Tax 3186 273.47 273.47 273.47 273.47 273.47 273.47 (Salary 6%)

Mary's Social Security Taxes 4062 348.67 348.67 348.67 348.67 348.67 348.67 (Salary*7.65%)

Property Taxes

2016 4100 June 4100

Property Insurance

2016 1200 June 1200

Medical Insurance 2400 240 240 240 300 240 300

Automobile Insurance and Registration

2016 700 May 175 June 175 (700/4)

Savings for auto purchase June500 500 500 500 500 500

2.

Total Fixed expenses 62780 7244.21 5258.86 5433.86 5318.86 5258.86 10793.86

Variable expenses

Food 1620 135 135 135 135 135 135 (1620/12)

Entertainment 3000 250 250 250 250 250 250 (3000/12)

Dining out 4700 391.67 391.67 391.67 391.67 391.67 391.67 (4700/12)

Electric 350 29.17 29.17 29.17 29.17 29.17 29.17

(350/12)

Water and sewer 2016 800 Jan 200.00 April 200.00 (800/4)

Heat 1250 208.33 208.33 208.33 208.33 - - (1250/6)

Cable TV 3000 250.00 250.00 250.00 250.00 250.00 250.00 (3000/12)

Telephone 600 50.00 50.00 50.00 50.00 50.00 50.00

(600/12)

Cell phone 900 75.00 75.00 75.00 75.00 75.00 75.00

(900/12)

Gifts 2016 2000 Jan 1000.00 (2000/2)

Personal care 600 50.00 50.00 50.00 50.00 50.00 50.00 (600/12)

Medical expenses 3700 308.33 308.33 308.33 308.33 308.33 308.33 (3700/12)

Vehicle gas and maintenance 2530 210.83 210.83 210.83 210.83 210.83 210.83 (2530/12)

Charitable contributions 1500 250 250 250 250 250 250

(3000/12)

Vacation June 6000

3.

Total Variable expenses 26550 3408.333 2208.33 2208.33 2408.33 2000 8000

4.Total expenses

(Addition of solution 2+ solution 3)

89330 10652.55 7467.2 7642.2 7727.2 7258.86 18793.86

5.SURPLUS/(DEFICIT)

(Solution1 Total Income-Solution 4 Total Expenses)

27920 4980.20 2265.55 2090.55 2005.55 2473.89 -9061.11