Comparable Analysis for Electric Car Market Worksheet For the second table in the assignment 3, please output as excel table like the picture shows . Runni

Comparable Analysis for Electric Car Market Worksheet For the second table in the assignment 3, please output as excel table like the picture shows . Running Head: COMPARABLE ANALYSIS FOR ELECTRIC CAR MARKET
1
Comparable Analysis for Electric Car Market
Qiansen Gong
Comparable Analysis for Electric Car Market
Brand
name
Electric
Brands
From
China
Dongfen
g
Model
name
average
price
Standard
charging
time
Range
Maximu
m power
Maxi
Battery battery
mum
cathod pack
torque e type
(kwh)
Supplier
Jun
Feng
ER30
SKIO
Price
before
incentive
s begin at
149
800.00 ¥
The battery
takes
2-3
hours by fast
charging and
6-8 Hours by
standard
The batter
delivers a
range of
159 miles
It
produces
60
kW
equivalen
t to 80 hp
The
car has
a
torque
of 200
N.m or
Dongfeng
venture
with
Zhejiang
as
suppliers
The
vehicle
has a
Lithium
-iron
phosph
The car has
a battery
pack of a
31.82
kWh batter
y
COMPARABLE ANALYSIS FOR ELECTRIC CAR MARKET
BAIC
BAIC
EC3
The price
begins at
151,800.
00
¥
before
incentive
s
Roewe A
uto
Roewe
RX5
eMAX
500
The price
before
incentive
s starts at
235
800.00 ¥
FAW
FAW
CA700
5EV4
The price
begins at
$3000
Electric
Brands
from the
USA
Nissan
Nissan
ESflow
The cost
of the car
ranges
between
charging
(Wang,
2017).
The battery
will take 9
hours
to
make it full
while using
the onboard
charger while
it can charge
up to 80% in
40 minutes
when using a
fast charger
The battery
is full after
charging for
7 hours using
the standard
charger.
Using
the
fast charger
can charge
the battery
for
40
minutes up to
80%
complete.
Charging for
an average
between 7 to
nine
hours
will make the
battery full.
The car has a
standard
charging
time of
2
147.5
lb.ft
torque
The
The
engine
car has
produces a
45
kW torque
equivalen of 150
t to 60 hp N.m or
power.
110.6
lb.ft
torque.
ate
battery
type
Lithium The car has BAIC
battery a battery Group
type
pack
capacity of
30.7 kWh
battery.
The batter
delivers a
range of
44 miles
when it is
full.
The
engine
produces
124 kW
equivalen
t to 166
hp
power.
The
engine
genera
tes
250
N.m or
184
lb.ft
torque.
The car
uses a
Lithium
battery
type.
The
battery
can
last
for more
than
50
miles
when full.
The
engine
produces
35 kW or
48
hp
power.
The
engine
genera
tes
130
N.m.
The car The battery
uses
pack
is
lithium 12kWh
battery
type
(FAW
Electric
al Car,
2020).
China
First
Automobil
e Group
Corporatio
n
Nissan
ESflow
can cover
a range of
The
maximu
m power
of the
The
car
deliver
s 187
The car
has a
Lithium
-ion
The
Nissan
motor
company
The batter
delivers a
range of
188 miles
when it is
full
(Muniz,
2019).
The vehicle Roewe of
has
a SAIC
battery
Motor
pack of a
16.6 kWh
battery.
The car has
a battery
pack of 40
kwh.
COMPARABLE ANALYSIS FOR ELECTRIC CAR MARKET
34000
and
40000 us
dollars.
Chevrolet Chevrol The price
et volt
of a
Chevrolet
volt is
between
23700
and
27500
US
dollars.
Tesla
Model
Model S
S
costs
between
80000
and
100000
US
dollars.
around 12
hours.
150 miles.
vehicle is
80 kW.
The Model
can charge
for about 13
hours using a
120-volt
charger.
The car
can
deliver an
estimate
of 53
miles.
The peak
power
ranges
around
130 to
140 kW.
The current
charging
period for
Model S is
10 hours.
The range
coverage
of models
is about
402 miles.
The
vehicle
has a
lithiumion battery
with a 100
kwh
range.
The car
has a
maximu
m power
of
350kW.
3
poundfeet to
power
its
engine
.
The
maxim
um
torque
is 294
poundfeet.
mangan
ese
oxide
cathode
.
limited
supplies
Nissan
ESflow.
The car
has a
lithiumion
cathode
battery
type.
The car has
a battery
pack
capacity of
16 kwh.
Chevrolet
General
Motors
are
suppliers
of
Chevrolet
volt.
The
vehicl
e has
an
estima
te of
553
ponds
feet
maxim
um
torque.
The
vehicle
uses a
single
crystal
cathode
battery.
The battery
pack
ranges
between 60
and 90
kwh.
Tesla
incorporat
ed the
supplies
Model S
electric
vehicles.
2. Relative Valuation Models
Company info
Market data
Dongfeng. The stock
ticker of the company The company has a
is $4.97
market cap of 5.52B,
and its EV is 5.67B.
The net debt is 18
643M CNY
Financial data
Profitability
margins
The EBITDA is
1.36%, EBIT is 1.37%. The net
income percentage is
12.72%
The sales for 2019
were $377,349 and
an
EBITDA
of
$0.408B. The EBIT
is $86.727M, while
the net income for
the company is
1,846.6M.
BAIC Group. The The price of the The
sales
were The EBITDA
ticker is 3.58 HKD
company is $8.83. $286,343B by 2019, 16.13%, EBIT
Valuation
The EV/SALES of
the
company
is
135,0x.
The
EV/EBITDA
is
11,6x, while the P/E
ratio is 3,4x.
is The EV/SALES of
is the company is 0,43x.
COMPARABLE ANALYSIS FOR ELECTRIC CAR MARKET
SAIC Motor and the
ticker is 18.56 CNY
China
First
Automobile
Group
Corporation and the
ticker is 13.77 CNY.
Nissan Motor
Company has a ticker
of 440 JPY.
Chevrolet General
Motors. Company has
a ticker of 26.45 US
dollars.
Tesla Inc.
The stock price of
Tesla Inc. is 1500.84.
The market cap is and it has an
3.70B, and its EV is EBITDA
of
$
3.89B.
31,443.36M.
The
The net debt is EBIT
of
the
$9,120M
company is 22.788
B. The net income is
$4.50B
The price per share is The sales recorded
$18.56. The market are USD 128.81
cap is 216.85B, and billion, and it has an
its Enterprise Value EBITDA
of
is $159.60 (Deng, $24,595M.
The
2019). The net debt EBIT is 33,914M,
of SAIC is $6,424M
while net income for
2019 was 25,603M.
The price is $6.100. The sales value is
The market cap is $26.34B, and it has
EBITDA
of
91.893B, and the EV an
The
is ¥13.77. The net $12,592.6M.
EBIT
is
16,720M.
debt 54,720.61M
The net income is
$52.77M
The price per share is The current sales
8.6 million dollars.
were 9878866
The EV of the
million dollars. The
company is
company’s EBITDA
76600424, and the
is 343647, and EBIT
company’s net debt is is 40469. The net
6264999 million
income is 105
(Khillari, 2020). The million dollars.
market capacity is
1.86 trillion dollars.
The company’s
The sales are about
market capacity is
432422 million
38.424 billion, and
dollars. EBITDA is
EV is 784 million
19599 dollars, EBIT
dollars. The price per is 5481 dollars. The
share of Chevrolet is EV/EBITDA is 3.03
26.45 US dollars. The billion dollars. Net
net debt is 71 million income is 6.732
dollars.
billion dollars.
The firm has a market The current
capacity of 278.21
EBITDA is 2985
million dollars, and
million dollars, and
The price per share is EBIT is 5214
0.36 million dollars.
million dollars. The
4
13.14%. The net The EV/EBITDA is
income percentage is 2.7x while P/E ratio
1.81%
is 10,1x
In
terms
of
profitability,
EBITDA is 2.06%,
while
EBIT
is
0.89%. The net
Income percentage
is 19.8%.
The EV/SALES of
the company is 0,23x.
The EV/EBITDA is
4.34x, while the P/E
ratio is 9,85x.
The EBITDA is
47.8%, the EBIT is
63.5%, and the net
income percentage is
0.2%
The EV/SALES of
the company is 0.6.
The EV/EBITDA is
111.23. The P/E is
113.90
The EBITDA is 679%, while the
EBIT is -0.41%. The
net income % is
1062.9.
The EV/EBIT is
318224 million
dollars, and the
EV/EBITDA is
703961 million
dollars.
The firm’s EBIT is
3.0%, and EBITDA
is 7.6%. the net
income % is 1556.8
The firm has an
EV/EBIT of 3.84 and
EV/EBITDA of
21.22. The price per
earnings ratio is 10.
8X.
The company’s net
margin is 0.27%.
The EBIT is -0.28%,
whereas the
EBITDA is 3.6%
The price/ earnings
are 305.05X. The
EV/EBITDA is
92.02, and the
EV/EBIT is 11.48.
COMPARABLE ANALYSIS FOR ELECTRIC CAR MARKET
The company’s net
debt is one billion
dollars. The
company’s Enterprise
Valuation is 82533
million US dollars.
company’s net
income is 24.6
billion. The sales are
482778million
dollars.
5
and, the net income
% is 0.479.
References
Deng, X., & Wang, Y. (2019, September). Analysis of Financial Value of Relationship Capital—
A Case Study of SAIC Motor. In 2019 3rd International Conference on Education,
Management Science and Economics (ICEMSE 2019). Atlantis Press.
FAW Electrical Car. (2020). Retrieved from http://auto-che.com/v/ca/ca7005ev4-270-faw.html
Khillari, S. (2020). Electric Vehicle Market| Growth, Trends and Forecast Report, 2026.
COMPARABLE ANALYSIS FOR ELECTRIC CAR MARKET
6
Muniz, S. T. G., Belzowski, B. M., & Zhu, J. (2019). The trajectory of China’s new energy
vehicles policy. International Journal of Automotive Technology and Management, 19(34), 257-280.
Wang, J. (2017). This is the new Dongfeng Junfeng EJ30 electric sedan. CarNewsChina.
Retrieved
from
electric-sedan/
https://carnewschina.com/2017/11/21/new-dongfeng-junfeng-ej30-
Valuation
EV/Sales EVEBITDA EVEBIT
PIE
x
?
X
?
22.8%
Company Name
The Coca-Cola Company
Pepsico, Inc.
Dr Pepper Snapple Group, Inc
Monster Beverage Corporation
National Beverage Corp
Market Data
Price Market Cap
(S/share) (SM
38.14 168,041
81.37 123,883
5231 10,326
69.62 11,618
20.81 964
TEV
(SM
185,122
143,824
12,764
11,004
968
Financial Data
Sales EBITDA EBIT Earnings
(SM ($M (SM (SM
46,854 13,104 11,127 7,381
66,415 12,344 9,878 5,618
5,997
1,319 1,103
2246 606 584 357
645 78 66 41
4.0x
22x
21x
4.9%
15x
14.1x
11.7x
9.7x
18.1x
620
16.6%
14.6%
11.6%
18.9%
14.6%
22. 1x
16.7x
32.5x
12.5%
23.5x
13.2x
15.3x
23.5x
Average
Median
2.9x
2.2x
12.5x
14.6x
22.8x

Purchase answer to see full
attachment