I was curious if you would be able to work on this problem since


Question Description:

35

I was curious if you would be able to work on this problem since you got a perfect score on the last one! Email Problem 1.xlsx Johnson Parker is a automotive parts company that sells car parts and provides car service to customers. This is Johnson Parker’s first year of operations and they noted the following adjusted trial balance at year-end. As such, they have hired you as their CPA to prepare the income statement and balance sheet for their company. Johnson Parker has notified you of the following things to consider: 1.) Net Income hasn’t been closed out to retained earnings yet as of the end of the period. 2.) When preparing the income statement, ensure that you use the Multiple Step Method. 3.) Johnson Parker has one customer with a notes receivable balance. The customer intends to pay this balance off in 5 years. 4.) Supplies Inventory are all considered to be used within the next fiscal year. 5.) Pre-Paid Expenses are for expenses that will be incurred by Johnson Parker within the next fiscal year. 6.) Johnson Parkers investments are considered long-term. 7.) Classify all selling and administrative expenses under the operating expense section on the income statement. 8.) Items that need to be recorded net of tax for the financial statements are entered net of tax on the trial balance. Prepare the Balance Sheet and Income Statement on the following tabs below using the adjusted trial balance to the right. Account Description Accounts Payable Accounts Receivable Accumulated Depreciation Accumulated Other Comprehensive Income Additional Paid In Capital Admin Wages Expense Allowance for Doubtful Accounts Bad Debt Expense Building Cash Common Stock Cost of Goods Sold Deprecation Expense Gain on Sale of PP&E Income Tax Expense Interest Income Inventory Investment (Available for Sale) Loss on Extraordinary Items Loss on Operations of Discontinued Operations Loss on Sale of Assets of Discontinued Operations Notes Receivable Pre-Paid Expense Rent Expense Retained Earnings Revenue (Third Party Sales) Sales Team Wages Service Revenue Supplies Supplies Expense Unearned Service Revenue Wages Payable Amount 1,000,000 1,500,000 300,000 140,000 4,999,000 2,000,000 20,000 20,000 3,000,000 500,000 1,000 5,000,000 300,000 100,000 1,080,000 10,000 1,500,000 250,000 20,000 50,000 30,000 1,200,000 610,000 310,000 8,000,000 1,000,000 4,000,000 300,000 400,000 100,000 400,000 Balance Sheet Classifications Assets: Current Assets Long Term Investments Property Plant and Equipment Intangible Assets Other Assets Liabilities: Current Liabilities Long- Term Debt Stockholders Equity Note: ITEMS IN WHITE ARE ITEMS THAT COULD BE FILLED IN BY YOU. JUST BECAUSE IT IS WHITE, DOES NOT MEAN THERE HAS TO BE SOMETHING THERE. Johnson Parker Multiple Step Income Statement-Fiscal Year End 12/31/20xx (Enter Account (Enter Account (Enter Account Total Revenue (Enter Account (Enter Account Gross Profit Discription) Discription) Discription) Discription) Discription) – Operating Expenses (Selling and Administrative) (Enter Account Discription) (Enter Account Discription) (Enter Account Discription) (Enter Account Discription) (Enter Account Discription) (Enter Account Discription) (Enter Account Discription) (Enter Account Discription) Total Operating Expenses – Income from Operations – Other Revenues (Enter Account Discription) (Enter Account Discription) Total Other Revenues – Other Expenses (Enter Account Discription) (Enter Account Discription) Total Other Expenses – Income from Continued Operations (Before Tax) – (Enter Account Discription) Income from Continued Operations – Discontinued Operations (Enter Account Discription) (Enter Account Discription) Net Discontinued Operations – Income Before Extraordinary Items – (Enter Account Discription) Net Income – Note: ITEMS IN WHITE ARE ITEMS THAT COULD BE FILLED IN BY YOU. JUST BECAUSE IT IS WHITE, DOES NOT MEAN THERE HAS TO BE SOMETHING THERE. Assets (Enter Balance Shee

Answer

35