Writing a Winning Business Plan ◾ 333
PolyMedica Industries, Inc.
Pro Forma Balance Sheets
($000s)
Jun30
1991
Sep 30
1991
Dec 31
1991
Mar 31
1992
Jun30
1992
Sep 30
1992
Dec 31
1992
Mar 31
1993
Mar 31
1994
Mar 31
1995
Mar 31
1996
LIABILITIES AND SHAREHOLDERS’ EQUITY
CURRENT LIABILITIES
Accounts payable$471.8$508.8$547.8$588.3$901.4$946.3$991.4$1,045.3$1,823.9$1,897.9$1,985.9
Accrued liabilities357.5 387.5417.5 447.5 864.5894.5 924.5954.5 1,409.01,509.0 1,659.0
TOTAL CURRENT LIABILITIES829.3 896.3 965.31,035.8 1,765.91,840.8 1,915.91,999.8 3,232.93,406.9 3,644.9
Prom
issory note 400.0 383.3 366.6 349.9333.2 316.5299.8 283.1216.3 149.582.7
TOTAL LIABILITIES1,229.3 1,279.61,331.9 1,385.72,099.1 2,157. 32,215.7 2,282.93,449.2 3,556.43,727.6
SHAREHOLDERS’ EQUITY
Series A redeemable convertible preferred
stock, $.01 par value
Series B redeemable convertible preferred
stock, $.01 par value
Series C redeemable convertible preferred
stock, $.01 par value
Common stock, $.01 par value
Additional paid-in capital
Retained earnings (deficit)
0.9
5.2
2.4
3.8
6,289.8
(1,149.8)
0.9
5.2
2.4
3.8
6,289.8
(1,205.7)
0.9
5.2
2.4
3.8
6,289.8
(1,258.3)
0.9
5.2
2.4
3.8
6,289.8
(1,139.9)
0.9
5.2
2.4
3.8
6,289.8
(1,087.1)
0.9
5.2
2.4
3.8
6,289.8
(748.8)
0.9
5.2
2.4
3.8
6,289.8
(484.5)
0.9
5.2
2.4
3.8
6,289.8
(5.3)
0.9
5.2
2.4
3.8
6,289.8
1,387.5
0.9
5.2
2.4
3.8
6,289.8
4,939.8
0.9
5.2
2.4
3.8
6,289.8
11,364.9
TOTAL SHAREHOLDERS’ EQUITY 5,152.35,096.4 5,043.85,162.2 5,215.05,553.3 5,817.66,296.8 7,689.611,241.917,667.0
$6,381.6 $6,376.0 $6,375.7 $6,547.9 $7,314.1 $7,710.6 $8,033.2 $8,579.8 $11,138.8$14,798.3 $21,394.6
Confidential PolyMedica Industries, Inc.
334 ◾ The Guide to Entrepreneurship: How to Create Wealth for Your Company
PolyMedica Industries, Inc.
Pro Forma Cash Flows
($000s)
Q/E
06/30/91
Q/E
09/30/91
Q/E
12/31/91
Q/E
03/31/92
Q/E
06/30/92
Q/E
09/30/92
Q/E
12/31/92
Q/E
03/31/93
FYE
March 31,
1994
FYE
March 31,
1995
FYE
March 31,
1996
Beginnin
g cash balance $3,380.3 $2,824.2 $2,226.3 $1,813.6 $1,568.3 $2,038.2 $1,808.8 $1,689.3 $1,626.8 $2,898.2 $3,633.7
Cash receipts:
Accounts receivable
Interest income
625.5
67.6
995.5
56.5
1,260.5
44.5
1,531.7
36.3
1,836.0
31.4
2,146.1
40.8
2,552.1
36.2
2,848.7
33.8
16,585.3
130.1
26,028.2
231.9
38,428.5
290.7
Total cash receipts 693.11,052.0 1,305.11,567.9 1,867.42,186.9 2,588.32,882.5 16,715.4 26,260.0 38,719.2
Cash disbursements:
Direct cost of sales and
operating expenses
less depreciation and
amortization
661.11,180.1 1,388.91,551.5 1,015.82,038.6 2,308.92,526.3 13,022.8 21,131.5 29,004.6
Chan
ge in other asset accounts
Prom
issory note principal payments
Interest expense on promissory note
In
come
tax payments
588.2
0.0
0.0
0.0
446.0
16.7
7.0
0.0
305.2
16.7
7.0
0.0
238.0
16.7
7.0
0.0
358.0
16.7
7.0
0.0
354.0
16.7
7.0
0.0
375.2
16.7
7.0
0.0
377.0
16.7
7.0
18.0
1,386.2
66.8
28.0
940.2
1,900.3
66.8
28.0
2,397.9
2,130.8
66.8
28.0
4,337.2
Total cash disbursements 1,249.31,649.8 1,717.81,813.2 1,397. 52,416.3 2,707.82,945.0 15,444.0 25,524.5 35,567.4
Ending cash balance$2,824.2$2,226.3$1,813.6$1,568.3$2,038.2$1,808.8$1,689.3$1,626.8$2,898.2$3,633.7$6,785.6
Confidential PolyMedica Industries, Inc.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.