A

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

Plan Month
Current Interest Rate
Long-term Interest Rate
Tax Rate
Other
Other

Jan
1
10.00%
10.00%
30.00%
0
0

Feb
2
10.00%
10.00%
30.00%
0
0

Mar
3
10.00%
10.00%
30.00%
0
0

Apr
4
10.00%
10.00%
30.00%
0
0

May
5
10.00%
10.00%
30.00%
0
0

Jun
6
10.00%
10.00%
30.00%
0
0

Jul
7
10.00%
10.00%
30.00%
0
0

Aug
8
10.00%
10.00%
30.00%
0
0

Sep
9
10.00%
10.00%
30.00%
0
0

Oct
10
10.00%
10.00%
30.00%
0
0

Nov
11
10.00%
10.00%
30.00%
0
0

Dec
12
10.00%
10.00%
30.00%
0
0

2016
1
10.00%
10.00%
30.00%
0
0

Calculated Totals (not included in output)

Payroll Expense

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

General Assumptions

$1,036,800

Break-even Analysis
Monthly Units Break-even
Monthly Revenue Break-even

285,221
$285,221

Assumptions:
Average Per-Unit Revenue
Average Per-Unit Variable Cost
Average Percent Variable Cost
Estimated Monthly Fixed Cost

$1.00
$0.00
22%
$223,065
Units
0
47537
95074
142611
190148
237685
285222
332759
380296
427833
475370
522907

Sales
$0
$47,537
$95,074
$142,611
$190,148
$237,685
$285,222
$332,759
$380,296
$427,833
$475,370
$522,907

Profits
###
###
###
###
($74,355)
($37,177)
$1
$37,178
$74,356
$111,533
$148,711
$185,889

Market Analysis
2016

Potential Customers

2017

Segment Name
Segment Name
Other

Growth
0%
0%
0%

0
0
0

0
0
0

Total

0.00%

2018

2019

2020

0
0
0

0
0
0

0
0
0

CAGR
0.00%
0.00%
0.00%

0.00%

Sales Forecast
Jan

Feb

Sales
Standard No Breakfast (A)
Standard No Cancellation (B)
Superior Corner (C)
Twin or King Deluxe (D)
DRSV (E)
Club Deluxe (F)
Family Suite (G)
Club Suite (G1)
Ambassador (H)
Presidential (I)
M.I.C.E.
outlet
outlet 2
outlet 3
Office Rental
Retail Rental
SPA
PABX, Business Center, Mini Bar, Laundry,
Hotel Car
Total Sales

Direct Cost of Sales

Standard No Breakfast A
Standard no Cancellation B
Superior Corner C
Twin or King Deluxe D
DRSV E
Club Deluxe F
Family Suite G
Club Suite G1
Ambassador H
Presidential I
M.I.C.E.
outlet
outlet 2
outlet 3
SPA
PABX, Business Center, Laundry, Hotel Car, Mini Bar
Subtotal Direct Cost of Sales

$3,652
$15,196
$0
$93,838
$34,838
$7,257
$0
$4,308
$2,845
$748
$50,656
$28,031
$8,058
$16,678
$9,500
$2,315
$2,600
$7,150

$3,417
$10,661
$0
$73,153
$28,969
$9,052
$81
$4,030
$2,662
$0
$33,253
$22,939
$14,556
$19,970
$9,500
$2,315
$2,600
$7,150

$287,670

$244,308

Jan

$475
$3,799
$0
$13,607
$5,400
$1,451
$0
$668
$128
$15
$15,283
$6,108
$3,835
$12,958
$598
$1,502
$65,827

Feb

$444
$2,665
$0
$10,607
$4,490
$1,810
$20
$625
$120
$0
$9,937
$7,116
$6,140
$10,700
$598
$1,502
$56,774

Sales Forecast
Jan

Feb

Unit Sales
Row 1
Total Unit Sales

0
0

0
0

Unit Prices

Jan
$0.00

Row 1

Feb
$0.00

Sales
Row 1
Total Sales

$0
$0

Direct Unit Costs

Row 1

0.00%

Jan
$0.00

$0
$0
Feb
$0.00

Direct Cost of Sales

Row 1
Subtotal Direct Cost of Sales

$0
$0

$0
$0

Mar

Apr

May

Jun

Jul

$3,652
$18,995
$0
$140,757
$46,451
$19,353
$87
$5,170
$2,845
$0
$51,850
$41,204
$10,072
$36,077
$9,500
$2,315
$2,600
$7,150

$3,535
$22,058
$18,382
$300,000
$56,190
$28,093
$84
$41,693
$5,507
$7,243
$84,603
$38,952
$14,621
$37,909
$9,500
$2,315
$2,600
$7,150

$4,206
$29,884
$40,467
$350,000
$93,409
$27,827
$2,604
$16,824
$6,178
$8,236
$71,597
$54,629
$18,130
$41,960
$9,500
$2,315
$2,600
$7,150

$16,283
$32,000
$46,994
$450,000
$150,000
$49,000
$840
$32,562
$2,989
$7,970
$87,285
$84,264
$24,304
$48,270
$9,500
$2,315
$2,600
$7,150

$22,715
$90,000
$76,482
$600,000
$220,000
$75,000
$4,687
$56,780
$8,340
$11,118
$93,969
$94,145
$25,344
$51,970
$9,500
$2,315
$2,600
$7,150

$398,078

$680,435

$787,516

$1,054,326

$1,452,115

Mar

$475
$4,749
$0
$20,410
$7,200
$3,871
$22
$801
$128
$0
$15,202
$13,343
$4,670
$19,036
$598
$1,502
$92,007

Mar
0
0

Apr

$460
$5,515
$3,217
$43,500
$8,709
$5,619
$21
$6,462
$248
$145
$25,281
$16,377
$6,156
$22,115
$598
$1,502

$145,925

Apr
0
0

May

$547
$7,471
$7,082
$50,750
$14,478
$5,565
$651
$2,608
$278
$165
$20,798
$15,414
$7,645
$25,286
$598
$1,502

$160,838

May
0
0

Jun

$2,117
$8,000
$8,224
$65,250
$23,250
$9,800
$210
$5,047
$135
$159
$25,645
$17,896
$9,793
$38,270
$598
$1,502

$215,896

Jun
0
0

Jul

$2,953
$22,500
$13,384
$87,000
$34,100
$15,000
$1,172
$8,801
$375
$222
$28,664
$19,363
$10,565
$46,371
$598
$1,502

$292,570

Jul
0
0

Mar
$0.00
$0
$0
Mar
$0.00
$0
$0

Apr
$0.00
$0
$0
Apr
$0.00
$0
$0

May
$0.00
$0
$0
May
$0.00
$0
$0

Jun
$0.00
$0
$0
Jun
$0.00
$0
$0

Jul
$0.00
$0
$0
Jul
$0.00
$0
$0

Aug

Sep

Oct

Nov

Dec

$16,826
$29,884
$56,654
$325,000
$110,000
$22,262
$3,472
$33,647
$15,444
$8,236
$80,153
$77,687
$21,282
$50,402
$9,500
$2,315
$2,600
$7,150

$16,283
$28,920
$31,329
$171,531
$67,797
$21,544
$840
$32,562
$8,968
$7,970
$57,381
$47,517
$14,914
$45,818
$9,500
$2,315
$2,600
$7,150

$4,206
$30,391
$30,391
$156,397
$30,967
$14,515
$87
$17,233
$2,845
$7,484
$116,009
$56,471
$13,809
$46,965
$9,500
$2,315
$2,600
$7,150

$4,071
$14,705
$0
$136,217
$22,476
$9,364
$84
$16,677
$2,754
$724
$94,130
$38,408
$10,137
$34,648
$9,500
$2,315
$2,600
$7,150

$4,206
$15,196
$0
$93,838
$23,225
$9,677
$868
$4,308
$0
$0
$207,170
$31,758
$8,383
$33,068
$9,500
$2,315
$2,600
$7,150

$872,514

$574,939

$549,335

$405,960

$453,262

Aug

$2,187
$7,471
$9,914
$47,125
$17,050
$4,452
$868
$5,215
$695
$165
$24,681
$18,691
$8,707
$35,285
$598
$1,502

$184,606

Aug
0
0

Sep

$2,117
$7,230
$5,483
$24,872
$10,509
$4,309
$210
$5,047
$404
$159
$15,688
$16,790
$6,260
$22,026
$598
$1,502

$123,204

Sep
0
0

Oct

$547
$7,598
$5,318
$22,678
$4,800
$2,903
$22
$2,671
$128
$150
$33,353
$17,265
$5,888
$25,839
$598
$1,502

$131,260

Oct
0
0

Nov

$529
$3,676
$0
$19,751
$3,484
$1,873
$21
$2,585
$124
$14
$24,627
$12,876
$4,483
$18,098
$598
$1,502
$94,241

Nov
0
0

Dec

$547
$3,799
$0
$13,607
$3,600
$1,935
$217
$668
$0
$0
$70,661
$12,217
$4,060
$14,623
$598
$1,502

$128,034

Dec
0
0

Aug
$0.00
$0
$0
Aug
$0.00
$0
$0

Sep
$0.00
$0
$0
Sep
$0.00
$0
$0

Oct
$0.00
$0
$0
Oct
$0.00
$0
$0

Nov
$0.00
$0
$0
Nov
$0.00
$0
$0

Dec
$0.00
$0
$0
Dec
$0.00
$0
$0

2016
$103,052
$337,890
$300,699
$2,890,731
$884,322
$292,944
$13,734
$265,794
$61,377
$59,729
$1,028,056
$616,005
$183,610
$463,735
$114,000
$27,780
$31,200
$85,800
$7,760,458
2016
$13,398
$84,473
$52,622
$419,157
$137,070
$58,588
$3,434
$41,198
$2,763
$1,194
$309,820
$173,456
$78,202
$290,607
$7,176
$18,024
$1,691,182

2016
0
0

2016
$0.00
$0
$0
2016
$0.00
$0
$0

Jan

Feb

Mar

Apr

$3,652
$15,196
$0

$3,417
$10,661
$0

$3,652
$18,995
$0

$3,535
$22,058
$18,382

$18,848

$14,078

$22,647

$43,975

Jan
$475

Feb
$444

Mar
$475

Apr
$460

$598

$598

$598

$598

$1,073

$1,042

$1,073

$1,058

Jan
0
0

Feb
0
0

Mar
0
0

Apr
0
0

Jan
$0.00
$0
$0
Jan
$0.00
$0
$0

Feb
$0.00
$0
$0
Feb
$0.00
$0
$0

Mar
$0.00
$0
$0
Mar
$0.00
$0
$0

Apr
$0.00
$0
$0
Apr
$0.00
$0
$0

May

Jun

Jul

Aug

Sep

$4,206
$29,884
$40,467

$16,283
$32,000
$46,994

$22,715
$90,000
$76,482

$16,826
$29,884
$56,654

$16,283
$28,920
$31,329

$74,557

$95,277

$189,197

$103,364

$76,532

May
$547

Jun
$2,117

Jul
$2,953

Aug
$2,187

Sep
$2,117

$598

$598

$598

$598

$598

$1,145

$2,715

$3,551

$2,785

$2,715

May
0
0

Jun
0
0

Jul
0
0

Aug
0
0

Sep
0
0

May
$0.00
$0
$0
May
$0.00
$0
$0

