INPUT Income Statement

SALES 3,200,000 Base Year

GROWTH SALES 3,200,000
FIRST 3 YRS 15.00% COGS 2,400,000
AFTER 3 YRS 10% OF LAST YEAR GROSS PROFIT 800,000
CASH SALES 90% SALARIES 320,000
GP MARGIN 25% ON SALES RENT 224,000
SALARIES 10% ON SALES UTILITIES 96,000
RENT 7% ON SALES OTHER EXP 64,000
UTILITIES 3% ON SALES EBIT 96,000
OTHER EXP 2% ON SALES TAX -
TAX RATE 0% ASSUMED NET INCOME 96,000
INFLATION 3% FOR OPT EXP
EPS 0.64
NO. OF SHARES 150,000
PROJECTION IN YEARS 6
Increase in Capital % 4
FACE VALUE /SHARE 10

Additional Plant
Year Amount
2 900,000
4 1,000,000
7 2,500,000
Statement Balance Sheet
Base Year Base Year
3,200,000
2,400,000 CAPITAL 1,500,000
800,000 RETAINED EARNINGS 145,000
320,000 TOTAL EQUITY 1,645,000
224,000
96,000 LONG TERM LOANS 450,000
64,000
96,000 CURRENT LIABILITIES
- ACCOUNT PAYBLE 60,000
96,000 SHORT TERM LOAN 72,000
132,000
0.64 TOTAL LIABILITIES 582,000

TOTAL EQUITIES AND LIABILITES 2,227,000

PLANT & EQUIP 900,000

LONG TERM INVESTMENTS 600,000
1,500,000

CURRENT ASSETS
INVENTORY 48,000
AR 320,000
CASH AND BANK 359,000
727,000
TOTAL ASSETS 2,227,000

DIFFRENCE -
ASSETS WITHOUT EXCESS CASH 2,227,000
EQ & LIAB WITHOUT REVOLVER 2,227,000
-
Income Statement
YEARS 0 1 2 3 4
SALES 3,200,000 3,680,000 4,232,000 4,866,800 5,353,480
COGS 2,400,000 2,760,000 3,174,000 3,650,100 4,015,110
GROSS PROFIT 800,000 920,000 1,058,000 1,216,700 1,338,370
SALARIES 320,000 329,600 339,488 349,673 360,163
RENT 224,000 230,720 237,642 244,771 252,114
UTILITIES 96,000 98,880 101,846 104,902 108,049
OTHER EXP 64,000 65,920 67,898 69,935 72,033
EBIT 96,000 194,880 311,126 447,420 546,012
TAX - - - - -
NET INCOME 96,000 194,880 311,126 447,420 546,012

EPS 0.64 1.30 2.07 2.98 3.64

YEARS 0 1 2 3 4
INCREASE IN SALES 0% 15% 15% 15% 10%
 3 4 5 6 7 8 9 1
4,866,800 5,353,480 5,888,828 6,477,711 7,125,482 7,838,030 8,621,833 9,484,01
3,650,100 4,015,110 4,416,621 4,858,283 5,344,111 5,878,523 6,466,375 7,113,01
1,216,700 1,338,370 1,472,207 1,619,428 1,781,370 1,959,508 2,155,458 2,371,00
349,673 360,163 370,968 382,097 393,560 405,366 417,527 430,05
244,771 252,114 259,677 267,468 275,492 283,756 292,269 301,03
104,902 108,049 111,290 114,629 118,068 121,610 125,258 129,01
69,935 72,033 74,194 76,419 78,712 81,073 83,505 86,01
447,420 546,012 656,078 778,815 915,539 1,067,701 1,236,898 1,424,88
- - - - - - - -
447,420 546,012 656,078 778,815 915,539 1,067,701 1,236,898 1,424,88

2.98 3.64 4.37 5.19 6.10 7.12 8.25 9.5

3 4 5 6 7 8 9 1
15% 10% 10% 10% 10% 10% 10% 10
 9 10
