Preschool Business Plan

Page 1


Legal Page

Confidentiality Agreement

The undersigned reader acknowledges that the information provided by _______________ in this business plan is confidential; therefore, reader agrees not to disclose it without the express written permission of _______________. It is acknowledged by reader that information to be furnished in this business plan is in all respects confidential in nature, other than information which is in the public domain through other means and that any disclosure or use of same by reader, may cause serious harm or damage to _______________. Upon request, this document is to be immediately returned to _______________. ___________________ Signature ___________________ Name (typed or printed) ___________________ Date This is a business plan. It does not imply an offering of securities.


Table of Contents

1.0 Executive Summary...............................................................................................................................1 Chart: Highlights..................................................................................................................................1 1.1 Objectives..........................................................................................................................................1 1.2 Mission...............................................................................................................................................2 1.3 Keys to Success..................................................................................................................................2 2.0 Company Summary...............................................................................................................................2 2.1 Company Ownership.........................................................................................................................2 2.2 Start-up Summary..............................................................................................................................2 Table: Start-up.....................................................................................................................................3 Chart: Start-up......................................................................................................................................3 [MULTIPLE PAGES REDACTED FOR SAMPLE]......................................................................4 Table: Sales Forecast.......................................................................................................................4 Chart: Sales Monthly.......................................................................................................................5 Chart: Sales by Year........................................................................................................................5 6.5 Milestones..........................................................................................................................................5 Table: Milestones.................................................................................................................................6 Chart: Milestones.................................................................................................................................6

......................................................................................................................................................................6 7.0 Operational Plan....................................................................................................................................7 7.1 IPC IPI Preschools.................................................................................................................................7 [MULTIPLE PAGES REDACTED FOR SAMPLE]......................................................................8 Table: Profit and Loss..........................................................................................................................8 Chart: Profit Monthly...........................................................................................................................9 Chart: Profit Yearly..............................................................................................................................9 Chart: Gross Margin Monthly............................................................................................................10 Chart: Gross Margin Yearly...............................................................................................................10 8.5 Projected Cash Flow........................................................................................................................11 Table: Cash Flow...............................................................................................................................11 Chart: Cash.........................................................................................................................................12 8.6 Projected Balance Sheet...................................................................................................................12 Table: Balance Sheet..........................................................................................................................12 8.7 Business Ratios................................................................................................................................13 Table: Ratios......................................................................................................................................13 Page 1


Table of Contents

8.8 Long-term Plan................................................................................................................................14 Table: Sales Forecast...................................................................................................................................1 ......................................................................................................................................................................1 Table: Personnel...........................................................................................................................................2 ......................................................................................................................................................................2 Table: Profit and Loss..................................................................................................................................3 ......................................................................................................................................................................4 Table: Cash Flow.........................................................................................................................................5 ......................................................................................................................................................................6 Table: Balance Sheet....................................................................................................................................7

Page 2


IPC SAMPLE BUSINESS PLAN © 2011

1.0 Executive Summary IPC INTERNATIONAL PRESCHOOL OF ISTANBUL is a limited liability company (“Company”) established and operated under Turkish Laws, working in child care and education industry. During its first 5 years of operation, the Company will focus on care and education of children from 0 to under 6 years (preschool). The key for the Company’s growth (as shown is the Chart below) will be its value for money concept allowing a quick expansion of franchising system. The Company will make its initial public offering (IPO) and start expanding its business to other activities from 6th year. Chart: Highlights

1.1 Objectives There are nine major objectives, the first four of which are immediate to short term. Medium and long term objectives have also been highlighted in order to provide a longer term set of goals.

Short term objectives (1-12 months) • • • •

Launch the first 2 IPC schools within 12 months of operation; Achieve a 100% capacity for both schools within 6 months of operation; Offering paid training courses to 100 teachers and sort out 20 of them for the first 2 schools within 12 months of operation; 50 software copies to be sold within 12 months of operation.

Page 1


IPC SAMPLE BUSINESS PLAN © 2011

Medium and long-term objectives: • • • • •

Profitable and self-sufficient by the end of FY2; Achieve the annual growth rate of 20% in terms of profit; Achieve the net profit margin of at least 20% for every school; Launch a school within 3 months from the signing of every franchise agreement; Launch 5 IPC schools with 300 students across Turkey.

