W5 Finc 23 hours
Week 1
| Instructions | ||||
| 1. The purpose of this template is to gather data that will be analyzed and discussed in your memorandum. Insert the name of the company below. Use the sample below to give you an idea of the type of response you should submit. | ||||
| 2. Risks of the company are disclosed in the annual 10-K Report section and generally located in Item 1A Risk Factors. Use the risks in the 10-K as your basis for your memorandum. You ONLY need two areas of risk. Hint: To easily find the 10K Report, Google the name of your company and 10K Report. Then, once in the report, you can use the find function to look for the word "risk." | ||||
| 3. While not a requirement, you can copy/paste the below MS Excel table as a picture to your memorandum to assist in your analysis and recommendations | ||||
| Sample Entry | ||||
| NVDA | ||||
| Name of Risk (e.g., supply chain, currency risk, interest rate risk, etc.) | Enter a brief descritpion of the risk mentioned in the 10K Report. Do you believe it is a strategic, financial operational, regulatory risk? | |||
| 1 | Manufacturing difficulties / Operational Risk | Redefine the nod naming to get away from the size and focus on efficiency and density. As a backup plan, use third-party foundries like TSMC or Samsung to make new generation chips, separate designs, and manufacturing plants. | ||
| 2 | Cybersecrity and privacy risk / Operational and Financial Risk | Educate every employee to alert of the phish emails, Create effective crisis response process, using new technologies like blockchain and AI security, and create backup servers of the cloud, working together with industries. | ||
| INSERT THE NAME OF YOUR COMPANY HERE | ||||
| Name of Risk (e.g., supply chain, currency risk, interest rate risk, etc.) | Enter a brief descritpion of the risk mentioned in the 10K Report. Do you believe it is a strategic, financial operational, regulatory risk? | |||
| 1 | Supply chain risk | According to the 10-k report, Tesla is facing supply chain risk. Tesla buys its parts globally from single sources direct suppliers, even without long-term contracts. This strategy puts the organization at risk of component shortages. Unexpected business changes, pricing changes, tariffs, and government regulations changes as a result of the Covid-19 pandemic's effects these circumstances include Trade and shipping disruptions are uncontrollable. Absence of any component will cause production delays | ||
| 2 | Operational risk | According to the report, Tesla may be unable to meet global delivery, sales, installation, vehicle charging, and service targets. Because cash investment and resources are involved, the risk involves financial operation risk. management. They are dealing with uncertainty because there is no guarantee that They will be able to increase sales, install products, and avoid cost overruns. | ||
| Devon Charles |
Week 2
| Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in Memo #2 submission. Insert the name of the company in the "INSERT COMPANY HERE." 2. The template intends for you to gather financial information that is readily available in multiple online financial resources. Part of the learning process is the data gathering exercise. Please take your time looking for it. Please use end of year ratios. 3. Ratios can be found from a variety of online financial resources, to include, but not limited to: Morningstar's, Yahoo Finance, Google Finance, Market Watch, Bloomberg, and many more. Sometimes it is as simple as Google: "What is Apple's revenue?" 4. Do not edit the table. Do not add extra ratios. More is not necessarily better - we are looking for quality over quantity. 5. You can also change the font size and the column widths. Keep the headings standard. 6. While not a requirement, you can copy/paste the Excel completed table as a picture in your memorandum template. | |||||||
| TESLA | NISSAN | ||||||
| Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast | Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast |
| Found on Income Statement | Report in Millions or % | Found on Income Statement | Report in Millions or % | ||||
| Revenue | 24.5M | 31.5M | 74.8B | Revenue | 7M | 11M | 73B |
| Operating Income | 1.9B | 6.5B | Operating Income | $-6.1B | $-4.2B | ||
| Net Income | -870 | 690M | 11.1B | Net Income | $-675M | $-1.9M | 1.2B |
Week 3
| Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in Memo #3 submission. Insert the name of the company in the "INSERT COMPANY HERE." 2. The template intends for you to gather financial information that is readily available in multiple online financial resources. Part of the learning process is the data gathering exercise. Please take your time looking for it. Please use end of year ratios. 3. Ratios can be found from a variety of online financial resources, to include, but not limited to: Morningstar's, Yahoo Finance, Google Finance, Market Watch, Bloomberg, and many more. Sometimes it is as simple as Google: "What is Apple's revenue?" 4. Do not edit the table. Do not add extra ratios. More is not necessarily better - we are looking for quality over quantity. 5. You can also change the font size and the column widths. Keep the headings standard. 6. While not a requirement, you can copy/paste the Excel completed table as a picture in your memorandum template. | |||||||
| YOUR COMPANY | NISSAN | ||||||
| Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast | Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast |
| Report in Millions or % | Report in Millions or % | ||||||
| P/E Ratio | 190 | 54.4 | 54.3 | P/E Ratio | 52.7 | 12.96 | 10.06 |
| EPS | 1.63 | 1.05 | 3.23 | EPS | -2.16 | 0.98 | 0.64 |
| Dividend per Share | 0 | 0 | 0 | Dividend Per Share | 0.03 | 0.05 | 0 |
| Growth Rate: Revenue % | 70.67 | 59.8 | 74.86 | Growth Rate: Revenue % | -18.68 | 1.45 | |
| Growth Rate: Net Income % | 665.46 | 219.8 | 11.19 | Growth Rate: Net Income % | -31.7 | -145.8 | -338.44 |
Week 4
| Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in Memo #3 submission. Insert the name of the company in the "INSERT COMPANY HERE." 2. The template intends for you to gather financial information that is readily available in multiple online financial resources. Part of the learning process is the data gathering exercise. Please take your time looking for it. Please use end of year ratios. 3. Ratios can be found from a variety of online financial resources, to include, but not limited to: Morningstar's, Yahoo Finance, Google Finance, Market Watch, Bloomberg, and many more. Sometimes it is as simple as Google: "What is Apple's revenue?" 4. Do not edit the table. Do not add extra ratios. More is not necessarily better - we are looking for quality over quantity. 5. You can also change the font size and the column widths. Keep the headings standard. 6. While not a requirement, you can copy/paste the Excel completed table as a picture in your memorandum template. | |||||||||||
| YOUR COMPANY | INSERT COMPETITOR USED IN DISCUSSION | ||||||||||
| Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast | Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast | ||||
| Report in Millions or % | Report in Millions or % | ||||||||||
| Market Capitalization (Market Cap) | 668.90B | 1.061T | 568.99B | Market Capitalization (Market Cap) | 21.24B | 18.90B | 13.95B | ||||
| Daily Trade Volume / Average Volume
tc={3E5A08BC-E732-0C49-9148-CF81EEBB3E10}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Use the daily information from whatever day you enter the data. It changes daily. Your information should look like: 12.7 Mil / 76.9 Mil |
73.496M | Daily Trade Volume / Average Volume
tc={F556DFD6-17B1-0D44-B7A9-2D2342C13A06}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Use the daily information from whatever day you enter the data. It changes daily. Your information should look like: 12.7 Mil / 76.9 Mil |
342.68 | 345.45 | |||||||
| Beta | 1.97 | Beta | 1.23 | 0.9742 | |||||||
| Operating Cash Flow
tc={C02C41DA-38FF-C14D-BD77-9FE50FDB786E}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Operating, Investing, Financing, CapEx, and FCF is found on the Cash Flow Statement |
tc={F556DFD6-17B1-0D44-B7A9-2D2342C13A06}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Use the daily information from whatever day you enter the data. It changes daily. Your information should look like: 12.7 Mil / 76.9 Mil |
5.943B | 11.497B | 16.03B | Operating Cash Flow
tc={B489DA7E-01B0-5D44-8E9C-5F55DB812CA1}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Operating, Investing, Financing, CapEx, and FCF is found on the Cash Flow Statement |
10.91B | 12.434B | 17.122B | |||
| Investing Cash Flow | (-3.132B) | (-7.868B) | (-5.84B) | Investing Cash Flow | (-6.52B) | (-3.47B) | (-0.480B) | ||||
| Financing Cash Flow | 9.973M | (-5.203M) | (-4.289B) | Financing Cash Flow | (-1.43B) | (-6.01B) | (-1.357B) | ||||
| Capital Expenditure | 3.232B | 6.514B | 1.803M | Capital Expenditure | 13.327B | 9.423B | (-656.52M) | ||||
| Free Cash Flow | 2.786B | 3.787B | 8.90B | Free Cash Flow | 8.466B | 3.678B | 389.59M |
Week 5
| Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in Memo #3 submission. Insert the name of the company in the "INSERT COMPANY HERE." 2. The template intends for you to gather financial information that is readily available in multiple online financial resources. Part of the learning process is the data gathering exercise. Please take your time looking for it. Please use end of year ratios. 3. Ratios can be found from a variety of online financial resources, to include, but not limited to: Morningstar's, Yahoo Finance, Google Finance, Market Watch, Bloomberg, and many more. Sometimes it is as simple as Google: "What is Apple's revenue?" 4. Do not edit the table. Do not add extra ratios. More is not necessarily better - we are looking for quality over quantity. 5. You can also change the font size and the column widths. Keep the headings standard. 6. While not a requirement, you can copy/paste the Excel completed table as a picture in your memorandum template. | |||||||
| YOUR COMPANY | INSERT COMPETITOR USED IN DISCUSSION | ||||||
| Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast | Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast |
| Report in Millions or % | Report in Millions or % | ||||||
| Current Valuation | Current Valuation | ||||||
| Price/Earnings | Price/Earnings | ||||||
| Price/Book | Price/Book | ||||||
| Price/Sales | Price/Sales | ||||||
| Price/Cash Flow | Price/Cash Flow | ||||||
| Dividend Yield % | Dividend Yield % | ||||||
| Forward Valuation | Forward Valuation | ||||||
| Forward P/E | Forward P/E | ||||||
| PEG Ratio | PEG Ratio | ||||||
| Liquidity Ratios (Financial Health) | Liquidity Ratios (Financial Health) | ||||||
| Current Ratio | Current Ratio | ||||||
| Quick Ratio | Quick Ratio | ||||||
| Financial Leverage | Financial Leverage | ||||||
| Debt/Equity | Debt/Equity |
Week 6
| Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in Memo #3 submission. Insert the name of the company in the "INSERT COMPANY HERE." 2. The template intends for you to gather financial information that is readily available in multiple online financial resources. Part of the learning process is the data gathering exercise. Please take your time looking for it. Please use end of year ratios. For example, in this tempalte gather the required yearly/quarterly total assets and total liabilites: the debt ratio, etc. will compute for you, and so on for each ratio. 3. Ratios can be found from a variety of online financial resources, to include, but not limited to: Morningstar's, Yahoo Finance, Google Finance, Market Watch, Bloomberg, and many more. Sometimes it is as simple as Google: "What is Apple's revenue?" 4. Do not edit the table. Do not add extra ratios. More is not necessarily better - we are looking for quality over quantity. 5. You can also change the font size and the column widths. Keep the headings standard. 6. While not a requirement, you can copy/paste the Excel completed table as a picture in your memorandum template. | |||||||
| YOUR COMPANY | INSERT COMPETITOR USED IN DISCUSSION | ||||||
| Insert Financial Resource(s) Used Here | Most Recent Information (i.e., end of FY or most recent quarter | Insert Financial Resource(s) Used Here | Most Recent Information (i.e., end of FY or most recent quarter | ||||
| Report in Millions or % | Report in Millions or % | ||||||
| Debt Ratio
tc={9AFFFA8B-C13D-6947-8CA7-DCB37E4C25CC}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Gather the most recently available information from a financial source of your choice. The Excel formula is pre-loaded. |
Total Assets | Total Liabilities | ERROR:#DIV/0! | Debt Ratio
tc={F377E8FB-0FA5-844B-867F-CE60878E1198}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Gather the most recently available information from a financial source of your choice. The Excel formula is pre-loaded. |
Total Assets | Total Liabilities | ERROR:#DIV/0! |
| Debt to Equity Ratio | Total Liabilities | Shareholder's Equity | ERROR:#DIV/0! | Debt to Equity Ratio | Total Liabilities | Shareholder's Equity | ERROR:#DIV/0! |
| Interest Coverage Ratio | Operating Income | Interest Expenses | ERROR:#DIV/0! | Interest Coverage Ratio | Operating Income | Interest Expenses | ERROR:#DIV/0! |
| Debt Service Coverage Ratio | Operating Income | Total Debt | ERROR:#DIV/0! | Debt Service Coverage Ratio | Operating Income | Total Debt | ERROR:#DIV/0! |
| Weighted Average Cost of Capital |
tc={7EFAEB4F-EBCD-794F-8CB4-0A69A748B2A4}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Use the resources from the course to help locate the WACC |
Weighted Average Cost of Capital | |||||
Week 7
| Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in Memo #3 submission. Insert the name of the company in the "INSERT COMPANY HERE." 2. The template intends for you to gather financial information that is readily available in multiple online financial resources. Part of the learning process is the data gathering exercise. Please take your time looking for it. Please use end of year ratios. 3. Ratios can be found from a variety of online financial resources, to include, but not limited to: Morningstar's, Yahoo Finance, Google Finance, Market Watch, Bloomberg, and many more. Sometimes it is as simple as Google: "What is Apple's revenue?" 4. Do not edit the table. Do not add extra ratios. More is not necessarily better - we are looking for quality over quantity. 5. You can also change the font size and the column widths. Keep the headings standard. 6. While not a requirement, you can copy/paste the Excel completed table as a picture in your memorandum template. | |||||||
| YOUR COMPANY | INSERT COMPETITOR USED IN DISCUSSION | ||||||
| Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast | Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast |
| Margin Ratios | Margin Ratios | ||||||
| Gross Profit Margin | Gross Profit Margin | ||||||
| EBITDA | EBITDA | ||||||
| Operating Profit | Operating Profit | ||||||
| Net Profit | Net Profit | ||||||
| Cash Flow | Cash Flow | ||||||
| Profitability Ratios | Profitability Ratios | ||||||
| Return on Assets (ROA) | Return on Assets (ROA) | ||||||
| Return on Equity (ROE) | Return on Equity (ROE) | ||||||
| Return on Invested Capital (ROIC) | Return on Invested Capital (ROIC) | ||||||
| Interest Coverage | Interest Coverage |
Week 8
| Instructions 1. The purpose of this template is to gather data that will be analyzed and discussed in Memo #2 submission. Insert the name of the company in the "INSERT COMPANY HERE." 2. The template intends for you to gather financial information that is readily available in multiple online financial resources. Part of the learning process is the data gathering exercise. Please take your time looking for it. Please use end of year ratios. 3. Ratios can be found from a variety of online financial resources, to include, but not limited to: Morningstar's, Yahoo Finance, Google Finance, Market Watch, Bloomberg, and many more. Sometimes it is as simple as Google: "What is Apple's revenue?" 4. Do not edit the table. Do not add extra ratios. More is not necessarily better - we are looking for quality over quantity. 5. You can also change the font size and the column widths. Keep the headings standard. 6. While not a requirement, you can copy/paste the Excel completed table as a picture in your memorandum template. | ||||||||||
| YOUR COMPANY | INSERT COMPETITOR USED IN DISCUSSION | |||||||||
| Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast | Insert Financial Resource(s) Used Here | 2020 | 2021 | Trailing Twelve Months (TTM) / QoQ / Forecast | |||
| Revenue | 24.5M | 31.5M | 74.8B | Revenue | 7M | 11M | 73B | |||
| Operating Income | 1.9B | 6.5B | 0.00 | Operating Income | $-6.1B | $-4.2B | 0.00 | |||
| Net Income | -870.00 | 690M | 11.1B | Net Income | $-675M | $-1.9M | 1.2B | |||
| P/E Ratio | 190.00 | 54.40 | 54.30 | P/E Ratio | 52.70 | 12.96 | 10.06 | |||
| EPS | 1.63 | 1.05 | 3.23 | EPS | -2.16 | 0.98 | 0.64 | |||
| Dividend per Share | 0.00 | 0.00 | 0.00 | Dividend Per Share | 0.03 | 0.05 | 0.00 | |||
| Growth Rate: Revenue % | 70.67 | 59.80 | 74.86 | Growth Rate: Revenue % | -18.68 | 1.45 | 0.00 | |||
| Growth Rate: Net Income % | 665.46 | 219.80 | 11.19 | Growth Rate: Net Income % | -31.70 | -145.80 | -338.44 | |||
| Market Capitalization (Market Cap) | 668.90B | 1.061T | 568.99B | Market Capitalization (Market Cap) | 21.24B | 18.90B | 13.95B | |||
| Daily Trade Volume / Average Volume
tc={7BE6F433-EFCF-2041-86F5-FEA1809A6AB1}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Use the daily information from whatever day you enter the data. It changes daily. Your information should look like: 12.7 Mil / 76.9 Mil |
0.00 | 0.00 | 73.496M | Daily Trade Volume / Average Volume
tc={B70BB9CD-E47B-594B-A3F1-6225C60E150F}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Use the daily information from whatever day you enter the data. It changes daily. Your information should look like: 12.7 Mil / 76.9 Mil |
342.68 | 0.00 | 345.45 | |||
| Beta | 0.00 | 0.00 | 1.97 | Beta | 1.23 | 0.00 | 0.97 | |||
| Operating Cash Flow
tc={650034D3-7CAE-F941-8D26-BE91E6EA720A}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Operating, Investing, Financing, CapEx, and FCF is found on the Cash Flow Statement |
5.943B | 11.497B | 16.03B | Operating Cash Flow
tc={8A6358BD-0759-254C-9B88-5A84804DC780}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Operating, Investing, Financing, CapEx, and FCF is found on the Cash Flow Statement |
10.91B | 12.434B | 17.122B | |||
| Investing Cash Flow | (-3.132B) | (-7.868B) | (-5.84B) | Investing Cash Flow | (-6.52B) | (-3.47B) | (-0.480B) | |||
| Financing Cash Flow | 9.973M | (-5.203M) | (-4.289B) | Financing Cash Flow | (-1.43B) | (-6.01B) | (-1.357B) | |||
| Capital Expenditure | 3.232B | 6.514B | 1.803M | Capital Expenditure | 13.327B | 9.423B | (-656.52M) | |||
| Free Cash Flow | 2.786B | 3.787B | 8.90B | Free Cash Flow | 8.466B | 3.678B | 389.59M | |||
| Price/Earnings | 0.00 | 0.00 | 0.00 | Price/Earnings | 0.00 | 0.00 | 0.00 | |||
| Price/Book | 0.00 | 0.00 | 0.00 | Price/Book | 0.00 | 0.00 | 0.00 | |||
| Price/Sales | 0.00 | 0.00 | 0.00 | Price/Sales | 0.00 | 0.00 | 0.00 | |||
| Price/Cash Flow | 0.00 | 0.00 | 0.00 | Price/Cash Flow | 0.00 | 0.00 | 0.00 | |||
| Dividend Yield % | 0.00 | 0.00 | 0.00 | Dividend Yield % | 0.00 | 0.00 | 0.00 | |||
| Forward P/E | 0.00 | 0.00 | 0.00 | Forward P/E | 0.00 | 0.00 | 0.00 | |||
| PEG Ratio | 0.00 | 0.00 | 0.00 | PEG Ratio | 0.00 | 0.00 | 0.00 | |||
| Current Ratio | 0.00 | 0.00 | 0.00 | Current Ratio | 0.00 | 0.00 | 0.00 | |||
| Quick Ratio | 0.00 | 0.00 | 0.00 | Quick Ratio | 0.00 | 0.00 | 0.00 | |||
| Financial Leverage | 0.00 | 0.00 | 0.00 | Financial Leverage | 0.00 | 0.00 | 0.00 | |||
| Debt/Equity | 0.00 | 0.00 | 0.00 | Debt/Equity | 0.00 | 0.00 | 0.00 | |||
| Debt Ratio
tc={F84C6A4B-BA58-0348-A538-E39E462989EF}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Gather the most recently available information from a financial source of your choice. The Excel formula is pre-loaded. |
tc={B70BB9CD-E47B-594B-A3F1-6225C60E150F}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Use the daily information from whatever day you enter the data. It changes daily. Your information should look like: 12.7 Mil / 76.9 Mil |
tc={8A6358BD-0759-254C-9B88-5A84804DC780}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Operating, Investing, Financing, CapEx, and FCF is found on the Cash Flow Statement |
ERROR:#DIV/0! | Debt Ratio
tc={B583A84A-0766-2D4F-81DD-A02DB5FC8766}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Gather the most recently available information from a financial source of your choice. The Excel formula is pre-loaded. |
ERROR:#DIV/0! | |||||
| Debt to Equity Ratio | ERROR:#DIV/0! | Debt to Equity Ratio | ERROR:#DIV/0! | |||||||
| Interest Coverage Ratio | ERROR:#DIV/0! | Interest Coverage Ratio | ERROR:#DIV/0! | |||||||
| Debt Service Coverage Ratio | ERROR:#DIV/0! | Debt Service Coverage Ratio | ERROR:#DIV/0! | |||||||
| Weighted Average Cost of Capital | 0.00% | Weighted Average Cost of Capital | 0.00% | |||||||
| Gross Profit Margin | 0.00 | 0.00 | 0.00 | Gross Profit Margin | 0.00 | 0.00 | 0.00 | |||
| EBITDA | 0.00 | 0.00 | 0.00 | EBITDA | 0.00 | 0.00 | 0.00 | |||
| Operating Profit | 0.00 | 0.00 | 0.00 | Operating Profit | 0.00 | 0.00 | 0.00 | |||
| Net Profit | 0.00 | 0.00 | 0.00 | Net Profit | 0.00 | 0.00 | 0.00 | |||
| Cash Flow | 0.00 | 0.00 | 0.00 | Cash Flow | 0.00 | 0.00 | 0.00 | |||
| Return on Assets (ROA) | 0.00 | 0.00 | 0.00 | Return on Assets (ROA) | 0.00 | 0.00 | 0.00 | |||
| Return on Equity (ROE) | 0.00 | 0.00 | 0.00 | Return on Equity (ROE) | 0.00 | 0.00 | 0.00 | |||
| Return on Invested Capital (ROIC) | 0.00 | 0.00 | 0.00 | Return on Invested Capital (ROIC) | 0.00 | 0.00 | 0.00 | |||
| Interest Coverage | 0.00 | 0.00 | 0.00 | Interest Coverage | 0.00 | 0.00 | 0.00 |