I have a question on an advanced accounting problem. I need solution on excel with formulas to show where the answer is coming from. I need to know how to solve it, not just have the answer.

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. 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 depreciation) Total $ $ 8,000 33,600 35750 27,000 41,600 27,250 173,200 $ $ $ $ Liabilities and Capital Accounts Payable Other Current Liabilities Long-term Note (8% due 2008) Cox, Capital Andrews, Capital Bennet, Capital Total $ 32,450 $ 6,750 $ 34,000 $ 37,500 $ 25,000 $ 37,500 $ 173,200 The review of the accounts resulted in the accumulation of the following information: 1. 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 partnership after she invests sufficient cash to increase the total capital interest to $150,000. Because 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