1.2 Mission IPC International Preschool of Istanbul Ltd will be dedicated to: • •

providing exceptional tender loving care and qualified bilingual education at an affordable price to 0-6 year old children of the middle class; raising early childhood education standards in Turkey through world class quality consultancy practices and training courses offered to teachers, managers and parents.

1.3 Keys to Success There are four generally accepted keys to success in the early childhood education sector: 1. 2. 3. 4.

Identify and quantify the market; Distinguish a brand, product & service; Recruit and maintain a trained staff complement; Establish a reputation for quality

2.0 Company Summary IPC International Preschool of Istanbul Ltd is incorporated as a limited liability company in Turkey and is headquartered in Istanbul. 2.1 Company Ownership IPC IPI Ltd is owned by its founder and director Samantha Smith and its investment partners. 2.2 Start-up Summary The start-up table takes into account median rent for 6 months, furniture, equipment which includes canteen equipment and computing costs. The cash required row makes the employment cost assumptions at gross salary for 6 months. This is summarized in the table below. All figures include costs for both a single IPC IPI Ltd preschool and the IPC IPI Ltd Headquarters office. Salary expectations reflect the low end of the salary spectrum.

Page 2


IPC SAMPLE BUSINESS PLAN © 2011

Table: Start-up

Start-up

Requirements

Start-up Expenses Legal Stationery etc. Insurance

$1,200 $750 $1,050

Rent

$16,000

Other

$5,000

Advertising &PR Licenses (IPC) IPC Consultancy

$1,250 $45,000 $6,000

Renovations

$11,000

Total Start-up Expenses

$87,250

Start-up Assets Cash Required Other Current Assets Long-term Assets

$129,900 $17,858 $10,000

Total Assets

$157,758

Total Requirements

$245,008

Chart: Start-up

Page 3


IPC SAMPLE BUSINESS PLAN © 2011

[MULTIPLE PAGES REDACTED FOR SAMPLE]

Table: Sales Forecast

Sales Forecast 2012

2013

2014

2015

2016

Sales IPC Schools

$96,800

$434,400

$866,400

$1,395,200

$1,782,400

IPC Software/Curriculum

$2,000

$50,000

$100,000

$175,000

$250,000

IPC Franchises

$7,500

$17,500

$52,500

$92,500

$112,500

5 day Manager/Teacher Training

$324,000

$356,400

$392,040

$450,846

$541,015

Consultancy Services

$120,000

$120,000

$132,000

$151,800

$182,160

Total Sales

$550,300

$978,300

$1,542,940

$2,265,346

$2,868,075 2016

Direct Cost of Sales

2012

2013

2014

2015

$21,500

$23,500

$0

$0

$0

Teacher Training

$3,600

$3,960

$4,320

$4,752

$5,464

Curriculum & Software

$3,850

$3,000

$3,000

$3,000

$3,000

Consulting License

$6,000

$6,000

$6,000

$6,000

$6,000

IPC Onsite Training

$60,000

$60,000

$60,000

$60,000

$60,000

Other

$17,592

$18,556

$17,133

$18,156

$19,306

Local Consultants/Trainers

$81,000

$89,100

$98,010

$107,811

$118,592

$193,542

$204,116

$188,463

$199,719

$212,362

Franchise Fees

Subtotal Direct Cost of Sales

Page 4


IPC SAMPLE BUSINESS PLAN © 2011

Chart: Sales Monthly

Chart: Sales by Year

6.5 Milestones The Milestones Table reflects marketing milestones proposed by IPC IPI Ltd and its strategic partner, IPC. All IPC related expenses are covered by the IPC.

Page 5


IPC SAMPLE BUSINESS PLAN © 2011

Table: Milestones

Milestones

Milestone

Start Date

End Date

Budget

Manager

Department

IPC IPI Branding

7/21/2011

9/1/2011

$1,120

IPC

Marketing

Website & IPC Microsite

9/1/2011

9/12/2011

$3,500

IPC

Marketing

PR campaign

9/1/2011

1/1/2013

$2,750

IPC

Marketing

Local Advertisements

4/2/2012

9/1/2012

$1,000

IPI Ltd

Marketing

