Answer Happy

D Firm B E Firm F Firm D G Firm E 1 2 1 A B С Input (Source Data) Firm A ASSETS Cash Mkt. Sec. A/R previous year A/Rcurrent year Prepaids Inventory previous year Inventory current year Current Assets Fixed Assets previous year Fixed Assets current year Total Assets previous year 3 Total Assets current year LIABILITIES Current Liabilities 5 Long-Term Liabilities 5 Total Liabilities 7 EQUITY Total Equity previous year B Total Equity current year 9 Retained Earnings MV of equity 1 INCOME Sales 2 STATEMENT COGS 3 (current) Operating Expenses 4 SG&A Expense 5 Depreciation and Amort 6 Earnings before Tax 7 Provision for Tax (Tax Expense) 8 Interest Expense 9 NI 0 CASH FLOW STCash from Operations -1 2 0
- G IS الف الف - H Đ А Balance Sheet C А B B С D E E $ CS D cs $ CS $ CS $ $ CS 1 2 Firms 3 Year 4 Cash Mit 5 Sec Current 6 Assets Fored 7 Assets Total 8 Assets Current 9 Lisb Long term 10 Debt 11 Total Lab Page 12 Equity 13 Rating D D E E cs $ CS $ CS 14 15 Income Statement 16 m A А B B c С 17 years 18 $ $ CS $ CS 19 Revenues Cost of 20 Revenues Cross 21 Profit 22 Ops Inc Net 23 Income 24 Rating 25 26 Liquidity: Fim A For Firm 27 Current Ratio (CAC) 28 Cash Rate (Cash Marketable Secanties.CL 29 Cash Flow from Operations Ratio (CFOCL) 30 Ratings 31 32 Lererage Tim FB Fic 33 Total Liabilities/Total Equity 34 Total Labilities (BV) Equity at Market Times Interest Eamed (EBIT Interest INPUT Financial Analysis Market Analysis Ready Accessibility Unavailable Firm Firm E Fim D Firm
F G H Firm B Firm Firm D Firm E Firm B Firm C Form D Form E Page 2 A1 Xv fx Balance Sheet A B С D E 28 Cash Ratio (Cash+Marketable Securities/CL) 29 Cash Flow from Operations Ratio (CFO/CL) 30 Ratings 31 32 Leverage Fim A 33 Total Liabilities/Total Equity 34 Total Liabilities (BV)/Equity at Market Times Interest Emmed (EBIT / Interest 35 Expense) 36 Ratings 37 38 Activity FormA 39 Inventory Tumover (COGS/Avg Inventory 40 Avg. # of Days Inventory (365/Inv. Tumoy 41 Receivables Tumover (Sales / Avg. AR) Working Capital Tumover (Sales/Avg. 42 Working Capital) Fixed Assets Tumover (Sales/Avg. Fixed 43 Assets) Total Assets Tumover (Sales/Avg. Total 44 Assets) Length of Operating Cycle (365((1/Inventory 45 Tumover) + (1/Receivables Tumover) 46 Ratings 47 48 Profit Firm A 49 Gross Margin (Gross Profit/Sales) 50 Return on Sales (NI/Sales) 51 ROA (NI/Avg. Total Assets) 52 ROE (NI/ Avg Stockholders' Equity) 53 Ratings 54 55 ROE -Profit Activity Solvency Fπη Α 56 -Net Income/Sales 57 Sales/Avg Total Assets -Return on Assets-Net Income/Avg. Total 58 Assets 59 I Avg Total Assets/Avg. Common Equity 60 =ROE=NI / Avg. Common Equity 61 Ratings 62 63 64 Firm B Fum C Fum D Form E S S2 96 点击 Firm B Firm Firm D Firm E
Undo Clipboard Font GRANI A1 Xfx Earnings Per Share & Stock Price Analysis / Forecast A B С D E F G 1 Earnings Per Share & Stock Price Analysis / Forecast 1 yr 2 yr 2 EPS Achial forecast forecast 3 Firm A 4 Firm B 5 Firm 6 Firm D 7 Firm E 8 insert notes here 9 10 Stock Price Trends Current Price, same Price, same Stock 52 week 52-week day, I year day, 5 11 Price, Oct High Low ago years ago 12 Firm A 13 Fimm B 14 Firm 15 Firm D 16 Fin E 17 insert notes here 18 19 1 year stock price graph for companies & DJIA 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Copy graph to spreadsheet, and move it into this space 34 35 36 5 year stock price graph for companies & DJIA 37 38 39 40 41
52 53 Price Earnings Ratios PE 2 yr. Current PE Actual Forecast Forecast Stock Price EPS EPS EPS PE 1 yr 54 55 56 57 Company Firm A Firm B Firm Firm D Firm E 59 60 62 8898883988 Growth Analysis (historical) 5 year stock retum- 5 year Eamings growth 5 year Eamings last 5 years - last 5 years Growth-next 5 years 63 64 65 Farm A Firm B Firm Firm D Firm E 69 70 71 Intrinsic Value PEG Intrinsic Value PEG (PE PEG (PE actual); 5 based on 1 yr ahead Growth forecast) y. Eam Intrinsic Value Price 心四科而四四四四 72 73 74 75 76 77 78 79 80 Firm A Firm B Farm Firm D Furm E Dividend & Yield Market to Book Market Book Value Value Dividend Yield Payout Market to Book 81 82 83 84 85 86 Fim A Fam B Firm Firm D Fum E Company Fimm A Firm B Firm Firm D Firm E
Undo Clipboard Font A1 VX ✓ fx Earnings Per Share & Stock Price Analysis / Forecast A B C D E F G H 88 89 Market Rating Summary 90 Company Rating Discussion 91 Firm A 92 Firm B 93 Firm C 94 Firm D 95 Firm E