Financial Modeling - Avenue Supermarts Ltd

Historical Data of Avenue Supermarts Ltd Forecasted Data of Avenue Supermarts Ltd
Years Mar-18(A) Mar-19(A) Mar-20(A) Mar-21(A) Mar-22(A) Mar-23(E) Mar-24(E) Mar-25(E) Mar-26(E) Mar-27(E)

# Income Statement

Sales 15,121 20,053 24,930 24,339 31,094 38,656 47,635 57,429 68,588 81,242
Sales Growth 32.62% 24.32% -2.37% 27.75% 24.3% 23.2% 20.6% 19.4% 18.5%

COGS 12,968 17,598 21,630 21,030 27,100 33,541 41,233 49,830 59,513 70,493
% of sales 85.76% 87.76% 86.76% 86.40% 87.15% 86.77% 86.77% 86.77% 86.77% 86.77%

Gross profit 2,153 2,455 3,300 3,310 5,115 6,303 7,599 9,075 10,750
Gross margins 14.24% 12.24% 13.24% 13.60% 12.85% 13.23% 13.23% 13.23% 13.23% 13.23%

Selling and Administrative 97 137 120 110 210 259 312 373 442
145
Cost % of sales 0.64% 0.68% 0.48% 0.45% 0.46% 0.54% 0.54% 0.54% 0.54% 0.54%

Operating & Other Expenses 616 636 992 1,261 1,234 1,575 1,941 2,340 2,794 3,310
% of sales 4.07% 3.17% 3.98% 5.18% 3.97% 4.07% 4.07% 4.07% 4.07%

EBITDA 1,441 1,682 2,188 1,939 2,616 3,330 4,103 4,947 5,908 6,999
Ebitda margins 9.53% 8.39% 8.78% 7.97% 8.41% 8.61% 8.61% 8.61% 8.61% 8.61%

Depreciation & Amortization 159 212 374 414 498 998 1,538 2,173 2,914 3,775
% of sales 1.05% 1.06% 1.50% 1.70% 1.60% 2.58% 3.23% 3.78% 4.25% 4.65%

EBIT 1,282 1,814 1,525 2,118 2,332 2,565 2,774 3,223

Ebit margins 8.48% 7.33% 7.28% 6.27% 6.81% 6.03% 5.38% 4.83% 4.37% 3.97%
54 61
Interest & Other items 0.17% 61 0.13% 61
% of sales 0.39% 0.24% 0.28% 0.17% 0.16% 0.11% 0.09% 0.07%
 profit Before 1,222 1,422 1,745 1,483 2,064 2,271 2,504 2,713 2,933 3,163
Tax % of sales 8.08% 7.09% 7.00% 6.09% 6.64% 5.88% 5.26% 4.72% 4.28% 3.89%

Taxes 416 519 444 384 572 568 626 678 733 791
Tax % 34.03% 36.53% 25.43% 25.88% 27.69% 25.00% 25.00% 25.00% 25.00% 25.00%

Net Profit 1,301 1,493 1,703 1,878 2,035 2,200 2,372

Net margins 5.33% 4.50% 5.22% 4.52% 4.80% 4.41% 3.94% 3.54% 3.21% 2.92%

No. of Equity Shares 62 62 65 65 65 65 65 65 65 65

Earning Per Share 12.9220.0816.9723.0426.2928.9931.4133.9636.61

Eps Growth 12% 39% -15% 36% 14% 8% 8% 8%
# Balance Sheet 129 146 3,416 1,566 1,639 1,639 1,639 1,639 1,639 1,639
Assets
Current Assets
Cash and Short Term
Investments
Total Receivables
Total Inventory
Other Current
Assets
Total Current Assets

Non Current Assets Net

Property/Plant/Equipment
Goodwill & Intangibles
Long Term Investments
Other Assets
Deferred Tax Assets (Net)
Mar-18(A) Mar-19(A) Mar-
20(A) Mar-21(A) Mar-
22(A) Mar-23(E) Mar-
24(E) Mar-25(E) Mar-
26(E) Mar-27(E)

628 236
1,449 305 -6,613 -15,436
-25,926-38,336 -52,916
34
67 70
103 122
1,163 1,609 1,947
2,2482,743 2,958 3,646
4,3955,249 6,218
147 174 258 321
329 329
329 329
329 329
Changes in Cash anc Cash Equivalents
Opening Cash Balance
Changes in Cash anc Cash Equivalents
Ending Cash Balance
1,972 2,083 2,348
4,0613,443 -3,257 -11,376
-21,099 -32,635 -46,223

3,469 4,699 6,234

7,95010,311 18,842 29,045
41,02955,021 71,272
78 78
78 78 78
78 78 78
 Total Assets 5,648 7,006 12,076 13,655 15,471 17,302 19,387 21,647 24,103 26,766

Liabilities and shareholders' equity

Current Liabilities
Accounts Payable 349 533 506 730 761 889 1,095 1,321 1,577 1,868
Other current liabilities 337 694 219 376 457 457 457 457 457 457
Total Current Liabilities 1,227 726 1,106 1,218 1,346 1,552 1,778 2,034 2,325
#
Non current liabilities
Total Long Term Debt 246 126 221 312 507 507 507 507 507 507
Deferred Tax Liabilities (Net) 45 63 47 50 62 62 62 62 62 62
Other Liabilities 2 2 2 3 5 5 5 5 5 5
Total Liabilities 979 1,417 996 1,471 1,793 1,921 2,127 2,353 2,609 2,900

Shareholders Equity
Common Stock 624 624
Minority Interest 0.64 0.56 0.46 0.40 0.25
Reserves & Surplus 2,235 3,154 4,437 5,541 7,035 8,739 10,617 12,652 14,851 17,223
Additional Paid-in Capital 1,810 1,810 5,995 5,995 5,995 5,995 5,995 5,995 5,995 5,995
Total Equity Capital 4,670 5,588 11,080 12,184 13,678 15,381 17,259 19,294 21,494 23,866
Total Shareholder Equity & Liabilities 5,648 7,006 12,076 13,655 15,471 17,302 19,387 21,647 24,103 26,766

Check TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE

Cash Flow Statement Mar-18(A) Mar-19(A) Mar-20(A) Mar-21(A) Mar-22(A) Mar-23(E) Mar-24(E) Mar-25(E) Mar-26(E) Mar-
27(E)
Net Income 806 903 1,301 1,099 1,493 1,703 1,878 2,035 2,200
Deprecia tion 159 212 374 414 498 998 1,538 2,173 2,914 2,372
Changes in Working Capita/ -292 -321 -101 -487 -91 -497 -542 -617 3,775
Other Operating Cash Flows -700
Cash Flow from Operations (CFO) 965 823 1,355 1,412 1,504 2,611 2,920 3,666 4A97 5,447

Capital Expenditure (7,305) (1,772) (2,901) (4,139) (11,647) (9,529) (11,742) (14,156) (16,907) (20,026)
Cash Flow from Investing (CFI) -7,305 -1,772 -2,901 -4,139 -11,647 -9,529 -11,742 -14,156 -16,907 -20,026