Financial Accounting, Student Value Edition (5th Edition)
5th Edition
ISBN: 9780134728520
Author: Robert Kemp, Jeffrey Waybright
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 29BE
To determine
Identify whether the stock increased or decreased in attractiveness during the past two years using four ratios.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
(Learning Objectives 2, 3, 4: Reconstruct transactions from the financial statements)Parker Networking Solutions began operations on January 1, 2018, and immediately issuedits stock, receiving cash. Parker’s balance sheet at December 31, 2018, reported the followingstockholders’ equity:Common stock, $1 par...................... $ 59,000Additional paid-in capital.................. 473,500Retained earnings.............................. 40,000Treasury stock, 300 shares................ (3,600)Total stockholders’ equity............ $568,900During 2018, Parkera. issued stock for $9 per share.b. purchased 800 shares of treasury stock, paying $12 per share.c. resold some of the treasury stock.d. declared and paid cash dividends.
Using Excel to Calculate Equity Balances
PROBLEM
Pasta Creations issued additional shares of common shares,
reported net income, and declared dividends during the
year. Information concerning its equity is provided here.
Beginning of year common shares
Beginning of year retained earnings
Additional common shares issued
Net income reported
Dividends declared
$ 98,000
476,000
52,000
78,000
16,000
Student Work Area
Required: Provide input into cells shaded in yellow in this
template. Input the required mathematical formulas or functions
with cell references to the Problem area or work area as
a. Calculate the ending balances of (1) common shares, (2)
retained earnings, and (3) total shareholders' equity.
Common shares
Retained earnings
Total shareholders' equity
b. Calculate the same amounts if the company had reported a
net loss rather than net income and had not declared any
dividends.
Net loss amount
Common shares
Retained earnings
Total shareholders' equity
$
72,000
(Learning Objective 7: Calculate return on assets) Handley Grocery Corporationreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$50,000$ 2,200$40,000$48,350$ 2,100$39,300Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?
Chapter 12 Solutions
Financial Accounting, Student Value Edition (5th Edition)
Ch. 12 - Prob. 1DQCh. 12 - Which amount is the base amount for vertical...Ch. 12 - Prob. 3DQCh. 12 - Prob. 4DQCh. 12 - Prob. 5DQCh. 12 - Prob. 6DQCh. 12 - Prob. 7DQCh. 12 - How would you expect a recession to affect asset...Ch. 12 - Prob. 9DQCh. 12 - Prob. 10DQ
Ch. 12 - Prob. 1SCCh. 12 - Prob. 2SCCh. 12 - Prob. 3SCCh. 12 - Prob. 4SCCh. 12 - Prob. 5SCCh. 12 - Prob. 6SCCh. 12 - Prob. 7SCCh. 12 - Prob. 8SCCh. 12 - Prob. 9SCCh. 12 - Prob. 10SCCh. 12 - Prob. 11SCCh. 12 - Prob. 12SCCh. 12 - Prob. 1SECh. 12 - Prob. 2SECh. 12 - Prob. 3SECh. 12 - Prob. 4SECh. 12 - Prob. 5SECh. 12 - Prob. 6SECh. 12 - Prob. 7SECh. 12 - Prob. 8SECh. 12 - Prob. 9SECh. 12 - Prob. 10SECh. 12 - Horizontal analysis(Learning Objective 2)15-20 min...Ch. 12 - Prob. 12AECh. 12 - Horizontal analysis(Learning Objective 2)15-20...Ch. 12 - Prob. 14AECh. 12 - Prob. 15AECh. 12 - Prob. 16AECh. 12 - Prob. 17AECh. 12 - Horizontal analysis(Learning Objective 2)15-20...Ch. 12 - Prob. 26BECh. 12 - Prob. 27BECh. 12 - Prob. 28BECh. 12 - Prob. 29BECh. 12 - Prob. 30BECh. 12 - Trend percentages and return on assets (Learning...Ch. 12 - Common-size financial statements and profitability...Ch. 12 - Current ratio, debt ratio, EPS (Learning Objective...Ch. 12 - Calculating various ratios for analysis (Learning...Ch. 12 - Prob. 35APCh. 12 - Prob. 36APCh. 12 - Trend percentages and return on assets (Learning...Ch. 12 - Common-size financial statements and profitability...Ch. 12 - Prob. 39BPCh. 12 - Calculating various ratios for analysis(Learning...Ch. 12 - Calculating various ratios for analysis (Learning...Ch. 12 - Prob. 42BPCh. 12 - Prob. 1CECh. 12 - Prob. 1CPCh. 12 - Prob. 1EIACh. 12 - Prob. 2EIACh. 12 - Prob. 1FACh. 12 - Industry Analysis Purpose: To help you understand...Ch. 12 - Prob. 1SBACh. 12 - Prob. 1WC
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
- (Learning Objective 7: Evaluate liquidity using the quick [acid-test] ratio and days’sales in receivables) Northern Products reported the following amounts in its 2019 financialstatements. The 2018 amounts are given for comparison.2019 2018Current assets:Cash............................................ $ 9,500Short-term investments................ 7,000Accounts receivable..................... $70,100Less: Allowance foruncollectibles.......................$86,500(7,500) (5,500) 64,600Inventory..................................... 190,000Prepaid insurance ........................ 2,200Total current assets..................... 273,300Total current liabilities.................... 106,000Net sales (all on account) ................$ 9,50010,50079,000189,0002,200290,20099,0001,077,000 734,000Requirements1. Compute Northern’s quick (acid-test) ratio at the end of 2019. Round to two decimalplaces. How does the quick ratio compare with the industry average of 0.92?2. Compare days’ sales…arrow_forwardS15-7 Computing rate of return on total assets Godhi's 2014 financial statements reported the following items-with 2013 figures given for comparison: Learning GODHI, INC. Balance Sheet As of December 31, 2014 and 2013 2014 2013 $ 33,538 $ 29,562 Total Assets 17,100 14,962 Total Liabilities Total Stockholders' Equity (all common) 16,438 14,600 $ 33,538 $ 29,562 Total Liabilities and Stockholders' Equity Net income for 2014 was $3,890 and interest expense was $210. Compute Godhi's rate of return on total assets for 2014. (Round to the nearest percent.)arrow_forward(Learning Objective 7: Calculate return on assets) Hometown Supply Companyreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$84,000$ 4,200$70,000$82,600$ 4,050$69,450Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?arrow_forward
- Using Excel for financial statement analysis Download an Excel temp/ate for this problem online in MyAccountingLab or at http://www.pearsonhighered.com/Horngren Riverside Sweets, a retail candy store chain, reported the following figures: Additional financial information: a. 75% of net sales revenue are on account. b. Market price of stock is $36 per share on June 30, 2019. c. Annual dividend for 2019 was $1.50 per share. d. All short-term investments are cash equivalents. Requirements Perform a horizontal analysis on the balance sheet for 2018 and 2019. Perform a vertical analysis on the income statement. Compute the following ratios: a. Working Capital b. Current Ratio c. Acid-Test (Quick) Ratio d. Cash Ratio e. Accounts Receivable Turnover f. Days’ Sales in Receivables g. Inventory Turnover h. Days’ Sales in Inventory i. Gross Profit Percentage j. Debt Ratio k. Debt to Equity Ratio l. Times-Interest-Earned Ratio m. Profit Margin Ratio n. Rate of Return on Total Assets o. Asset…arrow_forwardFor years ended December 31 Equity Investee Financial Summary, $ millions 2018 2017 2016 Net sales... Gross margin Net income.. Cummins' share of net income. $7,352 $7,050 $5,654 1,373 1,422 1,182 647 680 499 $ 336 $ 308 $ 260 Royalty and interest income.. 58 49 41 Total equity, royalty and interest from investees... $ 394 $ 357 $ 301 Current assets $3,401 1,449 $3,416 1,379 Noncurrent assets Current liabilities.. Noncurrent liabilities.. Net assets... (2,669) (218) (2,567) (237) $1,963 $1,991 Cummins' share of net assets $1,144 $1,116 a. What assets and liabilities of unconsolidated affiliates are omitted from Cummins' balance sheet as a result of the equity method of accounting for those investments? b. Do the liabilities of the unconsolidated affiliates affect Cummins directly? Explain. c. How does the equity method impact Cummins' ROE and its RNOA components (net operating asset turnover and net operating profit margin)?arrow_forwardAdditional Activities Considering the amount of capital in starting your own business, draw a graph of profit income forecast monthly for 6 consecutive months by considering the following percentage: а. 25% d. 73% b. 40% е. 62% c. 54% f. 47%arrow_forward
- gnment #11 - Chapter 14 Question 1 of 7 Current Attempt in Progress Condensed data from the comparative statement of financial position of Penny Worth Inc. 2021 2020 2019 Current assets $114,000 $112,000 $102,000 Non-current assets 404,000 330,000 300,000 Current liabilities 111,000 99.000 96,000 Non-current liabilities 90,000 111,000 121,000 Common shares 110,000 101.000 101,000 Retained earnings 207,000 131,000 84,000 (a) Using horizontal analysis, calculate the percentage of a base-year amount, using 2019 as the b decimal place, eg. 15.2%.)arrow_forwardThe statement of retained earnings reconciles the net income earned during a given year, and any cash dividends paid, with the change in retained earnings between the start and the end of that year Select one: O True O False Next page CHAPTER 5 - STOCK VALUATION- ies CH3 Jump to... ENG 07:09 Sunny INITL 25/072021arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- PFIN (with PFIN Online, 1 term (6 months) Printed...FinanceISBN:9781337117005Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
PFIN (with PFIN Online, 1 term (6 months) Printed...
Finance
ISBN:9781337117005
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License