The company is Johnson and Johnson (years 2017-2023)
a template is attached , filling out that well can work too (but must be adjusted)
calculations and excel should not be too professional, just a basic one. But beta, WACC, CAPM etc (given in the assignemnt description)must be calculated not taken from the internet and the way of calculation must be in the excel (formulas must be used)
word doc-essay not needed i did that
I only need the excel with the calculations
a. risk-and-return,
b. time value of money,
c. weighted-average cost of capital (WACC),
d. capital asset pricing model (CAPM),
e. economic value added (EVA),
• Conduct a discounted cash flow analysis (DCF) outlining the following items:
a. free cash flows (FCF),
b. net operating profit after tax (NOPAT),
c. capital expenditures (CAPEX),
d. net working capital (NWC),
e. return on net assets (RONA),
f. terminal value,
g. Beta calculation.
• Conduct a relative valuation using book and market multiples
a. earnings before interest and taxes (EBIT),
b. earnings before interest and taxes (EBITDA),
c. enterprise value (EV),
d. transaction multiples, and
e. potential liquidation value.
• Double check calculations with scenario and sensitivity analysis