Question: Using Excel and the following expanded ledger accounts, create an income statement for Niagara Gym Inc (owner: Alexia Jones). Date the Income Statement for the

 Using Excel and the following expanded ledger accounts, create an income

Using Excel and the following expanded ledger accounts, create an income statement for Niagara Gym Inc (owner: Alexia Jones). Date the Income Statement for the month ending December 31, 2020. Be sure to place the accounts in the correct order and provide a correct format. Note: Not all accounts will be used. Use Excel formulas to determine the net incomeet loss of the fiscal period and the total revenues/expenses. Explain, with the net income/oss obtained, how this figure would affect the capital account of the company. Accounts Balances Accounts Balances Accounts Payable 31,255 Equipment 17,800 Accounts Receivable 7,540 Members Fees 14,600 Automobile 41,520 Advertising Expense 2,880 Bank 31,600 Land 74,560 99,000 Begining Capital 21,500 Building 65,000 Loan Payable Mortgage Payable Phone Expense 32,480 3,850 Salaries Expense 190 42,590 Tanning Bed Rental 650 Maintenance Expense Drawings 7,500 2,690 Interest Expense Towel Rental 160

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!