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.

Neveready flashlights inc. needs $317,000 to take a cash discount of 3/15, net 70. a banker will loan the money for 55 days at an interest cost of $13,200. a. what is the effective rate on the bank loan? (use a 360-day year. do not round intermediate calculations. input your answer as a percent rounded to 2 decimal places.) b. how much would it cost (in percentage terms) if the firm did not take the cash discount but paid the bill in 70 days instead of 15 days? (use a 360-day year. do not round intermediate calculations. input your answer as a percent rounded to 2 decimal places.) c. should the firm borrow the money to take the discount? no yes d. if the banker requires a 20 percent compensating balance, how much must the firm borrow to end up with the $317,000? e-1. what would be the effective interest rate in part d if the interest charge for 55 days were $7,200?

Two assets have the following expected returns and standard deviations when the risk-free rate is 5%: asset a e(ra) = 18.5% σa = 20% asset b e(rb) = 15% σb = 27% an investor with a risk aversion of a = 3 would find that on a risk-return basis. a. only asset a is acceptable b. only asset b is acceptable c. neither asset a nor asset b is acceptable d. both asset a and asset b are acceptable

Determine the hrm’s role in the performance management process and explain how to ensure the process aligns with the organization’s strategic plan.