so confused with this orject - I have had enough of this teacher she doesn't explain sshit to me
AutoSave . Off) ACG2209_CourseProjectWorkbook (1) - Excel Samantha Just SJ X File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments F11 X V . Vertical Analysis A B C D E F G H 22 Vertical Analysis Vertical Analysis Horizontal Analysis 23 Balance Sheet Year 1 Year 2 Year 3 Year 1 Year 2 Year 3 to 1 24 Cash and Cash Equivalents 25 Investments 26 Accounts Receivable Trade 27 Inventory (Add: FG and WIP + RM & supplies lines) 28 Total Current Assets 29 Net Property, Plant and Equipment 30 Goodwill 31 Trademarks 32 Total Assets 33 Accounts Payable 34 Accrued Liabilities 35 Total Current Liabilities 36 Total Noncurrent Liabilities 37 Total liabilities (Add total current liab + total noncurren 38 Common Stock 39 Class B Common Stock 40 Retained Earnings 41 Treasury Stock 42 Total Equity 43 Total liabilities and Shareholders Equity o o o o o o o o o o o o o o o o o o O O o o o o o o o o o o o o o o o O O O O O o o o o o o o o o o o o o o o o O O O O 44 45 Competition or 46 Tootsie Roll Industries TRI TRI Industry Ratio* * Ratio Benchmarks 47 Formula Year 1 Year 2 Year 1 48 Liquidity Ratios *Total Current Assets/Total Current 49 Current Ratio Liabilities Greater than 1 Module 02 Module 03 Module 04 Module 06 + + 100% Type here to search O em 4:45 PM 5/6/2020 19AutoSave . Off) ACG2209_CourseProjectWorkbook (1) - Excel Samantha Just SJ X File Home Insert Draw Page Layout Formulas Data Review View Help 9 Search Share Comments F11 X Vertical Analysis A B C D E F G H 45 Competition or 46 Tootsie Roll Industries TRI TRI Industry Ratio* * Ratio Benchmarks 47 Formula Year 1 Year 2 Year 1 48 Liquidity Ratios *Total Current Assets/Total Current 49 Current Ratio Liabilities Greater than 1. *(Cash & Cash Equivalents +linvestments + Accounts Receivable Ideally greater than Trade)/Total Current 1, but likely will be 50 Acid Test Ratio Liabilities less than 1. 51 52 Asset Management Ratio *Product Cost of Depends on Goods Sold/Average industry, higher is 53 Inventory Turnover Inventory better (remember, Avg Inv is beginning year inv + ending year inv, result divided by 54 2. ) 55 Solvency Ratios *Total Liabilities/Total 56 Debt ratio Assets Less than 67% *Operating Higher the better, Income/Interest unless interest exp 57 Times Interest Earned Ratio Expense is 0 Module 02 Module 03 Module 04 Module 06 + 1 - + 100% O X 4:46 PM Type here to search 5/6/2020 19FllE Home Insert Draw FageLayDut Formulas Data Review View Help ,0 Search ashale UComments F11 ' E X w/ fr Vertical Analysis v A A B G H l I ' *Total ljabi ies/Total 56 Debt ratio Assets Less than 6796 *Operating Higher the better, Income/Interest unless interest exp 57 Times Interest Earned Ratio Expense is 0. 58 59 Profitability Ratios *Total Gross Depends on Margin/Total industry, higher is 60 Gross Prot Percent Revenue better Depends on *Net Earnings/Total industry, higher is 61 Return on Net Sales Sales better Depends on company. Would MLocate in research want to see stay (on company income stable or increase, 62 Earnings Per Share (EPS) statement) not decrease. 63 64 Market Analysis Depends on **Locate in research company. Remaining 65 Price Earning Ratio (on Internet) steady is good. Depends on **Locate in research company. Remaining 66 Dividend Vield (on Internet) steady is good. 67 68 *Calculated by Author . ' ' V r > G) a
