Answer To: To fill in the missing parts of my excel file, especially the balance sheetTo evaluate the budget...
Kushal answered on Jan 06 2021
Income Statement
My Company // Income Statement
YEAR 1 margin YEAR 2 margin YEAR 3 margin
April May June July August September October November December January February March total year 1 10% quarter 1 quarter 2 quarter 3 quarter 4 total year 2 10% quarter 1 quarter 2 quarter 3 quarter 4 total year 3 %
REVENUES
Entrance tickets 286395 313600 313600 313600 313600 286395 27720 27720 286395 27720 286395 27720 2510860 922730.95 922730.95 345253.35 345253.35 2535968.6 931958.2595 931958.2595 348705.8835 348705.8835 2561328.286 10%
Sales store 51100 458585 458585 458585 458585 51100 137295 137295 51100 137295 51100 137295 2587920 977952.7 1389512.55 1389512.55 977952.7 4734930.5 987732.227 1403407.675 1403407.675 987732.227 4782279.805 10%
Total Revenues 337495 772185 772185 772185 772185 337495 165015 165015 337495 165015 337495 165015 5098780 1900683.65 2312243.5 1734765.9 1323206.05 7270899.1 1919690.487 2335365.935 1752113.559 1336438.11 7343608.091
COST OF GOODS SOLD
Cost of PRODUCT store 57279 91717 91717 91717 91717 57279 27459 27459 57279 27459 27459 57279 705820 240713 240713 112197 112197 705820 240713 240713 112197 112197 705820
Cost of ENTRANCE FEES greenhouse 5486 33561 33561 33561 33561 5486 2969 2969 5486 2969 2969 5486 168064 72608 72608 11424 11424 168064 72608 72608 11424 11424 168064
Total Costs 62765 125278 125278 125278 125278 62765 30428 30428 62765 30428 30428 62765 873884 313321 313321 123621 123621 873884 313321 313321 123621 123621 873884
GROSS PROFIT 274730 646907 646907 646907 646907 274730 134587 134587 274730 134587 307067 102250 4224896 1587362.65 1998922.5 1611144.9 1199585.05 6397015.1 1606369.487 2022044.935 1628492.559 1212817.11 6469724.091
EXPENSES
Equipment 22000 19800 17820 16038 14434.2 12990.78 11691.702 10522.5318 9470.27862 8523.250758 7670.925682 6903.833114 22000 0 0
Purchase of birds 800 800 1600 800 800 1600 800 800
Wages 64630 64630 64630 64630 64630 64630 64630 64630 64630 64630 64630 64630 775560
Landscaping 40000 40000 0 0
Warehouse 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 12000 2750 2750 2750 2750 11000 2750 2750 2750 2750 11000
Payroll Tax & Benefits 0 0 0
Consultants & Contractors 400 400 400 400 400 400
Communication & Advertising 6820.833333 6820.833333 6820.833333 6820.833333 6820.833333 6820.833333 2821 2821 2821 2821 2821 2821 57851 20462.5 20462.5 20462.5 20462.5
Supplies 4000 4000 4000 4000 4000 4000
Printing & Postage 190 190 190 190 190 190 190 190 190 190 190 190 2280 190 190 190 190 760 190 190 190 190 760
Utilities 500 500 500 500 500 500 500 500 500 500 500 500 6000 1500 1500 1500 1500 6000 1500 1500 1500 1500 6000
Dues & Subscriptions 340 340 340 340 340 340 340 340 340 340 340 340 4080 1020 1020 1020 1020 4080 1020 1020 1020 1020 4080
Affiliation with tourism platforms 1000 1000 1000 1000 1000 1000
Equipment Maintenance & Inspection 200 200 200 200 200 200 200 200 200 200 200 200 2400 200 200 200 200 800 200 200 200 200 800
Commercial auto 1000 1000 1000 1000 1000 1000
Workers Compensation 1440 1440 1440 1440 1440 1440 1440 1440 1440 1440 1440 1440 17280 3960 3960 3960 3960 15840 3960 3960 3960 3960 15840
Crime exposure 650 650 650 650 650 650
General Liability 1080 1080 1080 1080 1080 1080
Taxes (not Income Taxes) 0 0 0
Miscellaneous 160 160 160 160 160 160 160 160 160 160 160 160 1920 160 160 160 160 640 160 160 160 160 640
Depreciation (10%) 2200 1980 1782 1603.8 1443.42 1299.078 1169.1702 1052.25318 947.027862 852.3250758 767.0925682 690.3833114 15786.5502 0 0
Total Expenses 147610.8333 97060.83333 94882.83333 92922.63333 91958.45333 89570.69133 84141.8722 82855.78498 82498.30648 80656.57583 79719.01825 78875.21643 1102753.052 38372.5 31042.5 30242.5 31042.5 130700 17910 10580 9780 10580 48850
OPERATING INCOME/...