12/1/2011

4/2/2012

$250

IPI Ltd

Marketing

Social Media Creation & Promotion Totals

$8,620

Chart: Milestones

Page 6


IPC SAMPLE BUSINESS PLAN © 2011

7.0 Operational Plan The following section will review the operational requirements in order to establish the two major IPC IPI projects. This section will look at the physical requirements, layout options and equipment for the IPC IPI preschool and the IPI/IPC office. 7.1 IPC IPI Preschools

7.11

Location and Facility Type

IPC IPI will identify locations that demographically represent the business intentions of IPC IPI Ltd’s objectives. Therefore, IPC IPI will focus on densely populated residential neighborhoods of Istanbul to establish the first preschool. KOOLKID will identify a space of at least 2,500 sq. ft of indoor space and about 3,000 sq.ft of playground space. 7.12

Facility Layout

The IPC provides 3D rendering layout suggestions based on the floor plan of an identified site. Once IPC IPI has chosen a suitable site, IPC will provide a layout suggestion.

Page 7


IPC SAMPLE BUSINESS PLAN © 2011

[MULTIPLE PAGES REDACTED FOR SAMPLE]

Table: Profit and Loss

Pro Forma Profit and Loss 2012

2013

2014

2015

2016

Sales

$550,300

$978,300

$1,542,940

$2,265,346

$2,868,075

Direct Cost of Sales

$193,542

$204,116

$188,463

$199,719

$212,362

$0

$0

$0

$0

$0

Total Cost of Sales

$193,542

$204,116

$188,463

$199,719

$212,362

Gross Margin

$356,758

$774,184

$1,354,477

$2,065,627

$2,655,713

64.83%

79.14%

87.79%

91.18%

92.60%

Other Costs of Sales

Gross Margin %

Expenses Payroll

$261,300

$328,500

$390,600

$452,700

$452,700

Marketing/Promotion

$1,200

$5,500

$8,500

$12,000

$18,000

Depreciation

$1,500

$6,000

$10,500

$16,500

$22,500

$48,000

$138,000

$228,000

$348,000

$468,000

Utilities

$3,000

$9,000

$18,000

$30,000

$42,000

Insurance

$1,056

$4,224

$7,392

$11,616

$15,840

$39,195

$49,275

$58,590

$67,905

$67,905

$355,251

$540,499

$721,582

$938,721

$1,086,945

Profit Before Interest and Taxes

$1,508

$233,685

$632,895

$1,126,906

$1,568,768

EBITDA

$3,008

$239,685

$643,395

$1,143,406

$1,591,268

$24,500

$24,500

$24,500

$24,500

$24,500

$0

$73,215

$212,938

$385,842

$540,494

($22,993)

$135,970

$395,457

$716,564

$1,003,774

-4.18%

13.90%

25.63%

31.63%

35.00%

Rent

Payroll Taxes Total Operating Expenses

Interest Expense Taxes Incurred Net Profit Net Profit/Sales

Page 8


IPC SAMPLE BUSINESS PLAN © 2011

Chart: Profit Monthly

Chart: Profit Yearly

Page 9


IPC SAMPLE BUSINESS PLAN © 2011

Chart: Gross Margin Monthly

Chart: Gross Margin Yearly

Page 10


IPC SAMPLE BUSINESS PLAN © 2011

8.5 Projected Cash Flow Table: Cash Flow

Pro Forma Cash Flow 2012

2013

2014

2015

2016

Cash Sales

$550,300

$978,300

$1,542,940

$2,265,346

$2,868,075

Subtotal Cash from Operations

$550,300

$978,300

$1,542,940

$2,265,346

$2,868,075

$550,300

$978,300

$1,542,940

$2,265,346

$2,868,075

2012

2013

2014

2015

2016

Cash Spending

$261,300

$328,500

$390,600

$452,700

$452,700

Bill Payments

$286,591

$489,992

$726,776

$1,052,196

$1,363,661

Subtotal Spent on Operations

$547,891

$818,492

$1,117,376

$1,504,896

$1,816,361

$547,891

$818,492

$1,117,376

$1,504,896

$1,816,361

Net Cash Flow

$2,409

$159,808

$425,564

$760,450

$1,051,714

Cash Balance

$132,309