8,621,833 9,484,016
6,466,375 7,113,012
2,155,458 2,371,004
417,527 430,053
292,269 301,037
125,258 129,016
83,505 86,011
1,236,898 1,424,887
- -
1,236,898 1,424,887

8.25 9.50

9 10
10% 10%
Balance Sheet
YEARS 0 1 2 3

CAPITAL 1,500,000 1,560,000 1,622,400 1,687,296

RETAINED EARNINGS 145,000 339,880 651,006 1,098,427
TOTAL EQUITY 1,645,000 1,899,880 2,273,406 2,785,723

LONG TERM LOANS 450,000 450,000 450,000 450,000

CURRENT LIABILITIES
ACCOUNT PAYBLE 60,000 69,000 79,350 91,253
SHORT TERM LOAN 72,000 72,000 72,000 72,000
132,000 141,000 151,350 163,253
TOTAL LIABILITIES 582,000 591,000 601,350 613,253

TOTAL EQUITIES AND LIABILITES 2,227,000 2,490,880 2,874,756 3,398,975

PLANT & EQUIP 900,000 900,000 1,800,000 1,800,000

LONG TERM INVESTMENTS 600,000 600,000 600,000 600,000
1,500,000 1,500,000 2,400,000 2,400,000

CURRENT ASSETS
INVENTORY 48,000 55,200 63,480 73,002
AR 320,000 368,000 423,200 486,680
CASH AND BANK 359,000 567,680 (11,924) 439,293
727,000 990,880 474,756 998,975
TOTAL ASSETS 2,227,000 2,490,880 2,874,756 3,398,975

DIFFRENCE - - - -
ASSETS WITHOUT EXCESS CASH 2,227,000 2,490,880 2,874,756 3,398,975
EQ & LIAB WITHOUT REVOLVER 2,227,000 2,490,880 2,874,756 3,398,975
- - - -
 2 3 4 5 6 7 8 9

1,622,400 1,687,296 1,754,788 1,824,979 1,897,979 1,973,898 2,052,854 2,134,968

651,006 1,098,427 1,644,438 2,300,516 3,079,331 3,994,871 5,062,572 6,299,470
2,273,406 2,785,723 3,399,226 4,125,496 4,977,310 5,968,768 7,115,426 8,434,438

450,000 450,000 450,000 450,000 450,000 450,000 450,000 450,000

79,350 91,253 100,378 110,416 121,457 133,603 146,963 161,659

72,000 72,000 72,000 72,000 72,000 72,000 72,000 72,000
151,350 163,253 172,378 182,416 193,457 205,603 218,963 233,659
601,350 613,253 622,378 632,416 643,457 655,603 668,963 683,659

2,874,756 3,398,975 4,021,604 4,757,911 5,620,767 6,624,371 7,784,389 9,118,097

1,800,000 1,800,000 2,800,000 2,800,000 2,800,000 5,300,000 5,300,000 5,300,000

600,000 600,000 600,000 600,000 600,000 600,000 600,000 600,000
2,400,000 2,400,000 3,400,000 3,400,000 3,400,000 5,900,000 5,900,000 5,900,000

63,480 73,002 80,302 88,332 97,166 106,882 117,570 129,327

423,200 486,680 535,348 588,883 647,771 712,548 783,803 862,183
(11,924) 439,293 5,954 680,696 1,475,830 (95,059) 983,015 2,226,586
474,756 998,975 621,604 1,357,911 2,220,767 724,371 1,884,389 3,218,097
2,874,756 3,398,975 4,021,604 4,757,911 5,620,767 6,624,371 7,784,389 9,118,097

- - - - - - - -
2,874,756 3,398,975 4,021,604 4,757,911 5,620,767 6,624,371 7,784,389 9,118,097
2,874,756 3,398,975 4,021,604 4,757,911 5,620,767 6,624,371 7,784,389 9,118,097
- - - - - - - -
 8 9 10

2,052,854 2,134,968 2,220,366

