Please complete the following exercises and/or problems from the textbook:

• P3-36A
• CP3-45 This one is a continuum of problem p2-43 which I attached also since that was completed last week.

Prepare your answers in an Excel workbook, using one worksheet per exercise or problem.

The problems are attached.

P2-29A SolutionDate Jul. 1 Accounts & Explanation Debit Credit Cash $68,000 Yung, Capital $68,000 Owner Contribution Date Jul. 5 Accounts & Explanations Debit Credit Medical Rent $560 Cash $560 Medical Rent Date Jul. 9 Accounts & Explanations Debit Credit Land $16,000 Cash $16,000 Paid cash for land Date Jul. 10 Accounts & Explanations Debit Credit Office supplies $1,600 Accounts Payable $1,600 Purchased offices Supplies on Acct. Date Jul. 19 Accounts & Explanations Debit Credit Borrowed Cash $23,000 Notes Payable (Bank) $23,000 borrowed money from Bank Date Jul. 22 Accounts & Explanations Debit Credit Accounts Payable $1,300 Cash $1,300 Paid cash on account Date Jul. 28 Accounts & Explanations Debit Credit Prepaid advertising $240 Cash $240 Paid advertising in advance Date Jul. 31 Accounts & Explanations Debit Credit Cash $6,500 Service Revenue $6,500 Services Date Jul. 31 Accounts & Explanations Debit Credit Accounts Receivable $5,800 Service Revenue $5,800 Performed Services on account Date Jul. 31 Accounts & Explanations Debit Credit Salaries Expense $2,500 Rent Expense $1,000 Utilities Expense $400 Cash $3,900 Paid cash expenses Date Jul. 31 Accounts & Explanations Debit Credit Cash $1,140 Unearned Revenue $1,140 Collected Cash for future services Date Jul. 31 Accounts & Explanations Debit Credit Yung, withdrawals $7,000 Cash $7,000 Owner withdrawal Assets Liabilities Cash Jul. 1 $68,000 Jul.19 Jul, 31 $23,000 $6,500 Jul. 31 $1,140 Bal Jul. 31 Jul. 9 Bal. $69,640 Accounts Receivable $5,800 Land $16,000 $16,000 Office Supplies $560 Jul. 5 $16,000 Jul. 5 $1,300 $240 $3,900 $7,000 Jul. 22 Jul. 28 Jul. 31 Jul. 31 Jul. 22 Accounts Payable $1,600 $1,300 $300 Notes Payable Bank $23,000 $23,000 Unearned Revenue $1,140 $1,140 Equity Jul.10 Bal. Jul.19 Bal. Jul. 31 Bal. Yung, Capital $68,000 Jul. 1 $68,000 Bal. Jul. 31 Bal. Yung, withdrawals $7,000 $7,000 Service Revenue $6,500 Jul.31 $5,800 Jul. 31 $12,300 Bal. Medical Rent $560 $560 Salaries Expense Jul. 31 $2,500 Bal. $2,500 Office Rent Jul. 31 $1,000 Bal. $1,000 Utilities Expense Jul. 31 $400 Bal. $400 Jul. 5 Bal. Jul. 10 Bal. Jul. 28 Bal. $1,600 $1,600 Prepaid Advertisement $240 $240 $24,440 $93,280 $93,280 Vernon Yung, M.D. Trial Balance July 31, 2015 Balance Account Title Debit Credit Cash $69,640 Accounts Receivable $5,800 Office Supplies $1,600 Prepaid Advertisement $240 Land $16,000 Accounts Payable $300 Notes Payable $23,000 Unearned Revenue $1140 Yung, Capital $68,000 Yung, Withdrawals $7,000 Service Revenue $12,300 Medical rent $560 Salaries expense $2500 Office Rent $1000 Utilities Expense $400 Total $104,740 $104,740 This should be 69,880 This should be Advertising Expense You are missing Advertising payable P2-43 SolutionDate Dec. 2 Accounts & Explanations Cash Davis, Capital Debit Credit 18,000 $18,000 Date Dec. 2 Accounts & Explanations Office Rent Cash Debit Credit $550 $550 Date Dec. 3 Accounts & Explanations Equipment Cash Debit Credit $1,800 $1,800 Date Dec. 4 Accounts & Explanations Furniture Accounts Payable Debit Credit $4,200 $4,200 Date Dec. 5 Accounts & Explanations Office Supplies Accounts Payable Debit Credit $900 $900 Date Dec. 9 Accounts & Explanations Accounts receivable Service Revenue Debit Credit $1,500 $1,500 Date Dec. 12 Accounts & Explanations Utilities Expense Cash Debit Credit $250 $250 Date Dec. 18 Accounts & Explanations Cash Service Revenue Debit Credit $1,100 $1,100 Date Dec. 21 Accounts & Explanations Cash Unearned Revenue Debit Credit $1,400 $1,400 Date Dec. 26 Accounts & Explanations Accounts Payable Cash Debit Credit $400 $400 Date Dec. 28 Accounts & Explanations Cash Accounts Reeivable Debit Credit $300 $300 Date Dec. 30 Accounts & Explanations Davis, Withdrawals Cash Debit Credit $1,400 $1,400 Assets Liabilities Cash Dec. 2 $18,000 $550 Dec. 2 $1,800 Dec. 3 $250 Dec. 12 Dec. 18 Dec. 21 $1,100 $1,400 Dec. 28 Dec. 26 Accounts Payable $4,200 $900 $400 $4,700 Unearned Revenue $1,400 $1,400 Equity Dec. 4 Dec. 5 Davis, Capital $18,000 Dec. 2 $18,000 Bal. Bal. $300 $400 Dec. 26 Dec. 21 Bal. $1,400 Dec. 30 Bal. Dec. 9 $16,400 Accounts Receivable $1,500 $300 Dec. 28 Bal. $1,200 Equipment Dec. 3 Bal. $1,800 $1,800 Furniture Dec. 4 Bal. Dec. 5 Bal. $4,200 $4,200 Office Supplies $900 $900 $24,500 $24,500 Dec. 30 Bal. Davis, Withdrwals $1,400 $1,400 Service Revenue $1,500 Dec. 9 $1,100 Dec. 18 $2,600 Bal. Office Rent $550 $550 Utilities Expen Dec. 12 $250 Bal. $250 Dec. 2 Bal. Davis Consulting Trial Balance December 31, 2014 Balance Account Title Debit Credit Cash $16400 Accounts Receivable $1200 Equipment $1800 Furniture $4200 Office Supplies $900 Accounts Payable $4700 Unearned Revenue $1400 Davis, Capital $18000 Davis , Withdrawals $1400 Service Revenue $2600 Office Rent $550 Utilities Expense $250 Total: 26,700 $26,700 Davis Consulting Income Statement Month Ended December 31, 2014 Revenues Service Revenue $2600 Expenses Rent $550 Utilities Expense $250 Total Ex. $800 Net Income $1800 Davis, Consulting Statement of Owner Equity Month Ended December 31, 2014 Davis, Capital, December 31, 2014 $0 Owner Contribution $18000 Net Income for the month $1800 Owner Withdrawal $1400 Davis, Capital , December 31, 2014 $18400 Davis, Consulting Balance Sheet Month Ended December 31, 2014 Assets Liabilities Cash $16400 Accounts Payable $4700 Accounts Receivable $1200 Unearned Revenue $1400 Equipment $1800 Furniture $4200 Owner Equity Office Supplies $900 Davis, Capital $18400 Total Assets $24,500 Total Liabilities & Owner's Equity $24,500 8 25% nse