Certainly! Below is the data **converted into an Excel format**. You can copy and paste this directly into an Excel spreadsheet for structured columns and rows. --- ### Sheet 1: Statement of Financial Affairs | Book Value ($) | Assets | Amt ($) | Available for Unsecured Creditors ($) | |---------------------|-----------------------------------------|-----------|---------------------------------------| | | **Pledge with Fully Secured Creditors:**| | | | 79,000.00 | Land (Plot A and D) ($39,000 + $73,000) | 112,000.00| | | | Less: Notes Payable ($38,000 * 2) | 76,000.00 | 36,000.00 | | | **Pledge with Partially Secured Creditors:**| | | | 74,000.00 | Land (Plot B and C) ($34,000 + $37,000) | 71,000.00 | | | | Less: Notes Payable | 76,000.00 | - | | | **Free Assets:** | | | | 29,000.00 | Cash | | 29,000.00 | | 48,000.00 | Account Receivable | | 35,000.00 | | | **Total Amt. Available to pay liabilities with priority and unsecured creditors ($36,000 + $29,000 + $35,000)** | 100,000.00 | | | | Less: Liabilities and Priority | | 92,720.00 | | | Available for Unsecured Creditors | | 7,280.00 | | | Estimated Deficiency | | 96,720.00 | | | | | 104,000.00 | | 2,300,000.00 | | | | --- | Book Value ($) | Liabilities and Equity | Amt ($) | Unsecured Non-Priority Liabilities ($)| |---------------------|-----------------------------------------|-----------|---------------------------------------| | | **Liabilities with priorities** | | | | | Administrative Exp. | 68,720.00 | | | 24,000.00 | Salaries Payable | 24,000.00 | | | | **Total** | 92,720.00 | | | | **Fully Secured Creditors:** | | | | 76,000.00 | Notes Payable | 76,000.00 | | | | Land (Plot A and D) | 112,000.00| | | | **Partially Secured Creditors:** | | | | 76,000.00 | Notes Payable | 76,000.00 | | | | Land (Plot B and C) | 71,000.00 | 5,000.00 | | | **Unsecured Creditors:** | | | | 45,000.00 | Notes Payable | 45,000.00 | | | 54,000.00 | Account Payable | 54,000.00 | | | 78,000.00 | Less: Stakeholder Equity | -45,000.00| | | 2,300,000.00 | | | 104,000.00 | --- ### Sheet 2: Answers & Calculations | Explanation | Calculation/Result | |-------------|-------------------| | When Plot B is sold for $34,000 entire proceeds are transferred to Note Payable. | | | Balance unsecured portion of such note = $38,000 - $34,000 | = $4,000 | | After making payments to priority creditors, leftover for unsecured creditors | $7,280 | | Proportion paid to note payable (Plot B) = $7,280 * $4,000 / $104,000 | $280 | | **Total paid to note payable secured by Plot B** | $34,000 + $280 = $34,280 | | **Unsecured Note Payable paid proportionately** | $7,280 * $45,000 / $104,000 = $3,150 | | If Plot D is sold for $78,200 instead of $73,000, balance to unsecured creditors = $7,280 + $78,200 - $73,000 | = $12,480 | | Proportion paid to note payable (Plot B) = ($7,280 + $12,480) * $4,000 / $104,000 | $784.61 | | **Total paid to note payable secured by Plot B** | $34,000 + $12,480 * $4,000 / $104,000 = $34,480 | --- > **Tip:** When copying to Excel, paste each section into a separate sheet for clarity. If you want the **raw CSV format** for direct import, please let me know!