Financial Analysis and Valuation of SolarTek

The assignment provides a comprehensive analysis of SolarTek's financial performance, including calculation of key financial metrics such as FCF, Terminal Value, and Present Value. Additionally, it compares the company's valuation using different multiples methods like P/E, EV/EBITDA, P/BV, and Market Capitalization/Revenue. The report concludes that raising incremental funding through debt is preferable to equity in order to achieve an optimum capital structure.

Finance For Business
STUDENT ID:
[Pick the date]

Question 1
a) The formula for Free Cash Flow or FCF is as indicated below.
Input Value Computation
Forecasted EBIT for 2016 = $271,415
Forecasted EBIT for 2017 = $284,986
Tax rate = 35%
Forecasted Depreciation for 2016 = $144,360
Forecasted Depreciation for 2017 = $157,640
Net working capital = Current Assets – Current Liabilities
Forecasted net working capital for 2015 = 354357 – (103445+280000) = - $29,088
Forecasted net working capital for 2016 = 392464 – (115859+260000) = $16,605
Forecasted net working capital for 2017 = 435144 – (129762 + 240000) = $65,382
Change in working capital for 2016 = (16605-(-29088)) = $45,693
Change in working capital for 2017 = (65382- 16605) = $48,777
Capital expenditure in 2016 = Gross property & Equipment in 2016 - Gross property &
Equipment in 2015 = 2887180 – 2634240 = $ 252,940
Capital expenditure in 2017 = Gross property & Equipment in 2017 - Gross property &
Equipment in 2016 = 3152770 - 2887180 = $ 265,590
Computation of FCF
Using the computed input values, the requisite FCF can be computed as shown below.
Estimated FCF for 2016 = 271415(1-0.35) + 144360 – 45693 – 252940 = $22,146.75
Estimated FCF for 2017 = 284986(1-0.35) + 157640 - 48777 - 265590 = $28,513.9
Computation of Terminal Value

Estimated FCF for 2017 = $28,513.9
Perpetual growth rate after 2017 = 3% per annum
WACC = 6.5%
Hence, terminal value = 28513.9*(1+0.03)/(0.065-0.003) = $839,123.3
b) In order to find the present value of the firm, the future FCF need to be discounted using
the given WACC.
FCF 2013 = $43,000, FCF 2014 = $75,000, FCF 2015 = $82,000, FCF 2016 = $96,000
FCF 2017 = $112,000 & Terminal value = $2,100,000
Also, WACC = 6.5%
Hence, value of firm in 2012 = (43000/1.065) + (75000/1.0652) + (82000/1.0653) +
(96000/1.0654) + (112000/1.0655) + (2100000/1.0655) = $ 1,863,503
Outstanding shares in 2012 = 50,000
Hence, per share equity value = 1863503/50000 = $37.27
c) The various multiples that can be applied in the given case are P/E, EV/EBITDA. P/BV
and Mcap/Revenue.
 P/E Multiple
Based on the given data for the comparable firms, the P/E multiple is computed as
captured in the table shown below.
For the computation of average P/E, Southwest Solar is not considered owing to negative
value of EPS. However, this method is not suitable for SolarTek considering that in 2012,
the company incurred a loss and had a negative EPS.
 Price/Book Value or P/BV
The P/BV of the various comparable firms in 2012 is summarised below.

Hence, intrinsic price per share for SolarTek in 2012 = 2.76*(621670/50000) = $34.33
 Market Capitalization/Revenue or Mcap/Revenue
The Mcap/Revenue of the various comparable firms in 2012 is summarised below.
Hence, market capitalisation of SolarTek in 2012 – 0.55*1840720 = $1,010,427
Shares outstanding = 50,000
Intrinsic value per share for SolarTek in 2012 = 1010427/50000 = $20.21
 EV/EBITDA
This method would not be useful for the valuation of Solartek since in 2012 the company
has a negative EBITDA.
Conclusion
In order to compute the fair price of SolarTek share, it would be prudent to take the average
of the fair price of the share determined through various multiples method.
Fair value of SolarTek share in 2012 = (34.33+20.21)/2 = $ 27.27
Question 2
a) The computation for A/R DSO, AP DO and INV DOH for 2013 is as highlighted below.
The forecasted income statement & balance sheet for 2013 along with requisite explanation is
as indicated below.

b) The forecasted balance sheet if the incremental funding was raised through equity is as
shown below.

It is apparent that in the given case, all the additional funding has been obtained from
incremental equity and no use of line of credit or debt has been done.
c) For the given situation, it would be preferable to raise incremental money through debt
and not through equity. The primary reason is because the current debt level on the
company’s balance sheet is very low and hence the company should raise additional debt
to reach an optimum capital structure. Besides, this would also allow for lower tax outflow
owing to the higher interest cost. Also, the business of the company is expanding and the
cash flows are quite healthy for servicing debt. Further, raising money through debt also
prevents equity dilution and allows the current promoters to maintain control.