Q.Required to Estimate the FCFE and FCFF For Year (2017, 2018, 2019,2020) and also calculate Terminal and WACC value.
DCF techniques.
Fixed Assets NonCurrent Investments Long Term Loans And Advances Other NonCurrent Assets Total NonaCurrent Assets CURRENT ASSETS Current Investments Inventories Trade Receivables Cash And Cash Equivalents Short Term Loans And Advances OtherCurrentAssets Total Current Assets Total Assets OTHER ADDITIONAL INFORMATION CONTINGENT LIABILITIES, COMMITMENTS Contingent Liabilities CIF VALUE OF IMPORTS Raw Materials Stores, Spares And Loose Tools Capital Goods EXPENDITURE IN FOREIGN EXCHANGE Expenditure In Foreign Currency REMITTANCES IN FOREIGN CURRENCIES FOR DIVIDENDS Dividend Remittance In Foreign Currency EARNINGS IN FOREIGN EXCHANGE FOB Value Of Goods Other Earnings BONUS DETAILS Bonus Equity.r Share Capital NON-CURRENT INVESTMENTS NonCurrent Investments Quoted Market Value NonCurrent Investments Unquoted Book Value 300,447.00 237,319.00 233,239.00 190,316.00 151,122.00 171,945.00140,544.00 112,630.00 62,058.00 52,692.00 17,699.00 10,418.00 16,237.00 29,259.00 28,436.00 3,522.00 2,184.00 0.00 0.00 0.00 493,613.00 440,465.00 367,156.00 231,633.00 232,250.00 53,2rr.00 51,005.00 30,420.00 50,515.00 33,3?0.00 30,550.00 34,010.00 20,034.00 35,551.00 42,032.00 10,450.00 5,472.00 3,405.00 4,551.00 10,554.00 2,?31.00 1,254.00 5,002.00 11,5?1.00 35,524.00 3,533.00 4,900.00 11,938.00 12,307.00 11,277.00 14,343.00 8,231.00 776.00 547.00 466.00 123,912.00 106,231.00 90,564.00 116,152.00 135,333.00 617,525.00 546,746.00 457,720.00 397,735.00 367,533.00 66,494.00 73,386.00 79,905.00 80,641.00 75,955.00 0.00 0.00 146,516.00 241,456.00 302,630.00 0.00 0.00 4,142.00 3,217.00 3,719.00 0.00 0.00 13,897.00 9,788.00 4,218.00 221,977.00 0.00 8,013.00 7,785.00 8,222.00 1,311.00 622.00 524.00 137,634.00 209,169.00 261,118.00 169,763.00 198.00 229.00 248.00 5,100.00 2,100.55 2,100.55 2,100.55 2,100.55 12,182.00 15,991.00 30,647.00 16,950.00 18,039.00 160,045.00124,851.00 83,583.00 45,920.00 34,781.00 Mar 18 Mar 17 Mar 16 Mar 15 Mar 14 12 mths 12 maths 12 mths 12 moths 12 myths INCOME Revenue From Operations Gross 315 357 00 265 041 00 251 241 ,00 340 814.00 401 302 00 Less : Excise / Sevice Tax Other Levies 25. 31500 23 016 .00 18 .08300 11.738 00 11 185.00 Revenue From Operations Net ) 290 042 00 242 025.00 233 158 00 329 07600 390 17 00 Total Operating Revenues 290 04200 242 02500 233 15800 329 07600 390 117.00 Other Income 220.00 8.70900 7 58200 8721 00 8.936.00 Total Revenue 298 262.00 250 734 00 240 , 740.00 337 797 00 309 053.00 EXPENSE Cost Of Materials Consumed 198 029.00 164 250 00 152 76900 255 998 00 329 . 313.00 Purchase Of Stock- In Trade 7. 26800 516100 4 . 241 00 7.134. 00 524 00 Operating And Direct Expenses 21 64600 18 25500 17 .32800 19 . 693.00 16 584. 00 Changes In Inventories Of FG , WIP And Stock - In Trade 3 23200 483900 4 .17100 1943.00 41200 Employee Benefit Expenses 4740 00 4 43400 4260.00 68600 3 . 370.00 Finance Costs 656 00 2723 00 45400 2367.00 206 00 Depreciation And Amortisation Expenses 580.00 8.465.00 9.566.00 48800 7890 Other Expenses 850 00 1150800 12757 00 1059300 9037 00 Less : Transfer to / From Investment Fixed Assets Others 0.00 0.00 2507 00 1573.00 0.0 0 Total Expenses 252 537 00 209 957 00 205 039.00 308 329.00 371 235.00Balance Sheet - in Rs. Cr. ---- Mar 18 Mar 17 Mar 16 Mar 15 Mar 14 12 mths 12 mths 12 mths 12 mths 12 mths EQUITIES AND LIABILITIES SHAREHOLDER'S FUNDS Equity Share Capital 6,335.00 3,251.00 3,240.00 3,236.00 3,232.00 Total Share Capital 6,335.00 3,251.00 3,240.00 3,236.00 3,232.00 Reserves and Surplus 308,297.00 285,058.00 236,936.00 212,923.00 193,842.00 Total Reserves and Surplus 308,297.00 285,058.00 236,936.00 212,923.00 193,842.00 Total Shareholders Funds 314,632.00 288,309.00 240,176.00 216, 159.00 197,074.00 Equity Share Application Money 15.00 4.00 8.00 17.00 17.00 NON-CURRENT LIABILITIES Long Term Borrowings 81,596.00 78,723.00 77,866.00 76,227.00 62,711.00 Deferred Tax Liabilities [Net] 27,926.00 24,766.00 13, 159.00 12,677.00 12,215.00 Other Long Term Liabilities 504.00 0.00 0.00 0.00 0.00 Long Term Provisions 2,205.00 2,118.00 1,489.00 1,404.00 0.00 Total Non-Current Liabilities 112,231.00 105,607.00 92,514.00 90,308.00 74,926.00 CURRENT LIABILITIES Short Term Borrowings 15,239.00 22,580.00 14,490.00 12,914.00 22,770.00 Trade Payables 88,675.00 68, 161.00 54,521.00 54,470.00 57,862.00 Other Current Liabilities 85,815.00 60,817.00 54,841.00 19,063.00 10,767.00 Short Term Provisions 918.00 1,268.00 1, 170.00 4,854.00 4, 167.00 Total Current Liabilities 190,647.00 152,826.00 125,022.00 91,301.00 95,566.00 Total Capital And Liabilities 617,525.00 546,746.00 457,720.00 397,785.00 367,583.00 ASSETS NON-CURRENT ASSETS Tangible Assets 191,879.00 145,486.00 91,477.00 79,778.00 80,368.00 Intangible Assets 9,085.00 9,092.00 39,933.00 34,785.00 29,038.00 Capital Work-In-Progress 92,581.00 128,283.00 97,296.00 65, 178.00 32,673.00 Intangible Assets Under Development 6,902.00 4,458.00 9,583.00 10,575.00 9,043.00 Fixed Assets 300,447.00 287,319.00 238,289.00 190,316.00 151, 122.00 Non-Current Investments 171.945.00 140.544.00 112.630.00 62.058.00 52.692.00