In the year 2008, the United States was just entering a major recession. You are researching how various consumer prices changed in the ten-year period starting in 2008 and ending in 2018. Suppose you have located the following chart listing various consumer purchases and their costs in 2008 and 2018, as well as the percentage change based on the 2008 prices. Unfortunately, portions of the chart are missing. Fill in the blank spaces to complete the chart for your story. Round percent answers to the nearest tenth of a percent. Round dollar amount answers to the nearest whole dollar. Consumer Purchase 2008 2018 Percent Change Single-Family Home median resale price (for a particular month) $237,300 $290,700 % A particular compact car MSRP for the manual transmission $20,400 13.2% Pair of Jeans $44.60 $59.95 0% easy fit, stonewashed A particular fast food hamburger Average price at company-owned restaurants $2.97 $3.94

In the year 2008, the United States was just entering a major recession. You are researching how various consumer prices changed in the ten-year period starting in 2008 and ending in 2018. Suppose you have located the following chart listing various consumer purchases and their costs in 2008 and 2018, as well as the percentage change based on the 2008 prices. Unfortunately, portions of the chart are missing. Fill in the blank spaces to complete the chart for your story. Round percent answers to the nearest tenth of a percent. Round dollar amount answers to the nearest whole dollar. Consumer Purchase 2008 2018 Percent Change Single-Family Home median resale price (for a particular month) $237,300 $290,700 % A particular compact car MSRP for the manual transmission $20,400 13.2% Pair of Jeans $44.60 $59.95 0% easy fit, stonewashed A particular fast food hamburger Average price at company-owned restaurants $2.97 $3.94

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter15: Ratio Analysis (ratioa)

Section: Chapter Questions

Problem 6R: With the 2013 data still on the screen, click the Chart sheet tab. The chart presented shows the...

See similar textbooks

Similar questions

In 2011, home prices and mortgage rates fell so far that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cites where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 2627, 2011). a. Develop a scatter chart for these data, treating the average asking rent as the independent variable. Does a simple linear regression model appear to be appropriate? b. Use a simple linear regression model to develop an estimated regression equation to predict the monthly mortgage on the median priced home given the average asking rent. Construct a plot of the residuals against the independent variable rent. Based on this residual plot, does a simple linear regression model appear to be appropriate? c. Using a quadratic regression model, develop an estimated regression equation to predict the monthly mortgage on the median-priced home, given the average asking rent. d. Do you prefer the estimated regression equation developed in part (a) or part (c)? Create a plot of the linear and quadratic regression lines overlaid on the scatter chart of the monthly mortgage on the median-priced home and the average asking rent to help you assess the two regression equations. Explain your conclusions.
The economic downturn in 20082009 resulted in the loss of jobs and an increase in delinquent loans for housing. In projecting where the real estate market was headed in the coming year, economists studied the relationship between the jobless rate and the percentage of delinquent loans. The expectation was that if the jobless rate continued to increase, there would also be an increase in the percentage of delinquent loans. The following data show the jobless rate and the delinquent loan percentage for 27 major real estate markets. Source: The Wall Street Journal, January 27, 2009. a. Compute the correlation coefficient. Is there a positive correlation between the jobless rate and the percentage of delinquent housing loans? What is your interpretation? b. Show a scatter diagram of the relationship between the jobless rate and the percentage of delinquent housing loans.
Suppose the company has to revise its estimates because of a downturn in the economy. Unit sales for August, September, and October will be half (50%) of the original estimates. Revise the estimates in cells 1311 through 1313. After this is done, check your forecasted balance sheet. It should still balance! What effect will this new state of affairs have on net income and borrowing? Explain why these items changed.
You are pleased to see that you have been given a 4.55% raise this year. However, you read on the Wall Street Journal Web site that inflation over the past year has been 2.37%. How much better off are you in terms of real purchasing power? (Note: Be careful not to round any intermediate steps less than six decimal places.)
Inflation is a general increase in prices and may be measured by the Consumer Price Index (CPI). The following problem is related to price increases: 1. Your parents bought a home for $50,000 in 1982 and sold it in 2012 for $250,000. What was the annual rate of price increase over the 30 years?
A short article in the January 10, 2011 edition of The New York Times discussed the amount spent on DVDs over the past six years: (In 2004) consumers spent about $21.8billion to rent and and buy DVDs, Blu-ray discs, digital downloads and other forms of home entertainment...The number has fallen every year since, for a total drop of about 13.8 percent, to $18.8 billion in 2010. The reporter noted that the actual drop was about double what it seemed to be when the figures were adjusted for inflation: $21.8 billion figure from 2004 would amount to $25.3billion in current dollars. If we adjust for inflation, how dramatic is the drop in spending over the six year period?
You are pleased to see that you have been given a 6.28% raise this year. However, you read on the Wall Street Journal Web site that inflation over the past year has been2.93%. How much better off are you in terms of real purchasing power? (Note: Be careful not to round any intermediate steps less than six decimal places.) Your real purchasing power is _____%. (Round to two decimal places.)
Dollar sales for 2012 are expected to drop by approximately 8%, as a recession in Lewis’s market is forecasted to continue at least through the first three quarters of the year. Total sales are forecasted to be 2,700 cartons. Lewis will be unable to raise its selling price from the 2011 level of $35.75. However, costs are expected to increase to $24 per carton for the whole year. Due to these cost price pressures, the corporation wishes to lower its investment in inventory by holding only the essential inventory of 400 cartons at any time during the year. What is the effect of remaining on FIFO, assuming Lewis had adopted FIFO in 2009? What is the effect of remaining on LIFO, assuming Lewis adopted LIFO in 2009? What method would you recommend now?
the cpi measures price changes that occur from one month to the next for a specified bundle of products. nevertheless, products outside this selected set will tend to see similar impacts of inflation. true or false?
If a company’s current ratio declined in a year during whichits quick ratio improved, which of the following is the mostlikely explanation?a. Inventory is increasing.b. Inventory is declining.c. Receivables are being collected more rapidly than inthe past.d. Receivables are being collected more slowly than inthe past.
The average seling price of a new vehicle in the United States last year was $53,360. If the average price ten years earlier was $43,600, what was the annual increase/decrease in the selling price over this time period?
In 1990, the average home price in Texas was $85,815 and in 2010, the average price was $191,014. On average, what was the yearly increase in the average home price during this time period? Round to the nearest whole dollar. Part C: In 1990, the median price in Texas was $68,470 and in 2010, the median price was $146,417. On average, what was the yearly increase in the median home price during this time period? Round to the nearest whole dollar.