Question

Elliptical Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet...

Elliptical Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended June 30, 2016: Elliptical Consulting End-of-Period Spreadsheet For the Year Ended June 30, 2016 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 25,200 25,200 Accounts Receivable 52,000 52,000 Supplies 3,200 (a) 2,300 900 Office Equipment 34,000 34,000 Accumulated Depreciation 5,000 (b) 1,000 6,000 Accounts Payable 3,700 3,700 Salaries Payable (c) 330 330 Common Stock 30,000 30,000 Retained Earnings 53,200 53,200 Dividends 2,000 2,000 Fees Earned 58,000 58,000 Salary Expense 31,500 (c) 330 31,830 Supplies Expense (a) 2,300 2,300 Depreciation Expense (b) 1,000 1,000 Miscellaneous Expense 2,000 2,000 149,900 149,900 3,630 3,630 151,230 151,230 Based on the preceding spreadsheet, prepare an income statement, retained earnings statement, and balance sheet for Elliptical Consulting. Be sure to read the instructions for each financial statement carefully.

Homework Answers

Answer #1
Income statement shows the net income earned by company during the year. Net income is calculated as total revenue less total expenses.
Elliptical Consulting
Income statement for the year ended June 30,2016
Fees earned $58,000
Less: Expenses
Salary expense $31,830
Supplies expense $2,300
Depreciation expense $1,000
Miscellaneous expense $2,000
Net income $20,870
Statement of retained earnings shows the changes in retained earnings during the year.
Elliptical Consulting
Retained earnings as on 30th June 2016
Retained earnings, July 1 $53,200
Add: Net income $20,870
Less: Dividend $2,000
Retained earnings, June 30 $72,070
Balance sheet of company shows the financial position as on date. It includes assets details and how the assets are fund by way of liabilities and equity.
Elliptical Consulting
Balance sheet as on 30th June 2016
Assets
Current assets
Cash $25,200
Accounts receivable $52,000
Supplies $900
Total current assets $78,100
Property, plant and equipment
Office equipment $34,000
Less: Accumulated depreciation $6,000
Office equipment, net $28,000
Total assets $106,100
Liabilities and equity
Current liabilities
Accounts payable $3,700
Salaries payable $330
Total current liabilities $4,030
Stockholder's equity
Common stock $30,000
Retained earnings $72,070
Total stockholder's equity $102,070
Total liabilities and equity $106,100
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Financial statements from the end-of-period spreadsheet Demo Consulting is a consulting firm owned and operated by...
Financial statements from the end-of-period spreadsheet Demo Consulting is a consulting firm owned and operated by Jesse Flatt. The following end-of-period spreadsheet was prepared for the year ended August 31, 20Y9: During the year ended August 31, 20Y9, $15,000 of additional common stock was issued. Demo Consulting End-of-Period Spreadsheet For the Year Ended August 31, 20Y9 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title   Dr.   Cr.   Dr.   Cr.   Dr.   Cr. Cash 182,500 182,500 Accounts Receivable 234,500 234,500 Supplies 27,600...
Financial statements from the end-of-period spreadsheet Demo Consulting is a consulting firm owned and operated by...
Financial statements from the end-of-period spreadsheet Demo Consulting is a consulting firm owned and operated by Jesse Flatt. The following end-of-period spreadsheet was prepared for the year ended August 31, 20Y9: During the year ended August 31, 20Y9, $15,000 of additional common stock was issued. Demo Consulting End-of-Period Spreadsheet For the Year Ended August 31, 20Y9 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title   Dr.   Cr.   Dr.   Cr.   Dr.   Cr. Cash 182,500 182,500 Accounts Receivable 234,500 234,500 Supplies 27,600...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, the data for year-end adjustments are as follows: Fees earned but not yet billed, $37. Supplies on hand, $9. Insurance premiums expired, $46. Depreciation expense, $18. Wages accrued but not paid, $18. Enter the adjustment data and place...
Based upon the end-of-period spreadsheet, journalize the closing entries. Explanations should be omitted. If you are...
Based upon the end-of-period spreadsheet, journalize the closing entries. Explanations should be omitted. If you are unsure of account titles, see the chart of accounts Beacon Signals Company End-of-Period Spreadsheet For the Year Ended December 31, 2019 Unadjusted Trial Balance Adjustments Adjusted Trial Balance Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 13,000.00 13,000.00 Accounts Receivable 40,500.00 (a) 12,500.00 53,000.00 Prepaid Insurance 4,200.00 (b) 3,000.00 1,200.00 Supplies 3,000.00 (c) 2,250.00 750.00 Land 98,000.00 98,000.00 Building 500,000.00 500,000.00 Accumulated Depreciation-Building...
Finley Company End-of-Period Spreadsheet For the Year Ended December 31 Adjusted Trial Balance Income Statement Balance...
Finley Company End-of-Period Spreadsheet For the Year Ended December 31 Adjusted Trial Balance Income Statement Balance Sheet Account Title Debit Credit Debit Credit Debit Credit Cash 16,000 16,000 Accounts Receivable 6,000 6,000 Supplies 2,000 2,000 Equipment 19,000 19,000 Accumulated Depr. 6,000 6,000 Accounts Payable 10,000 10,000 Wages Payable 2,000 2,000 Common Stock 5,000 5,000 Retained Earnings 7,341 7,341 Dividends 1,000 1,000 Fees Earned 44,719 44,719 Wages Expense 20,237 20,237 Rent Expense 5,835 5,835 Depreciation Expense 4,988 4,988 Totals 75,060 75,060...
The following adjusted year-end trial balance at December 31 of Wilson Trucking Company. Account Title Debit...
The following adjusted year-end trial balance at December 31 of Wilson Trucking Company. Account Title Debit Credit Cash $ 8,900 Accounts receivable 16,500 Office supplies 2,000 Trucks 160,000 Accumulated depreciation—Trucks $ 32,960 Land 75,000 Accounts payable 12,900 Interest payable 3,000 Long-term notes payable 52,000 K. Wilson, Capital 153,332 K. Wilson, Withdrawals 19,000 Trucking fees earned 141,500 Depreciation expense—Trucks 21,259 Salaries expense 66,364 Office supplies expense 14,500 Repairs expense—Trucks 12,169 Totals $ 395,692 $ 395,692    The K. Wilson, Capital account...
The following adjusted year-end trial balance at December 31 of Wilson Trucking Company. Account Title Debit...
The following adjusted year-end trial balance at December 31 of Wilson Trucking Company. Account Title Debit Credit Cash $ 9,400 Accounts receivable 16,500 Office supplies 2,000 Trucks 164,000 Accumulated depreciation—Trucks $ 33,784 Land 75,000 Accounts payable 13,400 Interest payable 3,000 Long-term notes payable 52,000 K. Wilson, Capital 155,547 K. Wilson, Withdrawals 19,000 Trucking fees earned 128,000 Depreciation expense—Trucks 21,791 Salaries expense 60,032 Office supplies expense 7,000 Repairs expense—Trucks 11,008 Totals $ 385,731 $ 385,731    The K. Wilson, Capital account...
The following are Amena Consulting June 2007 transactions: June 1       Amena Ali, owner, invested $13,325 cash into...
The following are Amena Consulting June 2007 transactions: June 1       Amena Ali, owner, invested $13,325 cash into the business June 2       Purchased office supplies for $475 cash June 5       Purchased $6,235 of office equipment on credit June 7       Received $2000 cash as fees for services provided to a customer June 10     Paid $6,235 cash to settle the payable for the office equipment purchased on June 5 June 12     Billed a customer $3,300 as fees for services provided June 14     Paid $775 cash for monthly rent June 20     Collected...
Your friend has asked you to produce financial statements for his business, Mates Incorporated, for the...
Your friend has asked you to produce financial statements for his business, Mates Incorporated, for the year 1 July 2015 to 30 June 2016. To make your job a little more difficult he has produced his adjusted trial balance in alphabetical order as he was unaware of the proper order. Produce an Income Statement and Balance Sheet (either select from the Drop Down menu or enter an account or number in blank boxes). Do not use any form of punctuation...
Loxley Farms' is owned and operated by Ms. Robyn Hoodling. Robyn opened the business some time...
Loxley Farms' is owned and operated by Ms. Robyn Hoodling. Robyn opened the business some time ago and has had some training in basic bookkeeping. Robyn has been keeping a pretty good record of her business so far and has even managed to do some of the needed balance day adjustments already. There are a few balance day adjustment items remaining that she was unsure on and so she has enlisted your help and has provided you with her unadjusted...