$292,117

$717,681

$1,478,131

$2,529,845

Cash Received

Cash from Operations

Additional Cash Received Subtotal Cash Received Expenditures

Expenditures from Operations

Additional Cash Spent Subtotal Cash Spent

Page 11


IPC SAMPLE BUSINESS PLAN © 2011

Chart: Cash

8.6 Projected Balance Sheet

Table: Balance Sheet

Pro Forma Balance Sheet 2012

2013

2014

2015

2016

$2,529,845

Assets

Current Assets Cash

$132,309

$292,117

$717,681

$1,478,131

Other Current Assets

$17,858

$17,858

$17,858

$17,858

$17,858

Total Current Assets

$150,167

$309,975

$735,539

$1,495,989

$2,547,703

$10,000

Long-term Assets Long-term Assets

$10,000

$10,000

$10,000

$10,000

Accumulated Depreciation

$1,500

$7,500

$18,000

$34,500

$57,000

Total Long-term Assets

$8,500

$2,500

($8,000)

($24,500)

($47,000)

$158,667

$312,475

$727,539

$1,471,489

$2,500,703

2012

2013

2014

2015

2016

Total Assets

Liabilities and Capital

Current Liabilities

Page 12


IPC SAMPLE BUSINESS PLAN © 2011

Accounts Payable

$23,901

$41,739

$61,347

$88,733

$114,173

Current Borrowing

$122,500

$122,500

$122,500

$122,500

$122,500

$0

$0

$0

$0

$0

$146,401

$164,239

$183,847

$211,233

$236,673

Other Current Liabilities Subtotal Current Liabilities Long-term Liabilities

$0

$0

$0

$0

$0

Total Liabilities

$146,401

$164,239

$183,847

$211,233

$236,673

Paid-in Capital

$122,508

$122,508

$122,508

$122,508

$122,508

Retained Earnings

($87,250)

($110,243)

$25,728

$421,184

$1,137,748

Earnings

($22,993)

$135,970

$395,457

$716,564

$1,003,774

$12,265

$148,236

$543,693

$1,260,256

$2,264,031

$158,667

$312,475

$727,539

$1,471,489

$2,500,703

$12,265

$148,236

$543,693

$1,260,256

$2,264,031

Total Capital Total Liabilities and Capital

Net Worth

8.7 Business Ratios

Table: Ratios

Ratio Analysis 2012

2013

2014

2015

2016

n.a.

77.78%

57.72%

46.82%

26.61%

Other Current Assets

11.26%

5.72%

2.45%

1.21%

0.71%

Total Current Assets

94.64%

99.20%

101.10%

101.66%

101.88%

5.36%

0.80%

-1.10%

-1.66%

-1.88%

100.00%

100.00%

100.00%

100.00%

100.00%

92.27%

52.56%

25.27%

14.36%

9.46%

0.00%

0.00%

0.00%

0.00%

0.00%

92.27%

52.56%

25.27%

14.36%

9.46%

7.73%

47.44%

74.73%

85.64%

90.54%

100.00%

100.00%

100.00%

100.00%

100.00%

Gross Margin

64.83%

79.14%

87.79%

91.18%

92.60%

Selling, General & Administrative Expenses

69.01%

65.24%

62.16%

59.55%

57.60%

0.22%

0.56%

0.55%

0.53%

0.63%

Sales Growth

Percent of Total Assets

Long-term Assets Total Assets

Current Liabilities Long-term Liabilities Total Liabilities Net Worth

Percent of Sales Sales

Advertising Expenses

Page 13


IPC SAMPLE BUSINESS PLAN © 2011

Profit Before Interest and Taxes

0.27%

23.89%

41.02%

49.75%

54.70%

Current

1.03

1.89

4.00

7.08

10.76

Quick

1.03

1.89

4.00

7.08

10.76

92.27%

52.56%

25.27%

14.36%

9.46%

-187.46%

141.12%

111.90%

87.47%

68.21%

-14.49%

66.94%

83.62%

74.92%

61.75%

Additional Ratios

2012

2013

2014

2015

2016

Net Profit Margin

-4.18%

13.90%

25.63%

31.63%

35.00%

Return on Equity

-187.46%

91.73%

72.74%

56.86%

44.34%

