1. Calculate the shares. You have $27,000 to invest. You want to purchase shares of Alaska Air at \$44.26, Best Buy at $53.12, and Ford Motor at $9.41. How many shares of each company should you purchase so that your portfolio consists of 30 percent Alaska Air, 50 percent Best Buy, and 20 percent Ford Motor? (Use Excel's ROUNDUP function to ensure shares are rounded appropriately. Do not round intermediate calculations and round your final answers to the nearest whole number.) Comolete the followina analvsis. Do not hard code values in vour calculations. Complete the following analysis. Do not hard code values in your calculations