Question: table [ [ Magic GMBA 3 Corporation ] , [ Adjusted Trial Balance ] , [ December 3 1 , 2 0 1 9

\table[[Magic GMBA 3 Corporation],[Adjusted Trial Balance],[December 31,2019],[,$ Dr,$ Cr],[Cash,469,408,],[Accounts receivable,280,000,],[Allowance for bad debts,,4,400],[Inventory,360,000,],[Long term investment,87,200,],[Property, plant, and equipment,400,000,],[Accumulated depreciation,,160,000],[Accounts payable,,65,600],[Accrued payables,,48,000],[Unearned revenues,,64,000],[Other long term liability,,42,712],[Bonds payable,,400,000],[Discount on bonds payable,42,680,],[Deferred income tax,,25,568],[Preferred stock,,400,000],[Common stock,,40,000],[Additional paid-in capital,,440,000],[Retained earnings,,240,000],[Dividends,32,000,],[Treasury stock,304,000,],[Operating revenues,,972,000],[Cost of goods sold,480,000,],[Selling and administrative expenses,200,000,],[Depreciation expense,40,000,],[Other expense,64,000,],[Bad debt expense,3,600,],[Rent expense,80,000,],[Interest expense,35,392,],[Income tax expense,24,000,],[Totals,2,902,280,2,902,280]]to prepare (On an excel sheet - with formulas):
The income statement.
The statement of retained earnings.
The balance sheet.
Ratios that can be calculated from the data presented.
Prepare and submit a PowerPoint presentation, which includes:
Title and introduction
Objectives of comparative financial statements
The three financial statements, and the details of calculations
Detailed calculations of the ratios and your comments on the ratios calculated
Comments/Opinion on the financial health of the company
\ table [ [ Magic GMBA 3 Corporation ] , [

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!