ANNEX
Sales
Quantity
Selling Price
Sales Revenue
Cost of Goods Sold
Beginning Inventory
Purchases
Quantity
Unit Cost
Raw Material Cost
Goods Available for Sale
Ending Inventory
Cost of Goods Sold
Gross Profit
General and Adminstrative Cost
Selling and Distribution Cost
Wages and Salaries
Utilities
Maintenance Costs
Depreciation Expense
Misllaneous Expense
General and Adminstrative Cost
Profit Before Interest
Interest Expense
Net Income Before Tax
Provision for Tax
Net Income After Tax
Cash Flow Statement
Begning Cash
Loan
Sales
Cash from Trade Recievable
Cash In Flow
Cash Outflow
Working Capital
Product cost
Selling and Distribution Cost
Wages and Salaries
Utilities
Maintenance Costs
Loan Repayment
Misllanous Expense
Profit Tax
Total Working Capital
Capital Expenditure
Interest Expense
Equipment and Machinery
Total Capital Expnditure
Total Cash Outflow
Net Cash Flow (109,191,301.00)
Net Present Value $438,404,337.04
Internal Rate of Return 100%
Fixed Assets (non-current assets)
Property, plant and equipment
Net Fixed Asset
Current Asset
Inventories
Trade Recievables
Other Assets
Cash and bank balances
Total Current Assets
Total Assets
Capital and Liablities
Capital Account
Retained Earning
Total Capital
Current Liablities
other liablities
Total Current Liablities
Total Liablities
Tax payable
Total Capital and Liablities
Financial Ratios
Quick Ratio
Current Ratio
Total Deb Ratio
Debt Equity Ratio
Equity Multiplier
Times Interest Earned
Fixed Asset Turnover
Total Assets Turnover
Profit Margin
Return on Assets
Retun on Equity
ANNEX
2024 2025 2026
19,125,145.60 22,950,174.72 22,950,174.72
15.5 17.05 18.755
296,439,756.80 391,300,478.98 430,430,526.87
3,904,619.00 5,938,357.71 7,482,330.71
19,125,145.60 22,950,174.72 22,950,174.72
10.35 10.8675 11.410875
197,945,256.96 249,411,023.77 261,881,574.96
201,849,875.96 255,349,381.48 269,363,905.67
5,938,357.71 7,482,330.71 7,856,447.25
195,911,518.25 247,867,050.77 261,507,458.42
100,528,238.55 143,433,428.21 168,923,068.45
8,893,192.70 11,739,014.37 12,912,915.81
5,370,000.00 5,745,900.00 6,148,113.00
1,445,000.00 1,445,000.00 1,445,000.00
1,524,257.46 1,371,831.71 1,234,648.54
5,645,398.00 5,080,858.20 4,572,772.38
2,867,975.00 362,366.52 380,484.85
22,877,848.16 25,382,604.28 26,313,449.73
77,650,390.38 118,050,823.93 142,609,618.72
4,958,585.89 2,727,979.69 2,007,979.69
72,691,804.49 115,322,844.23 140,601,639.03
21,807,541.35 34,596,853.27 42,180,491.71
50,884,263.15 80,725,990.96 98,421,147.32
2024 2025 2026
682,963.00 39,776,171.63 113,037,821.77
30,000,000.00
237,151,805.44 313,040,383.18 344,344,421.50
15,859,234.00 59,287,951.36 78,260,095.80
283,694,002.44 412,104,506.18 535,642,339.06
195,911,518.25 247,867,050.77 261,507,458.42
8,893,192.70 11,739,014.37 12,912,915.81
5,370,000.00 5,745,900.00 6,148,113.00
1,445,000.00 1,445,000.00 1,445,000.00
1,524,257.46 1,371,831.71 1,234,648.54
25,340,529.00 6,000,000.00 6,000,000.00
474,747.50 362,366.52 380,484.85
21,807,541.35 34,596,853.27
238,959,244.92 296,338,704.72 324,225,473.89
4,958,585.89 2,727,979.69 2,007,979.69
4,958,585.89 2,727,979.69 2,007,979.69
243,917,830.81 299,066,684.41 326,233,453.58
39,776,171.63 113,037,821.77 209,408,885.47
2024 2025 2026
50,808,582.00 45,727,723.80 41,154,951.42
50,808,582.00 45,727,723.80 41,154,951.42
5,938,357.71 7,482,330.71 7,856,447.25
59,287,951.36 78,260,095.80 86,086,105.37
39,776,171.63 113,037,821.77 209,408,885.47
105,002,480.70 198,780,248.27 303,351,438.10
155,811,062.70 244,507,972.07 344,506,389.52
60,428,231.00 111,312,494.15 192,038,485.11
50,884,263.15 80,725,990.96 98,421,147.32
111,312,494.15 192,038,485.11 290,459,632.43
24,000,000.00 18,000,000.00 12,000,000.00
24,000,000.00 18,000,000.00 12,000,000.00
24,000,000.00 18,000,000.00 12,000,000.00
21,807,541.35 34,596,853.27 42,180,491.71
45,807,541.35 52,596,853.27 54,180,491.71
157,120,035.49 244,635,338.38 344,640,124.14
(1,308,972.79) (127,366.31) (133,734.62)
Formulas 2024 2025
CA-Inv/TCL 2.16 3.64
CA/CL 2.29 3.78
Total Liablities/Total Assets 0.29 0.22
Total Liablities/Total Equity 0.41 0.27
Total Asset/Total Capital 1.40 1.27
Profit Before Interest and Tax/Interest Expense 15.66 43.27
T.Revenue/Net Fixed Assets 5.83 8.56
T.Revenue/ Total Assets 1.90 1.60
Net Income/Revenue 0.17 0.21
Net Income/Total Assets 0.33 0.33
Net Income/Equity 0.46 0.42
2027 2028
22,950,174.72 22,950,174.72
20.6305 22.69355
473,473,579.56 520,820,937.52
7,856,447.25 8,249,269.61
22,950,174.72 22,950,174.72
11.98141875 12.5804896875
274,975,653.71 288,724,436.39
282,832,100.95 296,973,706.00
8,249,269.61 8,661,733.09
274,582,831.34 288,311,972.91
198,890,748.22 232,508,964.61
14,204,207.39 15,624,628.13
6,578,480.91 7,038,974.57
1,445,000.00 1,445,000.00
1,111,183.69 1,000,065.32
4,115,495.14 3,703,945.63
399,509.10 419,484.54
27,454,367.13 28,812,613.65
171,436,381.09 203,696,350.96
1,287,979.69 597,474.62
170,148,401.40 203,098,876.34
51,044,520.42 60,929,662.90
119,103,880.98 142,169,213.44
2027 2028
209,408,885.47 326,484,170.67
378,778,863.65 416,656,750.01
86,086,105.37 94,694,715.91
674,273,854.50 837,835,636.59
274,582,831.34 288,311,972.91
14,204,207.39 15,624,628.13
6,578,480.91 7,038,974.57
1,445,000.00 1,445,000.00
1,111,183.69 1,000,065.32
6,000,000.00 6,000,000.00
399,509.10 419,484.54
42,180,491.71 51,044,520.42
346,501,704.14 370,884,645.89
1,287,979.69 597,474.62
1,287,979.69 597,474.62
347,789,683.83 371,482,120.51
326,484,170.67 466,353,516.09 1,045,869,264.63 209,173,852.93
2027 2028
37,039,456.28 33,335,510.65
37,039,456.28 33,335,510.65
8,249,269.61 8,661,733.09
94,694,715.91 104,164,187.50
326,484,170.67 466,353,516.09
429,428,156.19 579,179,436.68
466,467,612.47 612,514,947.33
290,459,632.43 409,563,513.41
119,103,880.98 142,169,213.44
409,563,513.41 551,732,726.85
6000000 0
6,000,000.00 -
6,000,000.00 -
51,044,520.42 60,929,662.90
57,044,520.42 60,929,662.90
466,608,033.83 612,662,389.75
(140,421.36) (147,442.42) -
2026 2027 2028
5.45 7.38 9.36
5.60 7.53 9.51
0.16 0.12 0.10
0.19 0.14 0.11
1.19 1.14 1.11
71.02 133.10 340.93
10.46 12.78 15.62
1.25 1.02 0.85
0.23 0.25 0.27
0.29 0.26 0.23
0.34 0.29 0.26
Principal Interest
Period Principal Loan Repayment Payment Ending Balance
Year 0 1 30,000,000 - 441,750 30,000,000
2 30,000,000 500,000 441,750 29,558,250
3 29,558,250 500,000 435,245 29,123,005
4 29,123,005 500,000 428,836 28,694,169
5 28,694,169 500,000 422,522 28,271,647
6 28,271,647 500,000 416,300 27,855,347
7 27,855,347 500,000 410,170 27,445,177
8 27,445,177 500,000 404,130 27,041,047
9 27,041,047 500,000 398,179 26,642,867
10 26,642,867 500,000 392,316 26,250,551
11 26,250,551 500,000 386,539 25,864,012
12 25,864,012 500,000 380,848 25,483,164
Total 4,958,586
Year 1 1 25,483,164 500,000 254,832 24,983,164
2 24,983,164 500,000 249,832 24,483,164
3 24,483,164 500,000 244,832 23,983,164
4 23,983,164 500,000 239,832 23,483,164
5 23,483,164 500,000 234,832 22,983,164
6 22,983,164 500,000 229,832 22,483,164
7 22,483,164 500,000 224,832 21,983,164
8 21,983,164 500,000 219,832 21,483,164
9 21,483,164 500,000 214,832 20,983,164
10 20,983,164 500,000 209,832 20,483,164
11 20,483,164 500,000 204,832 19,983,164
12 19,983,164 500,000 199,832 19,483,164
2,727,980
Year 2 1 19,483,164 500,000 194,832 18,983,164
2 18,983,164 500,000 189,832 18,483,164
3 18,483,164 500,000 184,832 17,983,164
4 17,983,164 500,000 179,832 17,483,164
5 17,483,164 500,000 174,832 16,983,164
6 16,983,164 500,000 169,832 16,483,164
7 16,483,164 500,000 164,832 15,983,164
8 15,983,164 500,000 159,832 15,483,164
9 15,483,164 500,000 154,832 14,983,164
10 14,983,164 500,000 149,832 14,483,164
11 14,483,164 500,000 144,832 13,983,164
12 13,983,164 500,000 139,832 13,483,164
2,007,980
Year 3 1 13,483,164 500,000 134,832 12,983,164
2 12,983,164 500,000 129,832 12,483,164
3 12,483,164 500,000 124,832 11,983,164
4 11,983,164 500,000 119,832 11,483,164
5 11,483,164 500,000 114,832 10,983,164
6 10,983,164 500,000 109,832 10,483,164
7 10,483,164 500,000 104,832 9,983,164
8 9,983,164 500,000 99,832 9,483,164
9 9,483,164 500,000 94,832 8,983,164
10 8,983,164 500,000 89,832 8,483,164
11 8,483,164 500,000 84,832 7,983,164
12 7,983,164 500,000 79,832 7,483,164
1,287,980
Year 4 1 7,483,164 500,000 74,832 6,983,164
2 6,983,164 500,000 69,832 6,483,164
3 6,483,164 500,000 64,832 5,983,164
4 5,983,164 500,000 59,832 5,483,164
5 5,483,164 500,000 54,832 4,983,164
6 4,983,164 500,000 49,832 4,483,164
7 4,483,164 500,000 44,832 3,983,164
8 3,983,164 500,000 39,832 3,483,164
9 3,483,164 500,000 34,832 2,983,164
10 2,983,164 500,000 29,832 2,483,164
11 2,483,164 500,000 24,832 1,983,164
12 1,983,164 500,000 19,832 1,483,164
567,980
Year 5 1 1,483,164 500,000 14,832 983,164
2 983,164 500,000 9,832 483,164
3 483,164 12,981 4,832 470,183
4 29,495
5
6
7
8
9
10
11
12
Year 6 1 - 1,210,632 - (1,210,632)
2 (1,210,632) 1,210,632 (12,106) (2,421,264)
3 (2,421,264) 1,210,632 (24,213) (3,631,896)
4 (3,631,896) 1,210,632 (36,319) (4,842,528)
5 (4,842,528) 1,210,632 (48,425) (6,053,160)
6 (6,053,160) 1,210,632 (60,532) (7,263,792)
7 (7,263,792) 1,210,632 (72,638) (8,474,424)
8 (8,474,424) 1,210,632 (84,744) (9,685,056)
9 (9,685,056) 1,210,632 (96,851) (10,895,688)
10 (10,895,688) 1,210,632 (108,957) (12,106,320)
11 (12,106,320) 1,210,632 (121,063) (13,316,952)
12 (13,316,952) 1,210,632 (133,170) (14,527,584)
(799,017)
Year 7 1 (14,527,584) 1,210,632 (145,276) (15,738,216)
2 (15,738,216) 1,210,632 (157,382) (16,948,848)
3 (16,948,848) 1,210,632 (169,488) (18,159,480)
4 (18,159,480) 1,210,632 (181,595) (19,370,112)
5 (19,370,112) 1,210,632 (193,701) (20,580,744)
6 (20,580,744) 1,210,632 (205,807) (21,791,376)
7 (21,791,376) 1,210,632 (217,914) (23,002,008)
8 (23,002,008) 1,210,632 (230,020) (24,212,640)
9 (24,212,640) 1,210,632 (242,126) (25,423,272)
10 (25,423,272) 1,210,632 (254,233) (26,633,904)
11 (26,633,904) 1,210,632 (266,339) (27,844,536)
12 (27,844,536) 1,210,632 (278,445) (29,055,168)
(2,542,327)
Year 8 1 (29,055,168) 1,210,632 (290,552) (30,265,800)
2 (30,265,800) 1,210,632 (302,658) (31,476,432)
3 (31,476,432) 1,210,632 (314,764) (32,687,064)
4 (32,687,064) 1,210,632 (326,871) (33,897,696)
5 (33,897,696) 1,210,632 (338,977) (35,108,328)
6 (35,108,328) 1,210,632 (351,083) (36,318,960)
7 (36,318,960) 1,210,632 (363,190) (37,529,592)
8 (37,529,592) 1,210,632 (375,296) (38,740,224)
9 (38,740,224) 1,210,632 (387,402) (39,950,856)
10 (39,950,856) 1,210,632 (399,509) (41,161,488)
11 (41,161,488) 1,210,632 (411,615) (42,372,120)
12 (42,372,120) 1,210,632 (423,721) (43,582,752)
(4,285,637)
Year 9 1 (43,582,752) 1,210,632 (435,828) (44,793,384)
2 (44,793,384) 1,210,632 (447,934) (46,004,016)
3 (46,004,016) 1,210,632 (460,040) (47,214,648)
4 (47,214,648) 1,210,632 (472,146) (48,425,280)
5 (48,425,280) 1,210,632 (484,253) (49,635,912)
6 (49,635,912) 1,210,632 (496,359) (50,846,544)
7 (50,846,544) 1,210,632 (508,465) (52,057,176)
8 (52,057,176) 1,210,632 (520,572) (53,267,808)
9 (53,267,808) 1,210,632 (532,678) (54,478,440)
10 (54,478,440) 1,210,632 (544,784) (55,689,072)
11 (55,689,072) 1,210,632 (556,891) (56,899,704)
12 (56,899,704) 1,210,632 (568,997) (58,110,336)
(6,028,947)
ear 10 1 (58,110,336) 1,210,632 (581,103) (59,320,968)
2 (59,320,968) 1,210,632 (593,210) (60,531,600)
3 (60,531,600) 1,210,632 (605,316) (61,742,232)
4 (61,742,232) 1,210,632 (617,422) (62,952,864)
5 (62,952,864) 1,210,632 (629,529) (64,163,496)
6 (64,163,496) 1,210,632 (641,635) (65,374,128)
7 (65,374,128) 1,210,632 (653,741) (66,584,760)
8 (66,584,760) 1,210,632 (665,848) (67,795,392)
9 (67,795,392) 1,210,632 (677,954) (69,006,024)
10 (69,006,024) 1,210,632 (690,060) (70,216,656)
11 (70,216,656) 1,210,632 (702,167) (71,427,288)
12 (71,427,288) 1,210,632 (714,273)
4,958,586 2,727,980 2,007,980 1,287,980 597,475