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 21:30

Peninsula products has just applied for a loan at your bank. when reviewing peninsula's books for the year that just ended, you notice that the firm uses the fair value option for its bonds payable. you also see that the firm recorded a $55,000 debit in its bonds payable account and a $55,000 credit in its unrealized holding gain or loss"income account. over that same period, interest rates decreased by about 0.5 percent. how should this information affect the bank's decision as to whether to grant peninsula a loan? a : the bank should strongly consider giving a loan to peninsula because the changes in firm's bonds payable and unrealized holding gain or loss"income accounts suggest that peninsula has seen an increase in its credit rating over the past year. b : the bank should put little emphasis on the changes in peninsula's bonds payable and unrealized holding gain or loss"income accounts because these changes are likely the result of the rise in interest rates. c : the bank should hesitate before giving a loan to peninsula because the changes in firm's bonds payable and unrealized holding gain or loss"income accounts suggest that peninsula has seen a decline in its credit rating over the past year. d : the bank should put little emphasis on the changes in peninsula's bonds payable and unrealized holding gain or loss"income accounts because these changes are likely unrelated to either interest rates or the firm's credit rating.

Answers: 2

Answer

Business, 22.06.2019 08:40

Calculate the cost of each capital component—in other words, the after-tax cost of debt, the cost of preferred stock (including flotation costs), and the cost of equity (ignoring flotation costs). use both the capm method and the dividend growth approach to find the cost of equity.calculate the cost of new stock using the dividend growth approach.what is the cost of new common stock based on the capm? (hint: find the difference between re and rs as determined by the dividend growth approach and then add that difference to the capm value for rs.)assuming that gao will not issue new equity and will continue to use the same target capital structure, what is the company’s wacc? e. suppose gao is evaluating three projects with the following characteristics.each project has a cost of $1 million. they will all be financed using the target mix of long-term debt, preferred stock, and common equity. the cost of the common equity for each project should be based on the beta estimated for the project. all equity will come from reinvested earnings.equity invested in project a would have a beta of 0.5 and an expected return of 9.0%.equity invested in project b would have a beta of 1.0 and an expected return of 10.0%.equity invested in project c would have a beta of 2.0 and an expected return of 11.0%.analyze the company’s situation, and explain why each project should be accepted or rejected g

Answers: 1

Answer

Business, 22.06.2019 09:30

Which of these is not a result of regular exercise

Answers: 1

Answer

Business, 22.06.2019 22:00

Miami incorporated estimates that its retained earnings break point (bpre) is $21 million, and its wacc is 13.40 percent if common equity comes from retained earnings. however, if the company issues new stock to raise new common equity, it estimates that its wacc will rise to 13.88 percent. the company is considering the following investment projects: project size irr a $4 million 14.00% b 5 million 15.10 c 4 million 16.20 d 6 million 14.20 e 1 million 13.42 f 6 million 13.75 what is the firm's optimal capital budget?

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