Jun
$0.00
$0
$0
Jun
$0.00
$0
$0

Jul
$0.00
$0
$0
Jul
$0.00
$0
$0

Aug
$0.00
$0
$0
Aug
$0.00
$0
$0

Sep
$0.00
$0
$0
Sep
$0.00
$0
$0

Oct

Nov

Dec

2016

2017

$4,206
$30,391
$30,391

$4,071
$14,705
$0

$4,206
$15,196
$0

$103,052
$337,890
$300,699

#REF!
#REF!
#REF!

$64,988

$18,776

$19,402

$741,641

#REF!

Oct
$547

Nov
$529

Dec
$547

2016
$13,398

2017
#REF!

$598

$598

$598

$7,176

#REF!

$1,145

$1,127

$1,145

$20,574

#REF!

Oct
0
0

Nov
0
0

Dec
0
0

2016
0
0

2017
#REF!
#REF!

Oct
$0.00
$0
$0
Oct
$0.00
$0
$0

Nov
$0.00
$0
$0
Nov
$0.00
$0
$0

Dec
$0.00
$0
$0
Dec
$0.00
$0
$0

2016
$0.00
$0
$0
2016
$0.00
$0
$0

2017
#REF!
#REF!
#REF!
2017
#REF!
#REF!
#REF!

2018

2019

2020

#REF!
#REF!
#REF!

#REF!
#REF!
#REF!

#REF!
#REF!
#REF!

#REF!

#REF!

#REF!

2018
#REF!

2019
#REF!

2020
#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

#REF!

2018

2019

2020

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

2018
#REF!

2019
#REF!

2020
#REF!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

2018
#REF!

2019
#REF!

2020
#REF!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

Jan
$0
$0
$0

$0
Jan
$0

$0
$0

Jan
0
0

Jan
$0.00
$0
$0
Jan
$0.00
$0
$0

Feb

Mar

Apr

May

Jun

$0
$0
$0

$0
$0
$0

$0
$0
$0

$0
$0
$0

$0
$0
$0

$0

$0

$0

$0

$0

Feb
$0

Mar
$0

Apr
$0

May
$0

Jun
$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Feb

Mar

Apr

May

Jun

0
0

0
0

0
0

0
0

0
0

Feb
$0.00
$0
$0
Feb
$0.00
$0
$0

Mar
$0.00
$0
$0
Mar
$0.00
$0
$0

Apr
$0.00
$0
$0
Apr
$0.00
$0
$0

May
$0.00
$0
$0
May
$0.00
$0
$0

Jun
$0.00
$0
$0
Jun
$0.00
$0
$0

Jul

Aug

Sep

Oct

Nov

$0
$0
$0

$0
$0
$0

$0
$0
$0

$0
$0
$0

$0
$0
$0

$0

$0

$0

$0

$0

Jul
$0

Aug
$0

Sep
$0

Oct
$0

Nov
$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Jul

Aug

Sep

Oct

Nov

0
0

0
0

0
0

0
0

0
0

Jul
$0.00
$0
$0
Jul
$0.00
$0
$0

Aug
$0.00
$0
$0
Aug
$0.00
$0
$0

Sep
$0.00
$0
$0
Sep
$0.00
$0
$0

Oct
$0.00
$0
$0
Oct
$0.00
$0
$0

Nov
$0.00
$0
$0
Nov
$0.00
$0
$0

Dec

2016

2017

2018

2019

$0
$0
$0

$0
$0
$0

#REF!
#REF!
#REF!

#REF!
#REF!
#REF!

#REF!
#REF!
#REF!

$0

$0

#REF!

#REF!

#REF!

Dec
$0

2016
$0

2017
#VALUE!

2018
#VALUE!

2019
#VALUE!

$0

$0

#VALUE!

#VALUE!

#VALUE!

$0

$0

#VALUE!

#VALUE!

#VALUE!

2017

2018

2019

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

Dec
0
0

2016
0
0

Dec
$0.00
$0
$0
Dec
$0.00
$0
$0

2016
$0.00
$0
$0
2016
$0.00
$0
$0

2017
#REF!

2018
#REF!

2019
#REF!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

2017
#VALUE!

2018
#VALUE!

2019
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

2020
#REF!
#REF!
#REF!

#REF!
2020
#VALUE!

#VALUE!
#VALUE!

2020
#REF!
#REF!

2020
#REF!
#REF!
#REF!
2020
#VALUE!
#VALUE!
#VALUE!

Personnel Plan
Jan
$0

Payroll

Feb
$0

Mar
$0

Apr
$0

May
$0

Jun
$0

Jul
$0

Aug
$0

Sep
$0

Oct
$0

Nov
$0

Dec
$0

2016
$0

Dec

2016
$1,036,800
192

Personnel Plan
Jan
All Hotel & Office Tower staffing
Total People

Total Payroll

Average Salary
Revenue per employee
Net Profit Per Employee

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

192

Jan '16

Head Count

Feb

$86,400

192

Feb '16
192

192

Mar '16
192

192

Apr '16
192

192

May '16
192

192

June '16
192

192

July '16
192

192

Aug '16
192

192

Sept '16
192

192

Oct '16
192

192

Nov '16
192

192

Dec '16
192

$1,036,800
FY2016

192

192

$450

$450

$450

$450

$450

$450

$450

$450

$450

$450

$450

$450

$5,400

$1,498

$1,272

$2,073

$3,544

$4,102

$5,491

$7,563

$4,544

$2,994

$2,861

$2,114

$2,361

$40,419

$754

$1,220

$2,084

$3,518

$1,375

$303

$148

($824)

($997)

($399)

($334)

($276)

$6,572

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$1,161,216

Salaries & Wages

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$1,036,800

All hotel & Office Tower

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$1,036,800

Employee related expense

$10,368

$10,368

$10,368

$10,368

$10,368

$10,368

$10,368

$10,368

$10,368

$10,368

$10,368

$10,368

$124,416

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$96,768

$1,161,216

Personnel Expenses

TOTAL

Personnel Plan
Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

2016

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

0
$0
$0

192

192
$5,400
$1,036,800

Production Personnel
Subtotal

Sales and Marketing Personnel

Subtotal

General and Administrative Personnel

Subtotal

Other Personnel
Subtotal
Total People

Total Payroll

0
$0

Personnel Plan
2016

Production Personnel
People
Average per Person
Subtotal

Sales and Marketing Personnel

People
Average per Person
Subtotal

General and Administrative Personnel

People
Average per Person
Subtotal

Other Personnel
People
Average per Person
Subtotal
Total People

Total Payroll Expenditures

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

192

$450
$86,400

192
$86,400

$450
$86,400

192
$86,400

192
$1,036,800

Startup
Requirements
Startup Expenses
Legal
Stationery etc.
Insurance
Rent
Computer
Other
Total Startup Expenses

$0
$0
$0
$0
$0
$0
$0

Startup Assets
Cash Required
Startup Inventory
Other Current Assets
Long-term Assets
Total Assets

$0
$0
$0
$0
$0

Total Requirements

$0

Pro Forma Profit and Loss

Jan

Sales

$287,670
$65,827
$0

Direct Cost of Sales

Production Payroll
Total Cost of Sales
Gross Margin
Gross Margin %

Feb
$244,308
$56,774
$0

Mar
$398,078
$92,007
$0

Apr
$680,435
$145,925
$0

May
$787,516
$160,838
$0

Jun
$1,054,326
$215,896
$0

Jul
$1,452,115
$292,570
$0

Aug
$872,514
$184,606
$0

Sep
$574,939
$123,204
$0

Oct
$549,335
$131,260
$0

Nov
$405,960
$94,241
$0

Dec
$453,262
$128,034
$0

2016
$7,760,458
$1,691,182
$0

Jan
#VALUE!
#VALUE!
$0

Feb
$0
$0
$0

Mar
$18,848
$1,073
$0

Apr
$14,078
$1,042
$0

May
$22,647
$1,073
$0

Jun
$43,975
$1,058
$0

Jul
$74,557
$1,145
$0

Aug
$95,277
$2,715
$0

Sep
$189,197
$3,551
$0

Oct
$103,364
$2,785
$0

Nov
$76,532
$2,715
$0

Dec
$64,988
$1,145
$0

2016

2017

2018

2019

2020

#VALUE!
#VALUE!
$0

$19,402
$1,145
#REF!

$741,641
$20,574
#REF!

#REF!
#REF!
#REF!

#REF!
#REF!
#REF!

$65,827

$56,774

$92,007

$145,925

$160,838

$215,896

$292,570

$184,606

$123,204

$131,260

$94,241

$128,034

$1,691,182

#VALUE!

$0

$1,073

$1,042

$1,073

$1,058

$1,145

$2,715

$3,551

$2,785

$2,715

$1,145

#REF!

#REF!

#REF!

$221,843
77.12%

$187,534
76.76%

$306,071
76.89%

$534,510
78.55%

$626,678
79.58%

$838,430
79.52%

$1,159,545
79.85%

$687,908
78.84%

$451,735
78.57%

$418,075
76.11%

$311,719
76.79%

$325,228
71.75%

$6,069,276
78.21%

#VALUE!
#VALUE!

$0
0.00%

$17,775
94.31%

$13,036
92.60%

$21,574
95.26%

$42,917
97.59%

$73,412
98.46%

$92,562
97.15%

$185,646
98.12%

$100,579
97.31%

$73,817
96.45%

$63,843
98.24%

#VALUE!
#VALUE!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

$0
$7,192
$0
$7,192
2.50%

$0
$6,108
$0
$6,108
2.50%

$0
$9,952
$0
$9,952
2.50%

$0
$17,011
$0
$17,011
2.50%

$0
$19,688
$0
$19,688
2.50%

$0
$26,358
$0
$26,358
2.50%

$0
$36,303
$0
$36,303
2.50%

$0
$21,813
$0
$21,813
2.50%

$0
$14,373
$0
$14,373
2.50%

$0
$13,733
$0
$13,733
2.50%

$0
$10,149
$0
$10,149
2.50%

$0
$11,332
$0
$11,332
2.50%

$0
$194,012
$0
$194,012
0.00%

$0
$7,192
$0
$7,192
#VALUE!

$0
$6,108
$0
$6,108
0.00%

$0
$9,952
$0
$9,952
0.00%

$0
$17,011
$0
$17,011
0.00%

$0
$19,688
$0
$19,688
0.00%

$0
$26,358
$0
$26,358
0.00%

$0
$36,303
$0
$36,303
0.00%

$0
$21,813
$0
$21,813
0.00%

$0
$14,373
$0
$14,373
0.00%

$0
$13,733
$0
$13,733
0.00%

$0
$10,149
$0
$10,149
0.00%

$0
$11,332
$0
$11,332
0.00%

$0
$194,012
$0
$194,012
#VALUE!

#VALUE!

#REF!
#REF!
#REF!
#REF!
0.00%

#REF!

#REF!
#REF!
#REF!
#REF!
0.00%

#REF!
#REF!
#REF!
#REF!
#REF!

#REF!
#REF!
#REF!
#REF!
#REF!

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$86,400

$1,036,800

#REF!

#REF!

#REF!

#REF!

$0
$0
$86,400
0.00%

$0
$0
$86,400
0.00%

$0
$0
$86,400
0.00%

$0
$0
$86,400
0.00%

$0
$0
$1,036,800
#VALUE!

#REF!
#REF!
#REF!
0.00%

$0
$0
$0
$0
#VALUE!

