Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 12, Problem 5R
Click the Chart sheet tab. The stacked bar chart shows Chenʼs equity account balances at December 31, 2013. Match the stacked bars (A–G) that best describe what will happen to the equity accounts if the following transactions and events occur in 2014.
Letters may be repeated or not used. Consider each case independently. 
When the assignment is complete, close the file without saving it again.
TICKLERS (optional)
Worksheet. Suppose that the $54,000 “Additional paid-in capital” balance at December 31, 2011, comes from two ledger accounts: $42,000 from Paid-in capital in excess of par and $12,000 from Paid-in capital from
Chart. Using the STOCKEQ4 file, prepare a column chart showing the dollar amount of each of the stockholdersʼ equity account balances at December 31, 2013. Treasury stock can be shown as a negative value. Enter your name somewhere on the chart. Save the file again as STOCKEQ4. Print the chart.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Please don't use chat gpt. Also provide in text. Thank you
During its first year of operations, Bonita Corporation had the following transactions pertaining to its common stock.
Jan. 10
Mar. 1
July
Sept.
1
1
Issued 83,700 shares for cash at $6 per share.
Issued 5,000 shares to attorneys in payment of a bill for $37,000 for services rendered in helping the company to
incorporate.
Issued 32,100 shares for cash at $8 per share.
Issued 63,100 shares for cash at $10 per share.
Questions are attached in the screenshot below
greatly appreciate the hlep
thanks
@%12512oo
o--
Chapter 12 Solutions
Excel Applications for Accounting Principles
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- N3.arrow_forwardhelparrow_forwardAdjusted Trial Balance As of 12/31/20xx Accounts Account Balances Cash $20,521 28,000 4,000 Accounts Receivable Allowance for Uncollectible Accounts 35,000 Prepaid Rent Equipment Accumulated Depreciation Accounts Payable 40,114 10,000 10.521 |10,000 30,000 Deferred Revenue Common Stock Retained Carnings 10,000 Dividends 3,000 Service Revenue 65.114 1.000 4.000 4.000 4.000 Sales Discounts Rent Expense Interest Expense Income Tax Expense Question:Based on the Partial Trial Balance and Additionalarrow_forward
- Prepare a Statement of Owner's Equity using the information provided for Pirate Landing for the month of October 2018. If used, type in the account names exactly as written here. Account Normal Balances Cash $14,500 Pirate Pete, Capital October 1 $56,000 Net Loss October 2018 $7,800 Owner Investments $1,500 Wages Payable $3,250 Supplies Expense $750 Owner Withdrawals $100 PLEASE NOTE: When you fill in the dollar amounts, you must include a $ and commas as needed (i.e., $1,234). Increases: Total Increases Decreases: Total Decreasesarrow_forwardI posted this a few days ago. In the attached image is the updated trial balance. All I need is help with creating the balance sheet from the provided data. ACC 122 Fall 2020Comprehensive ProjectBestValue Corporation's Trial Balance at December 31, 20XX is presented below.All 20XX transactions have been recorded except for the items described on the next page.Debit CreditCash $ 109,890Accounts Receivable 28,789Inventory 25,540Debt Investments 0Land 55,674Buildings 215,850Equipment 75,120Allowance for Doubtful Accounts $ 1,027Accumulated Depreciation-Buildings 63,306Accumulated Depreciation-Equipment 16,048Accounts Payable 35,278Interest Payable 0Unearned Rent Revenue 48,900Dividends Payable 0Income Tax Payable 0Bonds Payable 0Discount on Bonds Payable 0Common Stock ($2 par) 29,200Paid in Capital in Excess of Par-Common Stock 44,580Preferred Stock ($60 par) 0Paid in Capital in Excess of Par-Preferred Stock 0Retained Earnings 107,904Treasury Stock 0Cash Dividends 0Sales Revenue…arrow_forwardcomplete the table by using 2 Data Tables. Given that the balance sheet is at May31,2020. There are options provided for the "Accounts" column in the second attachment , choose the most suitable 4 options among the 9 and write down its debit and credit.arrow_forward
- Using the picture for reference, why would the capital account result in 66,675 if the data table shows a seperate number?arrow_forwardPrepare the journal entries for these transactions, assuming that the common stock is no-par with a stated value of $3 per share. (List all debit entries before credit entries. Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Record entries in the order displayed in the problem statement.)arrow_forward(a) Prepare the journal entries for these transactions, assuming that the common stock has a par value of $2 per share. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Date Account Titles and Explanation Debit Credit choose a transaction date Jan. 5Aug. 1Sept. 20Dec. 19 enter an account title enter a debit amount enter a credit amount enter an account title enter a debit amount enter a credit amount enter an account title enter a debit amount enter a credit amount choose a transaction date Jan. 5Aug. 1Sept. 20Dec. 19 enter an account title enter a debit amount enter a credit amount enter an account title enter a debit amount enter a credit amount enter an account title enter a debit amount…arrow_forward
- help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardDuring its first year of operations, Bridgeport Corporation had the following transactions pertaining to its common stock. Jan. July 10 1 Issued 66,000 shares for cash at $6 per share. Issued 44,500 shares for cash at $10 per share.arrow_forwardFor an accessible version, see the Excel spreadsheet. Locate the formula in the textbook and calculate the 2022 Current Ratio (Liquidity). Fill in the numerator and denominator using the financial statements provided (no symbols or commas) and the answer should be in a XX.XX % format: Blank 1; ÷ Blank 2; = Blank 3% Blank 1 Blank 2 Blank 3 Add your answer https://multimedia.phoenix.edu/cms/202337987 Add your answer Add your answerarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
The ACCOUNTING EQUATION For BEGINNERS; Author: Accounting Stuff;https://www.youtube.com/watch?v=56xscQ4viWE;License: Standard Youtube License