Question
Question 3.)Compute the ratios of long-term debt-to-book equity and long-term debt-to-market value equity in the Excel file. The ratios need to be traced to the
Question 3.)Compute the ratios of long-term debt-to-book equity and long-term debt-to-market value equity in the Excel file. The ratios need to be traced to the data you collected in question 2). Recall to convert the data to a common unit (e.g., billions or millions) before computing the ratios. Use two decimals for the ratios. 3 pts
(please provide equations if possible)
3.)
| Book value | ||||||
| Long-term debt/total common equity | ||||||
| 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | |
| GOOGL | ||||||
| Market value | ||||||
| Long-term debt/total common equity | ||||||
| 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | |
| GOOGL | ||||||
(from questions 2 below)
| Long-term debt (million) | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 |
| GOOGL | $ 3,935 | $ 3,969 | $ 4,012 | $ 4,554 | $ 13,932 | $ 14,817 |
| Total market cap (billion) | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 |
| GOOGL | $ 539.06 | $ 729.45 | $ 723.45 | $ 921.13 | $ 1,190.00 | $ 1,920.00 |
(not sure if you need the balance sheet or not)
(Income Statement)
Thank you in advance.
Step 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
Financial Accounting Impact On Decision Makers
Authors: Gary A. Porter, Curtis L. Norton
7th Edition
1111464936, 978-1111464936
