Draw Page Layout Formulas Data Review View Cut Calibri (Body) 11 Copy B I U ' A Format AutoSave Home Insert Paste BD Comments Share Normal Bad Autosum Fill v % 0 Conditional Format Formatting as Table Good Neutral Insert Delete Format Clear Sort & Filter Find & Select Sensitivity Analyze Data Tell me Wrap Text Date FIN-3015-01 F23 Exam 2 Take Home Portion Automate Merge & Center +A $ S T U V W X Y Z AA AB AC AD AE AF 11 fx 11/2/2023 A B C D E F G H J K L M N P Q R 4 5 Complete the Balance Sheet below based on the given information 6 7 Cash 8 Marketable securities $ 30,000 $ 25,000 9 Accounts Receivable 10 Inventory 11 Total current Assets 12 Net Fixed Assets 13 Total Assets 14 15 16 17 18 19 21 6789022 Accounts Payable $ 120,000 Short-term Notes Payable Accrued Liabilities $ 20,000 Total Current Liabilities Long-Term Debt Total Debt Stockholder's Equity $ 600,000 23 Total Liabilites and Equity 24 25 Assumptions: 26 Sales $1,825,000 27 Gross profit margin = 30% 28 Inventory Turnover = 7.0 29 365 days per year 30 DSO = 40 days 31 Current ratio=1.40 32 Total Asset Turnover = 1.25 33 34 35 36 37 38 39 40 On my Honor I have neither given nor received aid on this examination, nor have I shared the 41 questions with anyone. 42 43 44 Signed: 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 Ready Problem 16 Problem 17 Problem 18 Accessibility: Good to go AG 60 A 100%