Tab #3: Overview

The OVERVIEW sheet summarizes the key information from all other relevant financial analysis or stock valuation tabs. It acts as an input tab for the stock ticker, analysis year, and unit selector (all key inputs for the entire model), an output tab for final valuation analysis, and a summary tab for investors to evaluate a company's overall fundamentals and trends. More specifics on this sheet are included below:

1. Master Workbook Inputs
   • Stock Ticker: This should always be equal to a publicly traded company's stock ticker, without any symbols (i.e., don't include $ or #). Updating this cell will trigger the model to refresh and pull the financial statement data, along with other financial data and company information.
   • Analysis Year: This is a dropdown selection driven off the BACKEND tab. Changing this year will adjust the last actual date of the financial statement and any outputs from these statements. It's recommended that you keep this year as the most recent year.
   • Unit Selector: This is a dropdown selection driven off the BACKEND tab. It lets you select between billions, millions, and thousands, which is how all of the numbers in the spreadsheet tabs will be outputted. It's recommended that you keep this option as "millions," for best readability.
2. Fundamental Company Information, Trading and Dividend Information, Key Statistics and Valuation Ratios
   • Fundamental Company Information: Company name, company website, company description, location info (exchange, currency, country), industry and sector info, company codes (ISIN, CIK, CUSIP).
     • The last fiscal year, last calendar year, and historical year are calculated in the BACKEND tab, and are critical towards this sheet functioning properly.
   • Trading and Dividend Information: Closing stock price and close/open difference calculations, 52-week high/low and high/low difference calculations, including % off 52-week high/low calculations. Market cap, enterprise value, shares outstanding, volume, and average volume are included as well. Dividend information (dividend per share, dividend payout ratio, dividend yield, how many days remaining to buy the dividend, etc.) are included if the company pays dividends.
   • Key Statistics and Valuation Ratios: Key growth metrics, median margins for profitability analysis, median returns for measuring effectiveness, YoY capital structure and debt comparisons, YoY short-term liquidity ratio comparisons, YoY efficiency comparisons, and YoY key valuation ratio comparisons (including a chart).
     • NOTE: I've inputted default statistics and valuation ratios here, but you can choose from any of the options on the KFR tab if you'd like to view another type of relevant ratio within that subsection category.
3. Stock Chart
   • Historical Performance: Input the number of months back for the stock chart date range and visual. Do NOT enter a number greater than 120, as the BACKEND tab only supports 10 years of historical data (for performance purposes). Inputting a negative number or decimal may break the historical performance chart. This will let you see the historical daily closing price for the company, its # month change percentage, and its # month CAGR percentage. Can choose between =STOCKHISTORY or =WISESHEETS for stock price data/chart visualization
4. Radar Chart
   • Can input five different measures/labels for assessing risk, based on your preferences, then select between 1 to 5 in the dropdown input boxes (with 1 = worst, 5 = best). This should be done after analyzing the entire company, and provides a good method of summarizing a company's risk profile. 
5. Stock Valuation Method Buy Price Ranges Overview
   • Dynamic chart visual to let you compare range of buy prices to historical and current stock prices. Must complete the valuation model(s) first, then fill in the low AND high values on the VALUATION tab, under the "Valuation Model Overview" section for this to work.
6. Key Financials and Key Financial Ratios
   • Key Financials: Ability to select any three line items from the KFS tab, which includes supplementary line items, and analyze their trends over a 5-year period + TTM.
   • Key Financial Ratios: Ability to select any three ratios from the KFR tab, and analyze their trends over a 5-year period + TTM.
7. Income Statement Summary and Charts
   • Income Statement (IS) Summary: Provides a summarized/condensed version of the income statement (IS) tab, with up to 5-years of historical financials + TTM. Note that unlike the IS tab, expenses are shown as negative values here.
   • Income Statement (IS) Charts: There are two charts that summarize the income statement further. The first is a revenue and costs combo stacked bar and line chart graph. The second is a line chart visualizing the growth of the income statement's primary profitability measures.
8. Balance Sheet Summary and Charts
   • Balance Sheet (BS) Summary: Provides a summarized/condensed version of the balance sheet (BS) tab, with up to 5-years of historical financials + TTM.
   • Balance Sheet (BS) Charts: There are four charts that summarize the balance sheet further. Lets you see (a) YoY assets and liabilities/equities change (shows % change and size, represented by length of bar chart), and (b) what consists of company's assets, liabilities, and equity over the TTM (via treemap charts).
9. Cash Flow Statement Summary and Charts
   • Cash Flow Statement (CFS) Summary: Provides a summarized/condensed version of the cash flow statement (CFS) tab, with up to 5-years of historical financials + TTM.
   • Cash Flow Statement (CFS) Charts: There are two charts that summarize the cash flow statement statement further. The first is an overview of the company's net financing, net investing, and net operating cash flows over a period of time, in addition to the company's PP&E and FCF. The second chart provides a historical breakdown of the company's cash position, with respect to its changes in cash balances, and beginning and ending cash balances.