1. Kershaw, Buehler, and Bauer are partners and agree to share profit and loss in the ratio of 30/30/40. The partners have agreed to liquidate, liquidation expenses will total $28,000. The following are the balances prior to liquidation: Cash, $100,000; Noncash assets, $700,000; Liabilities $354,000; Kershaw Capital, $200,000; Buehler Capital, $144,000 and Bauer Capital, $102,000. Assume actual liquidation expenses are $20,000 and noncash assets sold for $500,000 using an excel spreadsheet prepare a statement of partnership liquidation.