(chow, Alexander) Assignment 3b
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View (chow, Alexander) Assignment 3b as PDF for free.
More details
- Words: 291
- Pages: 3
3 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 11/8/07 Software Application A Pd. 7
3 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 Percent Budget Nov. Spending Difference Rent 25% $437.50 $450.00 ($12.50) Groceries 15% $262.50 $175.50 $87.00 Household Suppliers 7% $122.50 $105.75 $16.75
Utilities
Water Electric Cable Telephone
Automobile
Loan Gasoline Maintenance
5% 5% 2% 2%
$87.50 $87.50 $35.00 $35.00
$70.05 $82.05 $39.99 $24.99
$17.45 $5.45 ($4.99) $10.01
10% 4% 5%
$175.00 $70.00 $87.50
$175.00 $58.50 $50.00
$0.00 $11.50 $37.50
Entertainment Dining Recreation
2% 3%
$35.00 $52.50
$50.00 $60.00
($15.00) ($7.50)
Other
5% 5% 5%
$87.50 $87.50 $87.50 $822.50 $245.00 $332.50 $87.50 $262.50 $1,750.00
$87.50 $80.00 $100.00 $731.25 $217.08 $283.50 $110.00 $267.50 $1,609.33
$0.00 $7.50 ($12.50) $91.25 $27.92 $49.00 ($22.50) ($5.00) $140.67
Investments Savings Account Cash Total Housing Total Utilities Total Automobile Total Entertainment Total Other Total Budget Average Housing
$243.75
3 Average Utilities Average Automobile Average Entertainment Average Other Minimum Maximum
$110.00 $731.25
$54.27 $94.50 $55.00 $89.17
Alexander Chow 11/8/07 Software Application A Pd. 7
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 11/8/07 Software Application A Pd. 7
3 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 Percent Budget Nov. Spending Difference Rent 25% $437.50 $450.00 ($12.50) Groceries 15% $262.50 $175.50 $87.00 Household Suppliers 7% $122.50 $105.75 $16.75
Utilities
Water Electric Cable Telephone
Automobile
Loan Gasoline Maintenance
5% 5% 2% 2%
$87.50 $87.50 $35.00 $35.00
$70.05 $82.05 $39.99 $24.99
$17.45 $5.45 ($4.99) $10.01
10% 4% 5%
$175.00 $70.00 $87.50
$175.00 $58.50 $50.00
$0.00 $11.50 $37.50
Entertainment Dining Recreation
2% 3%
$35.00 $52.50
$50.00 $60.00
($15.00) ($7.50)
Other
5% 5% 5%
$87.50 $87.50 $87.50 $822.50 $245.00 $332.50 $87.50 $262.50 $1,750.00
$87.50 $80.00 $100.00 $731.25 $217.08 $283.50 $110.00 $267.50 $1,609.33
$0.00 $7.50 ($12.50) $91.25 $27.92 $49.00 ($22.50) ($5.00) $140.67
Investments Savings Account Cash Total Housing Total Utilities Total Automobile Total Entertainment Total Other Total Budget Average Housing
$243.75
3 Average Utilities Average Automobile Average Entertainment Average Other Minimum Maximum
$110.00 $731.25
$54.27 $94.50 $55.00 $89.17
Alexander Chow 11/8/07 Software Application A Pd. 7
Related Documents
(chow, Alexander) Assignment 3b
November 2019 15
(chow, Alexander) Assignment 6
November 2019 24
Assignment 2b (alexander Chow)
November 2019 13
(chow, Alexander) Assignment 3c
November 2019 11
(chow, Alexander) Assignment 4b
November 2019 19