Operating Expenses
Sales and Marketing Expenses

Sales and Marketing Payroll

Advertising/Promotion
Other Sales and Marketing Expenses
Total Sales and Marketing Expenses
Sales and Marketing %

Expenses

Payroll
Payroll Taxes
Rout ine & corrective maint
Repair
U tility
Wast e M anagement
Gas
Cleaning
Supplies
Busines s trip expenses
Transportation
Spare part s
Post al & communic at ion
Car Fuel
Stationary
Training & development
Low value items
Insurance
Security Company
HSE
MIT
Consult ing fee
Bank Fee
Real estate tax
Vehicle tax
L and tax
Best Western Internat ional Market ing
fee
Best Western Franchise Fee
Depreciation
Other
Total Expense
General and Administrative %

Other Expenses:

Other Payroll
Consultants
Other Expenses
Total Other Expenses
Other %

Total Operating Expenses

Profit Before Interest and Taxes
EBITDA
Interest Expense (BOC)
Taxes Incurred
Other Income
Other Income Account Name
Total Other Income
Other Expense
Other Expense Account Name
Total Other Expense
Net Other Income

Net Profit
Net Profit/Sales
Include Negative Taxes

15%

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$86,400
$10,368

$1,036,800
$124,416

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$30,235
$3,013
$22,500
$260
$470
$2,578
$2,337
$755
$210
$914
$5,220
$820
$820
$260
$1,484
$9,204
$3,473
$2,690
$850
$2,227
$8,559
$18,333
$12
$27
$4,046
$5,000

$362,820
$36,156
$270,000
$3,120
$5,640
$30,936
$28,044
$9,060
$2,520
$10,968
$62,640
$9,840
$9,840
$3,120
$17,808
$110,448
$41,676
$32,280
$10,200
$26,724
$102,708
$219,996
$144
$324
$48,552
$60,000

$0
$0
$223,065
77.54%

$0
$0
$223,065
91.30%

$0
$0
$223,065
56.04%

$0
$0
$223,065
32.78%

$0
$0
$223,065
28.33%

$0
$0
$223,065
21.16%

$0
$0
$223,065
15.36%

$0
$0
$223,065
25.57%

$0
$0
$223,065
38.80%

$0
$0
$223,065
40.61%

$0
$0
$223,065
54.95%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$223,065

$223,065

$223,065

$223,065

$223,065

$223,065

$223,065

$223,065

$223,065

$223,065

$223,065

$73,054
$73,054
$0
$21,916

$294,434
$294,434
$0
$88,330

$383,925
$383,925
$0
$115,178

$589,007
$589,007
$978,429
($116,827)

$900,177
$900,177

$443,030
$443,030

$214,297
$214,297

$181,277
$181,277

$78,505
$78,505

$270,053

$132,909

$64,289

$54,383

$23,552

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

($8,414)
($8,414)
$0
($2,524)

$0
$0

$0
$0
$0
($5,890)
-2.05%

($41,639)
($41,639)
$0
($12,492)

$0
$0

$0
$0
$0
($29,147)
-11.93%

$0
$0

$0
$0

$0
$0

$0
$51,138
12.85%

$0
$206,104
30.29%

$0
$268,748
34.13%

$0
$0

$0
$0
$0
($272,595)
-25.85%

$0
$0

$0
$0

$0
$0

$0
$0

$0
$0

$0
$630,124
43.39%

$0
$310,121
35.54%

$0
$150,008
26.09%

$0
$126,894
23.10%

$0
$54,954
13.54%

$0
$0
$223,065
49.21%

$0
$0
$2,676,780
34.49%

$86,400

$0
$0
$86,400
#VALUE!

$86,400

$86,400

$86,400

($86,400)
($86,400)
$0
($12,492)

($68,625)
($68,625)
$0
$21,916

($73,364)
($73,364)
$0
$88,330

($64,826)
($64,826)
$0
$115,178

$0
$0
$0
($572,107)
-126.22%

$0
$0
$0
$918,350
11.83%
1

$0
$0
$0
#VALUE!
#VALUE!

$0
$0

$0
$0
$0
($73,908)
0.00%

$0
$0

$0
$0
$0
($90,541)
-480.38%

$0
$0
$0
$0
0.00%

$0
$0
$86,400
0.00%

$86,400

#VALUE!
#VALUE!
$0
($2,524)

$0
$0

$0
$0
$0
$0
0.00%

$0
$0
$86,400
0.00%

$86,400

$3,198,484
$3,198,484
$1,886,556
$393,578

$0
$0

$0
$0
$0
$0
0.00%

$0
$0
$86,400
0.00%

$0
$0
$0
$0
0.00%
$2,676,780

$0
$0

$0
$0
$0
$0
#VALUE!

$0
$0
$86,400
0.00%

$0
$0
$0
$0
0.00%
$223,065
$90,831
$90,831
$908,127
($245,189)

$0
$0

$0
$0
$0
($161,694)
-1148.56%

$0
$0
$0
$0
0.00%

$0
$0

$0
$0
$0
($180,004)
-794.82%

$0
$0
$86,400
0.00%

$0
$0
$0
$0
0.00%
$86,400
($43,483)
($43,483)
$978,429
($116,827)

$0
$0

$0
$0
$0
($905,085)
-2058.18%

$0
$0
$86,400
0.00%

$0
$0
$0
$0
0.00%
$86,400
($12,988)
($12,988)
$0
$270,053

$0
$0

$0
$0
$0
($283,041)
-379.63%

$0
$0
$86,400
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
0.00%

$86,400

$86,400

$86,400

$86,400

$6,162
$6,162
$0
$132,909

$99,246
$99,246
$0
$64,289

$14,179
$14,179
$0
$54,383

($12,583)
($12,583)
$0
$23,552

$0
$0

$0
$0

$0
$0

$0
$0
$0
($126,747)
-133.03%

$0
$0
$0
$34,957
18.48%

$0
$0
$0
($40,204)
-38.90%

$0
$0
$0
$0
0.00%

$0
$0

$0
$0
$0
($36,135)
-47.21%

$0
$0
$0
$0
0.00%
$86,400
($22,557)
($22,557)
$908,127
($245,189)

$0
$0

$0
$0
$0
($685,495)
-1054.80%

#REF!
#REF!
#REF!
0.00%

#REF!
#REF!
#REF!
#REF!

#REF!
#REF!
#REF!
#REF!

#REF!
#REF!
#REF!
#REF!
0.00%

#REF!
#REF!
#REF!
#REF!
0.00%

#REF!
#REF!
#REF!
#REF!
#REF!

#REF!
#REF!
#REF!
#REF!
#REF!

$1,036,800

#REF!

#REF!

#REF!

#REF!

#VALUE!
#VALUE!
$1,886,556
$393,578

#REF!
#REF!
#REF!
#REF!

#REF!
#REF!
#REF!
#REF!

#REF!
#REF!
#REF!
#REF!

#REF!
#REF!
#REF!
#REF!

$0
$0

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

$0
$0

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

$0
#REF!
#REF!

$0
#REF!
#REF!

$0
#REF!
#REF!

$0
#REF!
#REF!

$0
#VALUE!
#VALUE!

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

2016

2017

2018

2019

2020

#VALUE!
#VALUE!
$0

($244,308)
$56,774
$0

($379,230)
$90,934
$0

($666,357)
$144,883
$0

($764,869)
$159,765
$0

($1,010,351)
$214,838
$0

($1,377,558)
$291,425
$0

($777,237)
$181,891
$0

($385,742)
$119,653
$0

($445,971)
$128,475
$0

($329,428)
$91,526
$0

($388,274)
$126,889
$0

#VALUE!
#VALUE!
$0

#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!

#REF!
#VALUE!
#VALUE!

#REF!
#VALUE!
#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

$144,883

$159,765

$214,838

$181,891

$119,653

$128,475

$126,889

#VALUE!
#VALUE!

#VALUE!

($187,534)
-76.76%

($288,296)
17.42%

($521,474)
14.04%

($605,104)
15.69%

($795,513)
18.07%

($1,086,133)
18.61%

($595,346)
18.31%

($266,089)
19.55%

($317,496)
21.20%

($237,902)
19.67%

($261,385)
26.49%

#VALUE!
#VALUE!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

$0
$0
$0
$0
#VALUE!

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
2.50%

$0
$0
$0
$0
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

#VALUE!

#VALUE!

#VALUE!

#VALUE!

$0

$0
$0
$0
#VALUE!

$0
$0
$0
$0
#VALUE!
$0
#VALUE!
#VALUE!
$0
$0

$0
$0

$0
$0
$0
#VALUE!
#VALUE!

$56,774

$0
$0
$0
91.30%

$0
$0
$0
$0
0.00%
$0
($44,761)
($44,761)
$0
$0

$0
$0

$0
$0
$0
($44,761)
18.32%

$90,934

$0
$0
$0
56.04%

$0
$0
$0
$0
0.00%
$0
($141,679)
($141,679)
$0
$0

$0
$0

$0
$0
$0
($141,679)
37.36%

$0
$0
$0
32.78%

$0
$0
$0
$0
0.00%
$0
($367,798)
($367,798)
$0
$0

$0
$0

$0
$0
$0
($367,798)
55.20%

$0
$0
$0
28.33%

$0
$0
$0
$0
0.00%
$0
($448,751)
($448,751)
$0
$0

$0
$0

$0
$0
$0
($448,751)
58.67%

$0
$0
$0
21.16%

$0
$0
$0
$0
0.00%
$0
($632,490)
($632,490)
$0
$0

$0
$0

$0
$0
$0
($632,490)
62.60%

$291,425

$0
$0
$0
15.36%

$0
$0
$0
$0
0.00%
$0
($913,165)
($913,165)
$0
$0

$0
$0

$0
$0
$0
($913,165)
66.29%

$0
$0
$0
25.57%

$0
$0
$0
$0
0.00%
$0
($436,868)
($436,868)
$0
$0

$0
$0

$0
$0
$0
($436,868)
56.21%

$0
$0
$0
38.80%

$0
$0
$0
$0
0.00%
$0
($115,051)
($115,051)
$0
$0

$0
$0

$0
$0
$0
($115,051)
29.83%

$0
$0
$0
40.61%

$0
$0
$0
$0
0.00%
$0
($167,098)
($167,098)
$0
$0

$0
$0

$0
$0
$0
($167,098)
37.47%

$91,526

$0
$0
$0
54.95%

$0
$0
$0
$0
0.00%
$0
($91,088)
($91,088)
$0
$0

$0
$0

$0
$0
$0
($91,088)
27.65%

$0

$0
$0
$0
49.21%

$0
$0
$0
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

$0
$0
$0
$0
0.00%

$0
$0
$0
$0
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#REF!
#REF!
#VALUE!
#VALUE!

#REF!
#REF!
#VALUE!
#VALUE!

#REF!
#REF!
#VALUE!
#VALUE!

#REF!
#REF!
#VALUE!
#VALUE!

#REF!
#REF!

#REF!
#REF!

#REF!
#REF!

$0
($113,388)
($113,388)
$0
$0

$0
$0

$0
$0
$0
($113,388)
29.20%

$0
#VALUE!
#VALUE!
$0
$0

$0
$0

$0
$0
$0
#VALUE!
#VALUE!

#REF!
#REF!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#REF!
#VALUE!

#VALUE!
#REF!
#VALUE!

#VALUE!
#REF!
#REF!

