Please make sure to post your answer as a formula.

ME ? X 1 Portfolio Weights - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Calibri 11 AR M Paste BIU % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 X fx A B D E F G H 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.) un 6 7 Amount to invest 8 $ $ $ $ Pricezia Prices BV Price Ford Motor 9 10 27,000 44.26 53.12 9.41 30.00% 50.00% 20.00% 11 w Alaska Air 12 West B 13 14 W Ford Motor 15 16 17 18 19 20 Complete the following analysis. Do not hard code values in your calculations. Shares Firm Alaska Air Best Buy Ford Motor 21 22 23 Sheet1 S + 30% READY Attempt(s) Hint