On the cities worksheet, click cell e13. depending on the city, you will either take a shuttle to/from the airport or rent a car. insert an if function that compares to see if yes or no is located in the rental car? column for a city. if the city contains no, display the value in cell f2. if the city contains yes, display the value in the rental car total (f4). copy the function from cell e13 and use the paste formulas option to copy the function to the range e14: e18 without removing the border in cell e18.

John is a 45-year-old manager who enjoys playing basketball in his spare time with his teenage sons and their friends. at work he finds that he is better able to solve problems that come up because of his many years of experience, but while on the court, he finds he is not as good keeping track of the ball while worrying about the other players. john's experience is:

What is an equation of the line in slope intercept formm = 4 and the y-intercept is (0,5)y = 4x-5y = -5x +4y = 4x + 5y = 5x +4

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?