Aim: How do we create Excel formulas?
Aim: How do we create Excel formulas for our budget? 0011 0010 1010 1101 0001 0100 1011
1
2
4
NOCTI Exam 0011 0010 1010 1101 0001 0100 1011
• • • •
Multiple Choice – Friday, May 18 Six Flags Plan Due – May 14th Six Flags Trip – Wed. May 23 Written (Resume, Cover Letter, Job Application, Excel) – Wed. May 30 • Written Continued Thurs. May 31 • June 8th – Impact Day at MLK
1
2
4
What is a budget? 0011 0010 1010 1101 0001 0100 1011
• A plan for saving and spending money • Based on your income minus your expenses
1
2
4
Sample Budget A B 0011 0010 1101 0001 0100 1011 $300.00 1 1010 Income (total) 2 Expenses 3 Phone $40.00 4 Games $60.00 5 Movies $20.00 6 Food $80.00 7 Transportation $75.00 8 Total Expenses $275.00 9
Savings
$25.00
10
Left
$0.00
1
2
4
=B3+B4+B5+B6+B7 Or =SUM(B3:B7) =B1-B8
=B1-B8-B9
Common Forms of Income 0011 0010 1010 1101 0001 0100 1011
• Wages – paid by hour • Salary – set amount for a period of time
These are considered Receipts of Cash
1
2
4
Personal Budget 0011 0010 1010 1101 0001 0100 1011
• 2 sections – Income/Payroll Section with Deductions (Receipts of Cash) – Expenses Section with payments of expenses and payment for loan (Payments of Cash)
1
2
4
Annual vs. Monthly Budgets 0011 0010 are 1010 1101 an 0001 0100 1011 • You given Annual Salary
of $100,000. How do I find out
how much I make Monthly? • I spend about $6000 in Car Insurance a year. How do I figure out how much I make a Month?
1
2
• I spend $25 a week on transportation. There are 4 weeks in a month. How do I figure out how much do I make in a month?
4
• I buy Starbucks coffee everyday Monday to Friday for $3.50. How many days are there in a week? How much do I spend a month?
Activities 0011 0010 1010 1101 0001 0100 1011
• Simple Cash Budget • Practice File 2 • Create your own budget – – – –
1
2
Include a Yearly Salary Include 8 items you must pay for Create formula for total cost of items Create formula to see how much you have left – Use My Personal Budget file
4
1
2
4
NOCTI Exam 0011 0010 1010 1101 0001 0100 1011
• • • •
Multiple Choice – Friday, May 18 Six Flags Plan Due – May 14th Six Flags Trip – Wed. May 23 Written (Resume, Cover Letter, Job Application, Excel) – Wed. May 30 • Written Continued Thurs. May 31 • June 8th – Impact Day at MLK
1
2
4
What is a budget? 0011 0010 1010 1101 0001 0100 1011
• A plan for saving and spending money • Based on your income minus your expenses
1
2
4
Sample Budget A B 0011 0010 1101 0001 0100 1011 $300.00 1 1010 Income (total) 2 Expenses 3 Phone $40.00 4 Games $60.00 5 Movies $20.00 6 Food $80.00 7 Transportation $75.00 8 Total Expenses $275.00 9
Savings
$25.00
10
Left
$0.00
1
2
4
=B3+B4+B5+B6+B7 Or =SUM(B3:B7) =B1-B8
=B1-B8-B9
Common Forms of Income 0011 0010 1010 1101 0001 0100 1011
• Wages – paid by hour • Salary – set amount for a period of time
These are considered Receipts of Cash
1
2
4
Personal Budget 0011 0010 1010 1101 0001 0100 1011
• 2 sections – Income/Payroll Section with Deductions (Receipts of Cash) – Expenses Section with payments of expenses and payment for loan (Payments of Cash)
1
2
4
Annual vs. Monthly Budgets 0011 0010 are 1010 1101 an 0001 0100 1011 • You given Annual Salary
of $100,000. How do I find out
how much I make Monthly? • I spend about $6000 in Car Insurance a year. How do I figure out how much I make a Month?
1
2
• I spend $25 a week on transportation. There are 4 weeks in a month. How do I figure out how much do I make in a month?
4
• I buy Starbucks coffee everyday Monday to Friday for $3.50. How many days are there in a week? How much do I spend a month?
Activities 0011 0010 1010 1101 0001 0100 1011
• Simple Cash Budget • Practice File 2 • Create your own budget – – – –
1
2
Include a Yearly Salary Include 8 items you must pay for Create formula for total cost of items Create formula to see how much you have left – Use My Personal Budget file
4
