Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FY2015/16 FY2021/22 Non-Current Assets Intangible Assets 228,736,901.00 1,924,802,802.00 Property, Plant and Equipment 34,753,521,841.00 51,577,200,923.00 Right of Use (ROU) Assets - 2,350,871,626.00 Capital Work-in-Progress 4,785,453,311.00 5,992,992,703.00
FY2015/16 | FY2021/22 | |
Non-Current Assets | ||
Intangible Assets | 228,736,901.00 | 1,924,802,802.00 |
Property, Plant and Equipment | 34,753,521,841.00 | 51,577,200,923.00 |
Right of Use (ROU) Assets | - | 2,350,871,626.00 |
Capital Work-in-Progress | 4,785,453,311.00 | 5,992,992,703.00 |
Long Term Loan and Advances | - | 1,183,671,039.00 |
Investments | 6,637,096,522.00 | - |
Investment in Associates | 1,549,166,381.00 | |
Investment in Subsidiary | 248,888,900.00 | |
Equity Investments | 130,000,000.00 | |
Term Deposit and Investment in Debenture | 2,854,212,000.00 | |
Loan Investments | 13,934,401,507.00 | |
Employee Loan | 2,387,926,403.00 | 3,563,575,599.00 |
Deferred Tax Asset | 4,344,825,367.00 | 8,310,934,189.00 |
Contract Cost Assets | - | 413,762,897.00 |
Total Non-Current Assets | 53,137,560,345.00 | 94,034,480,566.00 |
Current Assets | ||
Inventory | 400,423,766.00 | 170,863,497.00 |
Prepayments and Advance Tax | 1,073,720,871.00 | 2,161,681,444.00 |
Employee Loan | 99,496,933.00 | |
Current Tax Assets (Net) | 1,659,444,288.00 | |
Loan, Advance & Others | 1,009,041,040.00 | 359,895,862.00 |
Trade Receivable | 2,930,810,266.00 | 2,320,933,080.00 |
Investments | 21,212,480,000.00 | 52,285,700,000.00 |
Cash & Cash Equivalents | 35,395,139,319.00 | 5,671,274,409.00 |
Total Current Assets | 62,121,112,195.00 | 64,629,792,581.00 |
Total Assets | 115,258,672,540.00 | 158,664,273,147.00 |
Equity and Liabilities | ||
Share Capital | 15,000,000,000.00 | 18,000,000,000.00 |
Reserve and Surplus | 71,027,877,334.00 | 77,268,042,053.00 |
Total Equity | 86,027,877,334.00 | 95,268,042,053.00 |
Non-Current Liabilities | ||
Post Employment Benefits | 6,492,981,105.00 | 19,873,844,972.00 |
Subscriber Deposit | 1,817,172,000.00 | 62,588,773.00 |
Deferred Government Grant | - | 861,019,990.00 |
Lease Liability | - | 2,228,248,150.00 |
GSM License Fee | 4,273,940,138.00 | - |
Total Non-Current Liabilities | 12,584,093,243.00 | 23,025,701,885.00 |
Current Liabilities and Provisions | ||
Lease Liability | 260,613,435.00 | |
Provisions | 2,272,746,335.00 | 12,723,287,671.00 |
Current Liabilities | 14,373,955,628.00 | 14,244,862,146.00 |
Trade Payable | 1,957,828,024.00 | |
GSM liscense fee renewal liability | 3,668,703,704.00 | |
Non-Financial Liabilities | 7,515,234,227.00 | |
16,646,701,963.00 | 40,370,529,208.00 | |
Total Equity and Liabilities | 115,258,672,540.00 | 158,664,273,147.00 |
INCOME | ||
Income from Services | 40,704,147,500.00 | 37,919,789,343.00 |
Finance Income | 5,907,401,115.00 | |
Other Income | 3,505,102,437.00 | 547,466,437.00 |
44,209,249,937.00 | 44,374,656,895.00 | |
Service operation and maintenaince cost | ||
Total Expenditure | 21,268,425,406.00 | 23,550,626,502.00 |
Net Profit Before Interest and Depreciation (EBITDA) | 22,940,824,531.00 | 20,824,030,393.00 |
Depreciation | 3,790,044,218.00 | 5,614,593,104.00 |
Finance Cost | 926,225,743.00 | 770,938,324.00 |
Ammortization | 1,151,449,373.00 | |
Impairment- net of reversal | 223,422,359.00 | |
Net Profit before Tax | 18,224,554,570.00 | 13,063,627,232.00 |
Provision for Income Tax | 4,543,396,704.00 | 4,592,893,320.00 |
Net Profit After Tax | 13,681,157,866.00 | 8,470,733,912.00 |
Ratio Analysis | ||
Liquidity Ratios | ||
Current Ratio | 3.73 | 1.60 |
Quick Ratio | 3.64 | 1.54 |
Asset Management Ratios | ||
Receivable Turnover Ratio | 13.89 | 16.34 |
Days Sales outstanding | 26.28 | 22.34 |
Inventory Holding Period | 20.69 | 8.83 |
Fixed Assets Turnover Ratio | 0.77 | 0.40 |
Total Assets Turnover Ratio | 0.35 | 0.24 |
Debt Management Ratios | ||
Equity Multiplier | 1.34 | 1.67 |
Liabilities to Assets ratio | 0.25 | 0.40 |
Debt Equity Ratio | 0.34 | 0.67 |
Interest coverage ratio | 20.68 | 19.73 |
Profitability Ratio | ||
Net Profit Margin | 0.34 | 0.22 |
Operating Profit Ratio | 0.47 | 0.36 |
Basic Earning Power | 0.17 | 0.09 |
Return on Assets | 0.12 | 0.05 |
Return on common equity | 0.16 | 0.09 |
Estimate working capital need of next fiscal year using above data.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started