#VALUE!
#REF!
#REF!

Startup Funding
Startup Expenses to Fund
Startup Assets to Fund
Total Funding Required

$0
$0
$0

Assets
Non-cash Assets from Startup
Cash Requirements from Startup
Additional Cash Raised
Cash Balance on Starting Date
Total Assets

$0
$0
$0
$0
$0

Liabilities and Capital

Liabilities
Current Borrowing
Long-term Liabilities
Accounts Payable (Outstanding Bills)
Other Current Liabilities (interest-free)
Total Liabilities

$0
$0
$0
$0
$0

Capital
Planned Investment
Owner
Investor
Additional Investment Requirement
Total Planned Investment

$0
$0
$0
$0

Loss at Startup (Startup Expenses)

Total Capital

$0
$0

Total Capital and Liabilities

$0

Total Funding

$0

startup_accounts_payable

Past Performance
Sales
Gross Margin
Gross Margin %
Operating Expenses
Collection Period (days)
Inventory Turnover

2013
$0
$0
0.00%
$0
0
0.00

2014
$0
$0
0.00%
$0
0
0.00

2015
$0
$0
0.00%
$0
19
0.00

2013

2014

2015

Balance Sheet
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets

$0
$0
$0
$0
$0

$0
$0
$0
$0
$0

$100,000
$203,805
$120,000
$0
$423,805

Long-term Assets
Long-term Assets
Accumulated Depreciation
Total Long-term Assets

$0
$0
$0

$0
$0
$0

$23,603,883
$1,889,924
$21,713,959

Total Assets

$0

$0

$22,137,764

Current Liabilities
Accounts Payable
Current Borrowing
Other Current Liabilities (interest free)
Total Current Liabilities

$0
$0
$0
$0

$0
$0
$0
$0

$17,520
$0
$0
$17,520

Long-term Liabilities
Total Liabilities

$0
$0

$0
$0

$0
$17,520

Paid-in Capital
Retained Earnings
Earnings
Total Capital

$0
$0
$0
$0

$0
$0
$0
$0

$0
$22,120,244
$0
$22,120,244

Total Capital and Liabilities

$0

$0

$22,137,764

0
$0
0.00

15
$1,800,000
0.00

10
$2,000,000
9.81

Other Inputs
Payment Days
Sales on Credit
Receivables Turnover

Pro Forma Cash Flow

Jan

Feb

Mar

Apr

Cash Received
Cash from Operations
Cash Sales
Cash from Receivables
Subtotal Cash from Operations
Additional Cash Received
Non Operating (Other) Income
Sales Tax, VAT, HST/GST Received
New Current Borrowing
New Other Liabilities (interest-free)
New Long-term Liabilities
Sales of Other Current Assets
Sales of Long-term Assets
New Investment Received
Subtotal Cash Received

Expenditures
Expenditures from Operations
Cash Spending
Bill Payments
Subtotal Spent on Operations
Additional Cash Spent
Non Operating (Other) Expense
Sales Tax, VAT, HST/GST Paid Out
Principal Repayment of Current Borrowing
Other Liabilities Principal Repayment
Long-term Liabilities Principal Repayment
Purchase Other Current Assets
Purchase Long-term Assets
Dividends

10.00%

$158,219
$208,120
$366,339

$134,369
$128,801
$263,170

$218,943
$112,245
$331,188

$374,239
$183,370
$557,610

$0
$28,767
$0
$0
$0
$0
$0
$0
$395,106

$0
$24,431
$0
$0
$0
$0
$0
$0
$287,601

$0
$39,808
$0
$0
$0
$0
$0
$0
$370,996

$0
$68,044
$0
$0
$0
$0
$0
$0
$625,653

Jan

Feb

Mar

Apr

$86,400
$119,576
$205,976

$86,400
$164,064
$250,464

$86,400
$251,643
$338,043

$86,400
$383,133
$469,533

$0
$28,767
$0
$0
$0
$0
$0
$0

$0
$24,431
$0
$0
$0
$0
$0
$0

$0
$39,808
$0
$0
$0
$0
$0
$0

$0
$68,044
$0
$0
$0
$0
$0
$0

Subtotal Cash Spent

$234,743

$274,895

$377,851

$537,577

Net Cash Flow

$160,362
$260,362
$1

$12,706
$273,068
$1

($6,855)
$266,213
$1

$88,077
$354,290
$1

Cash Balance

May

Jun

Jul

Aug

Sep

Oct

Nov

$433,134
$307,802
$740,936

$579,879
$358,384
$938,264

$798,663
$480,414
$1,279,077

$479,883
$644,758
$1,124,640

$316,216
$388,168
$704,384

$302,134
$258,338
$560,473

$223,278
$245,050
$468,328

$0
$78,752
$0
$0
$0
$0
$0
$0
$819,687

$0
$105,433
$0
$0
$0
$0
$0
$0
$1,043,696

$0
$145,212
$0
$0
$0
$0
$0
$0
$1,424,288

$0
$87,251
$0
$0
$0
$0
$0
$0
$1,211,892

$0
$57,494
$0
$0
$0
$0
$0
$0
$761,878

$0
$54,934
$0
$0
$0
$0
$0
$0
$615,406

$0
$40,596
$0
$0
$0
$0
$0
$0
$508,924

May

Jun

Jul

Aug

Sep

Oct

Nov

$86,400
$426,767
$513,167

$86,400
$1,016,733
$1,103,133

$86,400
$923,940
$1,010,340

$86,400
$475,140
$561,540

$86,400
$287,794
$374,194

$86,400
$310,082
$396,482

$86,400
$251,316
$337,716

$0
$78,752
$0
$0
$0
$0
$0
$0

$0
$105,433
$0
$0
$1,700,297
$0
$0
$0

$0
$145,212
$0
$0
$0
$0
$0
$0

$0
$87,251
$0
$0
$0
$0
$0
$0

$0
$57,494
$0
$0
$0
$0
$0
$0

$0
$54,934
$0
$0
$0
$0
$0
$0

$0
$40,596
$0
$0
$0
$0
$0
$0

$591,919

$2,908,863

$1,155,551

$648,791

$431,688

$451,415

$378,312

$227,769
$582,059
$1

($1,865,166)
($1,283,108)
$1

$268,737
($1,014,371)
$1

$563,101
($451,270)
$1

$330,190
($121,080)
$1

$163,991
$42,911
$1

$130,612
$173,523
$1

Dec

2016

$249,294
$183,392
$432,686

$4,268,252
$3,498,842
$7,767,094

$0
$45,326
$0
$0
$0
$0
$0
$0
$478,012

$0
$776,046
$0
$0
$0
$0
$0
$0
$8,543,140

Dec

2016

$86,400
$738,233
$824,633

$1,036,800
$5,348,421
$6,385,221

$0
$45,326
$0
$0
$1,700,297
$0
$0
$0

$0
$776,046
$0
$0
$3,400,594
$0
$0
$0

$2,570,256

$10,561,861

($2,092,244)
($1,918,721)

($2,018,721)
($1,918,721)

Sources and Uses of Cash

(Indirect Cash Flow Method)

Jan

Feb

Mar

Apr

($5,890)
$0
$26,218
$78,669
$54,173
$0
$0
$28,767
$0
$181,937

($29,147)
$0
$7,830
$18,862
$9,053
$0
$0
$24,431
$0
$31,029

$51,138
$0
$34,178
$0
$0
$0
$0
$39,808
$0
$125,124

$206,104
$0
$41,705
$0
$0
$0
$0
$68,044
$0
$315,852

Jan
$0
$0
$0
$0
$0
$0
$28,767
$28,767

Feb
$0
$0
$0
$0
$0
$0
$24,431
$24,431

Mar
$0
$66,890
$35,233
$0
$0
$0
$39,808
$141,931

Apr
$0
$122,825
$53,918
$0
$0
$0
$68,044
$244,787

($16,807)
$242,961

$71,066
$314,027

Sources of Cash
Net Income
Depreciation
Increase in Accounts Payable
Decrease in Accounts Receivable
Decrease in Inventory
New Loans
New Investment
Sales Taxes (VAT/GST) Collected
Sale of Assets
Subtotal Sources of Cash

Use of Cash
Decrease in Accounts Payable
Increase in Accounts Receivable
Increase in Inventory
Repay Loans
Purchase Other Assets
Distributions
Sales Tax Payment
Subtotal Uses of Cash

Net Cash Flow

Cash Balance

$153,170
$253,170

$6,598
$259,768

May

Jun

Jul

Aug

Sep
$150,008
$0
$0
$129,445
$61,402
$0
$0
$57,494
$0
$398,349

Oct
$126,894
$0
$20,282
$11,138
$0
$0
$0
$54,934
$0
$213,248

Nov

$268,748
$0
$827
$0
$0
$0
$0
$78,752
$0
$348,326

($272,595)
$0
$252,488
$0
$0
$0
$0
$105,433
$0
$85,326

$630,124
$0
$0
$0
$0
$0
$0
$145,212
$0
$775,335

$310,121
$0
$0
$252,126
$107,964
$0
$0
$87,251
$0
$757,463

$54,954
$0
$0
$62,368
$37,019
$0
$0
$40,596
$0
$194,937

May
$0
$46,580
$14,913
$0
$0
$0
$78,752
$140,245

Jun
$0
$116,062
$55,058
$1,700,297
$0
$0
$105,433
$1,976,850

Jul
$147,978
$173,038
$76,674
$0
$0
$0
$145,212
$542,902

Aug
$128,924
$0
$0
$0
$0
$0
$87,251
$216,175

Sep
$25,038
$0
$0
$0
$0
$0
$57,494
$82,532

Oct
$0
$0
$8,056
$0
$0
$0
$54,934
$62,990

Nov
$33,878
$0
$0
$0
$0
$0
$40,596
$74,474

$208,081
$522,108

($1,891,524)
($1,369,417)

$232,434
($1,136,983)

$541,288
($595,695)

$315,817
($279,878)

$150,258
($129,620)

$120,463
($9,157)

Dec

2016

Jan

Feb

Mar

Apr

($572,107)
$0
$223,198
$0
$0
$0
$0
$45,326
$0
($303,583)

$918,350
$0
$606,726
$552,608
$269,611
$0
$0
$776,046
$0
$3,123,341

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Dec
$0
$20,576
$33,793
$1,700,297
$0
$0
$45,326
$1,799,993

2016
$335,817
$545,972
$277,645
$3,400,594
$0
$0
$776,046
$5,336,074

Jan
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Feb
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Mar
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Apr
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

($2,103,576)
($2,112,733)

($2,212,733)
($2,112,733)

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

May

Jun

Jul

Aug

Sep

Oct

Nov

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

May
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Jun
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Jul
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Aug
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Sep
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Oct
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Nov
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

Dec

2017

2017

2018

2019

2020

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

Dec
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

2017
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

2017
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

2018
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

2019
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

2020
#VALUE!
#VALUE!
#VALUE!
#REF!
#REF!
#REF!
#REF!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

#VALUE!
#VALUE!

Inventory Detail
Months of Inventory On Hand
Minimum Inventory Purchase

Inventory Balance
Beginning Inventory Balance
Less Inventory Used as COGS
Plus Inventory Purchase
Ending Inventory Balance

Calculated Totals (not included in output)

