(chow, Alexander) Assignment 3c

9 Excel Assignment 3b (Formulas & References)

My Budget Yearly Salary Taxes/Deduction - 30% Net Salary (after taxes) Monthly Salary (after taxes)

$30,000.00 $9,000.00 $21,000.00 $1,750.00

Category Housing

Items Percent Budget Rent 25% $437.50 Groceries 15% $262.50 Household Suppliers 7% $122.50

Utilities

Water Electric Cable Telephone

Automobile

Loan Gasoline Maintenance

5% 5% 2% 2%

$87.50 $87.50 $35.00 $35.00

10% 4% 5%

$175.00 $70.00 $87.50

Entertainment Dining Recreation

2% 3%

$35.00 $52.50

Other

5% 5% 5%

$87.50 $87.50 $87.50 $822.50 $245.00 $332.50 $87.50 $262.50 $1,750.00

Investments Savings Account Cash Total Housing Total Utilities Total Automobile Total Entertainment Total Other Total Budget

Alexander Chow 11/8/07 Software Application A Pd. 7

Alexander Chow's Budget vs. Spending $450.00 $425.00 $400.00 $375.00 $350.00 $325.00

Amount Spent

$300.00 $275.00 $250.00 $225.00 Column E

$200.00 $175.00 $150.00 $125.00 $100.00 $75.00 $50.00 $25.00 $Rent Gro- Hous ceries ehold Sup-

W ater

Elec- Cable Tele tric phon e

Loan

Item

G asoli

Maintenance

Dining

Recreation

InSavvest ings ment Ac-

Cash

Column E

9 Excel Assignment 3b (Formulas & References)

My Budget - November Yearly Salary Taxes/Deduction - 30% Net Salary (after taxes) Monthly Salary (after taxes) Category Housing

Items Nov. Spending Difference Rent $450.00 ($12.50) Groceries $175.50 $87.00 Household Suppliers $105.75 $16.75 Utilities Water $70.05 $17.45 Electric $82.05 $5.45 Cable $39.99 ($4.99) Telephone $24.99 $10.01 Automobile Loan $175.00 $0.00 Gasoline $58.50 $11.50 Maintenance $50.00 $37.50 Entertainment Dining $50.00 ($15.00) Recreation $60.00 ($7.50) Other Investments $87.50 $0.00 Savings Account $80.00 $7.50 Cash $100.00 ($12.50) Total Housing $731.25 $91.25 Total Utilities $217.08 $27.92 Total Automobile $283.50 $49.00 Total Entertainment $110.00 ($22.50) Total Other $267.50 ($5.00) Total Budget $1,609.33 $140.67 Average Housing Average Utilities Average Automobile Average Entertainment Average Other

Alexander Chow 11/8/07 Software Application A Pd. 7

Alexander Chow 11/8/07 Software Application A Pd. 7

9 Minimum Maximum

$110.00 $731.25

Alexander Chow 11/20/07 Software App. A Pd. 7

9

Alexander Chow's November Spending Breakdown

Row 25 Row 26 Row 27 Row 28 Row 29

Row 25 Row 26 Row 27 Row 28 Row 29

9

Alexander Chow 11/20/07 Software App. A Pd. 7

9 Excel Assignment 3b (Formulas & References)

My Budget - November Yearly Salary Taxes/Deduction - 30% Net Salary (after taxes) Monthly Salary (after taxes)

$30,000.00 $9,000.00 $21,000.00 $1,750.00

Category Housing

Items Budget Nov. Spending Difference Rent $437.50 $450.00 ($12.50) Groceries $262.50 $175.50 $87.00 Household Suppliers $122.50 $105.75 $16.75 Utilities Water $87.50 $70.05 $17.45 Electric $87.50 $82.05 $5.45 Cable $35.00 $39.99 ($4.99) Telephone $35.00 $24.99 $10.01 Automobile Loan $175.00 $175.00 $0.00 Gasoline $70.00 $58.50 $11.50 Maintenance $87.50 $50.00 $37.50 Entertainment Dining $35.00 $50.00 ($15.00) Recreation $52.50 $60.00 ($7.50) Other Investments $87.50 $87.50 $0.00 Savings Account $87.50 $80.00 $7.50 Cash $87.50 $100.00 ($12.50) Total Housing $822.50 $731.25 $91.25 Total Utilities $245.00 $217.08 $27.92 Total Automobile $332.50 $283.50 $49.00 Total Entertainment $87.50 $110.00 ($22.50) Total Other $262.50 $267.50 ($5.00) Total Budget $1,750.00 $1,609.33 $140.67 Average Housing Average Utilities Average Automobile Average Entertainment Average Other

$243.75 $54.27 $94.50 $55.00 $89.17

Alexander Chow 11/8/07 Software Application A Pd. 7

Alexander Chow 11/8/07 Software Application A Pd. 7

9 Minimum Maximum

$110.00 $731.25