Hygs yahoo finance

Printout Tuesday, April 30, 2019 3:40 PM Quick Notes Page 1 Quick Notes Page 2 Quick Notes Page 3 The information on this page is intended to make the template easier to use. It describes requirements, specific design features, and hints for overcoming challenges the designers encountered during development that resulted from the variety of ways financial statements are presented in annual reports and/or 10K filings at www.sec.gov. There are three requirements for making this template function properly: 1) Enable content (macros) by single-clicking on the button displayed when opening the template file. 2) All financial statement data must be entered. If a line item does not have an explicit template line item match, include the amount as part of a formula on an 'Other…' line item such as 'Other current assets' or 'Other operating expenses'. 3) Ensure Analysis ToolPak add-in is checked/active. Verify by typing Alt+T (Tools), then I (Add-Ins) is the easiest method. Alternatively, from the File tab, select Options, then Add-Ins, then click on the button with 'Excel Add-ins' displayed Manage: drop-down list. NOTE: If the Add-Ins option is unavailable, it will have to be installed from your original Microsoft Office/Excel CD. Recommendations: Set monitor resolution to 1024 x 768 or higher to minimize scrolling during data entry. Use a formula statement [= n + n + n ] rather than a hand-calculated summary amount when combining multiple financial statement lines into a single template cell. This will aid when troubleshooting entry errors that could result in mismatched check figures. Use the TAB key to navigate between cells. The active cell is automatically moved to the next cell which accepts data. Three buttons are common to each of the enterable financial statement worksheets – It is important to understand their function because all sheets are protected to preserve the integrity of total totals and ratio formulas. - Allows entry of data into appropriate cells and displays entry hints Edit Review - Displays printable versions of financial statements and hides entry hints - Clears values from all enterable cells and prepares the worksheet for data entry Clear The worksheet should be completed first. It is enterable and also contains a Clear button. The remaining worksheets – are automatically generated by the template. No entry is required or permitted. The template is flagged as ‘read-only’ to permit reuse. If you save your work, you will be prompted to rename the file. worksheet supplemental information Colored fields have special significance. Only cells with borders permit data entry. – financial statement header information – special data needed for ratios that cannot be found as line items on financial statements – check figures for financial statement summary comparisons An unbordered, colored cell on any sheet indicates Cover worksheet data has not been entered or a summary total on a financial statement does not compare favorably to its associated Cover worksheet check figure. - Amounts can usually be found in the 'Notes to consolidated financial statements' section of a company's annual report or 10K. Rent expense amounts are generally discussed under a note heading titled 'Commitments' or 'Commitments and Contingencies' and sometimes included under a note heading titled 'Leases'. Rent Expense - Amounts can usually be found on one of following statements: Statement of Stockholders' Equity, Statement of Cash Flows, or Statement of Operations. Dividends per share amounts are also often included in the 'Notes to consolidated financial statements' section of a company's annual report or 10K under note headings titled 'Selected Financial Data', 'Five Year Summary Data', or 'Quarterly Financial Data'. Dividends per Share The information on this page is intended to make the template easier to use. It describes requirements, specific design features, and hints for overcoming challenges the designers encountered during development that resulted from the variety of ways financial statements are presented in annual reports and/or 10K filings at www.sec.gov. – the template supports researching a company’s year-end stock price when following these steps: a) Enter the company’s Stock Ticker Symbol b) Enter the year end dates for the three years covered on the annual report c) Copy the contents from one year’s URL cell to the clipboard End of Year Stock Price d) Paste the clipboard contents into an open browser’s Address field (Internet Explorer is shown) e) Click the button (or your browser’s equivalent) to access the Marketwatch web site for the company’s stock price f) Make sure the Split Adjusted Price (see red arrow below) is used, if available; otherwise, use the Closing Price g) If the market was closed on the day supplied by the URL, change the historical quote date (see red arrow below) to the next earlier weekday until data is available. h) Repeat steps c) through g) for the remaining years - If Gross Profit is not listed on the Income Statement/Statement of Operations, review financial data for COGS information and enter a formula to net Sales and COGS. If there is no COGS data, enter the Net Sales amount as the Gross Profit amount. Service companies may not display a Cost of Goods/Cost of Sales amount. Gross Profit are alternative titles for the same data - Do not include Interest Expense or Other Income (Loss) items in this check figure; otherwise, the check figure will not compare favorably with the Income Statement Operating Profit subtotal. These are non-operating items and should be entered below the operating profit line.