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? (Do not round intermediate calculations and round your final answers to the nearest whole number.)
Please put it in an excel sheet using 1 grid for each company.