I want to feel my given data sheet. it doesn't matter what types of example will take. you can use any types of example. I just need to feel the data sheet before thursday. they just created excel sheet as an assignment. and I need to feel in the gap area. thank you.

LS K M P B D F G H CASE STUDY 2 3 Company Name 4 COMPARITIVE BALANCE SHEE 5 Year Ending as follows Trend Analysis for Year's ended 6 Latest Latest Latest 7 Assets Larsas Latestler 2 anos Leslie 8 9 Cash #DIV/0! #DIV/0! #DIV/0 10 Accounts Receivable (less Bad Debts estimate) #DIV/0! #DIV/0! #DIV/0! 11 Merchandise Inventory #DIV/0! #DIV/0! WOIV/0! 12 Prepaid Expenses #DIV/0! #DIV/0! #DIV/0! 13 Total Current Assets $ S $ #DIV/0! #DIV/0! #DIV/0! 14 Furniture and Equipment (less depreciation) #DIV/0! #DIV/0! #DIV/0! 15 Total Assets $ S $ #DIV/0! #DIV/0! #DIV/0! 16 17 Liabilities and Capital Late Lean 18 19 Accounts payable #DIV/0! #DIV/0! #DIV/0! 20 Notes payable #DIV/0! #DIV/0! #DIV/01 21 Accrued Expenses #DIV/0! #DIV/0!DIV/0! 22 Total Current Liability $ $ S #DIVO! #DIV/0! #DIV/0! 23 Capital / Owner's Equity #DIV/0! #DIV/0! #DIV/0! $ S 24 Total Liabilities and Capital/Owner's Equity 5 #DIV/0! #DIV/0! #DIV/0! 25 26 Please Note: The above Balance Sheet Analysis is designed for 3 year compartive statements Please read instructions at the bottom 27 28 COMPARATIVE INCOME STATEMENT 29 For Year's ended December 31 30 Clipboard Font Alignment Number Styles Cells Editing L5 K M N N P B D E F G H CASE STUDY 2. 3 Company Name 4 COMPARITIVE BALANCE SHEET 5 Year Ending as follows Trend Analysis for Year's ended 6 Latest Latest Lare 7 Assets La Lovestoster Zalens L319 lesz 8 9 Cash #DIV/0! #DIV/0! #DIV/0! 10 Accounts Receivable (less Bad Debts estimate) #DIV/0! #DIV/0! #DIV/0! 11 Merchandise Inventory #DIV/0! #DIV/0! #DIV/0! 12 Prepaid Expenses #DIV/0! #DIV/0! #DIV/0! 13 Total Current Assets $ $ S #DIV/0! #DIV/0! #DIV/01 14 Furniture and Equipment (less depreciation) #DIV/0! #DIV/0! #DIV/0! 15 Total Assets 5 5 5 #DIV/0! #DIV/0! #DIV/0! 16 17 Liabilities and Capital Las Pa 18 19 Accounts payable #DIV/0! #DIV/0! #DIV/0! 20 Notes payable #DIV/0! #DIV/0! #DIV/0! 21 Accrued Expenses #DIV/0! #DIV/0! #DIV/0! 22 Total Current Liability 5 $ S #DIV/0! #DIV/0! #DIV/0! 23 Capital / Owner's Equity #DIV/0! #DIV/OI #DIV/0! $ $ 24 Total Liabilities and Capital/Owner's Equity S #DIV/0! #DIV/0! #DIV/0! 25 26 Please Note: The above Balance Sheet Analysis is designed for 3 year compartive statements. Please read instructions at the bottom 27 28 COMPARATIVE INCOME STATEMENT 29 For Year's ended December 31 Arial Wrap Text LIO Copy - 10 AA -A- Fill - Paste BIU- E Merge & Center $- 2 Insert Delete Format Clear - Format Painter Clipboard Conditional Format Cell Formatting - as Table - Styles Styles Alignment Number Cells Font fo 154 K ! M N O B D E F G H 1 26 Please Note: The above Balance Sheet Analysis is designed for 3 year comparitive statements Please read instructions at the bottom 27 28 COMPARATIVE INCOME STATEMENT 29 For Year's ended December 31 30 Za Lamar Lalitientane 31 Sales (Net) #DIV/0! #DIV/0! #DIV/0! 32 Cost of Goods Sold #DIV/0! #DIV/0! #DIV/0! 33 Gross Margin $ S S #DIV/0! #DIV/0! #DIV/01 34 Expenses (less other income) #DIV/0! #DIV/0! #DIV/0! 35 Net Income for the years $ #DIV/0! #DIV/0! #DIV/0! 36 37 38 39 COMPARATIVE COMMON SIZE INCOME STATEMENT 40 41 Sales (Net) #DIV/01 #DIV/0! #DIV/0! 42 Cost of Goods Sold #DIV/0! #DIV/0! #DIV/0! 43 Gross Margin #DIV/0! #DIV/0! #DIV/0! 44 Expenses (less other income) #DIV/0! #DIV/0! #DIV/0! 45 Net Income for the year #DIV/0! #DIV/0! #DIV/0! 46 47 48 Ratios 49 Liquidity H K M N 0 142 fi C D E F G 42 Cost of Goods Sold #DIV/0! #DIV/0! #DIV/0! Gross Margin #DIV/0! #DIV/0! #DIV/0! 44 Expenses (less other income) #DIV/0! #DIV/0! #DIV/0! 45 Net Income for the year #DIV/0! #DIV/01 #DIV/01 46 47 48 Ratios 49 Liquidity 50 Current Ratio #DIV/01 #DIV/0! #DIV/0! 51 Quick Ratio (Acid Test) #DIV/0! #DIV/0! #DIV/0! 52 Debt liabilities to Equity/Capital #DIV/0! #DIV/0! #DIV/0! 53 54 Efficiency 55 D.S.O-Days Sales Outstanding #DIV/0! #DIV/01 #DIV/0! 56 Inventory Turnover #DIV/O #DIV/0! #DIV/0! 57 Acconts Payable to Sales #DIV/01 #DIVIOL #DIV/OF 58 59 Profitability 60 Return on Sales #DIV/0! #DIV/0! #DIV/0! 61 Return on Capital/Equity #DIV/0! #DIV/0! #DIV/OL 62 Return on Assets #DIV/0! #DIV/ #DIV/0! 63 64 65 IMPORTANT INSTRUCTIONS: 66 Please Note. The above Balance Sheet Analysis is designed for year compartive statements. For examploit you had tigures available 67 for 1998 1997 and 1996 for a particular company. Then you would enter the figureslo 1998'in the Latest Yes columns 1997 in the 68 Latestlesslyez'column and 1996 tigutes in the latestless 2Years column. This will then trend 1998 and 1997 over 1996 Ngures 69 F YOU ONLY HAVE TWO YEARS FIGURES For example you only have ligues for 1998 and 1987 Then enter the 1998 heures 70 in the Latestless year column and 1997 ligures in the 'Latestless 2 years oor. This will then trend 1938 over 1897 ligures 71