EALA INC.
SALES FORECAST (YEAR YEAR Production Volume Estimated Percentage of items sold (at regular price) Sold units (at regular price) Average Selling Price Revenue From regular Sales Unsold Items from Previous year Units Available for Discount Sale (50% discount) Percentage sold (at discount price) Sold units (at discount price) Selling Price (at discount) Revenue From Discounted Sales Total Sales (in units) Total Sales (in peso)
Year 1 Year 2 Year 3 5,749 5,857 5,966 95% 95% 95% 5,462 5,564 5,668 800 816 832 4,369,316.00 4,539,976.69 4,717,303.21 0 0 0 287 293 298 100% 100% 100% 287 293 298 400 408 416 114,982 119,473 124,140 5,749 5,857 5,966 4,484,298.00 4,659,449.77 4,841,442.77
EALA INC.
S FORECAST (YEAR 1-10) Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 6,077 6,191 6,307 6,425 6,545 6,667 95% 95% 95% 95% 95% 95% 5,774 5,881 5,991 6,103 6,217 6,333 849 866 883 901 919 937 4,901,555.90 5,093,005.30 5,291,932.51 5,498,629.59 5,713,400.04 5,936,559.18 0 0 0 0 0 0 304 310 315 321 327 333 100% 100% 100% 100% 100% 100% 304 310 315 321 327 333 424 433 442 450 459 469 128,988 134,026 139,261 144,701 150,353 156,225 6,077 6,191 6,307 6,425 6,545 6,667 5,030,544.21 5,227,031.76 5,431,193.89 5,643,330.37 5,863,752.67 6,092,784.42
Year 10 6,791 95% 6,452 956 6,168,434.68 0 340 100% 340 478 162,327 6,791 6,330,761.90
EALA INC Pro-forma Income Statement For the period from Year 1 to Year 10 Year 1
Year 2
Year 3
4,484,298.00 538,115.76
4,659,449.77 21,018.21 559,133.97
4,841,442.77 21,839.16 580,973.13
4,484,298.00
4,659,449.77
4,841,442.77
35,841.92
37,241.87
4,449,803.40
4,623,607.84
4,804,200.90
110,500.00 180,000.00 102,293.90 150,000.00
30,000.00 180,000.00 102,293.90 35,000.00 161,250.00
30,000.00 180,000.00 102,293.90 35,000.00 173,343.75
2,760,000.00 90,985.20 19,950.00 230,000.00 187,080.00
2,760,000.00 90,985.20 19,950.00 140,000.00 190,821.60
2,842,800.00 91,348.80 19,950.00 236,900.00 194,638.03
16,911.90
14,546.90
14,546.90
7,472.00 22,500.00 3,877,693.00
7,472.00 22,500.00 3,754,819.60
7,472.00 22,500.00 3,950,793.38
Operating Income Less: Interest Expense (16%)
572,110.40 27,855.10
868,788.24 27,855.10
853,407.52
Earnings before Tax Less: Income Tax (32%)
544,255.30 174,161.70
Net Income
370,093.60
840,933.14 269,098.61 94,936.91 571,834.54
853,407.52 273,090.41 3,991.80 580,317.11
Gross Sales Revenue VAT Output Tax (12%) Net Sales Revenue Cost of Sales Gross Income Less: Operating Expenses Advertising Expense Washing Expenses Depreciation Expense Repairs & Maintainance Rent Expense Salaries and Wages SSS Contribution Phil Health/Medicare Employee Benefits ( 13th Month Pay) Utilities Expense (electricity, water, gasoline, telephone) Supplies Expense Miscellaneous Expense ( Business Permit,etc) Insurance Expense Total Operating Expenses
34,494.60
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
5,030,544.21 22,692.17 603,665.31
5,227,031.76 23,578.51 627,243.81
5,431,193.89 24,499.46 651,743.27
5,643,330.37 25,456.38 677,199.64
5,863,752.67 26,450.68 703,650.32
6,092,784.42 27,483.81 731,134.13
6,330,761.90 28,557.30 759,691.43
5,030,544.21
5,227,031.76
5,431,193.89
5,643,330.37
5,863,752.67
6,092,784.42
6,330,761.90
38,696.49
40,207.94
81,084.05
82,581.28
84,141.99
85,696.71
87,315.28
4,991,847.72
5,186,823.82
5,350,109.84
5,560,749.09
5,779,610.68
6,007,087.71
6,243,446.62
110,500.00 180,000.00 102,293.90 35,000.00 186,344.53
30,000.00 180,000.00 102,293.90 35,000.00 200,320.37
100,500.00 180,000.00 102,993.90 35,000.00 215,344.40
30,000.00 180,000.00 102,993.90 35,000.00 231,495.23
30,000.00 180,000.00 102,993.90 35,000.00 248,857.37
30,000.00 180,000.00 102,993.90 35,000.00 267,521.67
30,000.00 180,000.00 102,993.90 35,000.00 287,585.80
2,842,800.00 91,348.80 19,950.00 144,200.00 198,530.79
2,928,084.00 93,530.40 19,950.00 244,007.00 202,501.41
2,928,084.00 93,630.40 19,950.00 244,007.00 206,551.44
3,015,926.52 93,895.20 20,550.00 251,327.21 210,682.47
3,015,926.52 99,475.20 20,550.00 251,327.21 214,896.11
3,106,404.32 95,080.40 20,700.00 258,867.03 219,194.04
3,106,404.32 102,024.00 20,700.00 258,867.03 223,577.92
14,546.90
14,546.90
14,546.90
14,546.90
14,546.90
14,546.90
14,546.90
7,472.00 22,500.00 3,955,486.92
7,472.00 22,500.00 4,080,205.98
7,472.00 22,500.00 4,170,580.04
7,472.00 22,500.00 4,216,389.42
7,472.00 22,500.00 4,243,545.22
7,472.00 22,500.00 4,360,280.26
7,472.00 22,500.00 4,391,671.86
1,036,360.80
1,106,617.84
1,179,529.81
1,344,359.67 -
1,536,065.47 -
1,646,807.46 -
1,851,774.76 -
1,036,360.80 331,635.45 58,545.05 704,725.34
1,106,617.84 354,117.71 22,482.25 752,500.13
1,179,529.81 377,449.54 23,331.83 802,080.27
1,344,359.67 430,195.09 52,745.56 914,164.58
1,536,065.47 491,540.95 61,345.85 1,044,524.52
1,646,807.46 526,978.39 35,437.44 1,119,829.07
1,851,774.76 592,567.92 65,589.54 1,259,206.83
EALA INC.
Pro-forma Statement of Retained Earnin For the period from Year 1 to Year 10 Year 1
Retained Earnings - Beginning
Year 2
-
Year 3
Year 4
370,093.60
941,928.14
1,522,245.25
Less: Net Income for the Year Dividends Declared During the Year
370,093.60 -
571,834.54 -
580,317.11 -
704,725.34 -
Retained Earnings - Ending
370,093.60
941,928.14
1,522,245.25
2,226,970.59
EALA INC.
tement of Retained Earnings iod from Year 1 to Year 10 Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
2,226,970.59
2,979,470.73
3,281,551.00
3,695,715.57
4,240,240.09
4,860,069.16
752,500.13 -
802,080.27 500,000.00
914,164.58 500,000.00
1,044,524.52 500,000.00
1,119,829.07 500,000.00
1,259,206.83 500,000.00
2,979,470.73
3,281,551.00
3,695,715.57
4,240,240.09
4,860,069.16
5,619,275.99
EALA INC. Pro-forma Statement of Cash Flows For the period from Year 1 to Year 5 Year 1 Cash Flows from Operating Activities Net Income Increase (Decrease) in Depreciation - Fixed Assets Increase (Decrease) in Depreciation - Leasehold Improvements Increase (Decrease) in Supplies On Hand Increase (Decrease) in Prepaid Expense Increase (Decrease) in Interest Payable Increase (Decrease) in Insurance Payable Increase (Decrease) in VAT Output Tax Payable Increase (Decrease) in Income Tax Payable Net Cash Provided by Operating Activities Cash Flows from Investing and Financing Activities Acquisition of Office Assets Acquisition of Store Assets Increase (Decrease) in Long-term Loan Dividends Paid Net Cash Provided by Investing and Financing Activities
389,640.54 (72,131.00) (30,862.90) (12,382.70) (75,000.00) 27,855.10 22,500.00 538,115.76 174,161.70 1,136,661.90
(109,200.00) (464,610.00) 198,465.00 (375,345.00)
Year 2
529,620.72 (72,131.00) (30,862.90) (423.54) 21,018.21 94,936.91 543,005.48
-
Increase (Decrease) in Cash
761,316.90
543,005.48
Add: Cash - Beginning
100,000.00
861,316.90
Cash Balance - End
861,316.90
1,404,322.39
Flows Year 5 Year 3
472,761.95 (57,131.00) (30,862.90) 21,839.16 3,991.80 410,599.01
(15,000.00) (198,965.00) (213,965.00)
Year 4
Year 5
528,086.57 (72,131.00) (30,862.90) 22,692.17 58,545.05 506,329.89
-
Year 6
502,867.07 1,311,630.78 (57,131.00) 15,369.00 (30,862.90) (30,862.90) 23,578.51 24,499.46 22,482.25 23,331.83 460,933.93 1,343,968.17
(15,000.00) (15,000.00)
(72,000.00) (15,500.00)
Year 7
1,357,991.74 (57,131.00) (30,862.90) 25,456.38 52,745.56 1,348,199.77
Year 8
1,418,461.31 (72,131.00) (30,862.90) 26,450.68 61,345.85 1,403,263.94
(500,000.00) (587,500.00)
(15,000.00) (500,000.00) (515,000.00)
(500,000.00) (500,000.00)
196,634.01
506,329.89
445,933.93
756,468.17
833,199.77
903,263.94
1,404,322.39
1,600,956.40
2,107,286.29
2,553,220.22
3,309,688.38
4,142,888.15
1,600,956.40
2,107,286.29
2,553,220.22
3,309,688.38
4,142,888.15
5,046,152.09
Year 9
1,419,515.82 (57,131.00) (30,862.90) 27,483.81 35,437.44 1,394,443.17
(15,000.00)
Year 10
1,480,083.13 (72,131.00) (30,862.90) 28,557.30 65,589.54 1,471,236.07
-
-
(500,000.00) (515,000.00)
(500,000.00) (500,000.00)
879,443.17
971,236.07
5,046,152.09
5,925,595.26
5,925,595.26
6,896,831.33
33,848,257.41
EALA INC. Pro-forma Balance Sheet As of December 31, Year 0 to Year 10 Y E A 0
1
2
ASSETS Currents Assets Cash Inventory ( Raw Materials) Supplies on Hand Prepaid Rent Total Current Assets
100,000.00 39,885.00 16,911.90 75,000.00 231,796.90
861,316.90 40,682.70 4,529.20 906,528.80
1,404,322.39 40,682.70 4,105.66 1,449,110.75
Fixed Assets Office Assets Store Assets Total Fixed Assets Less: Accumulated Depreciation Total Fixed Assets
109,200.00 464,610.00 573,810.00 573,810.00
109,200.00 464,610.00 573,810.00 72,131.00 501,679.00
109,200.00 464,610.00 573,810.00 144,262.00 429,548.00
Intangibles Leasehold Improvement Less: Accumulated Depreciation (10%) Total Intangibles
308,629.00 308,629.00
(30,862.90) 308,629.00 30,862.90 277,766.10
(30,862.90) 308,629.00 61,725.80 246,903.20
1,114,235.90
1,685,973.90
2,125,561.95
-
27,855.10 22,500.00 538,115.76 174,161.70
27,855.10 22,500.00 559,133.97 94,936.91
-
762,632.56
704,425.98
TOTAL ASSETS
LIABILITIES AND STOCKHOLDER'S EQUITY Current Liabilities Interest Payable Insurance Payable VAT Output Tax Payable Income Tax Payable Dividends Payable Total Current Liabilities Long-term Liabilities Long-term loan
198,965.00
198,965.00
198,965.00
TOTAL LIABILITIES
198,965.00
961,597.56
903,390.98
Stockholder's Equity Capital Stock (P10 par value) Retained Earnings
700,000.00 -
700,000.00 389,640.54
700,000.00 919,261.26
TOTAL STOCKHOLDER'S EQUITY
700,000.00
1,089,640.54
1,619,261.26
TOTAL LIABILITIES AND STOCKHOLDERS EQUITY
898,965.00
2,051,238.10
2,522,652.25
(215,270.90) (215,270.90)
365,264.20 365,264.20
397,090.30 397,090.30
ar 10 Y E A R 3
4
5
6
1,600,956.40 40,682.70 4,105.66 1,645,744.75
2,107,286.29 40,682.70 4,105.66 2,152,074.64
2,553,220.22 40,682.70 4,105.66 2,598,008.57
3,309,688.38 40,682.70 4,105.66
4,142,888.15 40,682.70 4,105.66
5,046,152.09 40,682.70 4,105.66
3,354,476.74
4,187,676.51
5,090,940.45
109,200.00 464,610.00 573,810.00 201,393.00 372,417.00
109,200.00 464,610.00 573,810.00 273,524.00 300,286.00
109,200.00 464,610.00 573,810.00 330,655.00 243,155.00
109,200.00 464,610.00 573,810.00 315,286.00 258,524.00
109,200.00 464,610.00 573,810.00 372,417.00 201,393.00
109,200.00 464,610.00 573,810.00 444,548.00 129,262.00
(30,862.90) 308,629.00 92,588.70 216,040.30
(30,862.90) 308,629.00 123,451.60 185,177.40
(30,862.90) 308,629.00 154,314.50 154,314.50
(30,862.90) 308,629.00 185,177.40 123,451.60
(30,862.90) 308,629.00 216,040.30 92,588.70
(30,862.90) 308,629.00 246,903.20 61,725.80
2,234,202.05
2,637,538.04
2,995,478.07
3,736,452.34
4,481,658.21
5,281,928.25
22,500.00 580,973.13 3,991.80
22,500.00 603,665.31 58,545.05
22,500.00 627,243.81 22,482.25
607,464.93
684,710.36
672,226.07
22,500.00 651,743.27 23,331.83 500,000.00 1,197,575.10
22,500.00 677,199.64 52,745.56 500,000.00 1,252,445.20
22,500.00 703,650.32 61,345.85 500,000.00 1,287,496.17
-
-
-
7
-
8
-
-
607,464.93
684,710.36
672,226.07
1,197,575.10
1,252,445.20
1,287,496.17
700,000.00 1,392,023.21
700,000.00 1,920,109.78
700,000.00 2,422,976.85
700,000.00 3,234,607.63
700,000.00 4,092,599.37
700,000.00 5,011,060.68
2,092,023.21
2,620,109.78
3,122,976.85
3,934,607.63
4,792,599.37
5,711,060.68
2,699,488.14
3,304,820.13
3,795,202.91
5,132,182.73
6,045,044.57
6,998,556.85
465,286.09 465,286.09
667,282.09 667,282.09
799,724.84 799,724.84
1,395,730.39 1,395,730.39
1,563,386.36 1,563,386.36
1,716,628.60 1,716,628.60
9
10
5,925,595.26 40,682.70 4,105.66
6,896,831.33 40,682.70 4,105.66
5,970,383.62
6,941,619.69
109,200.00 464,610.00 573,810.00 501,679.00 72,131.00
109,200.00 464,610.00 573,810.00 573,810.00 -
(30,862.90) 308,629.00 277,766.10 30,862.90
(30,862.90) 308,629.00 308,629.00 -
6,073,377.52
6,941,619.69
22,500.00 731,134.13 35,437.44 500,000.00 1,289,071.57
22,500.00 759,691.43 65,589.54 500,000.00 1,347,780.96
-
-
1,289,071.57
1,347,780.96
700,000.00 5,930,576.50
700,000.00 6,910,659.63
6,630,576.50
7,610,659.63
7,919,648.07
8,958,440.60
1,846,270.55 1,846,270.55
2,016,820.91 2,016,820.91