Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I just need the balance sheet and the income statement Spreadsheet Applications JAMES FINANCIAL SERVICES Woody James started James Financial Services, a financial services Consulting

I just need the balance sheet and the income statement

image text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Commercial Energy Auditing Reference Handbook

Authors: Steve Doty

3rd Edition

1498769268, 978-1498769266

More Books

Students also viewed these Accounting questions

Question

5. Describe how contexts affect listening

Answered: 1 week ago