Question

Upload File or can add clear full screen-shots instead , But no Pictures from mobile please

Q.4. You are an intern with an equity research organization. You have been given the task to project the values of certain income statement and balance sheet items for the next year (FY2020) for ABC Ltd (Your current time=0 is FY ending 2019). You have collected information about the historical income statement and balance sheet items. The historical information is provided in Table 1. Table 1 FY2016 PARTICULARS (All values in INR crores) Sales Revenue EBITDA Depreciation expense EBIT Interest ЕВТ Tax Net Profit FY2019 FY2018 FY2017 17273.00 15463.00 14789.00 12213.00 9385.00 10237.00 1811.00 745.00 645.00 10402.00 8640.00 9592.00 0.00 0.00 0.00 10402.00 8640.00 9592.00 2600.50 2160.00 2398.00 7801.50 6480.00 7194.00 13636.00 Not given Not given Not given Not given Not given Not given Not given Net PPE 17032.00 14522.00 13064.00 12813.00 Net PPE: Net Property Plant and equipment (Balance sheet item) 4.1. 4.2. Calculate the year-over- year (yoy) growth rate in Sales Revenue for (2016-2017, 2017-2018 and 2018-2019). Also calculate the average of the three growth rates and denote it as Sales growth rate [2] Calculate the EBITDA margin for three years (2019, 2018 and 2017). Also calculate the average of the EBITDA margin [2] Calculate the ratio Depreciation expense/Net PPE -1 for the three years (2019, 2018 and 2017). Calculate the average of this ratio of depreciation expense as a % of prior period Net PPE_[2] 4.3. 4.4. Calculate the corporate tax rate from the Table above and take an average of the three years. [1] 4.5. Calculate the Net PPE turnover ratio from the Table above for all the four years of data provided and take an average of the four years [1] 4.6. Project the Sales revenue for the FY2020 using the average growth rate in sales revenue 4.7. Project the EBITDA for the FY2020 using EBITDA margin average 4.8. Project the Depreciation expense for the year FY2020 using average Depreciation divided by NetPPER-1 [1] 4.9. Project the EBIT for the FY2020 using the projected values of EBITDA and depreciation_[i] 4.10. Project the Tax amount for the FY2020 using the tax % average calculated [1] 4.11. Project the Net Profit for the FY2020 4.12. Project the Net PPE figure for FY2020 ending using the average turnover ratio [1]

Answer 1

Sales Growth
Particulars	2016	2017	2018	2019
Sales	13636	14789	15463	17273
Growth		0.084555588	0.045574413	0.117053612
Average				0.082394538

Sales Growth = Current year sales - Previous Year sales / Previous Year sales

EBITDA Margin
Particulars	2016	2017	2018	2019
Sales (A)	13636	14789	15463	17273
EBITDA (B)	Not given	10237	9385	12213
EBITDA Margin (B/A)		0.692203665	0.606932678	0.707057257
Average				0.6687312

Depreciation Expense as % of Net PPE
Particulars	2016	2017	2018	2019
Net PPE (A)	12813	13064	14522	17032
Deprecaition (B)	Not given	645	745	1811
Depreciation% (B/A)		0.049372321	0.051301474	0.106329263
Average				0.069001019

Tax %
Particulars	2016	2017	2018	2019
EBT (A)	Not given	9592	8640	10402
Tax (B)		2398	2150	2600.5
Tax% (B/A)		0.25	0.248842593	0.25
Average				0.249614198

NET PPE Turnover
Particulars	2016	2017	2018	2019
Sales (A)	13636	14789	15463	17273
Net PPE (B)	12813	13064	14522	17032
Tax% (A/B)	1.06423164	1.132042254	1.064798237	1.014149836
Average				1.425073989

Net PPE in 2020 = Sales in 2020 / Average Net PPE Turnover = 18696.2/1.4241 = 13119.46

INCOME STATEMENT
PARTICULARS	AMOUNT	COMMENTS
Sales	18696.20085	Using sales growth
EBITDA	12502.73283	Using EBITDA Margin
Less:Depreciation	-1175.225356	Depreciation on 2019 NET PPE
EBIT	11327.50747
Less:Interest	0	same as previous years
EBT	11327.50747
Less Tax@24.9614%	-2827.506688	Tax as % of EBT
PAT	8500.000786