FINANCIAL & MANAGERIAL ACCW/CENGAGENOWV
15th Edition
ISBN: 9781337955423
Author: WARREN, JONES
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 11, Problem 3MAD
a.
To determine
Compute times-interest-earned ratio for each year.
b.
To determine
Plot the graph with the four points and the years in the horizontal axis.
c.
To determine
Interpret the trend in the ratio from the graph.
d.
To determine
Identify the cause for an increase in interest expense in Year 4.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The following financial data (in thousands) were taken from recent financial statements of Staples, Inc.:
Please see the attachment for details:
1. Determine the times interest earned ratio for Staples in Year 3, Year 2, and Year 1? Round your answers to one decimal place.2. Evaluate this ratio for Staples.
Ay 1.
Using your financial analysis of Gap Clothing company, Refer to the Annual Reports located in the Class Resources. You will use information in the Form 10-K to complete this assignment. Using the correct formulas and a separate tab for each analysis, calculate the following ratios using Microsoft Excel: Three liquidity ratios for the past 2 years Three solvency ratios for the past 2 years Three profitability ratios for the past 2 years
Prepare a comparative common-size income statement for Jubilee Corporation. To an investor, how does the current year compare with the prior year? Explain your reasoning.
E (Click the icon to view the comparative income statement.)
Data table
Start by calculating the percentages. (Round the percentages to two decimal places, X.XX.)
Jubilee Corporation
Comparative Common-Size Income Statement
A
C
For the Years Ended December 31
1
Jubilee Corporation
Current
2
Income Statement
year
Prior year
3
For the Years Ended December 31
Sales revenues
100.00 %
100.00 %
4
(amounts in thousands)
Less: Cost of goods sold
%
%
Current
Gross profit
%
%
year
Prior year
Less: Operating expenses
%
6 Sales revenues
$
494,208 $
429,000
%
Operating income
%
7 Less: Cost of goods sold
172,640
160,000
Less: Interest expense
8 Gross profit
2$
321,568 $
269,000
0%
Income before income taxes
%
%
9 Less: Operating expenses
143,370
135,000
Less: Income tax expense
10 Operating income
2$
178,198 $
134,000
%
%
11 Less:…
Chapter 11 Solutions
FINANCIAL & MANAGERIAL ACCW/CENGAGENOWV
Ch. 11 - Describe the two distinct obligations incurred by...Ch. 11 - Explain the meaning of each of the following terms...Ch. 11 - If you asked your broker to purchase for you a 12%...Ch. 11 - Prob. 4DQCh. 11 - Prob. 5DQCh. 11 - Prob. 6DQCh. 11 - Prob. 7DQCh. 11 - Fleeson Company needs additional funds to purchase...Ch. 11 - Prob. 9DQCh. 11 - Issuing bonds at face amount On January 1, the...
Ch. 11 - Issuing bonds at a discount On the first day of...Ch. 11 - Prob. 3BECh. 11 - Prob. 4BECh. 11 - Prob. 5BECh. 11 - Prob. 6BECh. 11 - Times interest earned Averill Products Inc....Ch. 11 - Prob. 1ECh. 11 - Entries for issuing bonds Thomson Co. produces and...Ch. 11 - Prob. 3ECh. 11 - Prob. 4ECh. 11 - Prob. 5ECh. 11 - Entries for issuing and calling bonds; gain Mia...Ch. 11 - Prob. 7ECh. 11 - Present value of amounts due Assume that you are...Ch. 11 - Prob. 9ECh. 11 - Present value of an annuity On January 1, you win...Ch. 11 - Prob. 11ECh. 11 - Prob. 12ECh. 11 - Prob. 13ECh. 11 - Prob. 14ECh. 11 - Appendix 2 Amortize premium by interest method...Ch. 11 - Prob. 16ECh. 11 - Prob. 17ECh. 11 - Bond discount, entries for bonds payable...Ch. 11 - Prob. 2PACh. 11 - Entries for bonds payable, including bond...Ch. 11 - Appendix 1 and Appendix 2 Bond discount, entries...Ch. 11 - Prob. 5PACh. 11 - Bond discount, entries for bonds payable...Ch. 11 - Prob. 2PBCh. 11 - Entries for bonds payable, including bond...Ch. 11 - Prob. 4PBCh. 11 - Prob. 5PBCh. 11 - Analyze and compare Amazon.com and Wal-Mart...Ch. 11 - Analyze and compare Clorox and Procter Gamble The...Ch. 11 - Prob. 3MADCh. 11 - Analyze and compare Hilton and Marriott Hilton...Ch. 11 - Prob. 1TIFCh. 11 - Prob. 3TIFCh. 11 - Prob. 4TIF
Knowledge Booster
Similar questions
- Consider again the example introduced in Section 4.5 of a credit card company that has a database of information provided by its customers when the customers apply for credit cards. An analyst has created a multiple regression model for which the dependent variable in the model is credit card charges accrued by a customer in the data set over the past year (y), and the independent variables are the customers annual household income (x1), number of members of the household (x2), and number of years of posthigh school education (x3). Figure 4.23 provides Excel output for a multiple regression model estimated using a data set the company created. a. Estimate the corresponding simple linear regression with the customers annual household income as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers annual household income and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? b. Estimate the corresponding simple linear regression with the number of members in the customers household as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the number of members in the customers household and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? c. Estimate the corresponding simple linear regression with the customers number of years of posthigh school education as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers number of years of posthigh school education and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain? d. Recall the multiple regression in Figure 4.23 with credit card charges accrued by a customer over the past year as the dependent variable and customers annual household income (x1), number of members of the household (x2), and number of years of posthigh school education (x3) as the independent variables. Do the estimated slopes differ substantially from the corresponding slopes that were estimated using simple linear regression in parts a, b, and c? What does this tell you about multicollinearity in the multiple regression model in Figure 4.23? e. Add the coefficients of determination for the simple linear regression in parts a, b, and c, and compare the result to the coefficient of determination for the multiple regression model in Figure 4.23. What does this tell you about multicollinearity in the multiple regression model in Figure 4.23? f. Add age, a dummy variable for gender, and a dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as independent variables to the multiple regression model in Figure 4.23. Code the dummy variable for gender as 1 if the customers gender is female and 0 if male, and code the dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as 1 if the customer has exceeded his or her credit limit in the past 12 months and 0 otherwise. Do these variables substantially improve the fit of your model?arrow_forwardConsider again the example introduced in Section 7.5 of a credit card company that has a database of information provided by its customers when they apply for credit cards. An analyst has created a multiple regression model for which the dependent variable in the model is credit card charges accrued by a customer in the data set over the past year (y), and the independent variables are the customers annual household income (x1), number of members of the household (x2), and number of years of post-high school education (x3). Figure 7.23 provides Excel output for a multiple regression model estimated using a data set the company created. a. Estimate the corresponding simple linear regression with the customers annual household income as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers annual household income and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year is explained by this simple linear regression model? b. Estimate the corresponding simple linear regression with the number of members in the customers household as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the number of members in the customers household and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year is explained by this simple linear regression model? c. Estimate the corresponding simple linear regression with the customers number of years of posthigh school education as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers number of years of posthigh school education and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year is explained by this simple linear regression model? d. Recall the multiple regression in Figure 7.23 with credit card charges accrued by a customer over the past year as the dependent variable and customers annual household income (x1), number of members of the household (x2), and number of years of post-high school education (x3) as the independent variables. Do the estimated slopes differ substantially from the corresponding slopes that were estimated using simple linear regression in parts (a), (b), and (c)? What does this tell you about multicollinearity in the multiple regression model in Figure 7.23? e. Add the coefficients of determination for the simple linear regression in parts (a), (b), and (c), and compare the result to the coefficient of determination for the multiple regression model in Figure 7.23. What does this tell you about multicollinearity in the multiple regression model in Figure 7.23? f. Add age, a dummy variable for sex, and a dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as independent variables to the multiple regression model in Figure 7.23. Code the dummy variable for sex as 1 if the customer is female and 0 if male, and code the dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as 1 if the customer has exceeded his or her credit limit in the past 12 months and 0 otherwise. Do these variables substantially improve the fit of your model?arrow_forwardNeed Help ASAP! Calculate the gross profit percentage ratio of Apple Inc. for the year 2020 (current year) and 2019 (previous year) and the gross profit percentage ratio of its industry peer Microsoft Corp. for the year 2020 (current year). Show calculations. Round the ratios to two decimal placesarrow_forward
- Create an appropriate graph to show the correlation between the total revenuegenerated by Tesco and the number of its stores over the last recorded fiveyears?arrow_forwardUse the following information to determine the Prior Year and Current Year trend percents for net sales using the Year as the base year Enter the answers thousands of dollars.arrow_forward10. Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B Compute the number of days sales in receivables ratios for each company for 2018 and 2019 C. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forward
- Net sales revenue, net income, and common stockholders' equity for Eyesight Mission Corporation, a manufacturer of contact lenses, follow for a four-year period. E (Click the icon to view the net sales revenue, net income, and common equity) Read the requirements. Requirement 1. Compute trend analyses for each item for 2017 2019 Use 2016 as the base year, and round to the nearest whole percent. Begin by computing Eyesight Mission Corporation's trend analysis for net sales revenue, then compute Eyesight Mission Corporation's trend analysis for net income and finally compute Eyesight Mission Corporation's trend analysis for common stockholders' equity 2019 2018 2017 2016 Net Sales Revenue $4 766,000 $4 708 000 644 000 664,000 Trend Percentages 100 % Requirements 2019 2018 2017 2016 766,000 $ 708,000 $ 644,000 $ 664,000 44,000 Net Sales Revenue $4 Net Income 60,000 38,000 36,000 Ending Common Stockholders' Equity 368,000 352,000 326,000 296,000arrow_forwardLoomis, Inc. reported the following on the company’s income statement in two recent years: Please see the image for details: a. Determine the times interest earned ratio for the current year and the prior year. Round to one decimal place.b. Is this ratio improving or declining?arrow_forwardUsing Table 6–13, create a pro forma balance sheet using the percentage ofsales method. If net income next year is $50,000, answer the following:a. How much did the owners take out of the business?b. What is the profit margin for next year?arrow_forward
- Alex is currently considering to invest his money in one of the companies betweenCompany A and Company B. The summarized final accounts of the companies for theirlast completed financial year are as follows: (refer to the images) Required:a. Calculate the following ratios for Company A and Company B. State clearly theformulae used for each ratio:i. Gross Profit Marginii. Net Profit Marginiii. Inventory Turnover Period (days)iv. Receivables Collection Period (days)v. Payables Payment Period (days)vi. Current Ratiovii. Quick Ratiob. Comment on each of the ratios calculated in part (a) above.arrow_forwardNet sales revenue, net income, and common stockholders' equity for Eyesight Mission Corporation, a manufacturer of contact lenses, follow for a four-year period. E (Click the icon to view the net sales revenue, net income, and common equity) Read the requirements. Requirement 1. Compute trend analyses for each item for 2017-2019. Use 2016 as the base year, and round to the nearest whole percent. Begin by computing Eyesight Mission Corporation's trend analysis for net sales revenue, then compute Eyesignt Mission Corporation's trend analysis for net income and finally compute Eyesight Mission Corporation's trend analysis for com 2019 2018 2017 2016 Net Sales Revenue 766,000 708,000 644.000 664,000 Trend Percentages 115 % 107 % 97 % 100 % Net Income 60,000 $4 38,000 $ 36.000 2. 44.000 Trend Percentages 136 % 86 % 82 % 100 % Ending Common Stockholdors' Equity 368,000 352 000 $ 326,000 $ 296,000 Trend Percentages 124 % 119 % 110 100 % % OTI Requirement 2. Compute the rate of return on…arrow_forwardHere is the operating data for Yalis Cleaning, Inc.: After analyzing the transactions, prepare a vertical analysis schedule for the company for 2021 and 2020 using service revenue as the base amount. Round percentages to two decimal places.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,