Beginning Inventory Balance less COGS
Months On Hand times COGS
Direct Cost of Goods Sold/Previous Year's Direct Cost of Goods Sold
Previous Year's Ending Inventory Balance/Previous Year's Inventory Used in COGS
Months of Inventory On Hand/Previous Year's Inventory On Hand

Jan
1.00
$100

$120,000
$65,827
$11,654
$65,827

$54,173
$65,827
n.a.
n.a.
n.a.

Feb
1.00

Mar
1.00

Apr
1.00

$65,827
$56,774
$47,721
$56,774

$56,774
$92,007
$127,240
$92,007

$92,007
$145,925
$199,843
$145,925

$9,053
$56,774
n.a.
n.a.
n.a.

($35,233)
$92,007
n.a.
n.a.
n.a.

($53,918)
$145,925
n.a.
n.a.
n.a.

May
1.00

Jun
1.00

Jul
1.00

Aug
1.00

Sep
1.00

$145,925
$160,838
$175,751
$160,838

$160,838
$215,896
$270,954
$215,896

$215,896
$292,570
$369,244
$292,570

$292,570
$184,606
$76,642
$184,606

$184,606
$123,204
$61,802
$123,204

($14,913)
$160,838
n.a.
n.a.
n.a.

($55,058)
$215,896
n.a.
n.a.
n.a.

($76,674)
$292,570
n.a.
n.a.
n.a.

$107,964
$184,606
n.a.
n.a.
n.a.

$61,402
$123,204
n.a.
n.a.
n.a.

Oct
1.00

$123,204
$131,260
$139,316
$131,260

($8,056)
$131,260
n.a.
n.a.
n.a.

Nov
1.00

$131,260
$94,241
$57,222
$94,241

$37,019
$94,241
n.a.
n.a.
n.a.

Dec
1.00

2016
1.00

$94,241
$128,034
$161,827
$128,034

$120,000
$1,691,182
$1,699,216
$128,034

($33,793)
$128,034
n.a.
n.a.
n.a.

($1,571,182)
$128,034
n.a.
n.a.
n.a.

n.a.
n.a.
n.a.

Jan
1.00

Feb
1.00

Mar
1.00

Apr
1.00

May
1.00

$128,034
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

Jun
1.00

Jul
1.00

Aug
1.00

Sep
1.00

Oct
1.00

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

Nov
1.00

Dec
1.00

2017
#VALUE!

2017
1.00

2018
1.00

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

$128,034
#VALUE!
#VALUE!
#VALUE!

$128,034
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
n.a.
n.a.
n.a.

#VALUE!
#VALUE!
#VALUE!
7.57%
100.00%

#VALUE!
#VALUE!
#REF!
#VALUE!
100.00%

2019
1.00

2020
1.00

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#REF!
#VALUE!
100.00%

#VALUE!
#VALUE!
#REF!
#VALUE!
100.00%

Payment Detail
Jan
10

Payment Delay in Days

Payables
Beginning Payables Balance
Plus New Payment Obligations
Less Cash Spending
Less Bill Payments
Ending Payables Balance

$17,520
$232,195
$86,400
$119,576
$43,738

Calculated Totals (not included in output)

Payment Obligations
Operating Expenses less Depreciation
Interest and Taxes
Non-Inventory Direct Costs of Sales
Inventory Purchase
Total Payment Obligations
Less Immediate Cash Payments
New Payment Obligations this Period

$223,065
($2,524)
$0
$11,654
$232,195
$86,400
$145,795

Calculated Totals (not included in output)

Estimated Payments
Payments
Payments
Payments
Payments

on this Period's Bills

from Initial Balance
on Previous Balance
on Payables

Lookup Area (not included in output)

Paid This Month
Payables from Previous Month
Payables Left from Two Months Back
Payables Left from Three Months Back
Payables Left from Four Months Back
Payables Left from Five Months Back

$17,520

$102,056
$17,520
n.a.
$119,576

0.70
0.30
0.00
0.00
0.00
0.00

Feb
10

Mar
10

Apr
10

May
10

Jun
10

$43,738
$258,294
$86,400
$164,064
$51,568

$51,568
$372,221
$86,400
$251,643
$85,746

$85,746
$511,238
$86,400
$383,133
$127,451

$127,451
$513,994
$86,400
$426,767
$128,278

$128,278
$1,355,621
$86,400
$1,016,733
$380,766

$223,065
($12,492)
$0
$47,721
$258,294
$86,400
$171,894

$223,065
$21,916
$0
$127,240
$372,221
$86,400
$285,821

$223,065
$88,330
$0
$199,843
$511,238
$86,400
$424,838

$223,065
$115,178
$0
$175,751
$513,994
$86,400
$427,594

$223,065
$861,602
$0
$270,954
$1,355,621
$86,400
$1,269,221

$120,326
$0
$43,738
$164,064

$200,075
$0
$51,568
$251,643

$297,387
$0
$85,746
$383,133

$299,315
$0
$127,451
$426,767

$888,455
$0
$128,278
$1,016,733

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

Jul
10

Aug
10

Sep
10

Oct
10

Nov
10

$380,766
$862,362
$86,400
$923,940
$232,789

$232,789
$432,616
$86,400
$475,140
$103,865

$103,865
$349,156
$86,400
$287,794
$78,827

$78,827
$416,764
$86,400
$310,082
$99,109

$99,109
$303,839
$86,400
$251,316
$65,232

$223,065
$270,053
$0
$369,244
$862,362
$86,400
$775,962

$223,065
$132,909
$0
$76,642
$432,616
$86,400
$346,216

$223,065
$64,289
$0
$61,802
$349,156
$86,400
$262,756

$223,065
$54,383
$0
$139,316
$416,764
$86,400
$330,364

$223,065
$23,552
$0
$57,222
$303,839
$86,400
$217,439

$543,173
$0
$380,766
$923,940

$242,351
$0
$232,789
$475,140

$183,929
$0
$103,865
$287,794

$231,255
$0
$78,827
$310,082

$152,207
$0
$99,109
$251,316

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

Dec
10

2016
10

Jan
10

Feb
10

$65,232
$1,047,830
$86,400
$738,233
$288,429

$17,520
$6,656,130
$1,036,800
$5,348,421
$288,429

$288,429
#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
#VALUE!
$0
#VALUE!
#VALUE!

$223,065
$662,938
$0
$161,827
$1,047,830
$86,400
$961,430

$2,676,780
$2,280,134
$0
$1,699,216
$6,656,130
$1,036,800
$5,619,330

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
$0
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
$0
#VALUE!

$673,001
$0
$65,232
$738,233

$5,330,901
$17,520
$1,397,370
$0

#VALUE!
$0
$288,429
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

Mar
10

Apr
10

May
10

Jun
10

Jul
10

#VALUE!
#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
$0
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
$0
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
$0
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
$0
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

Aug
10

Sep
10

Oct
10

Nov
10

Dec
10

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

0.70
0.30
0.00
0.00
0.00
0.00

2017
10

2017
10

2018
10

2019
10

2020
10

$288,429
#VALUE!
#VALUE!
#VALUE!
#VALUE!

$288,429
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#REF!
#VALUE!
#VALUE!
#VALUE!
#REF!

#REF!
#VALUE!
#VALUE!
#VALUE!
#REF!

#REF!
#VALUE!
#VALUE!
#VALUE!
#REF!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
$0

#VALUE!
$0
$288,429
#VALUE!

#VALUE!
$0
#REF!
#VALUE!

#VALUE!
$0
#REF!
#VALUE!

#VALUE!
$0
#REF!
#VALUE!

n.a.
n.a.
n.a.
n.a.
n.a.
n.a.

n.a.
n.a.
n.a.
n.a.
n.a.
n.a.

n.a.
n.a.
n.a.
n.a.
n.a.
n.a.

0.70
0.30
0.00
0.00
0.00
0.00

Receivables Detail
Estimated Collection Period in Days
Sales on Credit %

Receivables
Beginning Receivables Balance
Plus Sales on Credit
Less Cash from Receivables
Ending Receivables Balance

Calculated Totals (not included in output)

Received from this Month's Sales on Credit
Received from Initial Balance
Payments Received on Previous Balance
Payments Received on Receivables Total
Uncollected Remainder (Years Only)
Received This Month
Receivables From Previous Month
Receivables Left from two Months Back
Receivables Left from three Months Back
Receivables Left from four Months Back
Receivables Left from five Months Back
Receivables Left from six Months Back
Receivables Left from seven Months Back
Receivables Left from eight Months Back
Receivables Left from nine Months Back
Receivables Left from 10 Months Back
Receivables Left from 11 Months Back
Receivables Left from 12 Months Back
Receivables Left from 13 Months Back
Receivables Left from 14 Months Back
Receivables Left from 15 Months Back
Receivables Left from 16 Months Back
Receivables Left from 17 Months Back
Receivables Left from 18 Months Back
Receivables Left from 19 Months Back
Receivables Left from 20 Months Back
Receivables Left from 21 Months Back
Receivables Left from 22 Months Back
Receivables Left from 23 Months Back
Receivables Left from 24 Months Back
Receivables Left from 25 Months Back
Receivables Left from 26 Months Back
Calculated Totals (not included in output)
Previous Year Ending Balance/Previous Year Sales on Credit
Collection Period Estimator/Previous Year Collection Period Estimator

Jan
30
45.00%

$203,805

Feb
30
45.00%

Mar
30
45.00%

$203,805
$129,452
$208,120
$125,136

$125,136
$109,939
$128,801
$106,274

$106,274
$179,135
$112,245
$173,164

$4,315
$203,805
n.a.
$208,120

$3,665
$0
$125,136
$128,801

$5,971
$0
$106,274
$112,245

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Apr
30
45.00%

May
30
45.00%

Jun
30
45.00%

Jul
30
45.00%

Aug
30
45.00%

$173,164
$306,196
$183,370
$295,989

$295,989
$354,382
$307,802
$342,569

$342,569
$474,447
$358,384
$458,632

$458,632
$653,452
$480,414
$631,670

$631,670
$392,631
$644,758
$379,544

$10,207
$0
$173,164
$183,370

$11,813
$0
$295,989
$307,802

$15,815
$0
$342,569
$358,384

$21,782
$0
$458,632
$480,414

$13,088
$0
$631,670
$644,758

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Sep
30
45.00%

Oct
30
45.00%

Nov
30
45.00%

Dec
30
45.00%

2016
30
45.00%

$379,544
$258,723
$388,168
$250,098

$250,098
$247,201
$258,338
$238,961

$238,961
$182,682
$245,050
$176,593

$176,593
$203,968
$183,392
$197,169

$203,805
$3,492,206
$3,498,842
$197,169

$8,624
$0
$379,544
$388,168

$8,240
$0
$250,098
$258,338

$6,089
$0
$238,961
$245,050

$6,799
$0
$176,593
$183,392

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

$116,407
$203,805
$3,178,630
$3,498,842
$197,169
0
0.00
0.00
30.00
60.00
90.00
120.00
150.00
180.00
210.00
240.00
270.00
300.00
330.00
360.00
390.00
420.00
450.00
480.00
510.00
540.00
570.00
600.00
630.00
660.00
690.00
720.00
750.00

0
1
31.00
61.00
91.00
121.00
151.00
181.00
211.00
241.00
271.00
301.00
331.00
361.00
391.00
421.00
451.00
481.00
511.00
541.00
571.00
601.00
631.00
661.00
691.00
721.00
751.00
781.00

Jan
30
45.00%

Feb
30
45.00%

