MyLab Accounting with Pearson eText -- Access Card -- for Financial Accounting
12th Edition
ISBN: 9780134727677
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.17AE
To determine
To Prepare: The trend percentages for revenues and net income of Company B.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
PROGRAMS
SELF DEVELOPMENT
E-LIBRARY
8.
6.
10
11 12
13
14
15
16
Your company wants to invest JD 10,000,000 in network, taking into consideration the below table
Investment
10,000,000.00
Lifetime
Annual Revenues in Yearl
2,000,000.00
2%
Annual decline in revenues from Y2
30%
Direct Cost % of revenues
15%
OPEX % of revenues
7%
Interest Discount rate/fWACC)
CO
1. Using the data in the student spreadsheet file Ethan Allen Financials.xlsx forecast the 2019 income statement and balance sheet for Ethan Allen. Use the percent of sales method and the following assumptions: (1) sales in FY 2019 will be $797.3359; (2) the tax rate will be 35%; (3) each item that changes with sales will be the five-year average percentage of sales; (4) net fixed assets will increase to $300; and (5) the common dividend will be $0.75 per share. Use your judgment on all other items. a. What is the discretionary financing needed in 2019? Is this a surplus or deficit? b. Assume that the DFN will be absorbed by long-term debt and that the interest rate is 4% of LTD. Set up an iterative worksheet to eliminate it.
(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?
Chapter 12 Solutions
MyLab Accounting with Pearson eText -- Access Card -- for Financial 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
- (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_forward(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?arrow_forwardMacmillan Learning Assume that a three-month CD purchased for $1900 pays simple interest at an annual rate of 7%. How much total interest does it earn? What is the balance at maturity? (Enter your answers rounded to the nearest cent.) earned interest: $ balance at maturity: $ Barrow_forward
- (Learning Objective 7: Calculate return on assets) Oscar Optical Corporation providesa full line of designer eyewear to consumers. Oscar reported the following information for 2018and 2017:2018 2017Sales revenue ...............................Net income..................................Average total assets.....................$500,000$ 43,700$230,000$410,000$ 34,650$210,000Compute return on assets (ROA) for 2018 and 2017. Using the DuPont model, identify thecomponents and state whether each improved or worsened from 2017 to 2018.arrow_forwardS11-11 Accounting for warranty expense and warranty payable Learning Objective 3 Trail Runner guarantees its snowmobiles for three years. Company experience indicates that warranty costs will be approximately 5% of sales. Assume that the Trail Runner dealer in Colorado Springs made sales totaling $600,000 during 2018. The company received cash for 20% of the sales and notes receivable for the remainder. Warranty payments totaled $10,000 during 2018. Requirements 1. Record the sales, warranty expense, and warranty payments for the company. Ignore cost of goods sold. 2. Assume the Estimated Warranty Payable is $0 on January 1, 2018. Post the 2018 transactions to the Estimated Warranty Payable T-account. At the end of 2018, how much in Estimated Warranty Payable does the company owe?arrow_forwardTAM GENERAL MATHEMATICS FOR SENIOR HIGH SCHOOL 13) A thousand dollars is left in a credit union drawing 7% compounded monthly. What is the balance at the end of 10 years? amount for st. It is an the bank of the iturity f the 14.) S1750 is invested in an account earning 13.5% interest compounded monthly for a 2 year period. What is the balance at the end of 9 years? 15.) You lend out S5500 at 10% compounded monthly. If the debt is repaid in 18 months, what is the total owed at the time of repayment? these valarrow_forward
- The graph below charts the past five years of returns for two different assets. Percentage Return 15% 10% 5% 0% -5% -10% -15% 1 2 3 Year It can be stated that the two assets demonstrate: Select one: O a. perfectly positive correlation O b. perfectly negative correlation O c. negatively correlated O d. positively correlated 5arrow_forwardon 2 A student deposits $400 at the end of every 3-months for five years into an account that earns interest at ja = x%. At the end of five years, they have accumulated $11,000. Using linear interpolation, determine x. %3Darrow_forward2. Over the last nine years, you have earned the following returns on the NZX Year (ending in March) 2013-2014 17.45% 2014-2015 15.17% 2015-2016 17.26% 2016-2017 7.94% 2017-2018 16.92% 2018-2019 19.54% 0.36% 2019-2020 2020-2021 28.93% 2021-2022 -5.17% Return You have also collected the level of the CPI over the same period: Date March 2013 March 2014 March 2015 March 2016 March 2017 March 2018 March 2019 March 2020 March 2021 March 2022 Level 958 972 975 979 1000 1011 1026 1052 1068 1142 (a) For each tax year, calculate the inflation rate. (b) Now calculate a real rate of return for the NZX50 (use the full for- mula, not the approximation) for each year. (c) What is the mean nominal return for the NZX50? What is the mean real return? (d) What is the nominal volatility for the NZX50? What is the real volatility of the NZX50? (e) Suppose New Zealand had a 33% tax levied on capital gains and all dividends. Repeat your analysis, calculating after-tax mean real and nominal returns, along…arrow_forward
- Actual Year Projected Year 2022 2021 Revenues - high school students 88,200 110,300 Revenues - adult learners 571,200 745,000 Accounts receivable - high schools 7,400 10,200 Accounts receivable - adult learners 47,600 73,000 Commissions expense 21,400 27,800 Commissions payable 900 1,200 Salaries and benefits expense 638,900 947,000 Rent expense 12,000 12,400 Prepaid rent 1,200 1,200 Prepaid insurance 2,800 3,000 High school expenses (Cost of Sales) 49,400 65,300 Adult learner expenses (Cost of Sales) 68,500 98,700 Long-term debt Depreciation expense 10,000 18,000 Other operating expenses 50,000 55,000 Accounts payable 14,800 15,700 Salaries and benefits payable 26,600 37,500 3,800 Payroll taxes payable Income tax expense 2,700 Fixed assets, net of accumulated depreciation 35,000 45,000 Retained earnings (Accumulated deficit) (96,000) Common and preferred stock 400,000 75,000 400,000 Cash 255,000 Interest expensearrow_forwardDon Williams received a memo requesting that he complete a trend analysis of the following numbers using 2018 as the base year. 2019 $420,000 340,000 40,000 Sales Gross profit Net income 2021 $340,000 180,000 70,000 Sales Gross profit Net income Could you help Don with the request? (Round your answers to the nearest whole percent.) 2021 2020 $400,000 240,000 90,000 % % % 2020 % % % 2019 2018 $500,000 400,000 50,000 % % % 2018 Check my work 100 % 100 % 100 %arrow_forwardProblem 1: The Happy Toddlers The Happy Toddlers is a preparatory school for children three to five years old. Students are enrolled for a school-year. Parents can pay the full tuition fee of 70,000 at the start of the school year (June). There is also an option to pay two installments of 37,000 each at the start of every semester (June 1 and November 1). Of the 150 students enrolled, 80 are paid in full at the start of the year. The remaining students are on installment basis. One school year runs from June 1 to March 31. Determine the tuition fee revenue for the period December 31. This is the first year of Happy Toddlers operations.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License