12.99

12.17

12.17

12.17

12.17

27

24

25

25

27

3.47

3.13

2.12

1.54

1.15

11.94

1.11

0.34

0.17

0.10

1.00

1.00

1.00

1.00

1.00

$3,765

$145,736

$551,693

$1,284,756

$2,311,031

0.06

9.54

25.83

46.00

64.03

Assets to Sales

0.29

0.32

0.47

0.65

0.87

Current Debt/Total Assets

92%

53%

25%

14%

9%

Acid Test

1.03

1.89

4.00

7.08

10.76

Sales/Net Worth

44.87

6.60

2.84

1.80

1.27

Dividend Payout

0.00

0.00

0.00

0.00

0.00

Main Ratios

Total Debt to Total Assets Pre-tax Return on Net Worth Pre-tax Return on Assets

Activity Ratios Accounts Payable Turnover Payment Days Total Asset Turnover

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

Liquidity Ratios Net Working Capital Interest Coverage

Additional Ratios

8.8 Long-term Plan IPC IPI Ltd anticipates exponential growth over the next five years which takes into account wider brand recognition in FY3 onwards.

Page 14


Appendix Table: Sales Forecast

Sales Forecast Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

$2,000

$2,200

$2,600

$4,000

$6,000

$8,000

$12,000

$12,000

$12,000

$12,000

$12,000

$12,000

Software/Curriculum

$0

$100

$100

$100

$100

$200

$200

$200

$200

$300

$200

$300

IPC Franchises

$0

$0

$0

$0

$0

$5,000

$0

$0

$0

$0

$0

$2,500

$7,500

$7,500

$15,000

$20,000

$27,000

$27,000

$27,000

$40,000

$35,000

$35,000

$41,500

$41,500

Sales IPC Schools

5 day Manager/Teacher Training Consultancy Services Total Sales

Direct Cost of Sales Franchise Fees Teacher Training

$2,500

$3,500

$5,000

$8,000

$10,000

$10,000

$10,000

$10,000

$12,500

$15,250

$15,250

$18,000

$12,000

$13,300

$22,700

$32,100

$43,100

$50,200

$49,200

$62,200

$59,700

$62,550

$68,950

$74,300

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

$3,500

$0

$0

$9,000

$0

$0

$0

$9,000

$0

$0

$0

$0

$300

$300

$300

$300

$300

$300

$300

$300

$300

$300

$300

$300

Curriculum & Software

$1,000

$0

$0

$0

$1,350

$0

$0

$0

$0

$0

$0

$1,500

Consulting License

$6,000

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

IPC Onsite Training

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

Other

$1,466

$1,466

$1,466

$1,466

$1,466

$1,466

$1,466

$1,466

$1,466

$1,466

$1,466

$1,466

Local Consultants/Trainers

$6,750

$6,750

$6,750

$6,750

$6,750

$6,750

$6,750

$6,750

$6,750

$6,750

$6,750

$6,750

$24,016

$13,516

$13,516

$22,516

$14,866

$13,516

$13,516

$22,516

$13,516

$13,516

$13,516

$15,016

Subtotal Direct Cost of Sales

Page 1


Appendix Table: Personnel

Personnel Plan Jan Vietnamese Teachers

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

$900

$900

$900

$1,200

$1,500

$2,100

$2,100

$2,100

$2,100

$2,100

$2,100

$2,100

$2,700

$2,700

$2,700

$2,700

$2,700

$2,700

$2,700

$2,700

$2,700

$2,700

$2,700

$2,700

Administrative Manager

$600

$600

$600

$600

$600

$600

$600

$600

$600

$600

$600

$600

Cook

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

$200

Director

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

Manager

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

CFO

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

Consultants

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

$5,000

Sales/Marketing

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

HR/Admin

$600

$600

$600

$600

$600

$600

$600

$600

$600

$600

$600

$600

Foreign Teacher/Manager

Accounts Production Total People

Total Payroll

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$500

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

$3,000

23

23

23

24

25

27

27

27

27

27

27

27

$21,000

$21,000

$21,000

$21,300

$21,600

$22,200

$22,200

$22,200

$22,200

$22,200

$22,200

$22,200

Page 2


Appendix Table: Profit and Loss

