0% found this document useful (0 votes)
9 views12 pages

Calculation Sheet

The document provides financial data on various companies, including their debt, EBITDA, and debt-to-equity ratios. It highlights trends in different sectors, indicating varying levels of debt and stability across industries. Additionally, it notes macro trends such as increased digital investment and competition in sectors like automotive and retail.

Uploaded by

nsurywanshi822
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views12 pages

Calculation Sheet

The document provides financial data on various companies, including their debt, EBITDA, and debt-to-equity ratios. It highlights trends in different sectors, indicating varying levels of debt and stability across industries. Additionally, it notes macro trends such as increased digital investment and competition in sectors like automotive and retail.

Uploaded by

nsurywanshi822
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 12

Debt

Softbank 5962152
EBIDTA
Tokyo Electron Technology SolutionsLimited 770775

Hitachi Construction MachineryOceania Holdings Pty Ltd 610423

Hino Motors Manufacturing U.S.A, Inc. 422471

Rakuten Debt/Equity
4.62
Negative Ebit margin -0.38%

Sector/Vertical/Industry debt/EBIDTA
IT 1x
Healthcare 1-2x
Electronics 1.5x
Retail 2-3x
Automative 1-1.5
Telecom 2-3x
Real/estate 4-5x
Airlines 4-5x
E comm., chemical 10x
Ebidta D/E Ratio
1707657
26.09% EBIT
759586

231838

163762

Debt/Ebidta
17.01

risk Stability
Low stable
Low stable
Low stable
Moderate stable
Top companies are good/ Mid size face cash crunch stable
Moderate stable
mod-high stable
Moderate Suitable for FP
High Investment Negative
Equity
4265371
14,66%
1855206

857952

251018

EBIDTA Margin
13-14%
23-25%
15
5-8%
10
25-30
10
20
Negative

EBIDTA
EBIDTA margin
EBIT
DEBT
D/E
Account payable

EBIDTA
EBIT
Interest paid
Total debt repaid
A/P
Cogs

Ebidta
ebit
Debt Paid
interest
Revenue
Total debt
AP
COGS
A/C days

Company
Hitachi
IDEC
Mitshubshi
Honda
Sony
Makita
NSW
NEC
Kyocers
Mazda
Microsoft
Terumo
Mitsubihi Electric
Hino
Nishimoto
Softbank
Interest expenses
482111

Macro Trend
Increase in digital/IT budget
Booming, Digital infra.

Price war.especially fashion, food


High investment in electrification Toyota strong but nissan and mitsubishi weak
High capital investment

High debt,competition

Nissan Motors
25
766809
6.07%
0.55
4369888
5.69879591919239
69.0769049568669
2070387
10939854

25
13.26
-0.38
73341
958,066
465121
1987136

Sumitomo Corporation

25
8.56%
5.55%
598765
67188
7292084
2674690
1822237
5847329
113.74706383034

Account payable
1572764
3784
2879696
1663487
2100144
54628
3174
492833
207029
473851
26250
91029
601978
235221
19244
3,036,349
Current Assests Current liabilities Debt/Ebidta
9432918 12601670 3.49142245778865
Good
1800756 677925 1.01473039260861

1000755 613256 2.6329721615956

836177 1227162 2.57978651946117

24 23
920402 712351
7.26 6.72
4.48 3.56
1730676 1540671
1.8803479349 2.16279755345328
24 23
12.7 6.02
-1.19 -8.46
56784 36889
1,837,314

85.4340945964

24 23
7.77% 7.90%
6% 6.21%
548577 486665
71713 46483
6910302 6817872
2456547 2466733

Cogs A/P days Debt Ebidta


6962527 82.4497858320693
37943 36.4009171652215
16781207 62.6348891352094
17024788 35.6640420426968
8504810 90.1316502073533
481704 41.3930961752446
39518 29.3160078951364
2362875 76.1293106914247
1455280 51.9251175031609
3940700 43.8895665744665
83501 114.744134800781
475501 69.8749003682432
3829496 57.3762108643017
1401522 61.2588778485104
260029 27.012602440497
3,489,549 317.5961664387
Current ratio Intrest coverage Debt/Equity
0.748545073787839 1.3978038487
should more than 1 4-5 is good above 2 is bad
2.66 0.4154659914

1.63 0.7114885215

0.82 1.68303069899

You might also like