Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please help on the calculation What is the r and t value How is PVTV and WACC calculated(for calculating the intrinsic value by
Can you please help on the calculation What is the r and t value How is PVTV and WACC calculated(for calculating the intrinsic value by DCF method)
Balance Sheet | ||||||||||||
Maruti Suzuki India | ||||||||||||
Standalone Balance Sheet | ------------------- in Rs. Cr. ------------------- | |||||||||||
Mar 16 | Mar-17 | Mar-18 | Mar-19 | Mar-20 | Mar 21 | |||||||
|
| 12 mths | 12 mths | 12 mths | 12 mths | 12 mths | ||||||
| ||||||||||||
SHAREHOLDER'S FUNDS | ||||||||||||
Equity Share Capital | 151 | 151 | 151 | 151 | 151 | 151 | ||||||
Total Share Capital | 151 | 151 | 151 | 151 | 151 | 151 | ||||||
Reserves and Surplus | 29,733.20 | 36,280.10 | 41,606.30 | 45,990.50 | 48,286.00 | 51,215.80 | ||||||
Total Reserves and Surplus | 29,733.20 | 36,280.10 | 41,606.30 | 45,990.50 | 48,286.00 | 51,215.80 | ||||||
Total Shareholders Funds | 29,884.20 | 36,431.10 | 41,757.30 | 46,141.50 | 48,437.00 | 51,366.80 | ||||||
NON-CURRENT LIABILITIES | ||||||||||||
Long Term Borrowings | ||||||||||||
Deferred Tax Liabilities [Net] | 194.3 | 466.2 | 558.9 | 564 | 598.4 | 384.7 | ||||||
Other Long Term Liabilities | 807.5 | 1,105.00 | 1,585.30 | 2,036.50 | 2,170.30 | 2,164.50 | ||||||
Long Term Provisions | 14.8 | 21.9 | 26.5 | 39.5 | 51.6 | 44.7 | ||||||
Total Non-Current Liabilities | 1,016.60 | 1,593.10 | 2,170.70 | 2,640.00 | 2,820.30 | 2,593.90 | ||||||
CURRENT LIABILITIES | ||||||||||||
Short Term Borrowings | 77.4 | 483.6 | 110.8 | 149.6 | 106.3 | 488.8 | ||||||
Trade Payables | 7,407.30 | 8,367.30 | 10,497.00 | 9,633.00 | 7,494.10 | 10,161.70 | ||||||
Other Current Liabilities | 3,155.60 | 3,926.50 | 4,274.30 | 3,743.30 | 3,014.80 | 4,714.60 | ||||||
Short Term Provisions | 398.9 | 449 | 560 | 624.4 | 679.6 | 741.6 | ||||||
Total Current Liabilities | 11,039.20 | 13,226.40 | 15,442.10 | 14,150.30 | 11,294.80 | 16,106.70 | ||||||
Total Capital And Liabilities | 41,940.00 | 51,250.60 | 59,370.10 | 62,931.80 | 62,552.10 | 70,067.40 |
ASSETS | ||||||
NON-CURRENT ASSETS | ||||||
Tangible Assets | 12,163.10 | 12,919.70 | 13,047.30 | 14,956.70 | 15,374.50 | 14,732.80 |
Intangible Assets | 346.9 | 373 | 311.7 | 451.1 | 335.8 | 224.2 |
Capital Work-In-Progress | 1,006.90 | 1,252.30 | 2,125.90 | 1,600.10 | 1,337.40 | 1,192.30 |
Intangible Assets Under Development | 0 | 0 | 0 | 70.9 | 297.5 | |
Fixed Assets | 13,516.90 | 14,545.00 | 15,484.90 | 17,007.90 | 17,118.60 | 16,446.80 |
Non-Current Investments | 18,875.40 | 26,302.20 | 34,072.90 | 31,469.50 | 35,248.80 | 33,371.00 |
Long Term Loans And Advances | 0.4 | 0.3 | 0.2 | 0.2 | 0.2 | 0.2 |
Other Non-Current Assets | 1,701.30 | 1,626.90 | 1,890.70 | 2,092.60 | 1,757.10 | 1,722.70 |
Total Non-Current Assets | 34,094.00 | 42,474.40 | 51,448.70 | 50,570.20 | 54,124.70 | 51,540.70 |
CURRENT ASSETS | ||||||
Current Investments | 1,056.80 | 2,178.80 | 1,217.30 | 5,045.50 | 1,218.80 | 8,415.70 |
Inventories | 3,132.10 | 3,262.20 | 3,160.80 | 3,325.70 | 3,214.90 | 3,050.00 |
Trade Receivables | 1,322.20 | 1,199.20 | 1,461.80 | 2,310.40 | 1,974.90 | 1,276.60 |
Cash And Cash Equivalents | 42.2 | 13.8 | 71.1 | 178.9 | 21.1 | 3,036.40 |
Short Term Loans And Advances | 147.8 | 2.5 | 3 | 16 | 16.9 | 23 |
OtherCurrentAssets | 2,144.90 | 2,119.70 | 2,007.40 | 1,485.10 | 1,980.80 | 2,725.00 |
Total Current Assets | 7,846.00 | 8,776.20 | 7,921.40 | 12,361.60 | 8,427.40 | 18,526.70 |
Total Assets | 41,940.00 | 51,250.60 | 59,370.10 | 62,931.80 | 62,552.10 | 70,067.40 |
Free Cash Flow to Firm | Mar-16 | Mar-17 | Mar-18 | Mar-19 | Mar-20 | Mar-21 |
EBIT (Profit after Tax +Finance Cost) | 7,525.20 | 10,049.70 | 11,349.10 | 10,541.40 | 7,197.70 | 5,260.20 |
EBIT x (1-t) = (EBIT x (1-.34)) | 4966.632 | 6632.802 | 7490.406 | 6957.324 | 4750.482 | 3471.732 |
(+) Depreciation and Amortisation | 2,820.20 | 2,602.10 | 2,757.90 | 3,018.90 | 3,525.70 | 3,031.50 |
(-) Capital Expenditure | 3,630.20 | 3,697.80 | 4,541.90 | 3,636.40 | 2,359.70 | |
(-) Change in Working Capital | -3,193.20 | -4,450.20 | -7,520.70 | -1,788.70 | -2,867.40 | 2,420.00 |
Free Cash Flow | 10,054.90 | 14,071.21 | 7,223.02 | 7,507.18 | 1,723.53 | |
Growth Rate | 39.94% | -48.67% | 3.93% | -77.04% | ||
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