Developing a budget- BUSN235

profilelana615
Week2BudgetInformation.xlsx
Home>Business & Finance homework help>Management homework help>Developing a budget- BUSN235

Figure 5.17

Mark's 2010 Budget 5.17

Income Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Wages 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167
Tutoring 400 400 400 400 400 400 33 33 33 33 33 33
Memorabilia Sales 450 360 1,200 79 79 79 79 79 79 79 79 79
House Painting - - - - - 3,472 3,472 3,472 - - - -
Interest Income 31 34 34 15 15 16 23 29 34 - 2 2
Total Income 4,048 3,961 4,801 3,661 3,661 7,134 6,774 6,780 3,313 3,279 3,281 3,281
Payroll/Income Taxes (792) (792) (792) (792) (792) (792) (792) (792) (792) (792) (792) (792)
Disposable Income 3,256 3,169 4,009 2,869 2,869 6,342 5,982 5,988 2,521 2,487 2,489 2,489
Living Expenses
Groceries (260) (260) (260) (260) (260) (260) (260) (260) (260) (260) (260) (260)
Car_Fuel (156) (156) (156) (156) (156) (156) (156) (156) (156) (156) (156) (156)
Car-Service, etc (29) (29) (29) (29) (29) (29) (29) (29) (29) (29) (29) (29)
Car-Insurance - (400) - - - - - (400) - - - -
Electricity (65) (65) (65) (65) (65) (65) (65) (65) (65) (65) (65) (65)
Phone/Cable/Internet (89) (89) (89) (89) (89) (89) (89) (89) (89) (89) (89) (89)
Heat (200) (200) (200) - - - - - - (200) (200) (200)
Health Insurance (63) (63) (63) (63) (63) (63) (63) (63) (63) (63) (63) (63)
Medical (4) (4) (4) (4) (4) (4) (4) (4) (4) (4) (4) (4)
Dental (42) (42) (42) (42) (42) (42) (42) (42) (42) (42) (42) (42)
Travel/Entertainment - - - - - - - - - - - -
Car Loan Payment (499) (499) (499) (499) (499) (499) (499) (499) (499) (499) (499) (499)
Mortgage Interest (897) (897) (897) (897) (897) (897) (897) (897) (897) (897) (897) (897)
Property Tax - - - - - - - - - (4,350) - -
Total Living Expense (2,304) (2,704) (2,304) (2,104) (2,104) (2,104) (2,104) (2,504) (2,104) (6,654) (2,304) (2,304)
Income after Living Expense 952 465 1,705 765 765 4,238 3,878 3,484 417 (4,167) 185 185
Interest Expense - - - - - - - - - - - -
Capital Expeditures/Investment
Mortgage Principal (270) (270) (270) (270) (270) (270) (270) (270) (270) (270) (270) (270)
Free Cash Flow 682 195 1,435 495 495 3,968 3,608 3,214 147 (4,437) (85) (85)
Retirement Account Deposit - - (1,000) - - - - - - - - -
Home Improvement - - - - - - - - - (15,000) - -
Saving Deposit (withdrawl) 681 194 435 494 495 3,968 3,575 3,181 114 (19,471) (119) (119)
Draw on (pay off) Line of Credit - - - - - - - - - - - -
Net Cash Flow - - - - - - - - - - - -
Line of Credit - - - - - - - - - - - -
Money Market Account Balance 8,048 8,275 8,774 9,253 9,763 13,747 17,345 20,554 20,702 1,231 1,114 998

Scenario 1

Mark injures himself on the cross-trainer, and the doctor recommends a course of physical therapy.
Income Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Wages 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167 3,167
Tutoring 400 400 400 400 400 400 33 33 33 33 33 33
Memorabilia Sales 450 360 1,200 79 79 79 79 79 79 79 79 79
House Painting - - - - - 3,472 3,472 3,472 - - - -
Interest Income 31 34 34 15 15 16 23 29 34 - 2 2
Total Income 4,048 3,961 4,801 3,661 3,661 7,134 6,774 6,780 3,313 3,279 3,281 3,281
Payroll/Income Taxes (792) (792) (792) (792) (792) (792) (792) (792) (792) (792) (792) (792)
Disposable Income 3,256 3,169 4,009 2,869 2,869 6,342 5,982 5,988 2,521 2,487 2,489 2,489
Living Expenses
Groceries (260) (260) (260) (260) (260) (260) (260) (260) (260) (260) (260) (260)
Car_Fuel (156) (156) (156) (156) (156) (156) (156) (156) (156) (156) (156) (156)
Car-Service, etc (29) (29) (29) (29) (29) (29) (29) (29) (29) (29) (29) (29)
Car-Insurance - (400) - - - - - (400) - - - -
Electricity (65) (65) (65) (65) (65) (65) (65) (65) (65) (65) (65) (65)
Phone/Cable/Internet (89) (89) (89) (89) (89) (89) (89) (89) (89) (89) (89) (89)
Heat (200) (200) (200) - - - - - - (200) (200) (200)
Health Insurance (63) (63) (63) (63) (63) (63) (63) (63) (63) (63) (63) (63)
Medical (4) (4) (4) (4) (4) (4) (4) (4) (4) (4) (4) (4)
Dental (42) (42) (42) (42) (42) (42) (42) (42) (42) (42) (42) (42)
Travel/Entertainment - - - - - - - - - - - -
Car Loan Payment (499) (499) (499) (499) (499) (499) (499) (499) (499) (499) (499) (499)
Mortgage Interest (897) (897) (897) (897) (897) (897) (897) (897) (897) (897) (897) (897)
Property Tax - - - - - - - - - (4,350) - -
Total Living Expense (2,304) (2,704) (2,304) (2,104) (2,104) (2,104) (2,104) (2,504) (2,104) (6,654) (2,304) (2,304)
Income after Living Expense 952 465 1,705 765 765 4,238 3,878 3,484 417 (4,167) 185 185
Interest Expense - - - - - - - - - - - -
Capital Expeditures/Investment
Mortgage Principal (270) (270) (270) (270) (270) (270) (270) (270) (270) (270) (270) (270)
Free Cash Flow 682 195 1,435 495 495 3,968 3,608 3,214 147 (4,437) (85) (85)
Retirement Account Deposit - - (1,000) - - - - - - - - -
Home Improvement - - - - - - - - - (15,000) - -
Saving Deposit (withdrawl) 681 194 435 494 495 3,968 3,575 3,181 114 (19,471) (119) (119)
Draw on (pay off) Line of Credit - - - - - - - - - - - -
Net Cash Flow - - - - - - - - - - - -
Line of Credit - - - - - - - - - - - -
Money Market Account Balance 8,048 8,275 8,774 9,253 9,763 13,747 17,345 20,554 20,702 1,231 1,114 998

Scenario 2

Scenario 3

Scenario 4

Scenario 5