From the Adjusted Trial Balance, find the entry for the: Income Statement, Statement of Retained Earnings, and the Balance Sheet. (I have done the income statement, but couldn't get the answer for statement of retained earnings and balance sheet). Please let me know if you need more information and thank you so much for the help.
Sharpe Incorporated | ||
Adjusted Trial Balance | ||
December 31, 2020 | ||
Account Name | Debit | Credit |
Cash | 947,725 | |
Accounts Receivable | 1,475,000 | |
Prepaid Insurance | 22,875 | |
Land | 352,000 | |
Equipment | 195,000 | |
Accumulated Depreciation | 19,580 | |
Vacation Pay Payable | 11,880 | |
Interest Payable | 5,833 | |
Notes Payable | 38,840 | |
Common Dividends Payable | ||
Preferred Dividends Payable | ||
Bonds Payable | 1,000,000 | |
Bond Discount | 67,774 | |
Common Stock | 115,208 | |
PIC in Excess of Par - Common Stock | 664,392 | |
Preferred Stock | 189,000 | |
PIC in Excess of Par - Preferred Stock | 337,000 | |
PIC - Treasury Stock | ||
Stock Dividend Distributable | ||
Retained Earnings | 26,589 | |
Treasury Stock | 20,900 | |
Fees Earned | 1,975,000 | |
Advertising Expense | 140,000 | |
Commissions Expense | 63,000 | |
Depreciation Expense | 19,580 | |
Insurance Expense | 13,725 | |
Legal & Accounting Expense | 18,000 | |
Medical Insurance Expense | 32,000 | |
Miscellaneous Expense | 8,400 | |
Rent Expense | 170,000 | |
Salary Expense | 760,000 | |
Utilities Expense | 13,200 | |
Vacation Pay Expense | 11,880 | |
Interest Expense | 52,264 | |
4,383,322 | 4,383,322 |
Income Statement | ||
Particulars | Amount | Amount |
Fees Earned | 1975000 | |
Less: Expenses | ||
Advertising Expense | 140,000 | |
Commissions Expense | 63,000 | |
Depreciation Expense | 19,580 | |
Insurance Expense | 13,725 | |
Legal & Accounting Expense | 18,000 | |
Medical Insurance Expense | 32,000 | |
Miscellaneous Expense | 8,400 | |
Rent Expense | 170,000 | |
Salary Expense | 760,000 | |
Utilities Expense | 13,200 | |
Vacation Pay Expense | 11,880 | |
Interest Expense | 52,264 | |
Total Expenses | 1,302,049 | |
Net income | 672,951 | |
Statement of retained Earnings | ||
particulars | Amount | Amount |
Beginning Retained Earnings | 26589 | |
Add: Net Income | 672,951 | |
Less: Dividend distributable to common Stock | 0 | |
Ending retained Earnings | 699540 |
Balance Sheet | ||
Assets | Amount | Amount |
Current Assets | ||
Cash | 947725 | |
Accounts receivable | 1475000 | |
Prepaid insurance | 22875 | |
Total Current Assets | 2445600 | |
Land | 352000 | |
Equipment | 195000 | |
Accumulated depreciation | 19580 | 175420 |
Total Assets | 2973020 | |
Liabilities and Shareholder's Equity | ||
Current liabilities | ||
vacation pay payable | 11880 | |
interest payable | 5833 | |
Notes payable | 38840 | |
Total Current Liabilities | 56553 | |
Bond payable | 1000000 | |
Less: Discount | 67774 | |
932226 | ||
Total Liabilities | 988779 | |
Shareholder's Equity | ||
Preferred Stock | 189000 | |
Common Stock | 115208 | |
Treasury Stock | -20900 | |
Paid in capital in Excess of par- preferred | 337000 | |
paid in capital in Excess of par- Common | 664392 | |
Total paid up Capital | 1284700 | |
Retained earnings(26589+672951) | 699,540 | |
Total liabilities and Shareholder's Equity | 2,973,019 |
Note: Since there is $1 excess in the Debit balance of Adjusted Trial balance, hence that $1 extra is carried in Asset Balance
From the Adjusted Trial Balance, find the entry for the: Income Statement, Statement of Retained Earnings,...
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 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...
Adjusted trial balance to income statement, retained earnings and balance sheet hanges NOTE: This is a DIFFERENT COMPANY. Using the trial balance below, complete Step Income Statement and prepare the Statement of Retained Earnings and Red Balance sheet on the pages which follow. To get full credit you must include all me Matteo lo critical subtotals. Jackson Company Adjusted Trial Balance December 31, 2015 DEBIT 1.900 2,460 CREDIT 670 200 20 3,000 150 10,720 1,970 600 670 20 50 1,400...
CHART OF ACCOUNTS:CashAccounts ReceivablePrepaid InsuranceLandEquipmentAccumulated DepreciationVacation Pay PayableInterest PayableNotes PayableCommon Dividends PayablePreferred Dividends PayableBonds PayableBond DiscountCommon StockPIC in Excess of Par - Common StockPreferred StockPIC in Excess of Par - Preferred StockPIC - Treasury StockStock Dividend DistributableRetained EarningsTreasury StockFees EarnedAdvertising ExpenseCommissions ExpenseDepreciation ExpenseInsurance ExpenseLegal & Accounting ExpenseMedical Insurance ExpenseMiscellaneous ExpenseRent ExpenseSalary ExpenseUtilities ExpenseVacation Pay ExpenseInterest Expense
Cornerstone Exercise 3-25 Preparing a Retained Earnings Statement Sparrow Company had the following adjusted trial balance at December 31, 2019 Sparrow Company Adjusted Trial Balance December 31, 2019 Debit Credit Cash $3,150 Accounts Receiva ble 5,650 Prepaid Insurance 4,480 42,000 Equipment Accumulated Depreciation, $24,000 Equipment Accounts Payable 2,800 Salaries Payable 4,450 Unearned Service Revenue 3,875 Common Stock 8,000 Retained Earnings 2,255 Dividends 10,500 Service Revenue 99,600 Salaries Expense 49,400 Rent Expense 17,250 Insurance Expense 2,200 Depreciation Expense 4,950 Income Tax...
R THE L ord you 4. Use the Adjusted Trial Balance numbers to complete the Income Statement, Statement of Retained Earnings, and Balance Sheet For purposes of the Income Statement, prepare using the multiple step format and assume that Rent Revenue, any Unrcalized Holding Gains/Losses, Interest Expense, Interest Revenue, and any other Gains/Losses are NOT part of the major central ongoing operations of the company. For purposes of the Balance Sheet, be sure to prepare a classifed Balance Sheet. Link...
Cornerstone Exercise 3-25 (Algorithmic) Preparing a Retained Earnings Statement Sparrow Company had the following adjusted trial balance at December 31, 2019. Sparrow Company Adjusted Trial Balance December 31, 2019 Debit $3,150 5,650 Credit Cash Accounts Receivable Prepaid Insurance 4,480 42,000 Equipment Accumulated Depreciation, Equipment Accounts Payable Salaries Payable $24,000 2,800 4,450 3,875 8,000 2,255 Unearned Service Revenue 10,800 99,900 Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Insurance Expense Depreciation Expense Income Taxes Expense 49,400 17,250 2,200...
Instructions: Below is the adjusted trial balance for Central Advertising Inc. (1) Prepare an Income Statement, Statement of Retained Earnings, and a Balance Sheet. (2) Then prepare closing entries, post them to t-accounts, and prepare a post-closing trial balance. Central Advertising Inc. Adjusted Trial Balance August 31, 20xx Income Statement $19075 4750 1250 700 8000 $ 200 600 2000 Cash Accounts Receivable Prepaid Insurance Advertising Supplies Equipment Accumulated Depe Accounts Payable Unearned Revenue Interest Payable Notes Payable Common Stock Retained...
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...
The adjusted trial balance of rain company appears below using the information from the adjusted trial balance you are to prepare for the month ending December 31 1. an income statement 2. A retained earnings statement 3. A balance sheet figure out ş Problem #4 - 30 Points (FORMATTING IMPORTANT) The adjusted trial balance of Ryan Company trial balance, you are to prepare for the ance of Ryan Company appears below. Using the information from the adjusted you are to...