This assignment reviews the Income Statement, Statement of Retained Earnings and Balance Sheet. It is also a review of excel functions and formulas.
Using the trial balance given at the top, complete the financial statements below.
Complete statement titles, account titles and amounts.
The cells highlighted in yellow need to be filled in.
If the cell is a title, it can be typed.
If the cell is an amount, it needs to be cell reference.
If the cell is a formula, you need to set up an excel formula.
No numbers should be typed for this assignment.
JBT, Inc.
Trial Balance
For the year ended 12/31/XX
AccountDebitCredit
Cash 15,000
Accounts Receivable 8,600
Supplies 1,500
Equipment 13,000
Accumulated Depreciation - Equipment 750
Building 40,000
Accumulated Depreciation - Building 2,000
Accounts Payable 6,500
Salaries Payable 2,300
Unearned Revenue 2,000
Dividends 400
Common Stock 10,000
Retained Earnings 45,000
Service Revenue 16,900
Utility Expense 400
Rent Expense 1,000
Supplies Expense 2,500
Depreciation Expense - Building 500
Depreciation Expense - Equipment 250
Salary Expense 2,300
85,450 85,450
Title
Title
Title
RevenuesAmount
Expenses:
TitleAmount
TitleAmount
TitleAmount
TitleAmount
TitleAmount
TitleAmount
Total ExpensesFormula
TitleFormula
Title
Title
Title
Retained Earnings, January 1Amount
TitleAmount
TitleAmount
Retained Earnings, December 31Formula
Title
Title
Title
Assets
Current
TitleAmount
TitleAmount
TitleAmount
Total CurrentFormula
PP&E
TitleAmount
TitleAmount
Formula
TitleAmount
TitleAmount
Formula
Total PP&EFormula
Total AssetsFormula
Liabilities:
Current
TitleAmount
TitleAmount
TitleAmount
Total CurrentFormula
Stockholder's Equity
TitleAmount
TitleAmount
Total EquityFormula
Total Liabilities and EquityFormula
We need at least 9 more requests to produce the answer.
1 / 10 have requested this problem solution
The more requests, the faster the answer.
This assignment reviews the Income Statement, Statement of Retained Earnings and Balance Sheet. It is also a review of excel functions and formulas. Using the trial balance given at the top, complete the financial statements below. Complete statement ti
Requirement: Using this adjusted trial balance, complete an income statement, a statement of retained earnings, and a balance sheet. Make sure all three are in good form. Bertrand Irrigation System Adjusted Trial Balance December 31, 2018 Balance Account Title Debit Credit Cash $12,000 Accounts Receivable 46,200 Office Supplies 17,700 Prepaid Insurance 4,600 Building 58,000 Accumulated Depreciation—Building $24,300 Equipment 26,000 Accumulated Depreciation—Equipment 7,600 Accounts Payable 27,100 Interest Payable 1,800...
Prepare a Trial Balance, Multi Step Income Statement, Retained Earnings Statement, and Classified Balance Sheet the values needed are all the way on the left in the photo. i started the trial balance (the green chart) but could not get both sides to equal. ACCT 251 EXCEL ASSIGNMENT - PREPARING FINANCIAL STATEMENTS IN EXCEL (see instructions tab for detailed instructions) Prepare a multi-step income statement: Prepare a retained earnings statement: Prepare a classified balance sheet: 1,001,360 101,360 591,680 Service Revenue...
Prepare the Statement of Retained Earnings from the Adjusted Trial Balance and Income Statement. Within each section of the statement, use the drop-down menus to enter the accounts in Chart of Accounts order and select the account balances. Prepare the Statement of Retained Earnings from the Adjusted Trial Balance and Income Statement. Within each section of the statement, use the drop-down menus to enter the accounts in Chart of Accounts order and select the account balances. SMART TOUCH LEARNING SMART...
Using the trial balance below: complete the income statement, the statement of retained earnings and a balance sheet. Johnny Dollar's Body Shop Trial Balance December 31, 2020 6500 475 2500 600 35200 Cash Accounts receivable Body shop supplies Office supples Body shop equipment Accounts payable Common stock Retained earnings Dividends Revenue earned Body shop supplies expense Office supplies expense Rent expense Utilities expense Wages expense 1500 10000 11775 36000 95000 3425 775 6000 4800 22000
Assignment: Prepare in proper form: The Balance Sheet The Statement of Retained Earnings The Income Statement Calculate the Current Ratio Calculate Working Capital Carlson & Chan Sports Mgt Incorporated Trial Balance July 31, 2020 Debit Credit $ 345,567 56,788 12,500 2,250 2,000 345,670 $ 35,400 1,450,000 245,000 345,050 179,748 105 120 130 140 145 170 171 175 176 190 195 210 215 230 270 310 320 320 405 505 510 520 530 545 550 560 565 570 575 Cash...
Prepare a trial balance, multi-step income statement, statement of retained earnings, and classified balance sheet for Porter Company as of December 31, 2017 using the information on the preceeding tab. THERE ARE EXACTLY ENOUGH HIGHLIGHTED LINES FOR EACH ONE 1ACCT 251 EXCEL ASSIGNMENT PREPARING FINANCIAL STATEMENTS IN EXCEL Prepare a trial balance, multi-step income statement, statement of retained earnings, and classified balance sheet for Porter Company as of December 31, 2017 using the information on the preceeding tab. Working together...
Assignment: 1) complete the accountants worksheet excel (pictured below) 2) on a separate sheet, INCOME STATEMENT 3) on a separate sheet, RETAINED EARNINGS 4) on a separate sheet, BALANCE SHEET 5) on a separate sheet, ADJUSTING/CLOSING ENTRIES 6) POST CLOSING TRIAL BALANCE* Income Statement Debit Credit R. E. Statement Debit Credit Balance Sheet Debit Credit Unadjusted Trial Bal. Debit Credit 37,000 18,600 31,900 80,000 120,000 36,200 14,200 GWS Incorporated Accountant's Worksheet For the Month Ended September 30, 2010 Adjustments Adjusted...
Prepare an Income Statement and a statement of Retained Earnings sheet. Also, calculate profit margin and payout ratio. XYZ Company Adjusted Trial Balance Debit Credit Cash 9,800 Accounts receivable 5,250 5,300 Supplies Prepaid Advertising 3,000 Trucks 30,300 $ 10,000 Accumulated depreciation – Trucks Equipment 7,600 Accumulated depreciation – Equipment 2,100 Accounts payable 1,200 Unearned service fees 6,700 Common Stock 10,000 Retained earnings 16,050 Dividends 12,000 Service fees earned 90,000 Wages expense 29,800 Rent expense 10,200 Insurance expense 4,900 Supplies expense...
Use the information presented in this worksheet to prepare an income statement, retained earnings statement, and balance sheet. Show cell references if possible. ESP Corporation Worksheet for year ended December 31, 2018 Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Cash 5,900 $ 5,900 $ 5,900 Accounts Receivable 12,450 $ 2,800 $ 15,250 $ 15,250 Office Supplies $ 200 $ 200 $ 200 Prepaid insurance 2,400 $ 1,800 $ 600 $ 600 Equipment 169,000 $ 169,000 $ 169,500...
prepare an income statement, statement of retained earnings, and balance sheet. Sharon Silver, Registered Dietician July 31, 2017 Account Titles Balance Dividends $2,300 Unearned Revenues $1,500 Utilities Expense $150 Cash $36,200 Office Supplies $1,800 Rent Expense $500 Accounts Receivable $9,100 Accounts Payable h# $3,300 Retained Earnings (Beginning Balance) $0 Salaries Expense $1,700 Prepaid Insurance $2,000 Equipment $13,000 Notes Payable $30,000 Common Stock $23,150 Service Revenue $8,800