SpreadsheetsA spreadsheet is a tool that helps you do math quickly. It is helpful for keeping records of information too. You will create one Microsoft Excel file to help you make three spreadsheets.
The three images below represent what your pages should look like in Excel before you fill in all the information. |
Navigation |
Tab 1The first tab, or spreadsheet, is your Goods and Services page.
This page helps you keep track of 10 things your company sells. ITEM - list 10 items your company sells. PRICE - put a price for each item. QUANTITY - make an estimate of how many of each item you will sell in a month. SUBTOTAL - Use a formula to figure out the subtotal (Price x Quantity). TAX - Use a formula to figure out the tax (Subtotal x 8.25%), TOTAL - Use a formula to figure out the total with tax (Subtotal + Tax). GRAND TOTAL 1 - Use a formula to find the total tax charged (sum of all tax numbers). GRAND TOTAL 2 - Use a formula to find the grand total (sum of all the Total numbers). |
Tab 2The second tab, or spreadsheet, is your Expenses page.
This page helps you keep track of 10 expenses your company spends each month. ITEM - list 10 items your company spends money on. PRICE - put a price for each item. QUANTITY - make an estimate of how many of each item you will use in a month. SUBTOTAL - Use a formula to figure out the subtotal (Price x Quantity). TAX - Use a formula to figure out the tax (Subtotal x 8.25%), TOTAL - Use a formula to figure out the total with tax (Subtotal + Tax).GRAND TOTAL - Use a formula to find the grand total (sum of all the Total numbers). |
Page 3Your final tab, or spreadsheet, will calculate the total amount of income, expenses and net profit for the year.
INCOME - Use a formula to calculate the amount of income your company will make in a year (Goods and Services Grand Total x 12). EXPENSES - Use a formula to calculate the amount of expenses your company will spend in a year (Monthly Expenses Grand Total x 12). NET PROFIT - Use a formula to figure out your net profit, or the money you made AND get to keep (Income - Expenses). |
SAMPLE SPREADSHEET
The spreadsheet below is a sample of what your spreadsheet could look like when it's finished. You should not use the same items or the same prices. Use items and prices that are for your business. For example, if you have a clothing store, you might be selling T-Shirts, Jeans, Khakis, Shoes, etc.