PHOENIX MEDICAL:
MANAGER'S NOTES and QUESTIONS: Use the following information to complete the spreadsheets.
1. The client depends on you, the CPA, to provide journal entries for activity in fixed assets. While discussing fixed assets, the client divulges that he got a great deal to upgrade his laser dermatology equipment. Ultimately, you find out that $569,888 of new equipment was purchased and placed in service on 6/18/2014.
2. Furthermore, and much after the fact, you discover that old medical equipment was sold to an unrelated party for $75,000 cash. The original cost of the equipment was $300,000 and it was fully depreciated (no Sec. 179). The cash was deposited in one of the shareholders personal accounts.
a. Provide a journal entry to calculate the gain on sale and adjust the fixed asset and accumulated depreciation accounts. (Use the AJEs worksheet)
b. What is the nature of this gain?
c. Could the Dr. have structured this sale in a different way to avoid taxable income? How?
3. The client depends on his accountant to provide a journal entry for the annual depreciation expense. They have adopted a policy of treating book depreciation equal to tax depreciation. Depreciation expense for the year will include:
a. Depreciation on assets placed in service prior to 2014 is: $86,769
b. Maximize Sec. 179 expense on assets placed in service in 2014. (Only book the maximum here)
c. Take Sec. 168(k) - 50% Bonus - on new equipment if applicable.
Step 1: Determine Adjusted Book Income (Book Journals):
You are provided with the unadjusted trial balance (found on Phoenix Medical Data) as well as your manager's meeting notes and questions (found above) for your new tax client: Phoenix Medical.
Using the Workbook found under the Phoenix Medical Data link, use the worksheets to complete your work. Note there are several worksheets to use as well as footnotes to give you hints. Start with the journal entry worksheet. You will also note the journal entries and adjustments are already noted on the trial balance. You are to enter to the right of these notations.
Read the above client information, then adjust the unadjusted trial balance to generate a trial balance workpaper that includes: (Use the Trail Balance worksheet)
a. Adjusting Journal Entries based on the notes (Adj1 and 2).
b. While analyzing the financial information, you find that hidden in Accounts Payable is $28,953 of accrued salaries. You also find that the salaries were paid in the first week of February (r under book adjs).
- a. Does this have an impact on taxable income?
Step 2: Determine Taxable Income (Tax Adjustments):
Determine taxable income. Show all adjustments in the Microsoft® Excel spreadsheet. Footnote references are provided to assist you.
NOTE: The Dr. has filed his prior tax returns on the cash basis.
a. What questions will you ask to be sure he can continue to file on the cash basis?
You find that in 2014, the Dr. qualifies, and choose to file on the cash basis. His books are kept on the accrual basis.
Determine the adjustments needed and enter adjustment amount under Tax Adjustments. - (Use the Trail Balance worksheet)
1. No federal taxes were paid in 2013, and no estimated taxes were paid in 2014 (info only).
2. Within the state tax expense, you find $4,389 is late payment penalties (d).
3. Determine the accrual to cash adjustments for accounts receivable and accounts payable. (Change in AP and AR balances between the years) (a and f)
4. A charitable contribution carryforward of $40,000 is available (b).
5. Adjustment for meal and entertainment (c).
6. Adjustment for Tax exempt interest (e).
7. Included in insurance expense is $12,523 of officers' life insurance. You determine the company is the beneficiary, and each officer is a greater than 20% shareholder.
- a. Is there an adjustment necessary? Why or why not?
Step 3: Answer Manager's Questions:
Answer your manager's questions (highlighted in bold above - there are 5 total). Use Word and make sure your paper is in proper APA format. No need for intro or conclusion. References are required.
Attachment:- Spreadsheet.rar