Pro Forma Profit and Loss Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sales

$12,000

$13,300

$22,700

$32,100

$43,100

$50,200

$49,200

$62,200

$59,700

$62,550

$68,950

$74,300

Direct Cost of Sales

$24,016

$13,516

$13,516

$22,516

$14,866

$13,516

$13,516

$22,516

$13,516

$13,516

$13,516

$15,016

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$24,016

$13,516

$13,516

$22,516

$14,866

$13,516

$13,516

$22,516

$13,516

$13,516

$13,516

$15,016

Other Costs of Sales Total Cost of Sales

Gross Margin

($12,016)

($216)

$9,184

$9,584

$28,234

$36,684

$35,684

$39,684

$46,184

$49,034

$55,434

$59,284

Gross Margin %

-100.13%

-1.62%

40.46%

29.86%

65.51%

73.08%

72.53%

63.80%

77.36%

78.39%

80.40%

79.79%

$21,000

$21,000

$21,000

$21,300

$21,600

$22,200

$22,200

$22,200

$22,200

$22,200

$22,200

$22,200

$1,200

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$125

$125

$125

$125

$125

$125

$125

$125

$125

$125

$125

$125

$4,000

$4,000

$4,000

$4,000

$4,000

$4,000

$4,000

$4,000

$4,000

$4,000

$4,000

$4,000 $250

Expenses Payroll Marketing/Promotion Depreciation Rent Utilities

$250

$250

$250

$250

$250

$250

$250

$250

$250

$250

$250

Insurance

15%

$88

$88

$88

$88

$88

$88

$88

$88

$88

$88

$88

$88

Payroll Taxes

15%

$3,150

$3,150

$3,150

$3,195

$3,240

$3,330

$3,330

$3,330

$3,330

$3,330

$3,330

$3,330

$29,813

$28,613

$28,613

$28,958

$29,303

$29,993

$29,993

$29,993

$29,993

$29,993

$29,993

$29,993

Profit Before Interest and Taxes

($41,829)

($28,829)

($19,429)

($19,374)

($1,069)

$6,691

$5,691

$9,691

$16,191

$19,041

$25,441

$29,291

EBITDA

($41,704)

($28,704)

($19,304)

($19,249)

($944)

$6,816

$5,816

$9,816

$16,316

$19,166

$25,566

$29,416

$2,042

$2,042

$2,042

$2,042

$2,042

$2,042

$2,042

$2,042

$2,042

$2,042

$2,042

$2,042

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Net Profit

($43,870)

($30,871)

($21,471)

($21,416)

($3,111)

$4,649

$3,649

$7,649

$14,149

$16,999

$23,399

$27,249

Net Profit/Sales

-365.58%

-232.11%

-94.58%

-66.72%

-7.22%

9.26%

7.42%

12.30%

23.70%

27.18%

33.94%

36.67%

Total Operating Expenses

Interest Expense Taxes Incurred

Page 3


Appendix

Page 4


Appendix Table: Cash Flow

Pro Forma Cash Flow Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Cash Sales

$12,000

$13,300

$22,700

$32,100

$43,100

$50,200

$49,200

$62,200

$59,700

$62,550

$68,950

$74,300

Subtotal Cash from Operations

$12,000

$13,300

$22,700

$32,100

$43,100

$50,200

$49,200

$62,200

$59,700

$62,550

$68,950

$74,300

Cash Received

Cash from Operations

Additional Cash Received Sales Tax, VAT, HST/GST Received

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

New Current Borrowing

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

New Other Liabilities (interest-free)

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

New Long-term Liabilities

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Sales of Other Current Assets

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Sales of Long-term Assets

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

New Investment Received

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$12,000

$13,300

$22,700

$32,100

$43,100

$50,200

$49,200

$62,200

$59,700

$62,550

$68,950

$74,300

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

$21,000

$21,000

$21,000

$21,300

$21,600

$22,200

$22,200

$22,200

$22,200

$22,200

$22,200

$22,200

$1,158

$34,355

$23,046

$23,347

$31,837

$24,444

$23,226

$23,526

$31,926

$23,226

$23,226

$23,276

$22,158

$55,355

$44,046

$44,647

$53,437

$46,644

$45,426

$45,726

$54,126

$45,426

