Can you just make a trial balance, income statement, owners equity statement and balance sheet from the ending balances in the accounts

Spreadsheet Applications JAMES FINANCIAL SERVICES Woody James started James Financial Services, a financial services Consulting business, a year ago. Below is the trial balance as of June 1, 2016 and transactions that occurred during the month of June in 2016. Use Excel to enter beginning balances in the accounts and complete the requirements below for James Financial Services fo the month of June: JAMES FINANCIAL SERVICES TRIAL BALANCE Beginning Balances for the General Ledge Cash Account Receivable Building Equipment Supplies Telephone Expense Salaries Expense Utilities Expense Depreciation Supplies Payable Notes Payable Accumulated Depreciation Equity ervice Revenue 29,200.00 5,900.00 100,000.00 8,000.00 200.00 600.00 2,500.00 200.00 194.00 200.00 83,000.00 194.00 50,000.00 13,400.00 OTAL 146,794.00 146,794.00 Transactions during the month of June. net Purchased equipment for $100,000, paying $25,000 in cash and note for the balance Equipment has a useful life of 3 years and 55,000 salvage value June 5 Purchased office supplies of $600 on credit June 8 Provided services to customers, receiving cash, $20,000 June 10 Provided services to customers on credit, $14,400 June 15 Paid salaries, $10,000 cash June 15 Paid Utilities, $400 June 16 Collected $7,500 from customers on account June 18 Paid telephone bill, $600 June 20 Provided services to customers on credit, $14,000 June 30 Made adjusting entries for office supplies used. S300 and depreciation on office equipment and building using straight-line method. The Building has a useful life of 20 years. REQUIRED: USE EXCEL TO: A Enter the balances from the Trial Balance in the worksheet B. Develop Accounts in a General Ledger and Post the balances from the Trial Balance as beginning balances in the General Ledger C. Journalize the transactions for the month of June in general journal format D. Using formulas, Post journal entries to general ledger E. Using formulas, Generate a trial balance, income statement, owners' equity statement and balance sheet from the ending balances in the Accounts PLEASE NOTE THAT YOU MUST USE FORMULAS TO GENERATE EACH COMPONENT AFTER YOU JOURNALIZE THE TRANSACTIONS. EACH COMPONENT SHOULD BE IN A SEPARATE WORKSHEET AND YOU MUST LINK EACH OF THESE WORKSHEETS TOGETHER TO GENERATE THE FINANCIAL STATEMENTS