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 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
Get step-by-step solutions from verified subject matter experts
