Using Excel to Calculate Equity BalancesPROBLEMPasta Creations issued additional shares of common shares,reported net income, and declared dividends during theyear. Information concerning its equity is provided here.Beginning of year common sharesBeginning of year retained earningsAdditional common shares issuedNet income reportedDividends declared$ 98,000476,00052,00078,00016,000Student Work AreaRequired: Provide input into cells shaded in yellow in thistemplate. Input the required mathematical formulas or functionswith cell references to the Problem area or work area asa. Calculate the ending balances of (1) common shares, (2)retained earnings, and (3) total shareholders' equity.Common sharesRetained earningsTotal shareholders' equityb. Calculate the same amounts if the company had reported anet loss rather than net income and had not declared anydividends.Net loss amountCommon sharesRetained earningsTotal shareholders' equity$72,000

Shareholders' equity represents the total value of shareholders at the end of the accounting period.…

Answered: Using Excel to Calculate Equity…

Century 21 Accounting Multicolumn Journal

11th Edition

ISBN:9781337679503

Author:Gilbertson

Publisher:Gilbertson

Chapter17: Financial Statement Analysis

Section17.4: Analyzing Financial Statements Using Financial Ratios

Problem 1WT

See similar textbooks

Similar questions

Statement of stockholders equity The stockholders equity T accounts of I-Cards Inc. for the year ended December 31, 20Y9, are as follows. Prepare a statement of stockholders equity for the year ended December 31, 20Y9.
The income statement, statement of retained earnings, and balance sheet for Somerville Company are as follows: Includes both state and federal taxes. Brief Exercise 15-20 Calculating the Average Common Stockholders Equity and the Return on Stockholders Equity Refer to the information for Somerville Company on the previous pages. Required: Note: Round answers to four decimal places. 1. Calculate the average common stockholders equity. 2. Calculate the return on stockholders equity.
Calculating the Average Common Stockholders’ Equity andthe Return on Stockholders’ EquityRefer to the information for Somerville Company on the previous pages.Required:Note: Round answers to four decimal places.1. Calculate the average common stockholders’ equity.2. Calculate the return on stockholders’ equity
Please choose the correct letter of answer Which of the following is not an equity item? a. Retained earnings b. Treasury Shares c. Share Capital d. Unearned revenue The following are excluded as components of a complete set of financial statements, except * a. Environmental reports b. Statement of retained earnings c. Statement of changes in net worth d. Summarized statements of financial position for the last five years
The income statement is a financial summary of the firm's operating results during a specified period Select one: O True O False on age CHAPTER 5- STOCK VALL ctivities CH3 Jump to...
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, 20V9: 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 10,710 10,710 Accounts Receivable 25,500 25,500 Supplies 2,700 2,270 430 Land 22,190 22,190 Office Equipment 20,910 20,910 Accumulated Depreciation 2,830 1,350 4,180 Accounts Payable 6,890 6,890 Salaries Payable 330 330 Common Stock 8,600 8,600 Retained Earnings 17,410 17,410 Dividends 3,320 3,320 Fees Earned 70,770 70,770 Salary Expense 19,130 330 19,460 Supplies Expense 2,270 2,270 Depreciation Expense 1,350 1,350 Miscellaneous Expense 2,040 2,040 106,500 106,500 3,950 3,950 108,180 108,180 Based on the preceding spreadsheet, prepare an income statement for Demo Consulting. Demo Consulting…
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, 20V9: 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 10,710 10,710 Accounts Receivable 25,500 25,500 Supplies 2,700 2,270 430 Land 22,190 22,190 Office Equipment 20,910 20,910 Accumulated Depreciation 2,830 1,350 4,180 Accounts Payable 6,890 6,890 Salaries Payable 330 330 Common Stock 8,600 8,600 Retained Earnings 17,410 17,410 Dividends 3,320 3,320 Fees Earned 70,770 70,770 Salary Expense 19,130 330 19,460 Supplies Expense 2,270 2,270 Depreciation Expense 1,350 1,350 Miscellaneous Expense 2,040 2,040 106,500 106,500 3,950 3,950 108,180 108,180 Based on the preceding spreadsheet, prepare an income statement for Demo Consulting. Demo Consulting…
* CengageNOWv2 | Online teachin x E Login engagenow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre.. * еВook Show Me How Earnings per share Financial statement data for the years 20Y5 and 20Y6 for Black Bull Inc. follow: 20Υ5 20Y6 Net income $1,688,000 $2,459,000 Preferred dividends $50,000 $50,000 Average number of common shares outstanding 90,000 shares 110,000 shares a. Determine the earnings per share for 20Y5 and 20Y6. Round to two decimal places. 20Y5 20Υ6 Earnings per Share b. Is the change in the earnings per share from 20Y5 to 20Y6 favorable or unfavorable? Check My Work
Selected dividend transactions, stock splitSelected transactions completed by Canyon Ferry Boating Corporationduring the current fiscal year are as follows: Journalize the transactions.
Conduct a vertical analysis from the Balance Sheet below and select the INCORERECT observation Balance Sheet Particulars 1. Equity And Liabilities: 1. Shareholder's Funds (a) Share Capital (b) Reserve and Surplus 2. Non-Current Liabilities 3. Current Liabilities II. Assets: 1. Non-Current Assets 2. Current Assets Total Note No. Amount A Ltd. 8 Ltd. 4,00,000 5,40,000 2,00,000 2,60,000 3,00,000 2,50,000 1,00,000 1,50,000 10,00,000 12,00,000 4,00,000 7,00,000 6,00,000 5,00,000 www.Totalgoel 10,00,000 12,00,000 O a. In comparison to B. Ltd, A Ltd's existing liabilities are (10%) are in a stronger way (12.50%) O b. In comparison to A Ltd, B Ltd has a higher share capital O c. B Ltd's Non Current Assets are 18.33% higher than A Ltd O d. In comparison to A Ltd, B Ltd has a stronger long term status O e. B Ltd's Current Assets are 18.33% higher than A Ltd
The Income statement is a financial summary of the firm's operating results during a specified period Select one: O True O False Nex Jump to.. CHAPTER 5-STOCK VALUA
Statement of stockholders equity; net loss Selected accounts from the ledger of Restoration Arts for the fiscal year ended April 30, 20Y5, are as follows: Prepare a statement of stockholders equity for the year.

SEE MORE QUESTIONS

Recommended textbooks for you

Century 21 Accounting Multicolumn Journal

Accounting

ISBN:

9781337679503

Author:

Gilbertson

Publisher:

Cengage

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Century 21 Accounting General Journal

Accounting

ISBN:

9781337680059

Author:

Gilbertson

Publisher:

Cengage

Century 21 Accounting Multicolumn Journal

Accounting

ISBN:

9781337679503

Author:

Gilbertson

Publisher:

Cengage

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Century 21 Accounting General Journal

Accounting

ISBN:

9781337680059

Author:

Gilbertson

Publisher:

Cengage

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

Financial And Managerial Accounting

Accounting

ISBN:

9781337902663

Author:

WARREN, Carl S.

Publisher:

Cengage Learning,

SEE MORE TEXTBOOKS