Initial Investment: (250,000) Year 1: 60k Year 2: 70k Year 3: 80k Year 4: ? Year 5: 100k NPV: 19,068.30 Discount rate of 9% How would you find cash flows for year 4? Would you just take the PV of the other years? Could you solve this with a financial calculator?
In: Accounting
| PERIOD | 0 | 1 | 2 | 3 | 4 |
| EBIT | $46,000 | $57,000 | $70,000 | $80,000 |
The above table illustrates earnings before interest and taxes for a capital investment project. Additional information for this project:
If the opportunity cost of capital is 11.2%, what is the net present value of this project?
In: Finance
Consider the following time series data:
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Value | 24 | 12 | 20 | 13 | 18 | 24 | 14 |
| (a) | Compute MSE using the most recent value as the forecast for the next period. |
| If required, round your answer to one decimal place. | |
| What is the forecast for month 8? | |
| If required, round your answer to one decimal place. Do not round intermediate calculation. | |
| (b) | Compute MSE using the average of all the data available as the forecast for the next period. |
| If required, round your answer to one decimal place. Do not round intermediate calculation. | |
| What is the forecast for month 8? | |
| If required, round your answer to one decimal place. | |
| (c) | Which method appears to provide the better forecast? |
In: Statistics and Probability
Consider the following time series data:
|
Month |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
|
Value |
24 |
13 |
21 |
12 |
20 |
23 |
15 |
25 |
In: Statistics and Probability
Define the following Economics terms.
1. Perfect Competition
2. Zero Economic Profit
3. Monopoly
4. Monopolistic Competition
5. Oligopoly
6. Cartel
7: Natural Monopoly
8. Price Discrimination
9. Game Theory
10. Corporation
In: Economics
Consider the following time series. t 1 2 3 4 5 yt 6 10 8 13 15 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) What type of pattern exists in the data? (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. If required, round your answers to two decimal places. y-intercept, b0 = 4.1 Slope, b1 = 2.1 MSE = ???? (c) What is the forecast for t = 6? If required, round your answer to one decimal place. 16.7 I know how to do it all but the MSE.
In: Statistics and Probability
Flip a coin 3 times, what is 1. outcome 2. sample space 3. event(two tails) 4. event space(two tails)
In: Statistics and Probability
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
| Project A | -$300 | -$387 | -$193 | -$100 | $600 | $600 | $850 | -$180 | |
| Project B | -$400 | $134 | $134 | $134 | $134 | $134 | $134 | $0 | |
| Project Delta | |||||||||
| #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | ||
| Crossover Rate = IRRΔ | #N/A | ||||||||
| Project MIRR Calculations at WACC = 18% | |||||||||
| WACC | 18.00% | ||||||||
| MIRRA | #N/A | ||||||||
| MIRRB | #N/A | ||||||||
In: Finance
|
A
|
B
|
C
|
D
|
E
|
F
|
|
| 1 | Chapter 8: Applying Excel | |||||
| 2 | ||||||
| 3 | Data | |||||
| 4 | Exhibit 8-8: Standard Cost Card | |||||
| 5 | Inputs | Standard Quantity | Standard Price | |||
| 6 | Direct materials | 3.0 | pounds | $4.00 | ||
| 7 | Direct labor | 0.50 | hours | $22.00 | per hour | |
| 8 | Variable manufacturing overhead | 0.50 | hours | $6.00 | per hour | |
| 9 | ||||||
| 10 | Actual results: | |||||
| 11 | Actual output | 2,090 | units | |||
| 12 | Actual variable manufacturing overhead cost | $6,174 | ||||
| 13 | Actual Quantity | Actual price | ||||
| 14 | Actual direct materials cost | 6,115 | pounds | $3.9 | pounds | |
| 15 | Actual direct labor cost | 980 | hours | $22.3 | per hour | |
| 16 | ||||||
| Requirement 2: |
|
Revise the data in your worksheet to reflect the results for the subsequent period as shown below: |
| a-1. |
What is the materials quantity variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) |
| a-2. |
What is the materials price variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) |
| b-1. |
What is labor efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) |
| b-2. |
What is labor rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) |
| c-1. |
What is variable overhead efficiency variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) |
| c-2. |
What is variable overhead rate variance? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) |
In: Accounting
|
Consider the following time series data:
|
||||||||||||||||||||||||||
| - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 | ||||||||||||||||||||||||||
| What type of pattern exists in the data? | ||||||||||||||||||||||||||
| - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 | ||||||||||||||||||||||||||
| (b) | Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. | |||||||||||||||||||||||||
| If required, round your answers to two decimal places. Do not round intermediate calculation. | ||||||||||||||||||||||||||
| MSE: | ||||||||||||||||||||||||||
| The forecast for month 8: | ||||||||||||||||||||||||||
| (c) | Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for month 8. | |||||||||||||||||||||||||
| If required, round your answers to two decimal places. Do not round intermediate calculation. | ||||||||||||||||||||||||||
| MSE: | ||||||||||||||||||||||||||
| The forecast for month 8: | ||||||||||||||||||||||||||
| (d) | Compare the three-month moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? | |||||||||||||||||||||||||
| - Select your answer -3-month moving averageexponential smoothingItem 7 | ||||||||||||||||||||||||||
| (e) | Use trial and error to find a value of the exponential smoothing coefficient α that results in the smallest MSE. | |||||||||||||||||||||||||
| If required, round your answer to two decimal places. | ||||||||||||||||||||||||||
| α = |
In: Statistics and Probability