5,062,572 6,299,470 7,724,357
7,115,426 8,434,438 9,944,723

450,000 450,000 450,000

146,963 161,659 177,825

72,000 72,000 72,000
218,963 233,659 249,825
668,963 683,659 699,825

7,784,389 9,118,097 10,644,549

5,300,000 5,300,000 5,300,000

600,000 600,000 600,000
5,900,000 5,900,000 5,900,000

117,570 129,327 142,260

783,803 862,183 948,402
983,015 2,226,586 3,653,887
1,884,389 3,218,097 4,744,549
7,784,389 9,118,097 10,644,549

- - -
7,784,389 9,118,097 10,644,549
7,784,389 9,118,097 10,644,549
- - -
Cash Flow Statement
YEARS 0 1 2
Cash Collection
Previous Year 320,000 368,000 423,20
Current Year 3,312,000 3,808,800 4,380,12
3,632,000 4,176,800 4,803,32

Payments
COGS -Payment to vendor 2,758,200 3,171,930 3,647,72
SALARIES 329,600 339,488 349,67
RENT 230,720 237,642 244,77
UTILITIES 98,880 101,846 104,90
OTHER EXP 65,920 67,898 69,93
TAX - - -
3,483,320 3,918,804 4,416,99

Cash from Operating Activities 148,680 257,996 386,32

Investing Activities
Sale/Purchase of Plant & Equiptment - (900,000) -
Sale/Purchase of Investment - - -
Cash from Investing Activities - (900,000) -

Financing Activities
Addition/redemption of shares 60,000 62,400 64,89
Sale/Purchase of Investment - - -
Cash from Financing Activities 60,000 62,400 64,89

Increase or decrease in cash 208,680 (579,604) 451,21