Mar
30
45.00%

Apr
30
45.00%

$197,169
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
$0
$197,169
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

May
30
45.00%

Jun
30
45.00%

Jul
30
45.00%

Aug
30
45.00%

Sep
30
45.00%

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Oct
30
45.00%

Nov
30
45.00%

Dec
30
45.00%

2017
30
45.00%

2017
30
45.00%

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

$197,169
#VALUE!
#VALUE!
#VALUE!
#VALUE!

$197,169
#VALUE!
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!

#VALUE!
$0
#VALUE!
#VALUE!
#VALUE!

n.a.
$197,169
#VALUE!
#VALUE!
#VALUE!

Check

#VALUE!
$0
#VALUE!
#VALUE!

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

#VALUE!
$0
#VALUE!
#VALUE!

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

0.03
0.97
0.00
0.00
0.00
0.00

5.65%
100.00%

2018
30
45.00%

2019
30
45.00%

2020
30
45.00%

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

n.a.
#VALUE!
#VALUE!
#VALUE!
#VALUE!

n.a.
#VALUE!
#VALUE!
#VALUE!
#VALUE!

n.a.
#VALUE!
#VALUE!
#VALUE!
#VALUE!

0.03
0.97
0.00
0.00
0.00
0.00

#VALUE!
100.00%

0.03
0.97
0.00
0.00
0.00
0.00

#VALUE!
100.00%

0.03
0.97
0.00
0.00
0.00
0.00

#VALUE!
100.00%

Pro Forma Balance Sheet

Assets
Current Assets
Cash
Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Long-term Assets
Long-term Assets
Accumulated Depreciation
Total Long-term Assets
Total Assets

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

($1,283,108)
$458,632
$215,896
$0
($608,580)

($1,014,371)
$631,670
$292,570
$0
($90,131)

($451,270)
$379,544
$184,606
$0
$112,879

($121,080)
$250,098
$123,204
$0
$252,222

$23,603,883
$1,889,924
$21,713,959
$21,105,379

$23,603,883
$1,889,924
$21,713,959
$21,623,828

Oct

Nov

Dec

2016

($1,918,721)
$197,169
$128,034
$0
($1,593,518)

($1,918,721)
$197,169
$128,034
$0
($1,593,518)

$23,603,883
$1,889,924
$21,713,959
$20,120,441

$23,603,883
$1,889,924
$21,713,959
$20,120,441

Starting Balances

$100,000
$203,805
$120,000
$0
$423,805

$260,362
$125,136
$65,827
$0
$451,326

$273,068
$106,274
$56,774
$0
$436,116

$266,213
$173,164
$92,007
$0
$531,384

$354,290
$295,989
$145,925
$0
$796,204

$582,059
$342,569
$160,838
$0
$1,085,466

$23,603,883
$1,889,924
$21,713,959
$22,137,764

$23,603,883
$1,889,924
$21,713,959
$22,165,285

$23,603,883
$1,889,924
$21,713,959
$22,150,075

$23,603,883
$1,889,924
$21,713,959
$22,245,343

$23,603,883
$1,889,924
$21,713,959
$22,510,163

$23,603,883
$1,889,924
$21,713,959
$22,799,425

Liabilities and Capital

Jan

Feb

Mar

Apr

May

Current Liabilities
Accounts Payable
Current Borrowing
Other Current Liabilities
Subtotal Current Liabilities

$17,520
$0
$0
$17,520

$43,738
$0
$0
$43,738

$51,568
$0
$0
$51,568

$85,746
$0
$0
$85,746

$127,451
$0
$0
$127,451

$128,278
$0
$0
$128,278

Long-term Liabilities
Total Liabilities

$0
$17,520

$0
$43,738

$0
$51,568

$0
$85,746

$0
$127,451

$0
$128,278

Jun

$380,766
$0
$0
$380,766
($1,700,297)
($1,319,531)

Jul

$23,603,883
$1,889,924
$21,713,959
$21,826,838
Aug

$23,603,883
$1,889,924
$21,713,959
$21,966,181
Sep

$42,911
$238,961
$131,260
$0
$413,132

$173,523
$176,593
$94,241
$0
$444,356

$23,603,883
$1,889,924
$21,713,959
$22,127,091

$23,603,883
$1,889,924
$21,713,959
$22,158,315

Oct

Nov

$232,789
$0
$0
$232,789

$103,865
$0
$0
$103,865

$78,827
$0
$0
$78,827

$99,109
$0
$0
$99,109

$65,232
$0
$0
$65,232

$0
$232,789

$0
$103,865

$0
$78,827

$0
$99,109

$0
$65,232

Dec

$288,429
$0
$0
$288,429

2016

$288,429
$0
$0
$288,429

($1,700,297)
($1,411,868)

($3,400,594)
($3,112,165)

Paid-in Capital
Retained Earnings
Earnings
Total Capital
Total Liabilities and Capital

$0
$22,120,244
$0
$22,120,244
$22,137,764

$0
$22,120,244
($5,890)
$22,114,354
$22,158,093

$0
$22,120,244
($35,037)
$22,085,207
$22,136,775

$0
$22,120,244
$16,101
$22,136,345
$22,222,091

$0
$22,120,244
$222,205
$22,342,449
$22,469,900

$0
$22,120,244
$490,952
$22,611,196
$22,739,474

$0
$22,120,244
$218,357
$22,338,601
$21,019,070

$0
$22,120,244
$848,481
$22,968,725
$23,201,513

$0
$22,120,244
$1,158,602
$23,278,846
$23,382,710

$0
$22,120,244
$1,308,609
$23,428,853
$23,507,680

$0
$22,120,244
$1,435,503
$23,555,747
$23,654,857

$0
$22,120,244
$1,490,457
$23,610,701
$23,675,932

$0
$22,120,244
$918,350
$23,038,594
$21,626,726

$0
$22,120,244
$918,350
$23,038,594
$19,926,429

Net Worth

$22,120,244

$22,121,546

$22,098,507

$22,159,597

$22,382,712

$22,671,147

$22,424,910

$21,391,040

$21,722,974

$21,887,354

$22,027,981

$22,093,084

$21,532,309

$21,532,309

Cash Pilot
Accounts Receivable Balance
Pilot Accounts Receivable Balance
Inventory Balance
Pilot Inventory Balance
Accounts Payable Balance
Pilot Accounts Payable Balance
Cash Balance
Pilot Cash Balance
Variance

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

$125,136

$106,274

$173,164

$295,989

$342,569

$458,632

$631,670

$379,544

$250,098

$238,961

$176,593

$65,827

$56,774

$92,007

$145,925

$160,838

$215,896

$292,570

$184,606

$123,204

$131,260

$94,241

$43,738

$51,568

$85,746

$127,451

$128,278

$380,766

$232,789

$103,865

$78,827

$99,109

$65,232

$260,362
($260,362)

$273,068
($273,068)

$266,213
($266,213)

$354,290
($354,290)

$582,059
($582,059)

($1,283,108)
$1,283,108

($1,014,371)
$1,014,371

($451,270)
$451,270

($121,080)
$121,080

$42,911
($42,911)

$173,523
($173,523)

Dec Cash Pilot

Accounts Receivable Balance
$197,169 Pilot Accounts Receivable Balance
Inventory Balance
$128,034 Pilot Inventory Balance
Accounts Payable Balance
$288,429 Pilot Accounts Payable Balance
Cash Balance
($1,918,721) Pilot Cash Balance
$1,918,721 Variance

Long-term
Sales
Cost of Sales
Gross Margin
Gross Margin %
Operating Expenses
Operating Income
Net Income
Current Assets
Long-term Assets
Current Liabilities
Long-term Liabilities
Equity

2016
$7,760,458
$1,691,182
$6,069,276
78.21%
$2,676,780
$3,392,496
$918,350
($1,593,518)
$21,713,959
$288,429
($3,400,594)
$23,232,606

2017
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!
#REF!

2018
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

2019
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

2020
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

2021
$0
$0
$0
0.00%
$0
$0
$0
$0
$0
$0
$0
$0

2022
$0
$0
$0
0.00%
$0
$0
$0
$0
$0
$0
$0
$0

2023
$0
$0
$0
0.00%
$0
$0
$0
$0
$0
$0
$0
$0

2024
$0
$0
$0
0.00%
$0
$0
$0
$0
$0
$0
$0
$0

2025
$0
$0
$0
0.00%
$0
$0
$0
$0
$0
$0
$0
$0

Investment Analysis
Initial Investment
Investment
Dividends
Ending Valuation
Combination as Income Stream
Percent Equity Acquired
Net Present Value (NPV)
Internal Rate of Return (IRR)

Assumptions
Discount Rate
Valuation Earnings Multiple
Valuation Sales Multiple
Investment (calculated)
Dividends
Calculated Earnings-based Valuation
Calculated Sales-based Valuation
Calculated Average Valuation

Start
$0
$0
$0
$0
35%
#REF!
0%

2016
$0
$0
$0
$0

10.00%
10
2
$0

$0
$0
$9,180,000
$15,520,000
$12,350,000

2017

2018

2019

2020

#REF!
#REF!
$0
#REF!

#VALUE!
#VALUE!
#VALUE!
#VALUE!

#VALUE!
#VALUE!
$0
#VALUE!

#VALUE!
#VALUE!
$0
#VALUE!

10
2
#REF!
#REF!
#REF!
#REF!
#REF!

10
2
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

10
2
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

10
2
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!

Use of Funds
Use

Amount

Name
Name
Name
Name

$0
$0
$0
$0

Total

$0

Payback
Projected Payback Calculation
Investment
Cash Returns by Year
Combination as Income Stream
Cumulative Net Cash Flow to Investors
Payback Period

($400,000)
($300,000)
($200,000)
($100,000)
$0
$100,000
$200,000
$300,000
$400,000
$500,000

Investment
$500,000
($500,000)
($500,000)
5 years

1
2
3
4
5
6
7
8
9
10

2016
$100,000
$100,000
($400,000)
1

2017

2018

2019

$100,000
$100,000
$100,000
$100,000
$100,000
$100,000
($300,000) ($200,000) ($100,000)
2

2020
$100,000
$100,000
$0
5

2021
$100,000
$100,000
$100,000
6

2022
$100,000
$100,000
$200,000
7

2023
$100,000
$100,000
$300,000
8

2024
$100,000
$100,000
$400,000
9

2025
$100,000
$100,000
$500,000
10

Investment Offering

Seed
1

Round 1
2

Investment Amount
Equity Share Offering Percentage
Valuation
Investor Exit Payout
Investor Years Until Exit
Investor IRR

$0
0.00%
$0
$0
6
0.00%

$0
0.00%
$0
$0
5
0.00%

Share Ownership

Year 1
0

Year 2
0
0
0
0
$0.00
0
0
0

Proposed Year:

Valuation, Investment, Shares

Founders' Shares
Stock Split Multiple
Stock Options Issued
Investor Shares Issued
Price per share
Options Holders' Shares
Year 1 Investors' Shares
Year 2 Investors' Shares
Year 3 Investors' Shares
Total Shares Outstanding

Equity Ownership Percentage

Founders' Equity
Option Holders' Equity
Year 1 Investors' Equity
Year 2 Investors' Equity
Year 3 Investors' Equity
Total Equity
Investors' Equity
Founders' & Employees' Equity
Calculated Totals (not included in output)
Post-Split Pre-Investment Shares
Post-money total shares

