J" Insert Row HERE TO SAVE YOUR WORK H18 Book values 20,400 170,000 180,000 430,000 Fair Market Values 20,400 95.000 110,000 320,000 A B ABC Company As of June 30, 2018 ASSETS Cash Accounts receivable, net Inventory PPE LIABILITIES Accounts payable Taxes payable Note payable - A (secured by inventory) Note payable - B (secured by receivables) Other information: Bankruptcy court costs are estimated to be 15,000 REQUIRED Complete the Statement of Affairs for ABC Company. 350.000 120,000 100,000 100,000 350,000 120,000 100.000 100,000 ABC COMPANY STATEMENT OF AFFAIRS Estimated Amounts Remaining ASSETS Assets pledged with fully secured creditors: Asset value Less creditor claim Shoot MacBook Pro 80 F3 000 000 Ta FS 16 $ % & 3 Copy Merge Cell 3 - Insert Row CLICK HERE TO SAVE YOUR WORK H18 A B Estimated Amounts Remaining 25 ASSETS 26 Assets pledged with fully secured creditors: 27 Asset value 28 Less creditor claim 29 30 Assets pledged with partially secured creditors: 31 Asset value 32 Less creditor claim 33 34 Free assets: 35 36 37 38 39 Subtotal Amount Available to pay Unsecured Creditors 40 Less: Unsecured Creditors with Priority 41 (from Liabilities Section) 42 Net Amount Available to pay Unsecured Creditors 43 LIABILITIES 44 Fully secured creditors: 45 Liability 46 Less value of asset 47 48 Partially secured creditors: 49 Liability Sheet1 New Estimated Amounts Remaining MacE 5C ODO F118 D Estimated Amounts Remaining A B 42 Net Amount Available to pay Unsecured Creditors 43 LIABILITIES 44 Fully secured creditors: 45 Liability 46 Less value of asset 47 48 Partially secured creditors: 49 Liability 50 Less value of asset 51 52 Unsecured creditors with priority: 53 54 55 56 Remaining Unsecured Creditors: 57 58 59 Estimated Amount of Unsecured Liabilities 60 61 RECOVERY PERCENTAGE CALCULATION 62 Net Amount available to pay unsecured creditors 63 Amount owed to unsecured creditors 64 Estimated deficiency 65 Recovery percentage 66 67 Sheet1 New MacBoo F2 BO F3 ODO GOO FA 55 a # $ %