Cash at start 359,000 567,680 (11,92
Cash at end 567,680 (11,924) 439,29

Purchases 2,767,200 3,182,280 3,659,62

COGS 2,760,000 3,174,000 3,650,10
Inventory at start (48,000) (55,200) (63,48
Inventory at end 55,200 63,480 73,00

Payment 2,758,200 3,171,930 3,647,72

Purchases 2,767,200 3,182,280 3,659,62
COGS 2,760,000 3,174,000 3,650,10
Inventory at start (48,000) (55,200) (63,48
Inventory at end 55,200 63,480 73,00

Payment 2,758,200 3,171,930 3,647,72

Purchases 2,767,200 3,182,280 3,659,62
Account Payable at start 60,000 69,000 79,35
Account Payable at end (69,000) (79,350) (91,25

Additional NCA - 900,000 -

 2 3 4 5 6 7 8

368,000 423,200 486,680 535,348 588,883 647,771 712,548 783,8

3,808,800 4,380,120 4,818,132 5,299,945 5,829,940 6,412,934 7,054,227 7,759,6
4,176,800 4,803,320 5,304,812 5,835,293 6,418,823 7,060,705 7,766,775 8,543,4

3,171,930 3,647,720 4,013,285 4,414,613 4,856,075 5,341,682 5,875,850 6,463,4

339,488 349,673 360,163 370,968 382,097 393,560 405,366 417,5
237,642 244,771 252,114 259,677 267,468 275,492 283,756 292,2
101,846 104,902 108,049 111,290 114,629 118,068 121,610 125,2
67,898 69,935 72,033 74,194 76,419 78,712 81,073 83,5
- - - - - - - -
3,918,804 4,416,999 4,805,643 5,230,742 5,696,688 6,207,513 6,767,657 7,381,9

257,996 386,321 499,169 604,551 722,135 853,191 999,119 1,161,4

(900,000) - (1,000,000) - - (2,500,000) - -

- - - - - - - -
(900,000) - (1,000,000) - - (2,500,000) - -

62,400 64,896 67,492 70,192 72,999 75,919 78,956 82,1

- - - - - - - -
62,400 64,896 67,492 70,192 72,999 75,919 78,956 82,1

(579,604) 451,217 (433,339) 674,742 795,134 (1,570,890) 1,078,075 1,243,5

567,680 (11,924) 439,293 5,954 680,696 1,475,830 (95,059) 983,0
(11,924) 439,293 5,954 680,696 1,475,830 (95,059) 983,015 2,226,5

3,182,280 3,659,622 4,022,410 4,424,651 4,867,116 5,353,828 5,889,211 6,478,1

3,174,000 3,650,100 4,015,110 4,416,621 4,858,283 5,344,111 5,878,523 6,466,3
(55,200) (63,480) (73,002) (80,302) (88,332) (97,166) (106,882) (117,5
63,480 73,002 80,302 88,332 97,166 106,882 117,570 129,3

3,171,930 3,647,720 4,013,285 4,414,613 4,856,075 5,341,682 5,875,850 6,463,4

3,182,280 3,659,622 4,022,410 4,424,651 4,867,116 5,353,828 5,889,211 6,478,1
3,174,000 3,650,100 4,015,110 4,416,621 4,858,283 5,344,111 5,878,523 6,466,3
(55,200) (63,480) (73,002) (80,302) (88,332) (97,166) (106,882) (117,5
63,480 73,002 80,302 88,332 97,166 106,882 117,570 129,3

3,171,930 3,647,720 4,013,285 4,414,613 4,856,075 5,341,682 5,875,850 6,463,4

3,182,280 3,659,622 4,022,410 4,424,651 4,867,116 5,353,828 5,889,211 6,478,1
69,000 79,350 91,253 100,378 110,416 121,457 133,603 146,9
(79,350) (91,253) (100,378) (110,416) (121,457) (133,603) (146,963) (161,6

900,000 - 1,000,000 - - 2,500,000 - -

 8 9 10

712,548 783,803 862,183

7,054,227 7,759,650 8,535,615
7,766,775 8,543,453 9,397,798

5,875,850 6,463,436 7,109,779

405,366 417,527 430,053
283,756 292,269 301,037
121,610 125,258 129,016
81,073 83,505 86,011
- - -
6,767,657 7,381,996 8,055,896

999,119 1,161,457 1,341,902

- - -
- - -
- - -

78,956 82,114 85,399

- - -
78,956 82,114 85,399

1,078,075 1,243,571 1,427,301

(95,059) 983,015 2,226,586
983,015 2,226,586 3,653,887

5,889,211 6,478,132 7,125,945

5,878,523 6,466,375 7,113,012
(106,882) (117,570) (129,327)
117,570 129,327 142,260

5,875,850 6,463,436 7,109,779

5,889,211 6,478,132 7,125,945
5,878,523 6,466,375 7,113,012
(106,882) (117,570) (129,327)
117,570 129,327 142,260

5,875,850 6,463,436 7,109,779

5,889,211 6,478,132 7,125,945
133,603 146,963 161,659
(146,963) (161,659) (177,825)

- - -
CHART
GRAPHS 2 3 4
Years - 1 2
UTILITIES 96,000.00 98,880.00 101,846.40 104,90
LONG TERM LOANS 450,000.00 450,000.00 450,000.00 450,00

Chart Title
500,000.00

450,000.00

400,000.00

350,000.00

300,000.00
Axis Title

250,000.00

200,000.00

150,000.00

100,000.00

50,000.00

-
1 2 3 4
LONG TERM LOANS 450,000.00 450,000.00 450,000.00 450,000.00
UTILITIES 98,880.00 101,846.40 104,901.79 108,048.85
 4 5 6 7 8 9
2 3 4 5 6 7
101,846.40 104,901.79 108,048.85 111,290.31 114,629.02 118,067.89
450,000.00 450,000.00 450,000.00 450,000.00 450,000.00 450,000.00

Chart Title
120,000.00

115,000.00

110,000.00

105,000.00

100,000.00

95,000.00

90,000.00

85,000.00
4 5 6 7
450,000.00 450,000.00 450,000.00 450,000.00
108,048.85 111,290.31 114,629.02 118,067.89