Use the excel handout to develop financials for final project 1. Start with a monthly budget. Figure how many items you might sell. To make it realistic do not make all months the exact same. Cost of Good Sold. If you are selling products you need to figure how much they costs. Services do not use this section Expenses. All of you will have fees (business license), Internet/phone to accept credit cards, advertising like business cards, website, posters, etc 2. Then move to startup costs. Notice some numbers, your expenses from your budget where filled in here. You will need to add equipment and other purchases of things you will own for more than a year. 3. Then you will finish with the balance sheet. Again, notice some numbers from your start-up were filled in here. You will need to add cash and owners equity to make the balance sheet balance: Assets = liabilities + owners equity. Assets are the things you own, liabilities would be the things you owe like a loan, and owners equity would be your investment in the business. Business is taco truck price of taco's is 1.50each or 6.00 3 taco's side of rice and beans

AutoSave On Budget and Financials - Saved - Search Nicki Hernandez NH X File Home Insert Insert Page Layout Formulas Data Review View Help Share Comments y It Get Add-ins 6? ale tw III V E & HH 1 HHH Pivot Table Recommended Table Pivot Tables Illustrations XL Recommended Charts Maps PivotChart Slicer Timeline Link My Add-ins Text Comment Symbols 3D Map Line Column Win/ Loss Tables Add-ins Charts Tours Sparklines Filters Links Comments A2 x Taco & More A M N 0 P Q R S T U V w Y 1 B C D E F G H I J K L Budget: Profit and Loss Projection (12 Months) Taco & More Fiscal Year: 2020 YEARL Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2 2 3 4 5 Revenue (Sales) 6 Category 1 7 Category 2 8 Category 3 9 (Sales) 0 0 0 ol 0 0 0 0 0 11 Cost of Sales 0 0 0 12 Category 1 13 Category 2 14 Category 3 15 Total Cost of Sales 16 17 Gross Profit 0 01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 Expenses 20 Salary expenses 21 Payroll Tax expenses 22 Supplies 23 Repairs & maintenance 24 Advertising 25 Carltruck gas & maint 26 Accounting and legal 27 Rent & Related Costs Budget 0 0 0 0 0 Start Up Income Balance (+ + 85% Type here to search X 25 11:02 AM 11/13/2020 AutoSave On Budget and Financials - Saved - Search Nicki Hernandez NH X File Home Insert Insert Page Layout Formulas Data Review View Help Share Comments y CM HH HHH It Get Add-ins 6? ale Illustrations odo Line Column Win/ Loss Slicer Timeline Maps PivotChart Link Comment Text Symbols Pivot Table Recommended Table Pivot Tables Recommended Charts My Add-ins 3D Map Tours Tables Add-ins Charts Sparklines Filters Links Comments A2 X Taco & More C D E F G H 1 J K 1 M N 0 Q R S T U V w X 0 0 0 0 0 0 A 19 Expenses 20 Salary expenses 21 Payroll Tax expenses 22 Supplies 23 Repairs & maintenance 24 Advertising 25 Car/truck gas & maint. 26 Accounting and legal 27 Rent & Related Costs 28 Telephone 29 Utilities 30 Insurance 31 Depreciation 32 License & Permits 33 Other expenses (specify) 34 Other expenses (specify) 35 Total Expenses SU 37 Net Profit 38 39 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 01 0 0 0 0 0 0 0 0 0 o o o o 0 0 0 0 0 0 0 ol 41 42 43 Budget Start Up Income Balance + + 90% o Type here to search j 3 . X 11:01 AM 11/13/2020 25