Clipboard Font A1 Item Name ( 1 Item Name 2 Inventory remaining 3 Interest payable 4 Employee retirement fund 5 Co-Op retained earnings 6 Vehicles 7 Pre-paid expenses 8 Property & land 9 Renovations/improvements 10 Equipment/tools 11 Utilities bills 12 Petty cash Item Value (Book) Item Value (Market) 23,456 $ 42,575 41,225 S 41,225 350,000 $ 350,000 191,648 $ 214.453 92,250 $ 114,622 1,250 $ 1,250 707,070 $ 1,095,415 41,000 $ 6,426 9,500 $ 16,095 12,030 $ 12,030 35,299 $ 35,299 FO Alignment Number Current Assets: within 12 months from date on balance sheet F G H ASSETS Cost in (5) Market in (5) Inventory ren $ 23,456 $ 42,575 Pre-paid exp $ 1,250 $ 1,250 Petty cash $ 35,299 $ 35,299 Co-Op retain $ 191,648 $ 214.453 Total Current $ 251,653 $ 293,577 Vehicles $ Equipment'te $ 92,250 9,500 $ $ 114,622 16,095 Intermediate Assets: 12-120 months from date on balance sheet Total Non-c. $ 101,750 $ 130,717 Intermediate Assets: 12-120 months from date on balance F Vehicles $ Equipment $ 92,250 9,500 $ $ 114,622 16,095 sheet Total Non-cl $ 101,750 $ 130,717 Property & la $ Renovations $ 707,070 5 41,000 $ 1,095,415 6,426 Long-Term Assets: >120 months from date on balance sheet Total Non- CS 7 48,070 $ 1,101,841 TOTAL ASSETS $ 1,101,473 $ 1,526,135 u Insert Delete Format itional Format as Cell tting Table Styles Fill Clear ZY Sort & Filter Fin Sele Styles Cells Editing LIABILITIES Costin (5) Market in (5) Interest paya $ 41,225 $ 41,225 Utilities bills $ 12,030 $ 12,030 Own Current Liabilities: within 12 months from date on balance sheet Total Curren $ 53,255 S 53,255 Intermediate Liabilities: 12-120 months from date on balance sheet Total Non-c. $ KLEMN Intermediate Liabilities: 12-120 months from date on balance sheet Total Non-cl $ - $ Employee re $ 350,000 $ 350,000 Long-Term Liabilities: >120 months from date on balance sheet Total Non-c. $350,000 $350,000 TOTAL LIABILITIES $403,255 $ 403,255 NITI Ideas Sensitivity Clear Sort & Filter Find & Select Editing Ideas Sensitivity S PQ R + NET WORTH AS OF 01/01/2020 Cost in ($) Market in (5) Owner Equity: $ 698,218 $ 1,122,880 HW2 - AGR 333 (1) - Excel Formulas Data Review View Help 9 X cut Paste Copy A -A A == E 29 Wrap Text Merge & Alignment AutoSave Off 8 File Home Insert Draw Page Layout Arial 10 BIU - Format Painter Clipboard Font A1 1 X fx Ratio 1 Ratio Value 2 Debt-to-Equity Ratio 3 Net Capital Ratio 4 Intermediate Ratio 5 Equity-to-Asset Ratio 6 Debt-to-Asset Ratio 7 Liquidation Ratio 8 Working Capital to Gross Revenue Ratio B D Liquidity or Solvency? Level? 10 GROSS REVENUE (S) $187,299.24 NA 13 DIRECTIONS Referencing the ordered balance sheet (USING BOOK VALUE OF ASSETS, LIABILITIES AND EQUITY), fill in the formulas discussed in the slides in the 14 green cells B2:38 Indicate whether the ratio measures liquidity or solvency in each parallel cell 15 in column C In column D. describe the level of the ratio relative to the recommended guidelines ("good" or "strong for favorable values, "weak" or "review" for unfavorable "Yair" in between and 16 "NA" if no guidelines given in slides) Finally, produce a bar chart like we did in class - with the appropriate title, data 17 value labels, formatting, etc. 18
