Question: I need help filling in this excel sheet for the income statement, balance sheet, and trial balance using the transactions given for practice. Geralt Rivia

I need help filling in this excel sheet for the income statement, balance sheet, and trial balance using the transactions given for practice.

I need help filling in this excel sheet for the income statement,balance sheet, and trial balance using the transactions given for practice. GeraltRivia owns Witcher Enterprise. A trial balance for T'Challa Panther for his

Geralt Rivia owns Witcher Enterprise. A trial balance for T'Challa Panther for his yearly fiscal period and additional information follow directly. Wakanda Enterprises Trial Balance March 31, 2021 Cash 30,350.00 Accounts Receivable 4,000.00 Office Supplies 17,640.00 24,000.00 Prepaid Insurance 45,000.00 Office Equipment Accumulated Depreciation Office Equipment 22,500.00 65,000.00 26,000.00 Store Equipment Accumulated Depreciation-Store Equipment Account Payable T'Challa Panther, Capital T'Challa Panther, Drawings 37,500.00 82,090.00 21,100.00 Fees Earned 251,000.00 Rent Expense 10,000.00 General Expense 500.00 Repair Expense 1500.00 Salaries Expense 200,000.00 419,090.00 419,090.00 Additional Information 1. Office supplies on hand on September 30 are valued at $6, 100. 2. Prepaid Insurance balance of $24 000 was the original cost of the insurance on Jan 1, 2021. 3. Late invoices pertaining the September 30 fiscal period were: General Expense $ 830.00 Repair Expense 235.00 Total $1065.00 4. Depreciation on Store Equipment is calculated using the declining-balance method. Equipment depreciates at 20% 'Challa Panther, Drawings 21,100.00 Fees Earned 251,000.00 10,000.00 Rent Expense General Expense 500.00 Repair Expense 1500.00 Salaries Expense 200,000.00 419,090.00 419,090.00 Additional Information 1. Office supplies on hand on September 30 are valued at $6, 100. 2. Prepaid Insurance balance of $24 000 was the original cost of the insurance on Jan 1, 2021. 3. Late invoices pertaining the September 30 fiscal period were: General Expense $ 830.00 Repair Expense 235.00 Total $1065.00 4. Depreciation on Store Equipment is calculated using the declining-balance method. Equipment depreciates at 20% 5. The Office equipment cost $45,000 and was expected to last for 6 years. It was estimated that it would be worth $5,500 at the end of that time. (All values should be rounded to two decimal places.) Using the additional information above: a) Complete the eight-column work sheet. b) Journalize adjusting and closing entries Home Insert Page Layout Formulas Data Review View Share > X [G Calibri (Body) y 12 A === 19 Wrap Text General Cv IX V DV Y Paste BIU A EE Marge & Center $ %) Insert DAATA Format Conditional Format Call Formatting as Table Styles O Sort & Filter Find & Select E29 fy B C E E F G K L N D Worksheet Adjustment . I Year ended Mar. 31, 2021 Balance Sheet Income Statement General Journal Particulars Date P.R. C A 1 Wakanda Enterprises 2 Accounts 3 Cash 4 counts Receivable 5 Office Supplies 6 Prepaid Insurance 7 Office Equipment 8 Accumulated Depreciation Office Equipment 9 Store Equipment 10 Accumulated Depreciation Stare Ecuipment 11 Account Payable 12 T'Challa Panther, Capital 13 T'Challa Panther, Drawings 14 Fees Farrad 15 Rent Expense 16 General Expense 17 Repair Expense 18 Salaries Expense 19 20 21 22 23 24 25 26 27 28 Trial Balance 30,850.00 4,000.00 17,640.00 24,000.00 45,000.00 22.500.00 GS.CO.DO 26.000.00 37,500.00 83,377 n | 21,100.00 251,000.00 10,000.00 500 1500 200,000.00 419,050.00 419.090.00 29 | 30 Sheet1 + + 100%

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!