Question
2. Find the FCF and calculate the value of the company under the assumption of zero growth. Using the most recent 5 years 3. Using
2. Find the FCF and calculate the value of the company under the assumption of zero growth. Using the most recent 5 years
3. Using the Excel function PRICE, find what is the price of the bond and compare it with the price that appears on the YAS screen when you print it. Discuss the result.
4. Export the following profitability ratios (from Bloomberg) to an Excel spreadsheet and interpret them (the return on common equity, EBITDA margin (EBITDA/REVENUE), and return on invested capital). What are the dynamics of these ratios over the years?
Bond date is: 04/01/2060
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & lillions of USD except Per Share & 2014 Y & 2015Y & 2016 Y & 2017 Y & 2018 Y & 2019 Y & 2020Y & 2021 Y & 2022 Y & 2023 Y \\ \hline & lonths Ending & 01/26/2014 & 01/25/2015 & 01/31/2016 & 01/29/2017 & 01/28/2018 & 01/27/2019 & 01/26/2020 & 01/31/2021 & 01/30/2022 & 01/29/2023 \\ \hline III & \begin{tabular}{l} Returns \\ Return on Common Equity \end{tabular} & 0.48 & 14.22 & 1387 & 3257 & 4605 & 4026 & 2505 & 2078 & 4483 & 17.93 \\ \hline & Return on Assets & 6.44 & 8.73 & 8.43 & 19.36 & 28.91 & 33.76 & 18.27 & 18.79 & 26.73 & 10.23 \\ \hline & Return on Capital & 8.40 & 11.49 & 11.06 & 23.57 & 34.40 & 40.26 & 21.74 & 22.87 & 31.67 & 12.61 \\ \hline & Return on Invested Capital & 7.91 & 11.09 & 10.86 & 23.88 & 33.61 & 39.45 & 21.20 & 23.17 & 31.95 & 12.75 \\ \hline & Margins & & & & & & & & & & \\ \hline & Gross Margin & 54.92 & 55.51 & 56.11 & 58.80 & 59.93 & 61.21 & 61.99 & 62.34 & 64.93 & 56.93 \\ \hline & EBITDA Margin & 17.80 & 20.91 & 18.84 & 30.69 & 35.09 & 34.70 & 30.60 & 34.63 & 42.29 & 22.10 \\ \hline \end{tabular} NVDA $1480.100.78 nat Q480.0/480.17( 12 Weighted Average Cost of Capital Page 1/13 Security Description: BondStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started