FINANCIAL ANALYSIS MANAGEMENT & ENTERPRISE - FAME TABLE OF CONTENTS INTRODUCTION 1 Daimler's Horizontal Analysis of Statement of Financial Position

FINANCIAL ANALYSIS
MANAGEMENT &
ENTERPRISE - FAME

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
Ratio Analysis..............................................................................................................................1
Daimler's Horizontal analysis of statement of profit and loss.....................................................4
Daimler's Horizontal analysis of statement of financial position................................................5
Daimler's Vertical analysis of statement of profit and loss.........................................................7
Daimler's Vertical analysis of statement of financial position....................................................8
Tesla's horizontal analysis of statement of profit and loss.........................................................10
Tesla's horizontal analysis of statement of financial position....................................................11
Tesla's vertical analysis of statement of profit and loss.............................................................13
Tesla's vertical analysis of statement of financial position........................................................14
2. Analysing cash position of both organization........................................................................16
CONCLUSION..............................................................................................................................17
REFERENCES..............................................................................................................................18
APPENDIX....................................................................................................................................19

INTRODUCTION
Financial analysis is considered as process for business evaluation, budgets, projects
along with other entities on basis of finance. The present report will give brief discussion about
financial performance of Daimler and Tesla with context of ratio analysis, horizontal and vertical
analysis of their financial position. It will articulate about cash position of these specified
business entities.
Ratio Analysis
Liquidity
Ratio Formula 2014 2015 2016 2017
Daimler
Current
Ratio
Current
Asset/
Current
Liability 1.152 1.192 1.208 1.225
Tesla 1.518 0.991 1.074 0.856
Daimler Quick ratio
(Current
asset-
Inventory-
prepaid
expenses)/C
urrent
Liability 0.836 0.878 0.901 0.923
Tesla 1.020 0.493 0.686 0.526
Interpretation: The above table is reflecting comparison of Daimler and Tesla on basis of
liquidity of year 2014 to 2017 with context to current and quick ratio.
Current Ratio: The ideal ratio is of 2:1 which says organization has sufficient current
assets to repay its current liabilities. Daimler was not capable to reach idle ratio in duration of 4
years but it was constantly increasing from year to year. On the contrary, Tesla's liquidity
position was not good and it was decreasing in every year.
Quick Ratio: This ratio is all about quick assets as they must be sufficient of repaying
short term obligations in short duration. In year 2014, Tesla was having enough quick assets but
1

as time passed, it started decreasing. However, Daimler was not meet appropriate situation in any
year but it was improving from year to year.
Profitability
Ratio Formula
2014 2015 2016 2017
Daimler
Gross profit
ratio
(Gross
Profit/
Sales)*100 21.701 21.274 20.855 20.891
Tesla 27.580 22.837 22.843 18.896
Daimler
Return on
Asset (ROA)
Net profit/
Total Assets 0.037 0.039 0.035 0.041
Tesla -0.050 -0.110 -0.030 -0.068
Daimler
Return on
capital
employed
(ROCE)
Net
operating
profit/
Capital
employed) 0.077 0.090 0.076 0.077
Tesla -0.050 -0.136 -0.040 -0.078
Daimler
Return on
Equity
(ROE)
Profit after
tax/ Net
worth 0.159 0.157 0.147 0.164
Tesla -0.322 -0.816 -0.142 -0.463
Interpretation: The above table is representing profitability position of both organization
with reference to gross profit, return on asset, return on capital employed along with return on
equity. With reference to gross profit, in year 2014 Tesla had huge margin but it decreased in
huge proportion to year 2017. Consequently, Daimler had gained less margin and reduced also
but not with high proportion as it was approximate stable till year 2017. It is clearly viewed that
Daimler is performing in efficient aspect on basis of ROE, ROCE and ROA because Tesla is
giving negative outcome. Further, it could be evaluated that Daimler's profitability is higher in
year 2014 to 2017.
2

Efficiency
Ratio Formula 2014 2015 2016 2017
Daimler
Asset
Turnover
Ratio
Net sales/
Average
total asset 0.725 0.735 0.666 0.659
Tesla 0.774 0.580 0.455 0.458
Daimler
Inventory
turnover
ratio
Cost of
goods sold/
Average
inventory 5.322 5.274 4.936 5.091
Tesla 3.58 2.80 3.23 4.40
Daimler
Days' Sales
in inventory
(Closing
stock/ Cost
of goods
sold)*365 74.889 73.701 76.383 72.119
Tesla 150.285 149.366 139.688 86.657
Interpretation: The above table is showing efficiency of both organization by
considering asset turnover, inventory turnover and days' sales in inventory. Daimler and Tesla
both are giving turnover on its asset but it is reducing from year to year. In year 2014, Tesla was
giving huge turnover and in 2015 they had raised sales as well but average total assets were also
increased in huge proportion which given decreasing impact on its asset turnover. Hence, in year
2017 Daimler has given 75% turnover on asset and Tesla as 45%.
On basis of inventory turnover, Daimler is maintaining constant time from year 2014 to
2016 such as approx 5 times. It is decreasing from year 2014 to 2016 but with context to Tesla its
is performing in good aspect. The turnover on inventory has raised but not with huge proportion
as it is improving but could not match Daimler.
In the similar aspect, Days sales in inventory shows days about writing off its stock
where minimum days are better. The inventory of Daimler could be written of in approx 75 days
and Tesla's stock in 150 days in year 2014. This position was stable in Daimler but Tesla had
tried for reducing it and in year 2017 it is 86 days.
3

Leverage
Ratio Formula 2014 2015 2016 2017
Daimler Debt ratio
total
liabilities/
Total asset 0.770 0.753 0.762 0.750
Tesla 0.844 0.866 0.790 0.852
Daimler Equity ratio
Total Equity/
Total Assets 0.230 0.247 0.238 0.250
Tesla 0.156 0.135 0.210 0.148
Daimler
Debt equity
ratio
Total
Liabilities/
Total Equity 3.344 3.055 3.193 2.992
Tesla 5.414 6.432 3.768 5.763
Interpretation: The above table is signifying leverage ratio of Daimler and Tesla with
reference to debt and equity ratio along with capital structure as well. Tesla is highly operating
with debt which is high risk as it is increasing from year. However, Daimler is not having huge
debt but its capital structure needs to be balanced then it will help for attaining success (Annual
report of Daimler, 2017).
Common size analysis
Daimler's Horizontal analysis of statement of profit and loss
2014
Percenta
ge
Change
2015
Percenta
ge
Change
2016
Percent
age
Change
2017
Total Revenue 129,872
.0 15.09%
149,467.
0 2.54% 153261 7.22%
164,33
0
Cost of Sales (101,68
8.0) 15.72%
(117,670
.0) 3.08% -121298 7.17% -129999
Gross Profit 28,184. 12.82% 31,797.0 31963 7.41% 34331
4