All answers MUST BE entered as Excel Formulas (Show Formulas option in Excel).

Calculate the shares

1. Calculate the shares. U Portfolio Weights - Excel ? 3 8 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in Calibri 11 A % M Paste BYU Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font A1 AB D 4 E F G 2 3 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.) 6 Amount to invest S 8 $ 9 27,000 44.26 53.12 9.41 $ 10 $ Price Aluca Price Best Duy Price Ford Motor W Alaska Air West Buy W Ford Motor 11 12 30.00% 50.00% 20.00% 13 14 15 15 16 17 Complete the following analysis. Do not hard code values in your calculations Shares 18 19 20 21 22 23 24 25 26 Firm Alaska Air Best Buy Ford Motor