Business, 14.05.2021 04:00 jghdvine

In the Filter Analysis worksheet: a. Select Economy ONLY and Quarter 1 ONLY in their respective columns.
b. In row 34, the next blank row after the data, in the revenue and number of cars columns, calculate the sum of that column by adding the contents of the addresses of the cells resulting from the filter action (should be two values for Revenue and two values for NumCars).
c. Format the two values to match the data above in the particular respective column.
Year Quarter Location CarClass Revenue NumCars
2019 Q2 Airport Economy $368,286 2153
2019 Q4 Downtown Premium $431,761 2562
2019 Q4 Downtown Hybrid $431,140 2620
2019 Q1 Downtown Premium $424,833 2661
2019 Q4 Downtown SUV $431,029 2708
2019 Q1 Downtown Hybrid $425,127 2729
2019 Q1 Downtown SUV $424,718 2799
2019 Q3 Downtown Premium $494,587 3006
2019 Q3 Downtown Hybrid $494,669 3065
2019 Q4 Airport Premium $540,411 3082
2019 Q2 Downtown Premium $500,347 3101
2019 Q4 Airport Hybrid $541,112 3115
2019 Q2 Downtown Hybrid $500,601 3172
2019 Q3 Downtown SUV $495,372 3197
2019 Q4 Airport SUV $540,599 3231
2019 Q2 Downtown SUV $500,494 3251
2019 Q1 Airport Economy $499,117 3296
2019 Q1 Airport Premium $565,965 3418
2019 Q1 Airport Hybrid $565,721 3515
2019 Q3 Airport Economy $593,981 3555
2019 Q2 Airport Premium $599,690 3556
2019 Q1 Airport SUV $565,749 3623
2019 Q2 Airport Hybrid $599,005 3650
2019 Q2 Airport SUV $599,382 3783
2019 Q3 Airport Premium $658,374 3883
2019 Q3 Airport Hybrid $658,702 3927
2019 Q3 Airport SUV $658,241 4097
2019 Q2 Downtown Economy $641,168 4302
2019 Q3 Downtown Economy $681,155 4540
2019 Q4 Downtown Economy $704,556 4620
2019 Q1 Downtown Economy $718,651 4898
2019 Q4 Airport Economy $918,045 5224

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 17:10

Four analysts cover the stock of fluorine chemical. one forecasts a 6% return for the coming year. the second expects the return to be negative 6%. the third predicts a return of 8%. the fourth expects a 2% return in the coming year. you are relatively confident that the return will be positive but not large, so you arbitrarily assign probabilities of being correct of 35 % comma 8 %, 17 %, and 40%, respectively, to the analysts' forecasts. given these probabilities, what is fluorine chemicals expected return for the coming year

Answers: 3

Answer

Business, 21.06.2019 18:30

Beta coefficients and the capital asset pricing model personal finance problem katherine wilson is wondering how much risk she must undertake to generate an acceptable return on her porfolio. the risk-free return currently is 4%. the return on the overall stock market is 14%. use the capm to calculate how high the beta coefficient of katherine's portfolio would have to be to achieve a portfolio return of 16%.

Answers: 2

Answer

Business, 21.06.2019 20:20

Miller mfg. is analyzing a proposed project. the company expects to sell 8,000 units, plus or minus 2 percent. the expected variable cost per unit is $11 and the expected fixed costs are $287,000. the fixed and variable cost estimates are considered accurate within a plus or minus 5 percent range. the depreciation expense is $68,000. the tax rate is 32 percent. the sales price is estimated at $64 a unit, plus or minus 3 percent. what is the earnings before interest and taxes under the base case scenario?

Answers: 1

Answer

Business, 22.06.2019 00:40

The silverside company is considering investing in two alternative projects: project 1 project 2 investment $500,000 $240,000 useful life (years) 8 7 estimated annual net cash inflows for useful life $120,000 $40,000 residual value $32,000 $10,000 depreciation method straightminusline straightminusline required rate of return 11% 8% what is the accounting rate of return for project 2? (round any intermediary calculations to the nearest dollar, and round your final answer to the nearest hundredth of a percent, x.xx%.)

Answers: 3

Answer

You know the right answer?

In the Filter Analysis worksheet: a. Select Economy ONLY and Quarter 1 ONLY in their respective col...

Questions