Feasib Scratch Muna Laine(2)
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Feasib Scratch Muna Laine(2) as PDF for free.
More details
- Words: 1,984
- Pages: 20
EALA INC Pro-forma Income Statement For the period from Year 1 to Year 10 Year 1 Gross Sales Revenue
5,471,213.15
VAT Output Tax (12%)
Year 2
Year 3
656,545.58
5,741,857.39 32,477.31 689,022.89
5,966,128.05 26,912.48 715,935.37
Net Sales Revenue
6,079,125.72
6,379,841.54
6,629,031.16
Cost of Sales
1,949,218.67
2,047,692.37
2,127,672.99
Gross Income
4,129,907.05
4,332,149.17
4,501,358.17
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,419,064.80 90,985.20 19,950.00 230,000.00 187,080.00
2,509,064.80 90,985.20 19,950.00 140,000.00 190,821.60
2,494,601.20 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,536,757.80
7,472.00 22,500.00 3,503,884.40
7,472.00 22,500.00 3,602,594.58
Operating Income Less: Interest Expense (15%)
593,149.25 116,662.61
828,264.77 116,662.61
898,763.59
Earnings before Tax Less: Income Tax (32%)
476,486.64 152,475.72
Net Income
324,010.91
711,602.16 227,712.69 75,236.97 483,889.47
898,763.59 287,604.35 59,891.66 611,159.24
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
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
6,199,158.47 27,963.65 743,899.02
6,441,290.81 29,055.88 772,954.90
6,692,880.56 30,190.77 803,145.67
6,954,297.14 31,369.99 834,515.66
7,225,924.37 32,595.27 867,110.92
7,508,161.05 33,868.40 900,979.33
7,801,421.60 35,191.27 936,170.59
6,887,953.86
7,156,989.78
7,436,533.96
7,726,996.83
8,028,804.85
8,342,401.17
8,668,246.22
2,210,777.57
2,297,128.12
2,386,851.42
2,480,079.22
2,576,948.40
2,677,601.18
2,782,185.35
4,677,176.29
4,859,861.67
5,049,682.54
5,246,917.60
5,451,856.46
5,664,799.99
5,886,060.87
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,587,301.20 91,348.80 19,950.00 144,200.00 198,530.79
2,570,596.60 93,530.40 19,950.00 244,007.00 202,501.41
2,570,496.60 93,630.40 19,950.00 244,007.00 206,551.44
2,650,154.11 93,895.20 20,550.00 251,327.21 210,682.47
2,644,574.11 99,475.20 20,550.00 251,327.21 214,896.11
2,731,756.89 95,080.40 20,700.00 258,867.03 219,194.04
2,724,813.29 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,699,988.12
7,472.00 22,500.00 3,722,718.58
7,472.00 22,500.00 3,812,992.64
7,472.00 22,500.00 3,850,617.01
7,472.00 22,500.00 3,872,192.81
7,472.00 22,500.00 3,985,632.83
7,472.00 22,500.00 4,010,080.84
977,188.16
1,137,143.09
1,236,689.90
1,396,300.59 -
1,579,663.65 -
1,679,167.16 -
1,875,980.04 -
977,188.16 312,700.21 25,095.86 664,487.95
1,137,143.09 363,885.79 51,185.58 773,257.30
1,236,689.90 395,740.77 31,854.98 840,949.13
1,396,300.59 446,816.19 51,075.42 949,484.40
1,579,663.65 505,492.37 58,676.18 1,074,171.28
1,679,167.16 537,333.49 31,841.12 1,141,833.67
1,875,980.04 600,313.61 62,980.12 1,275,666.42
EALA
Pro-forma Bal As of December 31,
Y E A 0 ASSETS Currents Assets Cash Accounts Receivable Inventory Supplies on Hand Prepaid Advertising Prepaid Rent Total Current Assets
1
2
786,641.00 36,885.00 52,911.90 110,500.00 75,000.00 1,061,937.90
2,283,457.02 14,000.00 24,640.41 4,529.20 110,500.00 2,437,126.63
2,917,591.96 156,446.93 25,414.96 4,105.66 30,000.00 3,133,559.51
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 Improvements Less: Accumulated Depreciation 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,944,376.90
3,216,571.73
3,810,010.71
-
116,662.61 22,500.00 656,545.58 152,475.72
116,662.61 22,500.00 689,022.89 227,712.69
-
948,183.91
1,055,898.19
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
777,750.76
777,750.76
779,586.00
TOTAL LIABILITIES
777,750.76
1,725,934.67
1,835,484.19
1,166,626.14 -
1,166,626.14 324,010.91
1,166,626.14 807,900.38
Stockholder's Equity Capital Stock (P10 par value) Retained Earnings
TOTAL STOCKHOLDER'S EQUITY
1,166,626.14
1,490,637.05
1,974,526.52
TOTAL LIABILITIES AND STOCKHOLDERS EQUITY
1,944,376.90
3,216,571.73
3,810,010.71
-
0.00 0.00
5460.4 9,828.61
-
EALA INC. Pro-forma Balance Sheet As of December 31, Year 0 to Year 10 Y E A R 3
4
5
6
7
8
2,908,963.24 53,983.02 26,216.26 4,105.66 30,000.00 3,023,268.17
3,688,158.60 14,000.00 27,045.28 4,105.66 110,500.00 3,843,809.54
4,655,997.26 67,296.24 27,903.04 4,105.66 30,000.00 4,785,302.20
5,088,224.04 582,670.69 28,790.59 4,105.66 100,500.00
5,622,647.76 667,252.25 29,709.03 4,105.66 30,000.00
6,391,084.38 666,301.79 30,659.49 4,105.66 30,000.00
5,703,790.99
6,323,714.70
7,092,151.32
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
3,611,725.47
4,329,272.94
5,182,771.70
6,085,766.59
6,617,696.40
7,283,139.12
22,500.00 715,935.37 287,604.35
22,500.00 743,899.02 312,700.21
22,500.00 772,954.90 363,885.79
1,026,039.71
1,079,099.23
1,159,340.69
22,500.00 803,145.67 395,740.77 500,000.00 1,721,386.44
22,500.00 834,515.66 446,816.19 500,000.00 1,803,831.85
22,500.00 867,110.92 505,492.37 500,000.00 1,895,103.29
-
-
-
-
-
-
1,026,039.71
1,079,099.23
1,159,340.69
1,721,386.44
1,803,831.85
1,895,103.29
1,166,626.14 1,419,059.62
1,166,626.14 2,083,547.57
1,166,626.14 2,856,804.87
1,166,626.14 3,197,754.01
1,166,626.14 3,647,238.41
1,166,626.14 4,221,409.69
2,585,685.76
3,250,173.71
4,023,431.01
4,364,380.15
4,813,864.55
5,388,035.83
3,611,725.47
4,329,272.94
5,182,771.70
6,085,766.59
6,617,696.40
7,283,139.12
-
(0.00) (0.00)
-
-
-
-
9
10
7,171,621.48 680,318.13 31,643.15 4,105.66 30,000.00
8,148,453.19 679,300.04 32,661.24 4,105.66 30,000.00
7,887,688.42
8,864,520.13
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 -
7,990,682.32
8,864,520.13
22,500.00 900,979.33 537,333.49 500,000.00 1,960,812.82
22,500.00 936,170.59 600,313.61 500,000.00 2,058,984.20
-
-
1,960,812.82
2,058,984.20
1,166,626.14 4,863,243.36
1,166,626.14 5,638,909.79
6,029,869.50
6,805,535.93
7,990,682.32
8,864,520.13
-
-
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
324,010.91
807,900.38
1,419,059.62
Less: Net Income for the Year Dividends Declared During the Year
324,010.91 -
483,889.47 -
611,159.24 -
664,487.95 -
Retained Earnings - Ending
324,010.91
807,900.38
1,419,059.62
2,083,547.57
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,083,547.57
2,856,804.87
3,197,754.01
3,647,238.41
4,221,409.69
4,863,243.36
773,257.30 -
840,949.13 500,000.00
949,484.40 500,000.00
1,074,171.28 500,000.00
1,141,833.67 500,000.00
1,275,666.42 500,000.00
2,856,804.87
3,197,754.01
3,647,238.41
4,221,409.69
4,863,243.36
5,638,909.79
Total orders paid/ Total Sales in Units Cost of fnished goods per unit Total COGS
4,873 5,019 5,113 5,208 400 408 416 424 1,949,218.67 2,047,692.37 2,127,672.99 2,210,777.57
5,305 5,405 5,506 5,608 5,713 5,820 433 442 450 459 469 478 2,297,128.12 2,386,851.42 2,480,079.22 2,576,948.40 2,677,601.18 2,782,185.35
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 Accounts Receivable Increase (Decrease) in Inventory Increase (Decrease) in Supplies On Hand Increase (Decrease) in Prepaid Advertising Increase (Decrease) in Prepaid Rent 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 Increase (Decrease) in Cash Add: Cash - Beginning Cash Balance - End
Year 2
324,010.91 72,131.00 30,862.90 14,000.00 12,244.59 48,382.70 -
483,889.47 72,131.00 30,862.90 156,446.93 774.56 (423.54) 80,500.00
116,662.61 22,500.00 538,115.76 145,743.29 1,324,653.77
32,477.31 75,236.97 614,521.19
(109,200.00) (464,610.00) 779,586.00 205,776.00 1,530,429.77
614,521.19
786,641.00 2,283,457.02 2,283,457.02
2,917,591.96
Flows Year 5 Year 3
Year 4
Year 5
611,159.24 57,131.00 30,862.90 53,983.02 801.30 -
664,487.95 72,131.00 30,862.90 14,000.00 829.02 (80,500.00)
773,257.30 57,131.00 30,862.90 67,296.24 857.76 80,500.00
840,949.13 15,369.00 30,862.90 582,670.69 887.55 (70,500.00)
949,484.40 57,131.00 30,862.90 667,252.25 918.44 70,500.00
1,074,171.28 72,131.00 30,862.90 666,301.79 950.46 -
26,912.48 59,891.66 785,957.28
27,963.65 25,095.86 901,041.37
29,055.88 51,185.58 860,992.66
30,190.77 31,854.98 1,019,726.79
31,369.99 51,075.42 1,049,423.71
32,595.27 58,676.18 1,268,436.63
(15,000.00) (15,000.00)
(72,000.00) (15,500.00) (500,000.00) (587,500.00)
(15,000.00) (500,000.00) (515,000.00)
(500,000.00) (500,000.00)
901,041.37
845,992.66
432,226.79
534,423.71
768,436.63
2,917,591.96
2,908,963.24
3,688,158.60
4,655,997.26
5,088,224.04
5,622,647.76
2,908,963.24
3,688,158.60
4,655,997.26
5,088,224.04
5,622,647.76
6,391,084.38
(15,000.00) (779,586.00) (794,586.00) (8,628.72)
-
Year 6
Year 7
Year 8
-
Year 9
Year 10
1,141,833.67 57,131.00 30,862.90 680,318.13 983.66 -
1,275,666.42 72,131.00 30,862.90 679,300.04 1,018.09 -
33,868.40 31,841.12 1,295,537.10
35,191.27 62,980.12 1,476,831.71
(15,000.00)
-
-
(500,000.00) (515,000.00)
(500,000.00) (500,000.00)
780,537.10
976,831.71
6,391,084.38
7,171,621.48
7,171,621.48
8,148,453.19
48,876,198.92
EALA INC
SALES FORECAST (Y YEAR Total orders Unpaid orders Finished goods (in units) Work in Process Day 1 at P280 Day 2 at P364 Day 3 at 473.2 Total unpaid orders Total orders paid/ Total Sales in Units Percentage of paid orders sold at regular price Units sold at regular price Average Selling Price Revenue from regular sales Units sold at discount Selling price at discount Revenue from discounted sales Total Revenue Total Raw Materials Inventory Cost of fnished goods per unit Total units in Finished goods Inventory Total finished goods inventory WIP: DAY 1 in units in pesos DAY 2 in units in pesos DAY 3 in units in pesos Total Work in Process inventory Total Inventory
Year 1 6,160
Year 2 6,275
17
17
17 17 17 68 6,091 0.99 6,030 1,000 6,030,395.25 61 800 48,730.47 6,079,125.72
17 17 17 70 6,274 0.99 6,211 1,020 6,335,048.27 63 714 44,793.27 6,379,841.54
9,221.25 400 14 5475
9,393.55 408 14 5689
182 14 2,492 237 14 3,240 308 14 4,211.79 9,943.82 24,640.41
186 14 2,590 241 14 3,366 314 14 4,376.30 10,332.22 25,414.96
EALA INC.
ALES FORECAST (YEAR 1-10) Year 3 6,392
Year 4 6,512
Year 5 6,633
Year 6 6,757
Year 7 6,883
Year 8 7,012
Year 9 7,143
18
18
18
19
19
19
20
18 18 18 71 6,391 0.99 6,327 1,040 6,582,488.32 64 728 46,542.85 6,629,031.16
18 18 18 72 6,510 0.99 6,445 1,061 6,839,593.10 65 743 48,360.76 6,887,953.86
18 18 18 74 6,632 0.99 6,566 1,082 7,106,740.11 66 758 50,249.68 7,156,989.78
19 19 19 75 6,756 0.99 6,688 1,104 7,384,321.59 68 773 52,212.37 7,436,533.96
19 19 19 76 6,882 0.99 6,813 1,126 7,672,745.09 69 788 54,251.73 7,726,996.83
19 19 19 78 7,011 0.99 6,940 1,149 7,972,434.11 70 804 56,370.75 8,028,804.85
20 20 20 79 7,142 0.99 7,070 1,172 8,283,828.65 71 820 58,572.53 8,342,401.17
9,569.07 416 14 5911
9,747.87 424 14 6142
9,930.01 433 15 6382
10,115.56 442 15 6631
10,304.57 450 15 6891
10,497.11 459 16 7160
10,693.25 469 16 7439
189 14 2,691 246 14 3,498 320 14 4,547.24 10,735.78 26,216.26
193 14 2,796 251 14 3,634 327 14 4,724.85 11,155.11 27,045.28
197 15 2,905 256 15 3,776 333 15 4,909.39 11,590.82 27,903.04
201 15 3,018 261 15 3,924 340 15 5,101.15 12,043.54 28,790.59
205 15 3,136 267 15 4,077 347 15 5,300.39 12,513.95 29,709.03
209 16 3,259 272 16 4,236 353 16 5,507.42 13,002.73 30,659.49
213 16 3,386 277 16 4,402 361 16 5,722.54 13,510.60 31,643.15
Year 10 7,277 20 20 20 20 81 7,275 0.99 7,202 1,195 8,607,385.91 73 837 60,860.30 8,668,246.22 10,893.06 478 16 7730 218 16 3,518 283 16 4,574 368 16 5,946.05 14,038.31 32,661.24
0
0
0
0
0
0
0
0
EALA Incorporated
EALA Incorporated
Computation of Payback Period
Computation of Net Present Value
Project Cost Year 1 2 3 4 5 6 7 8 9 10 Payback Period
1,944,376.90 Year- End Cash Flow 2,283,457.02 2,917,591.96 2,908,963.24 3,688,158.60 4,655,997.26 5,088,224.04 5,622,647.76 6,391,084.38 7,171,621.48 8,148,453.19 1 year
EALA's Cost of Capital Total Investment Year
Year-End Cash Flow
1 2 3 4 5 6 7 8 9 10 NPV
2,283,457.02 2,917,591.96 2,908,963.24 3,688,158.60 4,655,997.26 5,088,224.04 5,622,647.76 6,391,084.38 7,171,621.48 8,148,453.19
19.2% 1,944,376.90 PV ($1,915,651.86) ($2,447,644.26) ($2,440,405.40) ($3,094,092.79) ($3,906,037.97) ($4,268,644.33) ($4,716,986.37) ($5,361,647.97) ($6,016,460.97) ($6,835,950.66) ($39,059,145.69)
EALA INC. Financial Ratios 1
2
3
Current Ratio Quick Ratio
2.49 2.47
3.72 3.70
4.95 4.93
Activity Ratios Inventory Turnover Total Asset Turnover
1.54 1.98
1.57 1.05
1.60 0.80
0.37
0.27
0.19
99.12% 47.00% 31.39%
99.12% 49.00% 33.22%
99.12% 47.00% 32.30%
7.38% 8.68%
1.46% 4.37%
7.24% 23.20%
Liquidity Ratios
Debt Ratios Debt Ratio Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Assets Return on Equity
EALA Incorporated Computation of Internal Rate of Return Year 0 1 2 3 4 5 6 7 8 9 10 IRR
Year-End Cash Flow (1,944,376.90) 2,283,457.02 2,917,591.96 2,908,963.24 3,688,158.60 4,655,997.26 5,088,224.04 5,622,647.76 6,391,084.38 7,171,621.48 8,148,453.19 136%
EALA INC.
Financial Ratios Years 4
5
6
7
8
9
10
6.16 6.14
7.40 7.38
6.54 6.53
7.63 7.62
8.69 8.68
9.79 9.78
10.80 10.79
1.63 0.65
1.66 0.54
2.03 0.53
2.07 0.44
2.11 0.39
2.15 0.34
2.19 0.31
0.16
0.13
0.15
0.13
0.11
0.10
0.09
99.12% 48.00% 32.90%
99.12% 48.00% 32.41%
99.12% 56.00% 38.15%
99.12% 56.00% 38.35%
99.12% 57.00% 38.70%
99.12% 56.00% 38.41%
99.12% 57.00% 38.73%
10.05% 29.71%
23.81% 41.96%
25.83% 44.18%
23.05% 36.46%
23.77% 37.94%
18.81% 27.31%
19.66% 28.34%
5,471,213.15
VAT Output Tax (12%)
Year 2
Year 3
656,545.58
5,741,857.39 32,477.31 689,022.89
5,966,128.05 26,912.48 715,935.37
Net Sales Revenue
6,079,125.72
6,379,841.54
6,629,031.16
Cost of Sales
1,949,218.67
2,047,692.37
2,127,672.99
Gross Income
4,129,907.05
4,332,149.17
4,501,358.17
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,419,064.80 90,985.20 19,950.00 230,000.00 187,080.00
2,509,064.80 90,985.20 19,950.00 140,000.00 190,821.60
2,494,601.20 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,536,757.80
7,472.00 22,500.00 3,503,884.40
7,472.00 22,500.00 3,602,594.58
Operating Income Less: Interest Expense (15%)
593,149.25 116,662.61
828,264.77 116,662.61
898,763.59
Earnings before Tax Less: Income Tax (32%)
476,486.64 152,475.72
Net Income
324,010.91
711,602.16 227,712.69 75,236.97 483,889.47
898,763.59 287,604.35 59,891.66 611,159.24
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
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
Year 10
6,199,158.47 27,963.65 743,899.02
6,441,290.81 29,055.88 772,954.90
6,692,880.56 30,190.77 803,145.67
6,954,297.14 31,369.99 834,515.66
7,225,924.37 32,595.27 867,110.92
7,508,161.05 33,868.40 900,979.33
7,801,421.60 35,191.27 936,170.59
6,887,953.86
7,156,989.78
7,436,533.96
7,726,996.83
8,028,804.85
8,342,401.17
8,668,246.22
2,210,777.57
2,297,128.12
2,386,851.42
2,480,079.22
2,576,948.40
2,677,601.18
2,782,185.35
4,677,176.29
4,859,861.67
5,049,682.54
5,246,917.60
5,451,856.46
5,664,799.99
5,886,060.87
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,587,301.20 91,348.80 19,950.00 144,200.00 198,530.79
2,570,596.60 93,530.40 19,950.00 244,007.00 202,501.41
2,570,496.60 93,630.40 19,950.00 244,007.00 206,551.44
2,650,154.11 93,895.20 20,550.00 251,327.21 210,682.47
2,644,574.11 99,475.20 20,550.00 251,327.21 214,896.11
2,731,756.89 95,080.40 20,700.00 258,867.03 219,194.04
2,724,813.29 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,699,988.12
7,472.00 22,500.00 3,722,718.58
7,472.00 22,500.00 3,812,992.64
7,472.00 22,500.00 3,850,617.01
7,472.00 22,500.00 3,872,192.81
7,472.00 22,500.00 3,985,632.83
7,472.00 22,500.00 4,010,080.84
977,188.16
1,137,143.09
1,236,689.90
1,396,300.59 -
1,579,663.65 -
1,679,167.16 -
1,875,980.04 -
977,188.16 312,700.21 25,095.86 664,487.95
1,137,143.09 363,885.79 51,185.58 773,257.30
1,236,689.90 395,740.77 31,854.98 840,949.13
1,396,300.59 446,816.19 51,075.42 949,484.40
1,579,663.65 505,492.37 58,676.18 1,074,171.28
1,679,167.16 537,333.49 31,841.12 1,141,833.67
1,875,980.04 600,313.61 62,980.12 1,275,666.42
EALA
Pro-forma Bal As of December 31,
Y E A 0 ASSETS Currents Assets Cash Accounts Receivable Inventory Supplies on Hand Prepaid Advertising Prepaid Rent Total Current Assets
1
2
786,641.00 36,885.00 52,911.90 110,500.00 75,000.00 1,061,937.90
2,283,457.02 14,000.00 24,640.41 4,529.20 110,500.00 2,437,126.63
2,917,591.96 156,446.93 25,414.96 4,105.66 30,000.00 3,133,559.51
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 Improvements Less: Accumulated Depreciation 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,944,376.90
3,216,571.73
3,810,010.71
-
116,662.61 22,500.00 656,545.58 152,475.72
116,662.61 22,500.00 689,022.89 227,712.69
-
948,183.91
1,055,898.19
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
777,750.76
777,750.76
779,586.00
TOTAL LIABILITIES
777,750.76
1,725,934.67
1,835,484.19
1,166,626.14 -
1,166,626.14 324,010.91
1,166,626.14 807,900.38
Stockholder's Equity Capital Stock (P10 par value) Retained Earnings
TOTAL STOCKHOLDER'S EQUITY
1,166,626.14
1,490,637.05
1,974,526.52
TOTAL LIABILITIES AND STOCKHOLDERS EQUITY
1,944,376.90
3,216,571.73
3,810,010.71
-
0.00 0.00
5460.4 9,828.61
-
EALA INC. Pro-forma Balance Sheet As of December 31, Year 0 to Year 10 Y E A R 3
4
5
6
7
8
2,908,963.24 53,983.02 26,216.26 4,105.66 30,000.00 3,023,268.17
3,688,158.60 14,000.00 27,045.28 4,105.66 110,500.00 3,843,809.54
4,655,997.26 67,296.24 27,903.04 4,105.66 30,000.00 4,785,302.20
5,088,224.04 582,670.69 28,790.59 4,105.66 100,500.00
5,622,647.76 667,252.25 29,709.03 4,105.66 30,000.00
6,391,084.38 666,301.79 30,659.49 4,105.66 30,000.00
5,703,790.99
6,323,714.70
7,092,151.32
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
3,611,725.47
4,329,272.94
5,182,771.70
6,085,766.59
6,617,696.40
7,283,139.12
22,500.00 715,935.37 287,604.35
22,500.00 743,899.02 312,700.21
22,500.00 772,954.90 363,885.79
1,026,039.71
1,079,099.23
1,159,340.69
22,500.00 803,145.67 395,740.77 500,000.00 1,721,386.44
22,500.00 834,515.66 446,816.19 500,000.00 1,803,831.85
22,500.00 867,110.92 505,492.37 500,000.00 1,895,103.29
-
-
-
-
-
-
1,026,039.71
1,079,099.23
1,159,340.69
1,721,386.44
1,803,831.85
1,895,103.29
1,166,626.14 1,419,059.62
1,166,626.14 2,083,547.57
1,166,626.14 2,856,804.87
1,166,626.14 3,197,754.01
1,166,626.14 3,647,238.41
1,166,626.14 4,221,409.69
2,585,685.76
3,250,173.71
4,023,431.01
4,364,380.15
4,813,864.55
5,388,035.83
3,611,725.47
4,329,272.94
5,182,771.70
6,085,766.59
6,617,696.40
7,283,139.12
-
(0.00) (0.00)
-
-
-
-
9
10
7,171,621.48 680,318.13 31,643.15 4,105.66 30,000.00
8,148,453.19 679,300.04 32,661.24 4,105.66 30,000.00
7,887,688.42
8,864,520.13
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 -
7,990,682.32
8,864,520.13
22,500.00 900,979.33 537,333.49 500,000.00 1,960,812.82
22,500.00 936,170.59 600,313.61 500,000.00 2,058,984.20
-
-
1,960,812.82
2,058,984.20
1,166,626.14 4,863,243.36
1,166,626.14 5,638,909.79
6,029,869.50
6,805,535.93
7,990,682.32
8,864,520.13
-
-
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
324,010.91
807,900.38
1,419,059.62
Less: Net Income for the Year Dividends Declared During the Year
324,010.91 -
483,889.47 -
611,159.24 -
664,487.95 -
Retained Earnings - Ending
324,010.91
807,900.38
1,419,059.62
2,083,547.57
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,083,547.57
2,856,804.87
3,197,754.01
3,647,238.41
4,221,409.69
4,863,243.36
773,257.30 -
840,949.13 500,000.00
949,484.40 500,000.00
1,074,171.28 500,000.00
1,141,833.67 500,000.00
1,275,666.42 500,000.00
2,856,804.87
3,197,754.01
3,647,238.41
4,221,409.69
4,863,243.36
5,638,909.79
Total orders paid/ Total Sales in Units Cost of fnished goods per unit Total COGS
4,873 5,019 5,113 5,208 400 408 416 424 1,949,218.67 2,047,692.37 2,127,672.99 2,210,777.57
5,305 5,405 5,506 5,608 5,713 5,820 433 442 450 459 469 478 2,297,128.12 2,386,851.42 2,480,079.22 2,576,948.40 2,677,601.18 2,782,185.35
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 Accounts Receivable Increase (Decrease) in Inventory Increase (Decrease) in Supplies On Hand Increase (Decrease) in Prepaid Advertising Increase (Decrease) in Prepaid Rent 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 Increase (Decrease) in Cash Add: Cash - Beginning Cash Balance - End
Year 2
324,010.91 72,131.00 30,862.90 14,000.00 12,244.59 48,382.70 -
483,889.47 72,131.00 30,862.90 156,446.93 774.56 (423.54) 80,500.00
116,662.61 22,500.00 538,115.76 145,743.29 1,324,653.77
32,477.31 75,236.97 614,521.19
(109,200.00) (464,610.00) 779,586.00 205,776.00 1,530,429.77
614,521.19
786,641.00 2,283,457.02 2,283,457.02
2,917,591.96
Flows Year 5 Year 3
Year 4
Year 5
611,159.24 57,131.00 30,862.90 53,983.02 801.30 -
664,487.95 72,131.00 30,862.90 14,000.00 829.02 (80,500.00)
773,257.30 57,131.00 30,862.90 67,296.24 857.76 80,500.00
840,949.13 15,369.00 30,862.90 582,670.69 887.55 (70,500.00)
949,484.40 57,131.00 30,862.90 667,252.25 918.44 70,500.00
1,074,171.28 72,131.00 30,862.90 666,301.79 950.46 -
26,912.48 59,891.66 785,957.28
27,963.65 25,095.86 901,041.37
29,055.88 51,185.58 860,992.66
30,190.77 31,854.98 1,019,726.79
31,369.99 51,075.42 1,049,423.71
32,595.27 58,676.18 1,268,436.63
(15,000.00) (15,000.00)
(72,000.00) (15,500.00) (500,000.00) (587,500.00)
(15,000.00) (500,000.00) (515,000.00)
(500,000.00) (500,000.00)
901,041.37
845,992.66
432,226.79
534,423.71
768,436.63
2,917,591.96
2,908,963.24
3,688,158.60
4,655,997.26
5,088,224.04
5,622,647.76
2,908,963.24
3,688,158.60
4,655,997.26
5,088,224.04
5,622,647.76
6,391,084.38
(15,000.00) (779,586.00) (794,586.00) (8,628.72)
-
Year 6
Year 7
Year 8
-
Year 9
Year 10
1,141,833.67 57,131.00 30,862.90 680,318.13 983.66 -
1,275,666.42 72,131.00 30,862.90 679,300.04 1,018.09 -
33,868.40 31,841.12 1,295,537.10
35,191.27 62,980.12 1,476,831.71
(15,000.00)
-
-
(500,000.00) (515,000.00)
(500,000.00) (500,000.00)
780,537.10
976,831.71
6,391,084.38
7,171,621.48
7,171,621.48
8,148,453.19
48,876,198.92
EALA INC
SALES FORECAST (Y YEAR Total orders Unpaid orders Finished goods (in units) Work in Process Day 1 at P280 Day 2 at P364 Day 3 at 473.2 Total unpaid orders Total orders paid/ Total Sales in Units Percentage of paid orders sold at regular price Units sold at regular price Average Selling Price Revenue from regular sales Units sold at discount Selling price at discount Revenue from discounted sales Total Revenue Total Raw Materials Inventory Cost of fnished goods per unit Total units in Finished goods Inventory Total finished goods inventory WIP: DAY 1 in units in pesos DAY 2 in units in pesos DAY 3 in units in pesos Total Work in Process inventory Total Inventory
Year 1 6,160
Year 2 6,275
17
17
17 17 17 68 6,091 0.99 6,030 1,000 6,030,395.25 61 800 48,730.47 6,079,125.72
17 17 17 70 6,274 0.99 6,211 1,020 6,335,048.27 63 714 44,793.27 6,379,841.54
9,221.25 400 14 5475
9,393.55 408 14 5689
182 14 2,492 237 14 3,240 308 14 4,211.79 9,943.82 24,640.41
186 14 2,590 241 14 3,366 314 14 4,376.30 10,332.22 25,414.96
EALA INC.
ALES FORECAST (YEAR 1-10) Year 3 6,392
Year 4 6,512
Year 5 6,633
Year 6 6,757
Year 7 6,883
Year 8 7,012
Year 9 7,143
18
18
18
19
19
19
20
18 18 18 71 6,391 0.99 6,327 1,040 6,582,488.32 64 728 46,542.85 6,629,031.16
18 18 18 72 6,510 0.99 6,445 1,061 6,839,593.10 65 743 48,360.76 6,887,953.86
18 18 18 74 6,632 0.99 6,566 1,082 7,106,740.11 66 758 50,249.68 7,156,989.78
19 19 19 75 6,756 0.99 6,688 1,104 7,384,321.59 68 773 52,212.37 7,436,533.96
19 19 19 76 6,882 0.99 6,813 1,126 7,672,745.09 69 788 54,251.73 7,726,996.83
19 19 19 78 7,011 0.99 6,940 1,149 7,972,434.11 70 804 56,370.75 8,028,804.85
20 20 20 79 7,142 0.99 7,070 1,172 8,283,828.65 71 820 58,572.53 8,342,401.17
9,569.07 416 14 5911
9,747.87 424 14 6142
9,930.01 433 15 6382
10,115.56 442 15 6631
10,304.57 450 15 6891
10,497.11 459 16 7160
10,693.25 469 16 7439
189 14 2,691 246 14 3,498 320 14 4,547.24 10,735.78 26,216.26
193 14 2,796 251 14 3,634 327 14 4,724.85 11,155.11 27,045.28
197 15 2,905 256 15 3,776 333 15 4,909.39 11,590.82 27,903.04
201 15 3,018 261 15 3,924 340 15 5,101.15 12,043.54 28,790.59
205 15 3,136 267 15 4,077 347 15 5,300.39 12,513.95 29,709.03
209 16 3,259 272 16 4,236 353 16 5,507.42 13,002.73 30,659.49
213 16 3,386 277 16 4,402 361 16 5,722.54 13,510.60 31,643.15
Year 10 7,277 20 20 20 20 81 7,275 0.99 7,202 1,195 8,607,385.91 73 837 60,860.30 8,668,246.22 10,893.06 478 16 7730 218 16 3,518 283 16 4,574 368 16 5,946.05 14,038.31 32,661.24
0
0
0
0
0
0
0
0
EALA Incorporated
EALA Incorporated
Computation of Payback Period
Computation of Net Present Value
Project Cost Year 1 2 3 4 5 6 7 8 9 10 Payback Period
1,944,376.90 Year- End Cash Flow 2,283,457.02 2,917,591.96 2,908,963.24 3,688,158.60 4,655,997.26 5,088,224.04 5,622,647.76 6,391,084.38 7,171,621.48 8,148,453.19 1 year
EALA's Cost of Capital Total Investment Year
Year-End Cash Flow
1 2 3 4 5 6 7 8 9 10 NPV
2,283,457.02 2,917,591.96 2,908,963.24 3,688,158.60 4,655,997.26 5,088,224.04 5,622,647.76 6,391,084.38 7,171,621.48 8,148,453.19
19.2% 1,944,376.90 PV ($1,915,651.86) ($2,447,644.26) ($2,440,405.40) ($3,094,092.79) ($3,906,037.97) ($4,268,644.33) ($4,716,986.37) ($5,361,647.97) ($6,016,460.97) ($6,835,950.66) ($39,059,145.69)
EALA INC. Financial Ratios 1
2
3
Current Ratio Quick Ratio
2.49 2.47
3.72 3.70
4.95 4.93
Activity Ratios Inventory Turnover Total Asset Turnover
1.54 1.98
1.57 1.05
1.60 0.80
0.37
0.27
0.19
99.12% 47.00% 31.39%
99.12% 49.00% 33.22%
99.12% 47.00% 32.30%
7.38% 8.68%
1.46% 4.37%
7.24% 23.20%
Liquidity Ratios
Debt Ratios Debt Ratio Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Assets Return on Equity
EALA Incorporated Computation of Internal Rate of Return Year 0 1 2 3 4 5 6 7 8 9 10 IRR
Year-End Cash Flow (1,944,376.90) 2,283,457.02 2,917,591.96 2,908,963.24 3,688,158.60 4,655,997.26 5,088,224.04 5,622,647.76 6,391,084.38 7,171,621.48 8,148,453.19 136%
EALA INC.
Financial Ratios Years 4
5
6
7
8
9
10
6.16 6.14
7.40 7.38
6.54 6.53
7.63 7.62
8.69 8.68
9.79 9.78
10.80 10.79
1.63 0.65
1.66 0.54
2.03 0.53
2.07 0.44
2.11 0.39
2.15 0.34
2.19 0.31
0.16
0.13
0.15
0.13
0.11
0.10
0.09
99.12% 48.00% 32.90%
99.12% 48.00% 32.41%
99.12% 56.00% 38.15%
99.12% 56.00% 38.35%
99.12% 57.00% 38.70%
99.12% 56.00% 38.41%
99.12% 57.00% 38.73%
10.05% 29.71%
23.81% 41.96%
25.83% 44.18%
23.05% 36.46%
23.77% 37.94%
18.81% 27.31%
19.66% 28.34%
Related Documents
Feasib Scratch Muna
November 2019 8
Feasib Scratch Muna Laine(2)
November 2019 6
Muna
May 2020 8
Scratch
May 2020 11
Scratch
May 2020 14