0
0
$0.00
0
0

Year 1
0.00%
0.00%
0.00%

Year 2
0.00%
0.00%
0.00%
0.00%

0.00%
0.00%
0.00%

0.00%
0.00%
0.00%

0
0
Years
0
1
2
3
4
5
6
7
8
9
10
11
12

0
0
Seed
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

13
14
15
16
17
18
19
20
21
22
23
24
25

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Round 2
3

$0
0.00%
$0
$0
4
0.00%

Exit
7

$0

Year 3
0
0
0
0
$0.00
0
0
0
0
0

Year 7
0
0
0

Year 3
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%

Year 7
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%

0
0
Round 1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0.00
0
0
0
0
0

0
Round 2
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

Personal Net Worth

Assets
Current Assets
Checking
Savings
Investment
Household Goods
Auto
Auto
All Other
Total Current Assets

Notes:

Balance
$0
$0
$0
$0
$0
$0
$0
$0

Long-term Assets
Main Residence
Improvements
Account
All Other
Total Long-term Assets

$0
$0
$0
$0
$0

Total Assets

$0

Liabilities
Current Borrowing
Credit Card
Credit Card
Credit Card
Auto Loan
Other Current Debt
Other Current Debt
All Other
Subtotal Current Borrowing

Balance
$0
$0
$0
$0
$0
$0
$0
$0

Long-term Borrowing
Mortgage
Other Long-term Loans
All Other
Subtotal Long-term Borrowing

$0
$0
$0
$0

Total Liabilities

$0

Net Worth

$0

A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

2017
-96.29%

2017
-96.85%

2018
#REF!

2019
#REF!

0.56%
0.30%
#VALUE!
2.04%
97.96%
100.00%

0.48%
0.26%
#VALUE!
1.97%
98.03%
100.00%

0.78%
0.41%
#VALUE!
2.39%
97.61%
100.00%

1.31%
0.65%
#VALUE!
3.54%
96.46%
100.00%

1.50%
0.71%
#VALUE!
4.76%
95.24%
100.00%

0.20%
0.00%
0.20%
99.80%

0.23%
0.00%
0.23%
99.77%

0.39%
0.00%
0.39%
99.61%

0.57%
0.00%
0.57%
99.43%

0.56%
0.00%
0.56%
99.44%

100.00%
77.12%
79.16%
#VALUE!
-2.92%

100.00%
76.76%
88.69%
#VALUE!
-17.04%

100.00%
76.89%
64.04%
#VALUE!
18.35%

100.00%
78.55%
48.26%
#VALUE!
43.27%

100.00%
79.58%
45.45%
#VALUE!
48.75%

Ratio Analysis
Sales Growth

2016
n.a.

2020 Industry Profile

#REF!
1.61%

Percent of Total Assets

Accounts Receivable
Inventory
Other Current Assets
Total Current Assets
Long-term Assets
Total Assets

0.92%
0.54%
0.00%
1.91%
98.09%
100.00%

Current Liabilities
Long-term Liabilities
Total Liabilities
Net Worth

0.08%
0.00%
0.08%
99.92%

5.41%
0.96%
31.28%
37.65%
62.35%
100.00%
18.81%
59.85%
78.66%
21.34%

Percent of Sales
Sales
Gross Margin
Selling, General & Administrative Expenses
Advertising Expenses
Profit Before Interest and Taxes

100.00%
0.00%
0.00%
0.00%
0.00%

100.00%
79.12%
22.10%
2.53%
4.11%

Main Ratios
Current
Quick
Total Debt to Total Assets
Pre-tax Return on Net Worth
Pre-tax Return on Assets

24.19
17.34
0.08%
0.00%
0.00%

10.32
8.81
0.20%
-0.04%
-0.04%

8.46
7.36
0.23%
-0.19%
-0.19%

6.20
5.12
0.39%
0.33%
0.33%

6.25
5.10
0.57%
1.32%
1.31%

8.46
7.21
0.56%
1.69%
1.68%

Additional Ratios

2016
0.00%
0.00%

2017
-2.05%
-0.03%

2017
-11.93%
-0.13%

2018
12.85%
0.23%

2019
30.29%
0.92%

2020
34.13%
1.19%

n.a
n.a

1.03
#VALUE!
#VALUE!
3.33
#VALUE!
0.02

1.03
#VALUE!
#VALUE!
3.33
#VALUE!
0.03

1.03
#VALUE!
#VALUE!
3.33
#VALUE!
0.03

n.a
n.a
n.a
n.a
n.a
n.a

Net Profit Margin

Return on Equity

1.05
1.00
78.66%
14.47%
3.09%

Activity Ratios
Accounts Receivable Turnover
Collection Days
Inventory Turnover
Accounts Payable Turnover
Payment Days
Total Asset Turnover

0.00
0
0.00
0.00
0
0.00

1.03
454
0.68
3.33
416
0.01

1.03
504
0.61
3.33
361
0.01

0.00
1.00

0.00
1.00

0.00
1.00

0.00
1.00

0.01
1.00

0.01
1.00

n.a
n.a

$406,285
0.00

$407,587
0.00

$384,548
0.00

$445,638
0.00

$668,753
0.00

$957,188
0.00

n.a
n.a

77.05
0%
5.95
0.01
0.00

90.66
0%
5.30
0.01
0.00

55.88
0%
3.10
0.02
0.00

33.08
1%
2.78
0.03
0.00

28.95
1%
4.54
0.03
0.00

n.a
n.a
n.a
n.a
n.a

Debt Ratios
Debt to Net Worth
Current Liab. to Liab.

Liquidity Ratios
Net Working Capital
Interest Coverage

Additional Ratios
Assets to Sales
Current Debt/Total Assets
Acid Test
Sales/Net Worth
Dividend Payout

n.a.
0%
5.71
0.00
0.00

as of
What is the Logistics worksheet?
The Logistics worksheet is where we
keep the Plan Settings. These Plan
Settings will change based on the
choices you make in the Plan Setup.
We use these Plan Settings to
customize your plan and make table
calculations. Deleting this worksheet or
any of these Plan Settings will generate
errors in this workbook.
Plan Settings
Plan Setting Name
PS_PlanTitle
PS_ExpenseCategories
PS_AdministrativeLabel
PS_SalesMarketingLabel
PS_ProductionLabel
PS_OtherLabel
PS_Startup
PS_Products
PS_NonProfit
PS_Inventory
PS_Receivables
PS_Accrual
PS_StandardTerm
PS_StartingMonth
PS_StartingYear
PS_Date
PS_AnnualDetail
PS_SalesByUnits
PS_QuickBooks
PS_NetOtherIncome
PS_Accounting
PS_PersonnelbyPeople
PS_Premier
PS_ProductServices

Value
0
0.00
General and Administrative
Sales and Marketing
Production
Other
0.00
0.00
0.00
1.00
1.00
1
1.00
1
2016
1
0
0.00
0.00
0
0
0
1
1

PS_DateSetting
PS_CellFormat

Public Names
accounts_payable
accounts_receivable
accounts_receivable_lookup
accumulated_depreciation
acid_test
additional_investment_requirement
assets_to_sales
average_per_unit_revenue

Start Cell
=Balance!$A$21:$AG$21
=Balance!$A$7:$AG$7
='Receivables Detail'!$B$30:$AB$39
=Balance!$A$14:$AG$14
=Ratios!$O$55:$AH$55
=Funding!$B$28
=Ratios!$O$53:$AH$53
='Break-even'!$O$7

$500.00

Page

as of
average_per_unit_revenue_calculated
average_per_unit_variable_cost
average_variable_cost
beginning_payables_balance
beginning_receivables_balance
cash
cash_balance_on_starting_date
cash_from_receivables
cash_sales
cash_spending
collection_days
collection_days_estimator
Collection_Period
cost_of_unit_sales
current_borrowing
current_interest_rate
depreciation
depreciation_actual
depreciation_variance
direct_cost_of_sales
dividend_payout
dividends
earnings
ending_inventory_balance
ending_payables_balance
ending_receivables_balance
estimated_collection_period_in_days
estimated_monthly_fixed_cost
estimated_monthly_fixed_cost_calculat
estimated_receivables_balance
general_and_administrative_payroll
general_and_administrative_percent
gross_margin
gross_margin_actual
gross_margin_percent
gross_margin_variance
include_negative_taxes
include_negative_taxes_2nd_year
include_negative_taxes_first_year
interest_expense
interest_expense_actual
interest_expense_variance
inventory
inventory_purchase
inventory_purchased_this_period
inventory_turnover
inventory_used_this_period
less_bill_payments
less_cash_spending
long_term_assets
long_term_interest_rate
long_term_liabilities
long_term_liabilities_principal_repayme
minimum_inventory_purchase

='Break-even'!$O$16
='Break-even'!$O$8
='Break-even'!$O$9
='Payment Detail'!$A$7:$AG$7
='Receivables Detail'!$A$8:$AG$8
=Balance!$A$6:$AN$6
=Funding!$B$10
='Cash Flow'!$A$7:$AG$7
='Cash Flow'!$B$6:$AG$6
='Cash Flow'!$C$24:$AG$24
=Ratios!$A$38:$AH$38
='Receivables Detail'!$A$3:$AN$3
='Receivables Detail'!$B$3:$BT$3
='P&L'!$A$4:$AN$4
=Balance!$A$22:$AG$22
=Assumptions!$A$4:$AG$4
='P&L'!$A$24:$AN$24
='P&L'!$CO$24:$DF$24
='P&L'!$DH$24:$DY$24
='P&L'!$A$4:$AG$4
=Ratios!$O$57:$AH$57
='Cash Flow'!$A$36:$AG$36
=Balance!$A$31:$AG$31
='Inventory Detail'!$A$11:$AG$11
='Payment Detail'!$A$11:$AG$11
='Receivables Detail'!$A$11:$AG$11
='Receivables Detail'!$A$3:$AG$3
='Break-even'!$O$10
='Break-even'!$O$18
='Receivables Detail'!$A$27:$AG$27
='P&L'!$A$22:$AG$22
='P&L'!$A$31:$AG$31
='P&L'!$A$9:$AG$9
='P&L'!$CO$9:$DF$9
='P&L'!$A$10:$AG$10
='P&L'!$DH$9:$DY$9
='P&L'!$AD$60:$AG$60
='P&L'!$AC$60
='P&L'!$O$60
='P&L'!$A$44:$AG$44
='P&L'!$CO$44:$DF$44
='P&L'!$DH$44:$DY$44
=Balance!$A$8:$AG$8
='Inventory Detail'!$A$10:$BT$10
='Inventory Detail'!$A$10:$AG$10
=Ratios!$O$39:$AH$39
='Inventory Detail'!$A$9:$AG$9
='Payment Detail'!$A$10:$AG$10
='Payment Detail'!$A$9:$AG$9
=Balance!$A$13:$AG$13
=Assumptions!$A$5:$AG$5
=Balance!$A$26:$AG$26
='Cash Flow'!$A$33:$AG$33
='Inventory Detail'!$C$4
Page

