Please submit in a spreadsheet format. Thank you!

PROBLEM 15-5 Adjusting Entries for Partner Admission The CAB Partnership, although operating profitably, has had a cash flow problem. Unable to meet its current commitments, the firm borrowed $34,000 from a bank giving a long-term note. During a recent meeting, the partners decided to obtain additional cash by admitting a new partner to the firm. They feel that the firm is an attractive investment, but that proper management of their liquid assets will be required. Meyers agrees to invest cash in the firm if her chief accountant can review the accounting records of the partnership L08 The balance sheet for CAB Partnership as of December 31, 2008, is as follows Assets Cash Accounts Receivable Inventory (at cost) Land Building (net of depreciation) Equipment (net of depreciation) $ 8,000 33,600 35,750 27,000 41,600 27,250 $173,200 Total Liabilities and Capital Accounts Payable Other Current Liabilities Long-Term Note (8% due 2008) Cox, Capital Andrews, Capital Bennet, Capital S 32,450 6,750 34,000 37,500 25,000 37,500 $173,200 Total The review of the accounts resulted in the accumulation of the following information Approximately 5% of the accounts receivable are uncollectible. The old partnership had been using the direct write-off method of accounting for bad debts. 2. Current replacement cost of the inventory is $41,250 3. The market value of the land based on a current appraisal is $65,000 4. The partners had been using an unreasonably long estimated life in establishing a depreciation policy for the building. On the basis of sound value (current replacement cost adjusted for use), the value of the building is $32,750 5. There are unrecorded accrued liabilities of $3,275 The partners agree to recognize the foregoing adjustments to the accounts. Cox, Andrews, and Bennet share profits 40:30:30. After the admission of Meyers, the new profit agreement is to be 30:20:30:20. Meyers is to receive a 25% capital interest in the partner- ship after she invests sufficient cash to increase the total capital interest to $150,000. Be- cause of the uncertainty of the business, no goodwill is to be recognized before or after Meyers is admitted Required: A. Prepare the necessary journal entries on the books of the old partnership to adjust the accounts B. Record the admission of Meyers C. Prepare a new balance sheet giving effect to the foregoing requirements