Financial Accounting (12th Edition) (What's New in Accounting)
12th Edition
ISBN: 9780134725987
Author: C. William Thomas, Wendy M. Tietz, Walter T. Harrison Jr.
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 12, Problem 12.60AP
Requirement 1.a.
To determine
To Compute: The quick (acid-test) ratio for E Corporation and G Company.
Requirement 1.b.
To determine
To Compute: The inventory turnover for E Corporation and G Company.
Requirement 1.c.
To determine
To Compute: The days’ sales in average receivables for E Corporation and G Company.
Requirement 1.d.
To determine
To Compute: The debt ratio for E Corporation and G Company.
Requirement 1.e.
To determine
To Compute: The times-interest-earned ratio for E Corporation and G Company.
Requirement 1.f.
To determine
To Compute: The return on common
Requirement 1.g.
To determine
The earning per share for E Corporation and G Company.
Requirement 1.h.
To determine
The price earnings ratio for E Corporation and G Company.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
213erform the 3 step DuPont Return on Equity (ROE) analysis for Brady Corp. using cell references. (25 pts) Write a brief analysis (50-100 words) of what
you learn from the DuPont analysis on your Excel worksheet.
Balance Sheet ($000)
Ratios
Calculation
Assets
Liabilities and Equity
Liquidity
Cash
2$
Accounts payable
Notes payable
1,500
12,500
Current
Marketable securities $
$
$
2,500
12,500
Quick
Accounts receivable
15,000
Total current liabilities
$ 25,000
Inventory
33,000
Long-term debt
22,000
Asset Management
Total current assets
2$
52,000
Total liabilities
47,000
Average collection period
Fixed assets (net)
35,000
Common stock (par value)
2$
5,000
Inventory turnover
Total assets
$
Fixed-asset turnover
Contributed capital in excess of par
Retained earnings
87,000
18,000
17,000
Total asset turnover
Total stockholders' equity
40,000
Total liabilities and stockholders' equity
87,000
Financial Leverage
Debt
Income Statement ($000)
Other Info
Debt-to-equity
Times interest earned
Sales…
1. You are required to do a short financial analysis using excel (20%)a. Pick a publicly - traded US company (a lot of companies are publicly traded, examples include Walmart, Apple, Google, Amazon etc)
b. Download the firms financial data from capital IQ;
2. Financial Analysis Excel Worksheet (80%)a. Using the balance sheet and income statement for analysisb. Calculate 8 ratios for the most recent 5 years (these 8 ratios are current ratio; inventory turnover; receivables turnover; total asset turnover; profit margin; equity multiplier; return on asset; return on equity), and think about the trends.c. Submit the excel worksheetGrading Criteria:This excel project is graded on completeness.
You have to finish all the requirements. The data have to be from Capital IQ
TOPIC: Financial Statement Analysis1. Calculate the debt ratio of a company that as an equity multiplier of 2.5
2. A company's sales last year were $615,000 and its net income was $45,800. It has $465,000 in assets financed only by common equity. Determine the profit margin needed to achieve a 14.5% ROE. Use 4 decimal places in your final answer. Express in percentage3. Net income for 2020 was P1,825,600. In 2021, it decreased by 53%. Still using the
2020 net income as the base year, by 2022, net income increased by 130%.
Determine the net income for 2021 and 2022, respectively.
4. P240,000 will be deposited in a fund at the beginning of each six months for 5 yrs.
Using 11% as the interest rate compounded semiannually, compute how much is in
the fund at the end of 4 ½ years just after the last deposit. (use 2 decimal places for
your final answer)
5. A company has $6,435,000 in common equity and 1,063,000 in outstanding shares.
Shares sell at a price of $30.70 each. Calculate the…
Chapter 12 Solutions
Financial Accounting (12th Edition) (What's New in Accounting)
Ch. 12 - Prob. 1QCCh. 12 - Prob. 2QCCh. 12 - Prob. 3QCCh. 12 - Prob. 4QCCh. 12 - Expressing accounts receivable as a percentage of...Ch. 12 - Kincaid Company reported the following data (in...Ch. 12 - Prob. 7QCCh. 12 - Ratios that measure liquidity include all of the...Ch. 12 - Verba Corporation has an inventory turnover of 15...Ch. 12 - The measure of a companys ability to collect cash...
Ch. 12 - A ratio that measures a companys profitability is...Ch. 12 - Prob. 12QCCh. 12 - Prob. 13QCCh. 12 - Prob. 14QCCh. 12 - Prob. 12.1ECCh. 12 - Prob. 12.1SCh. 12 - Prob. 12.2SCh. 12 - Prob. 12.3SCh. 12 - Prob. 12.4SCh. 12 - Prob. 12.5SCh. 12 - (Learning Objective 4: Evaluate a companys quick...Ch. 12 - Prob. 12.7SCh. 12 - (Learning Objective 4: Measure ability to pay...Ch. 12 - (Learning Objective 4: Measure profitability using...Ch. 12 - Prob. 12.10SCh. 12 - (Learning Objective 4: Use ratio data to...Ch. 12 - Prob. 12.12SCh. 12 - (Learning Objective 4: Analyze a company based on...Ch. 12 - Prob. 12.14SCh. 12 - Prob. 12.15SCh. 12 - Prob. 12.16AECh. 12 - Prob. 12.17AECh. 12 - Prob. 12.18AECh. 12 - Prob. 12.19AECh. 12 - Prob. 12.20AECh. 12 - Prob. 12.21AECh. 12 - Prob. 12.22AECh. 12 - Prob. 12.23AECh. 12 - Prob. 12.24AECh. 12 - Prob. 12.25AECh. 12 - Prob. 12.26AECh. 12 - Prob. 12.27BECh. 12 - Prob. 12.28BECh. 12 - Prob. 12.29BECh. 12 - Prob. 12.30BECh. 12 - Prob. 12.31BECh. 12 - LO 4 (Learning Objective 4: Calculate ratios;...Ch. 12 - Prob. 12.33BECh. 12 - Prob. 12.34BECh. 12 - Prob. 12.35BECh. 12 - Prob. 12.36BECh. 12 - Prob. 12.37BECh. 12 - Prob. 12.38QCh. 12 - Prob. 12.39QCh. 12 - Prob. 12.40QCh. 12 - Prob. 12.41QCh. 12 - Prob. 12.42QCh. 12 - Prob. 12.43QCh. 12 - Prob. 12.44QCh. 12 - Use the Orlando Medical Corporation financial...Ch. 12 - Prob. 12.46QCh. 12 - Use the Orlando Medical Corporation financial...Ch. 12 - Prob. 12.48QCh. 12 - Prob. 12.49QCh. 12 - Prob. 12.50QCh. 12 - Prob. 12.51QCh. 12 - Prob. 12.52QCh. 12 - Prob. 12.53QCh. 12 - Prob. 12.54QCh. 12 - Prob. 12.55QCh. 12 - LO 1, 2, 4 (Learning Objectives 1, 2, 4: Calculate...Ch. 12 - Prob. 12.57APCh. 12 - Prob. 12.58APCh. 12 - LO 4 (Learning Objective 4: Use ratios to evaluate...Ch. 12 - Prob. 12.60APCh. 12 - LO 2, 4, 5 (Learning Objectives 2, 4, 5: Analyze...Ch. 12 - Group B LO 1, 2, 4 (Learning Objectives 1, 2, 4:...Ch. 12 - Prob. 12.63BPCh. 12 - Prob. 12.64BPCh. 12 - LO 4 (Learning Objective 4: Use ratios to evaluate...Ch. 12 - Prob. 12.66BPCh. 12 - LO 2, 4, 5 (Learning Objectives 2, 4, 5: Analyze...Ch. 12 - Prob. 12.68CEPCh. 12 - Prob. 12.69CEPCh. 12 - (Learning Objectives 2, 3.4: Use trend...Ch. 12 - (Learning Objectives 4, 5: Calculate and analyze...Ch. 12 - Prob. 12.72DCCh. 12 - Prob. 12.73DCCh. 12 - Prob. 12.74EICCh. 12 - Focus on Financials Apple Inc. LO 1, 2, 3, 4, 5...Ch. 12 - Comprehensive Financial Statement Analysis Project...
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
- Assume you are given the following relationships for the Clayton Corporation: Sales/total assets 1.5 Return on assets (ROA) 3% Return on equity (ROE) 5% Calculate Clayton's profit margin and debt ratio.arrow_forwardProforma balance sheet for the upcoming year is given. The estimated net income is $2,621.60. If the company is planning pay $500 dividends, what should be the external financing needs (EFN)? Assets $20,972.80 Debt Equity $20,972.80 Total Total Proforma Balance Sheet Multiple Choice O O -$208.8. $208.8. $500. $291.2. -$500. $11,000.00 $10,181.60 $21,181.60arrow_forwardThe President of Paroy, has asked you to gather some statistics about his Company’s solvency. You have compiled the following data: Net Income Income Tax Rate P 900 000 34% Total Liabilities Total Stockholders 2 048 000 Interest Expense 100 000 Equity 4 352 000 REQUIRED: Using these data, calculate: 1.)Times interest earned ratio 2.)Debt ratio 3.)Equity ratioarrow_forward
- STOCK VALUATION1. If current price of stock is $25 and you hold it for one year and received dividend of $2.5. You sold itat $27. How much return you received? Show dividend yield and capital gain separately. 2. If investor required return is 20% and capital gain is 8% how much dividend company should pay?arrow_forwardAlbion Inc. provided the following information for its most recent year of operations. The tax rate is 40%. Required: 1. Compute the following: (a) return on sales, (b) return on assets, (c) return on stockholders equity, (d) earnings per share, (e) price-earnings ratio, (f) dividend yield, and (g) dividend payout ratio. 2. CONCEPTUAL CONNECTION If you were considering purchasing stock in Albion, which of the above ratios would be of most interest to you? Explain.arrow_forwardAssume you are given the following relationships for the Warner Corporation: Sales / Total assets 1.2× Return on assets (ROA) 3.95% Return on equity (ROE) 7.70%Calculate Warner’s profit margin. a. 4.74% b. 9.24% c. 3.29% d. 1.95% e. 6.42%arrow_forward
- [The following information applies to the questions displayed below.] Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Current Year $ 27,970 80, 264 100,917 9,097 251,134 $ 469,382 Exercise 13-11 (Algo) Analyzing profitability LO P3 Interest expense Income tax expense Total costs and expenses Net income Earnings per share Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity For both the current year and one year ago, compute the following ratios: $ 116,876 90,891 163,500 98,115 $ 469,382 $ 372,220 189,161 10,373 7,933 Current Year 1 Year Ago The company's income statements for the Current Year and 1 Year Ago, follow. For Year Ended December 31 Sales Cost of goods sold Other operating expenses $ 610, 197 $ 31,400 58,349 77,104 8,412 229,375 $ 404,640 579,687 $ 30,510 $1.88 $ 70,436…arrow_forwardCalculate the equity multiplier (total assets / total equity) for the firm below. Keep to 2 decimal places and do not convert it. ....for examples, if you calculate 6,000/400 = 15, you should enter 15 into BB to be marked correct. Sales $5,000 COGS $1,200 Depreciation $800 Interest $500 Net Income $200 Total Assets 6000 Total Equity 1300arrow_forwardJolie Foster Care Homes Incorporated shows the following data: Total Assets $ 1,970,000 2,460,000 2,740,000 2,830,000 Year 20X1 20X2 20X3 20X4 Net Income $ 192,000 221,000 196,000 189,000 Year 20X1 20X2 20X3 20X4 a-1. Compute the ratio of net income to total assets for each year. Note: Input your answers as a percent rounded to 2 decimal places. Return on Assets Stockholders' Equity $ 1,460,000 1,845,000 1,910,000 1,900,000 % % % % Total Debt $ 510,000 615,000 830,000 930,000arrow_forward
- Motorola Credit Corporation's annual report: Net revenue (sales) Net earnings Total assets Total liabilities Total stockholders' equity a. Find the total debt to total assets ratio. Note: Round your answer to the nearest hundredth percent. Total debt to total assets Return on equity b. Find the return on equity ratio. Note: Round your answer to the nearest hundredth percent. (dollars in millions) $ 297 163 2,175 1,880 295 Asset turnover c. Find the asset turnover ratio. Note: Round your answer to the nearest cent. Profit margin % % % d. Find the profit margin ratio on net sales. Note: Round your answer to the nearest hundredth percent.arrow_forwardMotorola Credit Corporation's annual report: (dollars in millions) %24 Net revenue (sales) Net earnings 307 168 Total assets Total liabilities Total stockholders' equity 2, 225 1,915 310 a. Find the total debt to total assets ratio. (Round your answer to the nearest hundredth percent.) Total debt to total assets b. Find the return on equity ratio. (Round your answer to the nearest hundredth percent.) Return on equity c. Find the asset turnover ratio. (Round your answer to the nearest cent.) acerarrow_forwardIf the P/E ratio in the company is 5, this means that the owner of the company is receiving $5 for every dollar the company earns Select one: O True O False Next page CHAPTER S-STOCK VALUATION vities CH3 Jump to... ENG 07:09arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Investing For Beginners (Stock Market); Author: Daniel Pronk;https://www.youtube.com/watch?v=6Jkdpgc407M;License: Standard Youtube License