Problem 5-23
Consider the following time series data.
| Quarter | Year 1 | Year 2 | Year 3 |
| 1 | 4 | 6 | 7 |
| 2 | 2 | 3 | 6 |
| 3 | 3 | 5 | 6 |
| 4 | 5 | 7 | 8 |
| (a) | Choose the correct time series plot. | ||||||||||||
|
|||||||||||||
| _________________ | |||||||||||||
| What type of pattern exists in the data? | |||||||||||||
| _________________ | |||||||||||||
| (b) | Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. | ||||||||||||
| If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) | |||||||||||||
| Value = __________6.667_______ + ___-1______________ Qtr1t + _____-3____________ Qtr2t + __________-2_______ Qtr3t | |||||||||||||
| (c) | Compute the quarterly forecasts for next year based on the model you developed in part (b). | ||||||||||||
| If required, round your answers to three decimal places. | |||||||||||||
|
|||||||||||||
| (d) | Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for Quarter 1 in Year 1, t = 2 for Quarter 2 in Year 1,… t = 12 for Quarter 4 in Year 3. | ||||||||||||
| If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) | |||||||||||||
| Value = 3.4167______________ + __0.2188______________ Qtr1t + _____-2.1875___________ Qtr2t + __-1.5938_______________ Qtr3t + ___0.4063______________ t | |||||||||||||
| (e) | Compute the quarterly forecasts for next year based on the model you developed in part (d). | ||||||||||||
| Round your interim computations and final answers to three decimal places. | |||||||||||||
|
|||||||||||||
| (f) | Is the model you developed in part (b) or the model you developed in part (d) more effective? | ||||||||||||
| If required, round your intermediate calculations and final answer to three decimal places. | |||||||||||||
|
|||||||||||||
| I only need (f) answered | |||||||||||||
| I only need (f) answered Both MSE needs to be included for part (b) and (d). | |||||||||||||
In: Other
Between about December 2007 and June 2009, the United States was considered to be in a recession. The U.S. Gross Domestic Product fell approximately 3% from the third quarter of 2008 to the third quarter of 2009. Also, during December 2007 and June 2009, the Standard and Poor’s 500 index dropped by 38% and the unemployment rate climbed from 5% to 9.5%.
The macroeconomic situation affected almost all companies since higher unemployment affected personal consumption, which dropped from 10,140.3 Billion Dollars in Aug 2008 to 9,807 Billion Dollars in June 2009, a drop of 3.8 percent.
Starbucks is one of the companies affected by the December 2007 recession. The following table shows several ratios for Starbucks corresponding to the years 2006, 2007, and 2008. Use a stock price of 10.9 dollars per share for the year 2009.
|
Year |
2006 |
2007 |
2008 |
2009 |
|
ROE |
0.253 |
0.294 |
0.127 |
|
|
ROA |
0.106 |
0.126 |
0.056 |
|
|
ROIC |
0.207 |
0.250 |
0.121 |
|
|
Asset Turnover |
1.758 |
1.761 |
1.830 |
|
|
Op. Profit Margin |
0.115 |
0.746 |
0.048 |
|
|
Long Term Debt Ratio |
0.0009 |
0.241 |
0.221 |
|
|
D/E Ratio |
0.987 |
1.340 |
1.277 |
|
|
Current Ratio |
0.970 |
0.787 |
0.798 |
|
|
Quick Ratio |
0.462 |
0.466 |
0.482 |
|
|
Payout Ratio |
0.000 |
0.000 |
0.000 |
|
|
Plowback Ratio |
1.000 |
1.000 |
1.000 |
|
|
Market to Book Ratio |
6.088 |
3.099 |
1.374 |
|
|
Stock Price Used for Mark/Book |
17.71 |
9.450 |
4.68 |
By using the financial statements provided, calculate the ratios presented in the table for the year 2009 and answer the following questions:
e- In what ratio can you see the change in the mix of debt and equity reflected?
g- Did the quick ratio increase or decrease between the years 2007 and 2009?
h- Explain why you expect the quick ratio to increase or decrease during a recession?
j- What areas should Starbucks improve for the years 2010 onwards, if any?
Annual report:
http://media.corporate-ir.net/media_files/irol/99/99518/SBUX_AR.pdf
Expert Answer
In: Finance
Governments often attempt to fight a recession by
a) increasing spending and cutting taxes which shifts the aggregate supply curve to the right.
b) increasing spending and cutting taxes which shifts the aggregate demand curve to the right.
c) increasing spending and cutting taxes which shifts the aggregate demand curve to the left.
d) increasing taxes to increase the supply of loanable funds.
In: Economics
3) What factors on the Consumer Spending side of the Y = C + G + I + NX shifts aggregate demand to the left?
4) What factors on the Government Spending side of the Y = C + G + I + NX shifts aggregate demand to the right?
5) What factors on the Investment Spending side of the Y = C + G + I + NX shifts aggregate demand to the left?
In: Economics
Please answer all, thank you.
In: Economics
VALERIE: Hi, Shen! Are the basics of aggregate demand and aggregate supply analysis essentially the same as microeconomic demand and supply analysis?
SHEN: There are a lot of similarities but there are some very important differences. A few of the key differences are that, when dealing with aggregate demand (AD) and aggregate supply (AS) curves, the vertical axis measures the price level and not just the price for one good or service and the horizontal axis measures aggregate output, or real GDP, and not just the quantity demanded and supplied for a specific good or service. Let’s see if you understand the fundamentals of aggregate demand and aggregate supply. Why does the aggregate demand (AD) curve slope downward? What could cause it to shift?
VALERIE: The aggregate demand (AD) curve is downward sloping because as price level decreases, buyers tend to purchase (LESS OR MORE) of all goods and services and the aggregate quantity demanded (INCREASES OR DECREASES) . A decrease in the price level also induces spending via the interest rate effect and the exchange rate effect. AD is simply the summation of all spending in the economy—the total of consumption, investment, government, and net export spending. Moreover, an increase in AD is caused by (AN INCREASE OR A DECREASE) in consumption, investment, government, and net export spending. An increase in AD means that a quantity of the economy’s goods and services are demanded at every price level. This is represented by the AD curve shifting to the (RIGHT OR LEFT).
SHEN: Why is the long-run aggregate supply curve (LRAS) vertical at the natural rate of unemployment, or potential real GDP level? What could cause it to shift?
VALERIE: The long-run aggregate supply (LRAS) curve is a vertical line at the value of real GDP at the natural rate of unemployment because it is (UNAFFECTED OR AFFECTED) by the price level. This level of real GDP is instead determined by the productive capacity in the economy. If this productive capacity of the economy increases, the vertical (LRAS) curve will shift to the (LEFT OR RIGHT) . The productive capacity of a nation might increase if there are (FEWER OR MORE) resources like human and physical capital, natural resources and technological knowledge or (MORE OR LESS) productive resources. If the long-run aggregate supply (LRAS) curve shifts to the right, this would illustrate (ECONOMIC GROWTH OR A RECESSION).
SHEN: Why does the short-run aggregate supply (SRAS) curve slope upward? What could cause it to shift to the right?
VALERIE: The short-run aggregate supply (SRAS) curve slopes upward because as the price level increases, firms receive a (HIGHER OR SMALLER) amount for their output and will increase production in the short run. If the SRAS curve shifts to the right, this means (LESS OR MORE) will be produced at any price level. A rightward shift of the SRAS curve could be caused by more (OPTIMISTIC OR PESSIMISTIC) expectations by businesses or (HIGHER OR LOWER) costs of production, (MORE OR FEWER) resources, like human and physical capital, natural resources and technological knowledge, or (MORE OR LESS) productive resources.
In: Economics
1.When Coca-Cola traded their soft drink for wine in Slovenia, the company was engaged in:
A.Exchange control.
B.Countertrade.
C.Tariff trading.
D.Quota trade.
E.Global bargaining
2. In the global marketplace. Production invention
A. is the most inexpensive solution to production introduction
B. is the most localized solution to production introduction
C. is the most global solution to the production introduction
D. is the least commonly enjoyed option to production introduction
E. is the most commonly employed option to the production introduction
3.Psychographics is the segmentation method that delves into how consumers
A. adjust to demographic changes
B.allocate scarce incomes to a variety of goods and services
C.describe themselves
d.value their livelihoods.
E. all of these
4.the type of global entry expansions that has the greatest risk and yet generally the highest profit potential is
A. a joint venture with a foreign partner
B. a joint venture with a local partner
C. a direct exporting by the firm without an export agent
D.a sales and marketing office in the foreign market
E. franchising but no licensing
F. a direct investment in a Wholly -owend Foreign Enterprise.
5.The wheel of retailing means
A. a retail format or individual competitior should always be scanning the environment for a new,cheaper retailer looming on the horizen that may pre-empt its current success.
B.bricks and mortar stores are endangered with the advent of the online store
C. this is a life cycle to bricks-and-mortar retailer formats that is very predictable
D.that fashions recycle and prices assortment over several years may repeat
E.when a retailer first enters the market, prices will be very competitive, then they will decline just as any other product or service experiences as it moves through PLC.
In: Finance
Francisco Company has 20 employees, each of whom earns $2,900
per month and is paid on the last day of each month. All 20 have
been employed continuously at this amount since January 1. On March
1, the following accounts and balances exist in its general
ledger:
FICA—Social Security Taxes Payable, $7,192; FICA—Medicare Taxes Payable, $1,682. (The balances of these accounts represent total liabilities for both the employer's and employees' FICA taxes for the February payroll only.)
Employees' Federal Income Taxes Payable, $14,500 (liability for February only).
Federal Unemployment Taxes Payable, $696 (liability for January and February together).
State Unemployment Taxes Payable, $4,640 (liability for January and February together).
During March and April, the company had the following payroll
transactions.
| Mar. | 15 | Issued check payable to Swift Bank, a federal depository bank authorized to accept employers' payments of FICA taxes and employee income tax withholdings. The $23,374 check is in payment of the February FICA and employee income taxes. | ||
| 31 | Recorded the journal entry for the March salaries payable. Then recorded the cash payment of the March payroll (the company issued checks payable to each employee in payment of the March payroll). The payroll register shows the following summary totals for the March pay period. |
| Salaries | ||||||||||||
|
Office Salaries |
Shop Salaries |
Gross Pay |
FICA Taxes* |
Federal Income Taxes |
Net Pay |
|||||||
| $ | 23,200 | $ | 34,800 | $ | 58,000 | $ | 3,596 | $ | 14,500 | $ | 39,063 | |
| $ | 841 | |||||||||||
* FICA taxes are Social Security and Medicare,
respectively.
| 31 | Recorded the employer's payroll taxes resulting from the March payroll. The company has a merit rating that reduces its state unemployment tax rate to 4.00% of the first $7,000 paid each employee. The federal rate is 0.60%. | |||
| Apr. | 15 | Issued check to Swift Bank in payment of the March FICA and employee income taxes. | ||
| 15 | Issued check to the State Tax Commission for the January, February, and March state unemployment taxes. Filed the check and the first-quarter tax return with the Commission. | |||
| 30 | Issued check payable to Swift Bank in payment of the employer's FUTA taxes for the first quarter of the year. | |||
| 30 | Filed Form 941 with the IRS, reporting the FICA taxes and the employees' federal income tax withholdings for the first quarter. |
Required:
Prepare journal entries to record the transactions and events for
both March and April. (If no entry is required for a
particular transaction, select "No journal entry required" in the
first account field.)
Journal entry worksheet
Record the cash payment of FICA (employees' and employer's) and employee income taxes of the month of February.
Note: Enter debits before credits.
Journal entry worksheet Record the (employee) payroll expenses and liabilities for the month of March. Note: Enter debits before credits.
|
In: Accounting
In accounting does the LIFO method change. Sometimes it means the oldest is first, sometimes it means the most recent?
In: Accounting
In: Accounting