Peoples Energy INC reported the following data for operating revenue and net income for 2001 through 2005. Year Operating Revenue (Millions), X Net Income (Millions), Y 2001 2270 96.9 2002 1482 89.1 2003 2138 103.9 2004 2260 81.6 2005 2600 78.1 Determine the least-squares regression line and interpret its slope. Estimate the net income if the operating revenue figure is $2500 million. Use Excel showing steps.

Peoples Energy INC reported the following data for operating revenue and net income for 2001 through 2005. Year Operating Revenue (Millions), X Net Income (Millions), Y 2001 2270 96.9 2002 1482 89.1 2003 2138 103.9 2004 2260 81.6 2005 2600 78.1 Determine the least-squares regression line and interpret its slope. Estimate the net income if the operating revenue figure is $2500 million. Use Excel showing steps.

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter5: Accounting Systems

Section: Chapter Questions

Problem 25E

See similar textbooks

Similar questions

SoCal Edison reported the following data for operating revenue and net income for 2001 through 2005. Year Operating Revenue (Millions), X Net Income (Millions), Y 2001 2270 96.9 2002 1482 89.1 2003 2138 103.9 2004 2260 81.6 2005 2600 78.1 Using Excel, determine the least-squares regression line and interpret its slope. Estimate the net income if the operating revenue figure is $2500 million.
XYZ Co. wants to know if its profitability performance has increased from 2009 to 2010. The company had net income of $48,000 in 2009 and $50,000 in 2010. Total assets were $480,000 at the end of 2009, and $560,000 at the end of 2010. Calculate return on assets(ROA) for 2009 and 2010 and Comment on the results.
An analyst is evaluating the profi tability of Daimler AG (Xetra: DAI) over a recentfi ve-year period. He gathers the following revenue data and calculates the followingprofi tability ratios from information in Daimler’s annual reports:2009 2008 2007 2006 2005Revenues (€ millions) 78,924 98,469 101,569 99,222 95,209Gross profi t margin 16.92% 21.89% 23.62% 20.60% 19.48%Operating profi t (EBIT) margin a–1.92% 2.77% 8.58% 5.03% 3.02%Pretax margin –2.91% 2.84% 9.04% 4.94% 2.55%Net profi t margin –3.35% 1.73% 4.78% 3.19% 2.37%aEBIT (Earnings before interest and taxes) is the operating profi t metric used by Daimler.Daimler’s revenue declined from 2007 to 2008 and from 2008 to 2009. Further,Daimler’s 2009 revenues were the lowest of the fi ve years. Management’s discussion ofthe decline in revenue and EBIT in the 2009 Annual Report notes the following:Th e main reason for the decline [in EBIT] was a signifi cant drop in revenuedue to markedly lower unit sales in all vehicle segments as a…
The following information is available to you for the Wooden Company: 2011 2010 Net Income. 53,394 39,510 Net Sales 233,715 182,795 From the information provided, calculate Wooden’s profit margin ratio for each year. Be sure to show your calculations. 2011 2010 Comment on the results, assuming that the industry average for the profit margin ratio is 25% for each of the two years.
A 2011 income statement shows the following figures in millions: Net Sales $23.5, Returns $.5, Cost of goods sold $12.9, and Operating Expenses $3.08 do a vertical analysis and round each percent to the nearest for tenth.
For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: Instructions Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place. Answer Check Figure: Sales, 12.0% increase To the extent the data permit, comment on the significant relationships revealed by the horizontal analysis prepared in (1). PR 17-2A Vertical analysis of incom
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. TannenhillCompany ElectronicsIndustryAverage Sales $4,000,000 100.0 % Cost of goods sold (2,120,000) (60.0) Gross profit $1,880,000 40.0 % Selling expenses $(1,080,000) (24.0) % Administrative expenses (640,000) (14.0) Total operating expenses $(1,720,000) (38.0) % Operating income $160,000 2.0 % Other revenue and expense: Other revenue 120,000 3.0 Other expense (80,000) (2.0) Income before income tax expense $200,000 3.0 % Income tax expense (80,000) (2.0) Net income $120,000 1.0 % a. Prepare a common-sized income statement comparing the results of operations for Tannenhill Company with the…
Pare Plumbing Products Ltd. reported the following data in 2018 (in millions): Data table 2018 Net operating revenues. . . . . . . . $32.7 Operating expenses. . . . . . . . . . 28.2 Operating income. . . . . . . . . . . . 4.5 Nonoperating items: Interest expense. . . . . . . . (1.1) Other. . . . . . . . . . . . . . . . . (0.1) Net income. . . . . . . . . . . . . . . . . . $3.3 Total assets. . . . . . . . . . . . . . . . . $200.0 Total stockholders' equity. . . . . . 74.0 Compute Pare's leverage ratio, debt ratio, and times-interest-earned ratio, and write a sentence to explain what those ratio values mean. Use year-end figures in place of averages where needed for the purpose of calculating the ratios. Would you be willing to lend Pare $1 million? Why or why not? (Enter all amounts in millions.) First, compute Pare's leverage…
LMM Company’s total assets at the end of last year were P405,000 and its earnings before interest and taxes was P52,500. What was its basic earning power (BEP) ratio?
Ash Company reported sales of $440,000 for Year 1, $490,000 for Year 2, and $540,000 for Year 3. Using Year 1 as the base year, what is the revenue trend percent for Years 2 and 3?
Identify any favorable and unfavorable trends in the following income statements by preparing a vertical analysis. (Round percentages to two decimal places.) Year 2 Year 1 Revenues $394,000 $212,500 Operating expenses: Wages expense $ 79,000 $ 65,000 Rent expense 19,000 18,000 Utilities expense 21,000 14,200 Interest expense 7,500 7,800 Total operating expenses $126,500 $105,000 Net income $267,500 $107,500
For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement: Please see the attachment for details: Instructions1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place.2. To the extent the data permit, comment on the significant relationshipsrevealed by the horizontal analysis prepared in (1).