Everyday Every 2-3 day Weekly Monthly Semi-annually Once year Sales in Units
Fried Chick 22 103 186 15 6 6200.462 1126.478 7,327
Sisig 12 67 134 22 10 4 4286.058 772.274 5,058
Humba 12 36 119 21 7 7 3131.698 550.978 3,683
Chicken/Po 28 75 168 12 4 5114.326 920.846 6,035
Chicken Ad 11 72 141 20 3 2 4516.042 817.278 5,333
Sinigang 11 27 129 15 4 5 2994.908 519.232 3,514
Porkchop 11 43 116 16 9 5 3267.222 579.474 3,847
Pater 38 85 107 8 4 4 4477.104 829.144 5,306
Kare-Kare 4 31 85 13 6 6 2359.98 417.548 2,778
Kinilaw 9 31 85 13 6 11 2395.38 423.648 2,819
Silog 29 48 70 9 5 6 2752.48 505.524 3,258
Daing 16 38 57 11 2 7 2173.634 398.482 2,572
Tinola 11 27 56 15 3 2 1815.922 328.118 2,144
Crispy Pata 7 31 50 13 8 8 1821.35 329.578 2,151
Pancit 16 32 57 8 2 4 1984.994 361.354 2,346
Shrimp 9 30 58 21 9 7 1960.956 352.52 2,313
Ginataang 35 32 44 5 2 2 1879.308 348.472 2,228
Fried Lumpi 63 58 64 5 3125.688 587.092 3,713
Pakbet 21 32 43 7 3 3 1787.866 330.126 2,118
Chopseuy 17 37 46 5 4 2 1952.282 360.998 2,313
Chicken Ina 11 47 73 17 4 7 2688.076 490.976 3,179
Menudo 9 13 49 10 7 6 1276.788 222.072 1,499
Mechado 8 11 50 11 4 6 1225.67 212.446 1,438
Utan 41 34 38 7 2 1880.556 353.136 2,234
Bulalo 5 13 30 25 8 12 1005.61 177.59 1,183
0 0 -
Fries 53 134 135 6 6433.09 1206.046 7,639
Burger 20 110 153 12 3 5846.206 1076.566 6,923
Pastries 22 47 118 13 3 3456.126 619.502 4,076
Pizza 27 64 135 41 6 4357.81 788.486 5,146
Ice Cream 32 96 157 13 5 5581.374 1020.454 6,602
Chips 45 82 113 8 4516.406 835.842 5,352
Siomai 38 82 144 9 3 4981.768 909.136 5,891
Siopao 15 69 127 13 4 2 4205.804 763.224 4,969
Pancakes 23 60 102 8 3 3565.244 651.504 4,217
Piyaya 29 57 80 8 2 3161.17 583.678 3,745
Candies and 45 64 42 9 2 2855.464 545.34 3,401
Pancit Cant 13 61 111 8 3 3 3684.432 668.716 4,353
Popcorn 22 51 75 11 4 2876.84 528.976 3,406
Kwekwek a 43 83 130 8 3 4812.89 883.758 5,697
Spaghetti 18 48 95 21 4 3120.21 565.666 3,686
0 0 -
Softdrinks 23 75 134 27 3 3 4588.838 835.874 5,425
Coffee 55 78 92 9 5 4 4139.864 770.34 4,910
Lemonade 22 64 133 12 3 4191.226 757.546 4,949
Frappe 20 37 110 32 11 2 3105.03 550.462 3,655
Fruit Shake 22 71 128 8 4 2 4306.046 782.702 5,089
JUICE 21 45 91 9 2 2941.812 533.192 3,475
halo-halo 14 53 116 36 3 3 3631.562 655.154 4,287
milk tea 18 47 92 23 8 6 3063.474 553.314 3,617
Rank Price Sales in Peso
1 35.00 256442.9 Probability
5 30.00 151749.96 Everyday 2 above 2 hrs
8 40.00 147307.04 Every 2-3 days 22.5
2 25.00 150879.3 Weekly 37.4
3 40.00 213332.8 Every 2 weeks
9 30.00 105424.2 Monthly 33.8
6 35.00 134634.36 Once a year
4 20.00 106124.96
13 25.00 69438.2
12 30.00 84570.84
10 25.00 81450.1
14 20.00 51442.32
21 30.00 64321.2
20 35.00 75282.48
15 20.00 46926.96
16 50.00 115673.8
19 15.00 33416.7
7 10.00 37127.8
22 20.00 42359.84
17 15.00 34699.2
11 50.00 158952.6
23 25.00 37471.5
24 25.00 35952.9
18 15.00 33505.38
25 250.00 295800
0
1 20.00 152782.72
2 30.00 207683.16
11 25.00 101890.7
7 18.00 92633.328
3 25.00 165045.7
6 25.00 133806.2
4 20.00 117818.08
8 25.00 124225.7
10 20.00 84334.96
12 8.00 29958.784
15 2.00 6801.608
9 20.00 87062.96
14 15.00 51087.24
5 25.00 142416.2
13 35.00 129005.66
0
1 15.00 81370.68
4 20.00 98204.08
3 35.00 173207.02
6 50.00 182774.6
2 20.00 101774.96
8 15.00 52125.06
5 40.00 171468.64
7 50.00 180839.4
Everyday Every 2-3 dWeekly Monthly Semi-annualOnce year
24 78 112 29 8 1 22559 1063.107
10140
4816
290
17
30257.6 15474.36985356
50.00 52.50
1,512,880.00 812,404.42
644,765.41
12895.3082113
18569.243824272 22283.092589126 26739.711106952
55.13 57.88 60.78
1,023,629.57 1,289,773.25 1,625,114.30
Annual Projected Sales in Units
Year 1 Year 2 Year 3 Year 4 Year 5
Fried Chicken 7,327 8,792 10,551 12,661 15,193
Sisig 5,058 6,070 7,284 8,741 10,489
Chicken/Pork BBQ 6,035 7,242 8,691 10,429 12,515
Chicken Adobo 5,333 6,400 7,680 9,216 11,059
Porkchop 3,847 4,616 5,539 6,647 7,977
Pater 5,306 6,367 7,641 9,169 11,003
Fried Lumpia 3,713 4,455 5,346 6,416 7,699
Fries 7,639 9,167 11,000 13,200 15,841
Burger 6,923 8,307 9,969 11,963 14,355
halo-halo 6,602 7,922 9,507 11,408 13,690
Siomai 5,891 7,069 8,483 10,179 12,215
Kwekwek and Tempura 5,697 6,836 8,203 9,844 11,813
Softdrinks 5,425 6,510 7,812 9,374 11,249
Fruit Shake 5,089 6,106 7,328 8,793 10,552
milk tea 3,617 4,340 5,208 6,250 7,500
TOTAL 83,501 100,201 120,241 144,290 173,148
Price
Year 1 Year 2 year 3 Year 4 Year 5
35.00 35.88 36.77 37.69 38.63
30.00 37.50 38.44 39.40 40.38
25.00 31.25 32.03 32.83 33.65
40.00 50.00 51.25 52.53 53.84
35.00 43.75 44.84 45.96 47.11
20.00 25.00 25.63 26.27 26.92
10.00 12.50 12.81 13.13 13.46
20.00 25.00 25.63 26.27 26.92
30.00 37.50 38.44 39.40 40.38
40.00 50.00 51.25 52.53 53.84
20.00 25.00 25.63 26.27 26.92
25.00 31.25 32.03 32.83 33.65
15.00 18.75 19.22 19.70 20.19
20.00 25.00 25.63 26.27 26.92
50.00 62.50 64.06 65.66 67.31
Year 1 Year 2 Year 3 Year 4 Year 5
Number of People Who will Avail Study Lounge
12,895 15,474 18,569 22,283 26,740
Price
50.00 52.50 55.13 57.88 60.78
Total Rent Income
644,765.41 812,404.42 1,023,629.57 1,289,773.25 1,625,114.30
Annual Projected Sales in Peso
Year 1 Year 2 Year 3 Year 4
Fried Chicken 256,442.90 315,424.77 387,972.46 477,206.13
Sisig 151,749.96 227,624.94 279,978.68 344,373.77
Chicken/Pork BBQ 150,879.30 226,318.95 278,372.31 342,397.94
Chicken Adobo 213,332.80 319,999.20 393,599.02 484,126.79
Porkchop 134,634.36 201,951.54 248,400.39 305,532.48
Pater 106,124.96 159,187.44 195,800.55 240,834.68
Fried Lumpia 37,127.80 55,691.70 68,500.79 84,255.97
Fries 152,782.72 229,174.08 281,884.12 346,717.47
Burger 207,683.16 311,524.74 383,175.43 471,305.78
Ice Cream 264,073.12 396,109.68 487,214.91 599,274.33
Siomai 117,818.08 176,727.12 217,374.36 267,370.46
Kwekwek and Tempura 142,416.20 213,624.30 262,757.89 323,192.20
Softdrinks 81,370.68 122,056.02 150,128.90 184,658.55
Fruit Shake 101,774.96 152,662.44 187,774.80 230,963.01
milk tea 180,839.40 271,259.10 333,648.69 410,387.89
TOTAL 2,299,050.40 3,379,336.02 4,156,583.30 5,112,597.46
Year 5
586,963.54
423,579.74
421,149.47
595,475.95
375,804.96
296,226.65
103,634.85
426,462.48
579,706.11
737,107.43
328,865.67
397,526.41
227,130.02
284,084.50
504,777.11
6,288,494.88
Cost of Goods per unit
Price YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
Fried Chicken 35.00 25.00 25.63 26.27 26.92 27.60
Sisig 30.00 21.43 26.79 27.46 28.14 28.85
Chicken/Pork BBQ 25.00 17.86 22.32 22.88 23.45 24.04
Chicken Adobo 40.00 28.57 35.71 36.61 37.52 38.46
Porkchop 35.00 25.00 31.25 32.03 32.83 33.65
Pater 20.00 14.29 17.86 18.30 18.76 19.23
Fried Lumpia 10.00 7.14 8.93 9.15 9.38 9.62
Fries 20.00 14.29 17.86 18.30 18.76 19.23
Burger 30.00 21.43 26.79 27.46 28.14 28.85
halo-halo 40.00 28.57 35.71 36.61 37.52 38.46
Siomai 20.00 14.29 17.86 18.30 18.76 19.23
Kwekwek and Tempura 25.00 17.86 22.32 22.88 23.45 24.04
Softdrinks 15.00 10.71 13.39 13.73 14.07 14.42
Fruit Shake 20.00 14.29 17.86 18.30 18.76 19.23
milk tea 50.00 35.71 44.64 45.76 46.90 48.08
-
Cost of Good Sold
YEAR 1 YEAR 2 YEAR 3 YEAR 4
Fried Chicken 183,173.50 225,303.41 277,123.19 340,861.52
Sisig 108,392.83 162,589.24 199,984.77 245,981.27
Chicken/Pork BBQ 107,770.93 161,656.39 198,837.36 244,569.96
Chicken Adobo 152,380.57 228,570.86 281,142.15 345,804.85
Porkchop 96,167.40 144,251.10 177,428.85 218,237.49
Pater 75,803.54 113,705.31 139,857.54 172,024.77
Fried Lumpia 26,519.86 39,779.79 48,929.14 60,182.84
Fries 109,130.51 163,695.77 201,345.80 247,655.33
Burger 148,345.11 222,517.67 273,696.74 336,646.99
halo-halo 188,623.66 282,935.49 348,010.65 428,053.10
Siomai 84,155.77 126,233.66 155,267.40 190,978.90
Kwekwek and Tempura 101,725.86 152,588.79 187,684.21 230,851.57
Softdrinks 58,121.91 87,182.87 107,234.93 131,898.97
Fruit Shake 72,696.40 109,044.60 134,124.86 164,973.58
milk tea 129,171.00 193,756.50 238,320.50 293,134.21
Total 1,642,178.86 2,413,811.44 2,968,988.07 3,651,855.33
YEAR 5
419,259.67
302,556.96
300,821.05
425,339.97
268,432.11
211,590.47
74,024.89
304,616.06
414,075.79
526,505.31
234,904.05
283,947.44
162,235.73
202,917.50
360,555.08
4,491,782.05
LOAN INFORMATION
Amount: 800,000.00 Fixed Annual Payment 200,365.16
Annual Interest Rate: 8.00% Total Payments 801,460.65
Loan Period in Years 5 Total Interest 186,983.95
Number of payment per ye 1
Year Annual Payments Interest Amortization Present Vaue
800,000.00
1 200,365.16 64,000.00 136,365.16 663,634.84
2 200,365.16 53,090.79 147,274.38 516,360.46
3 200,365.16 41,308.84 159,056.33 357,304.13
4 200,365.16 28,584.33 171,780.83 185,523.30
5 200,365.16 14,841.86 185,523.30 -
31.941680296624700%
399.27100370780900%
200,365.16
SEASON's Treetop and Study Lounge
Statement of Comprehensive Income
For period ended December 31
Year 1 Year 2
Net Sales Appendix C 2,299,050.40 3,379,336.02
Inventory, Beg. - 182,464.32
Purchases 1,824,643.17 2,499,548.39
Goods Available for Sales 1,824,643.17 2,682,012.71
Less: Inventory, End. 182,464.32 268,201.27
Cost of Goods Sold Appendix D 1,642,178.86 2,413,811.44
Gross Profit 656,871.54 965,524.58
Other Income:
Gain on Sale of Equipment - -
Total Other Income - -
Total Income 656,871.54 965,524.58
LESS: EXPENSES
Operating Expenses
Sales and Marketing 10,000.00 10,000.00
Depreciation Expense Appendix F 40,642.94 40,642.94
Salaries and Wages 392,010.00 392,010.00
Utilities Expense 15,000.00 15,300.00
Supplies Expense 10,000.00 10,200.00
Total Operating Expenses 467,652.94 468,152.94
Earnings before Interest and Taxes 189,218.60 497,371.64
Less: Interest Expense on Long-term debt 64,000.00 53,090.79
Earnings before Tax 125,218.60 444,280.85
Income Tax
Net Profit 125,218.60 444,280.85
y Lounge
e Income
ber 31
Year 3 Year 4 Year 5
4,156,583.30 5,112,597.46 6,288,494.88
268,201.27 329,887.56 405,761.70
3,030,674.36 3,727,729.47 4,585,107.25 152,053.60
3,298,875.64 4,057,617.03 4,990,868.95
329,887.56 405,761.70 499,086.89
2,968,988.07 3,651,855.33 4,491,782.05
1,187,595.23 1,460,742.13 1,796,712.82
- - -
- - -
1,187,595.23 1,460,742.13 1,796,712.82
5,000.00 5,000.00 5,000.00
40,642.94 40,642.94 40,642.94
522,680.00 522,680.00 522,680.00
15,606.00 15,918.12 16,236.48
10,404.00 10,612.08 10,824.32
594,332.94 594,853.14 595,383.74
593,262.29 865,888.99 1,201,329.08
41,308.84 28,584.33 14,841.86
551,953.45 837,304.66 1,186,487.21
551,953.45 837,304.66 1,186,487.21
No. of person Positon Salary
1 food production stuff 358 per day 365 130670
1 Service Staff 358 per day 365 130670
1 Janitorial Staff 358 per day 365 130670
392010
No. of person Positon Salary
2 food production stuff 358 per day 365 261340
1 Service Staff 358 per day 365 130670
1 Janitorial Staff 358 per day 365 130670
522680
SEASON's Treetop and Study Lounge
Statement of Financial POsition
As of the period ended December 31
Year 1
Assets
Current Assets
Cash 64,608.31
Inventory 182,464.32
Total Current Assets 247,072.63
Non-Currebt Assets
Building 810,971.75
Accumulated Depreciation - Building Appendix F (24,329.15)
Furniture and Fixtures 37,700.00
Accumulated Depreciation - Furniture and Fixture Appendix F (2,499.00)
Equipment 183,752.00
Accumulated Depreciation - Equipment Appendix F (13,814.79)
Total Non-Current Assets 991,780.81
Total Assets 1,238,853.44
Liabilities and Partners' Equity
Loan Payable 663,634.84
Partners' Equity 575,218.60
Total Liabilities and Owners' Equity 1,238,853.44
and Study Lounge
nancial POsition
nded December 31
Year 2 Year 3 Year 4 Year 5 Capitalized Cost: P810,971.75
Salvage Value: P81,097.17
Year
316,520.77 688,374.54 1,318,667.17 1,666,948.83
268,201.27 329,887.56 405,761.70 499,086.89 1
584,722.04 1,018,262.11 1,724,428.87 2,166,035.73 2
3
4
810,971.75 810,971.75 810,971.75 810,971.75 5
(48,658.31) (72,987.46) (97,316.61) (121,645.76) 6
37,700.00 37,700.00 37,700.00 37,700.00 7
(4,998.00) (7,497.00) (9,996.00) (12,495.00) 8
183,752.00 183,752.00 183,752.00 183,752.00 9
(27,628.78) (41,443.57) (55,258.36) (69,073.15) 10
951,138.67 910,495.72 869,852.78 829,209.84 11
1,535,860.71 1,928,757.83 2,594,281.65 2,995,245.57 12
13
14
516,360.46 357,304.13 185,523.30 - 15
1,019,499.45 1,571,452.90 2,408,757.57 2,995,244.78
1,535,859.91 1,928,757.04 2,594,280.86 2,995,244.78
Facility
talized Cost: P810,971.75
age Value: P81,097.17
Depreciation ExpenseAccumulated Depreciation Carrying Amount Year
810,971.75 16
$24,329.15 24,329.15 786,642.60 17
$24,329.15 48,658.31 762,313.45 18
$24,329.15 72,987.46 737,984.30 19
$24,329.15 97,316.61 713,655.15 20
$24,329.15 121,645.76 689,326.00 21
$24,329.15 145,974.91 664,996.85 22
$24,329.15 170,304.06 640,667.70 23
$24,329.15 194,633.21 616,338.55 24
$24,329.15 218,962.36 592,009.40 25
$24,329.15 243,291.51 567,680.25 26
$24,329.15 267,620.66 543,351.10 27
$24,329.15 291,949.81 519,021.95 28
$24,329.15 316,278.96 494,692.80 29
$24,329.15 340,608.11 470,363.65 30
$24,329.15 364,937.26 446,034.50
Facility
Useful Life: 30 years
Depreciation Method: Straight Line
Depreciation Expense Accumulated Depreciation Carrying Amount
$ 24,329.15 389,266.41 421,705.35
$ 24,329.15 413,595.56 397,376.20
$ 24,329.15 437,924.71 373,047.05
$ 24,329.15 462,253.86 348,717.90
$ 24,329.15 486,583.01 324,388.75
$ 24,329.15 510,912.16 300,059.60
$ 24,329.15 535,241.31 275,730.45
$ 24,329.15 559,570.46 251,401.30
$ 24,329.15 583,899.61 227,072.15
$ 24,329.15 608,228.76 202,743.00
$ 24,329.15 632,557.91 178,413.85
$ 24,329.15 656,887.06 154,084.70
$ 24,329.15 681,216.21 129,755.55
$ 24,329.15 705,545.36 105,426.40
$ 24,329.15 729,874.51 81,097.25
SEASON's Treetop and Study Lounge
Statement of Cash Flows
For period ended December 31
Year 1 Year 2
Cash Flows from Operating Activities
Cash Receipt from sale to customers 2,299,050.40 3,379,336.02
Cash paid for goods from supplier (1,824,643.17) (2,499,548.39)
Cash paid for marketing and advertsing (10,000.00) (10,000.00)
Cash paid for salaries and wages (392,010.00) (392,010.00)
Cash paid for utilities expense (15,000.00) (15,300.00)
Cash paid for supplies (10,000.00) (10,200.00)
Interest Paid (64,000.00) (53,090.79)
Net cash provided (used) by operating activities (16,602.77) 399,186.84
Cash Flows From Investing Activities
Cash paid for building construction (810,971.75) -
Cash paid for purchase of equipment (183,752.00) -
Cash paid for purchase of furniture and fixtures (37,700.00) -
Cash receipt from sale of equipment - -
Net cash provided (used) by Investing Activities (1,032,423.75) -
Cash Flows from Financing Activities
Proceeds from long-term borrowings 800,000.00 -
Payment of long term borrowings (136,365.16) (147,274.38)
Cash provided by partner's contribution 450,000.00 -
Cash distribution to partners - -
Net cash provided (used) by financing activities 1,113,634.84 (147,274.38)
Net increase (decrease) in cash 64,608.31 251,912.46
Cash at beginning of period - 64,608.31
Cash at end of period 64,608.31 316,520.77
Lounge
ws
er 31
Year 3 Year 4 Year 5 Capitalized Cost: P810,971.75
Salvage Value: P81,097.17
4,156,583.30 5,112,597.46 6,288,494.88 Year
(3,030,674.36) (3,727,729.47) (4,585,107.25)
(5,000.00) (5,000.00) (5,000.00) 1
(522,680.00) (522,680.00) (522,680.00) 2
(15,606.00) (15,918.12) (16,236.48) 3
(10,404.00) (10,612.08) (10,824.32) 4
(41,308.84) (28,584.33) (14,841.86) 5
530,910.10 802,073.46 1,133,804.96 6
7
8
- - - 9
- - 10
- - - 11
- - - 12
- - - 13
14
15
- - -
(159,056.33) (171,780.83) (185,523.30)
- - -
- - (600,000.00)
(159,056.33) (171,780.83) (785,523.30)
371,853.77 630,292.63 348,281.66
316,520.77 688,374.54 1,318,667.17
688,374.54 1,318,667.17 1,666,948.83
27,261.66
Facility
Capitalized Cost: P810,971.75
Salvage Value: P81,097.17
Depreciation Expense Accumulated Depreciation Carrying Amount Year
810,971.75 16
$24,329.15 24,329.15 786,642.60 17
$24,329.15 48,658.31 762,313.45 18
$24,329.15 72,987.46 737,984.30 19
$24,329.15 97,316.61 713,655.15 20
$24,329.15 121,645.76 689,326.00 21
$24,329.15 145,974.91 664,996.85 22
$24,329.15 170,304.06 640,667.70 23
$24,329.15 194,633.21 616,338.55 24
$24,329.15 218,962.36 592,009.40 25
$24,329.15 243,291.51 567,680.25 26
$24,329.15 267,620.66 543,351.10 27
$24,329.15 291,949.81 519,021.95 28
$24,329.15 316,278.96 494,692.80 29
$24,329.15 340,608.11 470,363.65 30
$24,329.15 364,937.26 446,034.50
acility
Useful Life: 30 years
Depreciation Method: Straight Line
Depreciation Expense Accumulated Depreciation Carrying Amount
$ 24,329.15 389,266.41 421,705.35
$ 24,329.15 413,595.56 397,376.20
$ 24,329.15 437,924.71 373,047.05
$ 24,329.15 462,253.86 348,717.90
$ 24,329.15 486,583.01 324,388.75
$ 24,329.15 510,912.16 300,059.60
$ 24,329.15 535,241.31 275,730.45
$ 24,329.15 559,570.46 251,401.30
$ 24,329.15 583,899.61 227,072.15
$ 24,329.15 608,228.76 202,743.00
$ 24,329.15 632,557.91 178,413.85
$ 24,329.15 656,887.06 154,084.70
$ 24,329.15 681,216.21 129,755.55
$ 24,329.15 705,545.36 105,426.40
$ 24,329.15 729,874.51 81,097.25
SEASON's Treetop and Study Lounge
Statement of Changes in Partners' Equity
For period ended December 31
Year 1 Year 2 Year 3 Year 4
Partners' Equity, Beginning Balance - 575,218.60 1,019,499.45 1,571,452.90
Add: Partners' Contribution 450,000.00 - - -
Partner's Share in Income 125,218.60 444,280.85 551,953.45 837,304.66
Total 575,218.60 1,019,499.45 1,571,452.90 2,408,757.57
Less: Withdrawal - - - -
Partners' Equity, Ending Balance 575,218.60 1,019,499.45 1,571,452.90 2,408,757.57
Year 5
2,408,757.57
-
1,186,487.21
3,595,244.78
600,000.00
2,995,244.78
cash $ 450,000.00
Partners equity $ 450,000.00
Cash $ 1,000,000.00
Loan Payable $ 1,000,000.00
building $ 908,721.75
cash $ 908,721.75
Equipment $ 183,752.00
cash $ 183,752.00
Furniture and Fixtures $ 37,700.00
cash $ 37,700.00
Supplies $ 39,655.00
cash $ 39,655.00
inventory $ 1,824,643.17
cash $ 1,824,643.17
Loan Payable $ 115,365.16
Interest Exense $ 85,000.00
Cash $ 200,365.16
cash $ 900,000.00
Patners drawing $ 900,000.00
depreciation expense $ (40,642.94)
accumulated $ (40,642.94)
salaries $ 392,010.00
cash $ 392,010.00
sales
Particular Year 1 Year 2 Year 3 Year 4 Year 5
Net Income 125,218.60 444,280.85 551,953.45 837,304.66 1,186,487.21
Net Sales 2,299,050.40 3,379,336.02 4,156,583.30 5,112,597.46 6,288,494.88
Net Profit Margin 5.45% 13.15% 13.28% 16.38% 18.87%
increase (%) 7.70% 0.13% 3.10% 2.49%
Particular Year 1 Year 2 Year 3 Year 4 Year 5
Net Income 125,218.60 444,280.85 551,953.45 837,304.66 1,186,487.21
Average Total Assets 1,238,853.44 1,535,860.71 1,928,757.83 2,594,281.65 2,995,245.57
Return on Assets 10.11% 28.93% 28.62% 32.28% 39.61%
Increase (%) 18.82% -0.31% 3.66% 7.34%
Particular Year 1 Year 2 Year 3 Year 4 Year 5
Net Income 125,218.60 444,280.85 551,953.45 837,304.66 1,186,487.21
Total Projected Costs 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00 1,500,000.00
Return on Investment 8.35% 29.62% 36.80% 55.82% 79.10%
Incease (%) 21.27% 7.18% 19.02% 23.28%
Particular Year 1 Year 2 Year 3 Year 4 Year 5
Cost of Goods Sold 1,642,178.86 2,413,811.44 2,968,988.07 3,651,855.33 4,990,868.95
Average Inventory 182,464.32 268,201.27 329,887.56 405,761.70 499,086.89
Inventory Turnover 9.00 9.00 9.00 9.00 10.00
Particular Year 1 Year 2 Year 3 Year 4 Year 5
Net Sales 2,299,050.40 3,379,336.02 4,156,583.30 5,112,597.46 6,288,494.88
Average Total Assets 1,238,853.44 1,535,860.71 1,928,757.83 2,594,281.65 2,995,245.57
Asset Turnover 185.58% 220.03% 215.51% 197.07% 209.95%
Particular Year 1 Year 2 Year 3 Year 4 Year 5
Net Income Before
189,218.60 497,371.64 593,262.29 865,888.99 1,201,329.08
Tax and Interest
Annual Interest Charges 64,000.00 53,090.79 41,308.84 28,584.33 14,841.86
Time Interest Earned 2.96 9.37 14.36 30.29 -
Particular Year 1 Year 2 Year 3 Year 4 Year 5
Total Liabilities 663,634.84 516,360.46 357,304.13 185,523.30 -
Total Assets 1,238,853.44 1,535,860.71 1,928,757.83 2,594,281.65 2,995,245.57
Debt Ratio 53.57% 33.62% 18.53% 7.15% 0.00%
Payback Period
Year Net Cah Inflow Cumulative Net Cash Inflow Cost
64,608.31 64,608.31