$45,426

$45,476

Sales Tax, VAT, HST/GST Paid Out

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Principal Repayment of Current Borrowing

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Other Liabilities Principal Repayment

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Subtotal Cash Received

Expenditures

0.00%

Expenditures from Operations Cash Spending Bill Payments Subtotal Spent on Operations

Additional Cash Spent

Page 5


Appendix Long-term Liabilities Principal Repayment

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Purchase Other Current Assets

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Purchase Long-term Assets

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Dividends

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$22,158

$55,355

$44,046

$44,647

$53,437

$46,644

$45,426

$45,726

$54,126

$45,426

$45,426

$45,476

Net Cash Flow

($10,158)

($42,055)

($21,346)

($12,547)

($10,337)

$3,556

$3,774

$16,474

$5,574

$17,124

$23,524

$28,824

Cash Balance

$119,742

$77,687

$56,341

$43,794

$33,457

$37,013

$40,787

$57,262

$62,836

$79,960

$103,485

$132,309

Subtotal Cash Spent

Page 6


Appendix Table: Balance Sheet

Pro Forma Balance Sheet

Assets

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

$132,309

Starting Balances

Current Assets Cash

$129,900

$119,742

$77,687

$56,341

$43,794

$33,457

$37,013

$40,787

$57,262

$62,836

$79,960

$103,485

Other Current Assets

$17,858

$17,858

$17,858

$17,858

$17,858

$17,858

$17,858

$17,858

$17,858

$17,858

$17,858

$17,858

$17,858

Total Current Assets

$147,758

$137,600

$95,545

$74,199

$61,652

$51,315

$54,871

$58,645

$75,120

$80,694

$97,818

$121,343

$150,167

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$10,000

$0

$125

$250

$375

$500

$625

$750

$875

$1,000

$1,125

$1,250

$1,375

$1,500

$10,000

$9,875

$9,750

$9,625

$9,500

$9,375

$9,250

$9,125

$9,000

$8,875

$8,750

$8,625

$8,500

$157,758

$147,475

$105,295

$83,824

$71,152

$60,690

$64,121

$67,770

$84,120

$89,569

$106,568

$129,968

$158,667

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

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

Liabilities and Capital

Current Liabilities Accounts Payable

$0

$33,587

$22,277

$22,277

$31,021

$23,669

$22,451

$22,451

$31,151

$22,451

$22,451

$22,451

$23,901

Current Borrowing

$122,500

$122,500

$122,500

$122,500

$122,500

$122,500

$122,500

$122,500

$122,500

$122,500

$122,500

$122,500

$122,500

Other Current Liabilities Subtotal Current Liabilities

Long-term Liabilities

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$122,500

$156,087

$144,777

$144,777

$153,521

$146,169

$144,951

$144,951

$153,651

$144,951

$144,951

$144,951

$146,401

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Total Liabilities

$122,500

$156,087

$144,777

$144,777

$153,521

$146,169

$144,951

$144,951

$153,651

$144,951

$144,951

$144,951

$146,401

Paid-in Capital

$122,508

$122,508

$122,508

$122,508

$122,508

$122,508

$122,508

$122,508

$122,508

$122,508

$122,508

$122,508

$122,508

Retained Earnings

($87,250)

($87,250)

($87,250)

($87,250)

($87,250)

($87,250)

($87,250)

($87,250)

($87,250)

($87,250)

($87,250)

($87,250)

($87,250)

$0

($43,870)

($74,741)

($96,212)

($117,627)

($120,738)

($116,089)

($112,439)

($104,790)

($90,641)

($73,641)

($50,242)

($22,993)

$35,258

($8,612)

($39,483)

($60,954)

($82,369)

($85,480)

($80,831)

($77,181)

($69,532)

($55,383)

($38,383)

($14,984)

$12,265

$157,758

$147,475

$105,295

$83,824

$71,152

$60,690

$64,121

$67,770

$84,120

$89,569

$106,568

$129,968

$158,667

$35,258

($8,612)

($39,483)

($60,954)

($82,369)

($85,480)

($80,831)

($77,181)

($69,532)

($55,383)

($38,383)

($14,984)

$12,265

Earnings Total Capital Total Liabilities and Capital

Net Worth

Page 7


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.