111 5
111 5
Fixed Assets
Buildings 25,000,000
Leasehold Improvements -
Equipment 757,550
Furniture and Fixtures 2819900
Vehicles -
Other Fixed Assets -
Total Fixed Assets 28,577,450
Operating Capital
Pre-Opening Salaries and Wages 434,712
Prepaid Insurance Premiums 375,000
Beginning Inventory 630,000
Legal and Accounting Fees -
Rent Deposits -
Utility Deposits 50,000
Supplies -
Advertising and Promotions 500,000
Licenses 55,000
Other Initial Start-Up Costs -
Working Capital (Cash On Hand) 5,000,000
Total Operating Capital 7,044,712
$130,678.10
Furniture Estimation
Admin Rooms 1E+05
Kitchens 1E+05
Workshops 4E+05
Security Room 52000
Bookstores 23000
Storage Rooms 1E+05
Shops 2E+05
Cafes 80000
Theater Room 1E+05
Classrooms 3E+05
Waiting Areas 52000
Info Desks 19500
Multifunctional Hall 1E+05
Toilets 59500
Event Halls 1008000
Total 2819900
Salaries and Related Expenses # Assumptions
Wages
Full-Time Employees 81
Estimated Hours Per month 315.00
Estimated Rate Per Hour $ 100.00
Independent Contractors
Total Salaries and Wages 2,551,500
Percent Change
Expenses
Advertising $ 41,667 500,000
Interior Design $ 83,333 1,000,000
Commissions and Fees $ 41,667 500,000
Safety and Accessibility Upgrades $ 41,667 500,000
Workshop Equipment $ 63,129 757,550
Furniture $ 234,992 2,819,900
Staffing $ 144,904 1,738,847
Insurance (Liability and Property) $ 31,250 375,000
Website Development: $ 2,083 25,000
Licince $ 4,583 55,000
Supplies $ -
Utilities $ 50,000 600,000
Maintenance and repairs
Total Expenses 739,275 8,871,297
Other Expenses
Depreciation 357,745
Interest 130,678 1,568,137
Total Other Expenses 1,925,882
Total Fixed Operating Expenses 739,275 10,797,179
Year Two Year Three Notes
30.00% 30.00%
650,000 845,000
60,000 60,000
650,000 845,000
25,000 -
- -
1,912,732 2,104,005
487,500 633,750
25,000 25,000
55,000 55,000
- -
600,000 600,000
4,465,232 5,167,755
357,745 357,745
1,568,137 1,568,137
1,925,882 1,925,882
6,391,114 7,093,637
Products and Services Assumptions % Month 1
2.53%
Paid Workshops Year1 5
Price Per Unit $ 1,500.00 100.00% Year2 37
Variable Cost Per Unit $ 600.00 40.00% Year3 63
Gross Margin Per Unit $ 900.00 60.00%
Projected Unit Sales
Seasonality Factor
Year One 198
Year Two Growth 197.59%
Year Three Growth 43.47%
Fixed Expense Allocation 20.00%
Craft Schools
Price Per Unit $ 3,300.00 100.00%
Variable Cost Per Unit $ 2,200.00 66.67%
Gross Margin Per Unit $ 1,100.00 33.33%
Month 1
Seasonality Factor 0.46%
Year One 2,193 Year1 10
Year Two Growth 170.64% Year2 330
Year Three Growth 53.97% Year3 681
Fixed Expense Allocation 20.00%
Year 1 Year 2 Year 3
Projected Revenue $ 7,237,284 $ 19,587,143 $ 30,158,246
Variable Costs $ 4,824,856 $ 13,058,095 $ 20,105,497
Gross Margin $ 2,412,428 $ 6,529,048 $ 10,052,749
Fixed Expenses $ 25,000 $ 30,000 $ 36,000
Profit $ 2,387,428 $ 6,499,048 $ 10,016,749
Entrance Fees
Price Per Unit $ 100.00 100.00%
Variable Cost Per Unit $ 20.00 20.00%
Gross Margin Per Unit $ 80.00 80.00%
Projected Unit Sales Month 1
Seasonality Factor 25.26%
Year One 1,979 Year1 50
Year Two Growth 274.53% Year2 375
Year Three Growth 57.81% Year3 848
Fixed Expense Allocation 5.00%
Year 1 Year 2 Year 3
Projected Revenue $ 197,903 $ 741,211 $ 1,169,696
Variable Costs $ 39,581 $ 39,581 $ 233,939
Gross Margin $ 158,322 $ 701,630 $ 935,757
Fixed Expenses $ 25,000 $ 26,250 $ 27,563
Profit $ 133,322 $ 675,380 $ 908,194
Branded Merchandise
Price Per Unit $ 200.00 100.00%
Variable Cost Per Unit $ 80.00 40.00%
Gross Margin Per Unit $ 120.00 60.00%
Projected Unit Sales Month 1
Seasonality Factor 1.82%
Year One 2,168 Year1 40
Year Two Growth 358.59% Year2 465
Year Three Growth 89.82% Year3 1,330
Fixed Expense Allocation 20.00%
Year 1 Year 2 Year 3
Projected Revenue $ 436,926 $ 1,988,738 $ 3,775,080
Variable Costs 174,890 $ 795,495 $ 1,510,032
Gross Margin 262,036 $ 1,193,243 $ 2,265,048
Fixed Expenses 12,500 $ 15,000 $ 18,000
Profit 249,536 $ 1,178,243 $ 2,247,048
online store
Price Per Unit $ 618.00 100.00%
Variable Cost Per Unit $ 247.00 39.97%
Gross Margin Per Unit $ 371.00 60.03%
Projected Unit Sales Month 1
Seasonality Factor 5.86%
Year One 853 50
Year Two Growth 323.83% 103
Year Three Growth 116.35% 583
Fixed Expense Allocation 16.67%
Year 1 Year 2 Year 3
Projected Revenue $ 436,926 $ 526,988 $ 4,832,295
Variable Costs $ 174,890 $ 892,699 $ 1,931,354
Gross Margin $ 262,036 $ (365,711) $ 2,900,941
Fixed Expenses $ 41,675 $ 48,621 $ 48,621
Profit $ 220,361 $ (414,332) $ 2,852,320
Breakeven Sales Revenue $ 69,420.89 $ 80,991.04 $ 80,991.04
Breakeven Sales Units 112 131 131
Below-the-Line Items
Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
$ - $ - $ - $ - $ - $ - $ - $ -
$ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00
$ - $ - $ - $ - $ - $ - $ - $ -
$ 296,853.77
$ 7,237,283.90
$ 197,902.51
$ 433,661.29
$ 526,987.81
$ 1,197,447.43
9,890,137
$ 118,741.51
$ 4,824,855.93
$ 39,580.50
$ 173,464.51
$ 210,624.58
$ 478,978.97
5,846,246
4,043,891
Totals
$ 500,000.00
$ 500,000.00
$ 357,745.00
$ 3,577,450.00
$ 375,000.00
$ -
$ -
$ 1,738,847.25
$ 1,000,000.00
$ 500,000.00
$ 25,000.00
$ 600,000.00
$ 55,000.00
$ -
9,229,042
(5,185,152)
$1,568,137.16
($6,753,288.72)
$0.00
($6,753,288.72)
YEAR 2
Revenue Month 1 Month 2 Month 3 Month 4 Month 5
Sales revenue
Paid Workshops $ 55,500.00 $ 58,275.00 $ 61,188.75 $ 64,248.19 $ 67,460.60
Craft Schools $ 1,089,000.00 ### ### ### ###
Entrance Fees $ 37,500.00 $ 41,250.00 $ 45,375.00 $ 49,912.50 $ 54,903.75
Branded Merchandise $ 93,000.00 $ 102,300.00 $ 112,530.00 $ 123,783.00 $ 136,161.30
online store $ 63,654.00 $ 89,115.60 $ 102,482.94 $ 117,855.38 $ 135,533.69
retail sales $ 309,000.00 $ 339,900.00 $ 343,299.00 $ 377,628.90 $ 415,391.79
Total 1,647,654 1,828,741 1,982,566 2,182,887 2,331,383
(Cost Of Good Sold)
Paid Workshops $ 22,200.00 $ 23,310.00 $ 24,475.50 $ 25,699.28 $ 26,984.24
Craft Schools $ 726,000.00 $ 798,600.00 $ 878,460.00 $ 966,306.00 ###
Entrance Fees $ 7,500.00 $ 8,250.00 $ 9,075.00 $ 9,982.50 $ 10,980.75
Branded Merchandise $ 37,200.00 $ 40,920.00 $ 45,012.00 $ 49,513.20 $ 54,464.52
online store $ 25,441.00 $ 35,617.40 $ 40,960.01 $ 47,104.01 $ 54,169.61
retail sales $ 123,600.00 $ 135,960.00 $ 137,319.60 $ 151,051.56 $ 166,156.72
Total 941,941 1,042,657 1,135,302 1,249,657 1,327,377
$ - $ - $ - $ - $ - $ - $ -
$ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00
$ - $ - $ - $ - $ - $ - $ -
$ 883,400.52
$ 19,587,142.89
$ 741,210.50
$ 1,988,738.39
$ 2,233,554.34
$ 6,120,201.93
31,554,249
$ 353,360.21
$ 13,058,095.26
$ 148,242.10
$ 795,495.36
$ 892,698.90
$ 2,448,080.77
17,695,973
-
13,858,276
Totals
$ 650,000.00
$ 650,000.00
$ 357,745.00
$ -
$ 487,500.00
$ 45,000.00
$ -
$ 1,912,731.98
$ 60,000.00
$ 25,000.00
$ 25,000.00
$ 600,000.00
$ 55,000.00
$ -
4,676,310
9,181,966
$1,568,137.16
$25,309,801.10
$5,061,960.22
$20,247,840.88
Revenue Month 1 Month 2 Month 3 Month 4
Sales revenue
Paid Workshops $ 94,500.00 $ 96,390.00 $ 98,317.80 $ 100,284.16
Craft Schools $ 2,248,586.64 $ 2,293,558.38 $ 2,339,429.55 $ 2,386,218.14
Entrance Fees $ 84,787.90 $ 86,907.60 $ 89,080.29 $ 91,307.29
Branded Merchandise $ 266,000.00 $ 273,980.00 $ 282,199.40 $ 290,665.38
online store $ 360,294.00 $ 367,499.88 $ 374,849.88 $ 382,346.88
retail sales $ 809,580.00 $ 825,771.60 $ 842,287.03 $ 859,132.77
Total 3,863,749 3,944,107 4,026,164 4,109,955
(Cost Of Good Sold)
Paid Workshops $ 37,800.00 $ 38,556.00 $ 39,327.12 $ 40,113.66
Craft Schools $ 1,499,057.76 $ 1,529,038.92 $ 1,559,619.70 $ 1,590,812.09
Entrance Fees $ 16,957.58 $ 17,381.52 $ 17,816.06 $ 18,261.46
Branded Merchandise $ 106,400.00 $ 109,592.00 $ 112,879.76 $ 116,266.15
online store $ 144,001.00 $ 146,881.02 $ 149,818.64 $ 152,815.01
retail sales $ 323,832.00 $ 330,308.64 $ 336,914.81 $ 343,653.11
Total 2,128,048 2,171,758 2,216,376 2,261,921
$ - $ - $ - $ - $ - $ - $ -
$ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00
$ - $ - $ - $ - $ - $ - $ -
$ 117,498.87 $ 1,267,442.48
$ 2,795,834.86 $ 30,158,245.84
$ 111,249.07 $ 1,169,695.95
$ 368,206.21 $ 3,775,079.86
$ 447,980.30 $ 4,832,295.46
$ 1,006,610.97 $ 10,858,159.60
4,847,380 52,060,919
$ 46,999.55 $ 506,976.99
$ 1,863,889.91 $ 20,105,497.23
$ 22,249.81 $ 233,939.19
$ 147,282.48 $ 1,510,031.95
$ 179,047.14 $ 1,931,354.33
$ 402,644.39 $ 4,343,263.84
2,662,113 28,631,064
-
4,847,380 23,429,856
Month 12 Totals
$ 70,416.67 $ 845,000.00
$ 70,416.67 $ 845,000.00
$ 29,812.08 $ 357,745.00
$ - $ -
$ - $ 633,750.00
$ - $ 60,000.00
$ -
$ 159,394.33 $ 1,912,731.98
$ 5,000.00 $ 60,000.00
$ 25,000.00
$ - $ 25,000.00
$ 50,000.00 $ 600,000.00
$ - $ 55,000.00
$ -
385,040 5,419,227
4,462,341 18,010,629
$130,678.10 $1,568,137.16
4,331,662 $45,073,555.05
- $9,014,711.01
4,331,662 $36,058,844.04
Balance Sheet
Date:
Assets 2025
Current Assets
Cash 5,000,000
Accounts receivable -
Inventory 630,000
Prepaid insuance 375,000
Short-term investments -
Total current assets $ 6,005,000
Fixed (Long-Term) Assets
Long-term investments 3,775,325
Property, plant, and equipment 3,577,450
(Less accumulated depreciation) -
Building 25,000,000
Total fixed assets $ 32,352,775
2026 2027
15,386,523 59,283,350
6,310,850 5,206,092
850,500 1,148,175
487,500 633,750
5,202,617 5,273,926
$28,237,989.69 $71,545,293.17
5,716,882
3,577,450 3,219,705
(357,745) (357,745)
25,000,000 25,000,000
$ 33,936,587 $ 27,861,960
$ 62,174,577 $ 99,407,253
15,201,305
7000000 5,000,000
144,904 144,904
$ 7,144,904 $ 20,346,209
5,716,882 4,148,745
$ 5,716,882 $ 4,148,745
25,000,000 35,000,000
24,312,791 39,912,299
$ 49,312,791 $ 74,912,299
$ 62,174,577 $ 99,407,253
{42}
budget
Enter Your Business Name Here
Projected Cash Flow Statement - Year One
fit Anaylsis
efits
YEAR2 Year3 Total
$ 883,400.52 $ 1,267,442.48 $ 2,447,696.77
$ 19,587,142.89 $ 30,158,245.84 $ 56,982,672.63
$ 741,210.50 $ 1,169,695.95 $ 2,108,808.97
$ 1,988,738.39 $ 3,775,079.86 $ 6,197,479.54
$ 2,233,554.34 $ 4,832,295.46 $ 7,592,837.60
$ 6,120,201.93 $ 10,858,159.60 $ 18,175,808.96
$ 31,554,248.58 $ 52,060,919.19 $ 93,505,304.47
00
00
00
00
00
$-
Costs Benefits