as of
monthly_sales_breakeven
='Break-even'!$O$4
monthly_units_breakeven
='Break-even'!$O$3
months_of_inventory_on_hand
='Inventory Detail'!$A$3:$AG$3
net_cash_flow
='Cash Flow'!$A$39:$AG$39
net_other_income
='P&L'!$A$57:$AG$57
net_other_income_actual
='P&L'!$CO$57:$DF$57
net_other_income_variance
='P&L'!$DH$57:$DY$57
net_profit
='P&L'!$A$58:$AG$58
net_profit_actual
='P&L'!$CO$58:$DF$58
net_profit_margin
=Ratios!$O$33:$AH$33
net_profit_variance
='P&L'!$DH$58:$DY$58
net_worth
=Balance!$A$35:$AG$35
new_accounts_payable
='Payment Detail'!$A$23:$AN$23
new_current_borrowing
='Cash Flow'!$A$13:$AG$13
new_investment_received
='Cash Flow'!$A$18:$AG$18
new_long_term_liabilities
='Cash Flow'!$A$15:$AG$15
new_other_liabilities_interest_free
='Cash Flow'!$A$14:$AG$14
new_payment_obligations_this_period ='Payment Detail'!$A$23:$AG$23
other_current_liabilities
=Balance!$A$23:$AG$23
other_liabilities_principal_repayment
='Cash Flow'!$A$32:$AG$32
paid_in_capital
=Balance!$A$29:$AG$29
past_capital_assets
=Past!$D$21
past_performance_accounts_payable
=Past!$D$28
past_performance_accounts_receivable =Past!$D$15
past_performance_accumulated_depreci=Past!$D$22
past_performance_cash
=Past!$D$14
past_performance_collection_days
=Past!$D$7
past_performance_current_borrowing =Past!$D$29
past_performance_earnings
=Past!$D$38
past_performance_gross_margin
=Past!$D$4
past_performance_gross_margin_percen=Past!$D$5
past_performance_inventory
=Past!$D$16
past_performance_inventory_turnover =Past!$D$8
past_performance_long_term_liabilities =Past!$D$33
past_performance_operating_expenses =Past!$D$6
past_performance_other_current_assets=Past!$D$17
past_performance_other_current_liabilit =Past!$D$30
past_performance_paid_in_capital
=Past!$D$36
past_performance_payment_days
=Past!$D$44
past_performance_sales
=Past!$D$3
payment_days_estimator
='Payment Detail'!$A$3:$AG$3
payment_delay_in_days
='Payment Detail'!$C$3
payroll
=Personnel!$C$72:$AN$72
payroll_expense
=Assumptions!$A$11:$AN$11
payroll_taxes
='P&L'!$A$28:$AG$28
Payroll1
=Personnel!$C$3:$AN$3
Payroll2
=Personnel!$C$12:$AN$12
Payroll3
=Personnel!$A$42:$AN$42
Payroll3GA
=Personnel!$C$32:$AN$32
Payroll3OTH
=Personnel!$C$38:$AN$38
Payroll3P
=Personnel!$C$20:$AN$20
Payroll3SM
=Personnel!$C$26:$AN$26
Payroll4
=Personnel!$A$68:$AN$68
Payroll4GA
=Personnel!$C$59:$AN$59
Page

as of
Payroll4OTH
=Personnel!$C$64:$AN$64
Payroll4P
=Personnel!$C$49:$AN$49
Payroll4SM
=Personnel!$C$54:$AN$54
percent_equity_acquired
='Investment Analysis'!$N$8
plan_month
=Assumptions!$A$3:$BT$3
plus_new_payment_obligations
='Payment Detail'!$A$8:$AG$8
principal_repayment_of_current_borrow ='Cash Flow'!$A$31:$AG$31
production_payroll
='P&L'!$5:$5
profit_before_int_and_taxes
='P&L'!$A$42:$AG$42
profit_before_interest_and_taxes
='P&L'!$A$42:$AG$42
profit_before_interest_and_taxes_actual='P&L'!$CO$42:$DF$42
profit_before_interest_and_taxes_varia ='P&L'!$DH$42:$DY$42
purchase_long_term_assets
='Cash Flow'!$A$35:$AG$35
purchase_other_current_assets
='Cash Flow'!$A$34:$AG$34
RD_CollectionDays
='Receivables Detail'!$C$3
retained_earnings
=Balance!$A$30:$AG$30
sales
='P&L'!$A$3:$AG$3
sales_2
='P&L'!$A$3:$AG$3
sales_3
='P&L'!$A$3:$AG$3
sales_4
='P&L'!$A$3:$AG$3
sales_5
='P&L'!$A$3:$AG$3
sales_6
='P&L'!$A$3:$AG$3
sales_actual
='P&L'!$CO$3:$DF$3
sales_and_marketing_percent
='P&L'!$A$19:$AG$19
sales_of_long_term_assets
='Cash Flow'!$A$17:$AG$17
sales_of_other_current_assets
='Cash Flow'!$A$16:$AG$16
sales_on_credit
='Receivables Detail'!$A$9:$AG$9
sales_on_credit_percent
='Receivables Detail'!$A$4:$AG$4
sales_tax_vat_hst_gst_paidout
='Cash Flow'!$A$30:$AG$30
sales_tax_vat_hst_gst_received
='Cash Flow'!$A$12:$AG$12
sales_units_directcosts
='Sales Forecast'!$A$41:$AG$43
sales_units_sales
='Sales Forecast'!$A$30:$AG$32
sales_variance
='P&L'!$DH$3:$DY$3
salesunits
='Sales Forecast'!$A$33:$AG$33
salesunits_actual
='Sales Forecast'!$CO$33:$DF$33
salesunits_variance
='Sales Forecast'!$DH$33:$DY$33
salesvalues
='Sales Forecast'!$A$7:$AG$7
salesvalues_actual
='Sales Forecast'!$CO$7:$DF$7
salesvalues_variance
='Sales Forecast'!$DH$7:$DY$7
Starting_balance_accounts_receivable =Balance!$B$7
starting_balance_inventory
=Balance!$B$8
starting_balance_payables
=Balance!$B$21
startup_accounts_payable
=Funding!$B$19
startup_additional_cash_raised
=Funding!$B$9
startup_cash_required
='Start-up'!$B$15
startup_current_borrowing
=Funding!$B$17
startup_inventory
='Start-up'!$B$16
startup_long_term_assets
='Start-up'!$B$18
startup_long_term_liabilities
=Funding!$B$18
startup_other_current_assets
='Start-up'!$B$17
startup_other_current_liabilities
=Funding!$B$20
startup_total_assets
='Start-up'!$B$19
startup_total_capital
=Funding!$B$32
startup_total_investment
=Funding!$B$29
Page

as of
startup_total_liabilities
=Funding!$B$21
startup_total_requirements
='Start-up'!$B$21
subtotal_cash_from_operations
='Cash Flow'!$A$8:$AG$8
subtotal_cash_received
='Cash Flow'!$A$19:$AG$19
subtotal_cash_spent
='Cash Flow'!$A$37:$AG$37
subtotal_current_liabilities
=Balance!$A$24:$AG$24
subtotal_direct_cost_of_sales_units
='Sales Forecast'!$A$44:$AG$44
subtotal_direct_cost_of_sales_units_act ='Sales Forecast'!$CO$44:$DF$44
subtotal_direct_cost_of_sales_units_var ='Sales Forecast'!$DH$44:$DY$44
subtotal_direct_cost_of_sales_values
='Sales Forecast'!$A$13:$AG$13
subtotal_direct_cost_of_sales_values_ac='Sales Forecast'!$CO$13:$DF$13
subtotal_direct_cost_of_sales_values_va='Sales Forecast'!$DH$13:$DY$13
subtotal_spent_on_operations
='Cash Flow'!$A$26:$AG$26
tax_rate
=Assumptions!$A$6:$AG$6
taxes_incurred
='P&L'!$A$45:$AG$45
taxes_incurred_actual
='P&L'!$CO$45:$DF$45
taxes_incurred_variance
='P&L'!$DH$45:$DY$45
total_assets
=Balance!$A$16:$AG$16
total_capital
=Balance!$A$32:$AG$32
total_cost_of_sales
='P&L'!$A$7:$AG$7
total_cost_of_sales_actual
='P&L'!$CO$7:$DF$7
total_cost_of_sales_variance
='P&L'!$DH$7:$DY$7
total_current_assets
=Balance!$A$10:$AG$10
total_expense
='P&L'!$A$30:$AG$30
total_general_and_administrative_expe ='P&L'!$A$30:$AG$30
total_general_and_administrative_expen='P&L'!$CO$30:$DF$30
total_general_and_administrative_expe ='P&L'!$DH$30:$DY$30
total_liabilities
=Balance!$A$27:$AG$27
total_liabilities_and_capital
=Balance!$A$33:$AG$33
total_long_term_assets
=Balance!$A$15:$AG$15
total_operating_expenses
='P&L'!$A$40:$AG$40
total_operating_expenses_actual
='P&L'!$CO$40:$DF$40
total_operating_expenses_variance
='P&L'!$DH$40:$DY$40
total_other_expense
='P&L'!$A$55:$AG$55
total_other_expense_actual
='P&L'!$CO$55:$DF$55
total_other_expense_variance
='P&L'!$DH$55:$DY$55
total_other_income
='P&L'!$A$50:$AG$50
total_other_income_actual
='P&L'!$CO$50:$DF$50
total_other_income_variance
='P&L'!$DH$50:$DY$50
total_other_operating_expenses
='P&L'!$A$37:$AG$37
total_other_operating_expenses_actual ='P&L'!$CO$37:$DF$37
total_other_operating_expenses_varian ='P&L'!$DH$37:$DY$37
total_sales_and_marketing_expense
='P&L'!$A$18:$AG$18
total_sales_and_marketing_expense_act='P&L'!$CO$18:$DF$18
total_sales_and_marketing_expense_var='P&L'!$DH$18:$DY$18
total_startup_expenses
='Start-up'!$B$12
total_unit_sales
='Sales Forecast'!$A$22:$AG$22
valuation_earnings_multiple
='Investment Analysis'!$B$14:$AG$14
valuation_sales_multiple
='Investment Analysis'!$B$15:$AG$15
variable_cost_per_unit_calculated
='Break-even'!$O$17

Page

as of

0
General and Administrative
Sales and Marketing
Production
Other
0
0
0
1
1
1
1
1
2016
1
0
0
0
0
0
0
1
1

Page

as of

Page

as of

Page

as of

Page

as of

:$AG$14
:$AG$15

Page

as of

Description
Plan title
True, if you select YES for expense categories
Expense categories label
Expense categories label
Expense categories label
Expense categories label
True, for a startup business - False for an ongoing business
True, if you sell products
True, if you selected the non-profit business type
True, if you manage inventory
True, if you sell on credit
True, if you selected the standard financials - False if you selected cash-basis
True, if you selected a "Standard Term" business plan - False if you selected the "Long-term" plan
1 if your starting month is set for January, 3 if it's set for March etc.
The starting year for your plan
Used to set PS_DateSetting
True, if you selected a 2nd year of monthly data - False, if you didn't
True, if you selected a units-based forecast - False, if you chose to forecast by values
True, if you selected "Yes, I use Quickbooks and I plan on importing financial data later."
True, if you chose to track other income and expenses
True, if you chose to forecast personnel costs by the number of employees and average salaries
True, if you chose to forecast personnel costs by the number of employees and average salaries
True, if the workbook was created by the Premier version
Usually set to 2, 1 if you chose to replace month and year labels with non-date specific month and year labels

Page

as of

Page

as of

Page

as of

Page

as of

Page

as of

and year labels

Page

as of

Page

as of

Page

as of

Page

as of

Page