Firm-specific investments are a type of ________ investments

Mike bought 200 shares of EG stock two years ago at $16 per share. The stock has traded in a range of $21 to $44 a share over the past year

EG is now selling for $43.60 a share. EG announces its earnings today and Mike feels the stock could go to $60 on good news or fall to $30 on bad. To protect his profits, the most appropriate order for him to place is A) market order to sell immediately. B) a limit sell order at $60.00. C) a stop loss order at $42. D) a stop-limit order to sell at $45.

Required: Download the spreadsheet for this problem from the course website and perform the following tasks:

1. Explore Excel's AutoFilter function. a. At the bottom of the table, in cell C79 enter the words "Total (sum)" and in cell D79 enter the SUM function to total all amounts in column D. b. At the bottom of the table, in cell C80 enter the words "Total (subtotal)"and in cell D80 enter "SUBTOTAL" function to sum all the amounts in column D. c. Use AutoFilter to display all purchases from suppliers in Zipcode 85110. What is displayed in cells D79 and D80? Why? d. Repeat step 3 for Zipcodes 85111 and 85116. What is the value of using the AutoFilter function? 2. Use the AutoFilter and Sort functions to identify the following warning signs of potentially fraudulent supplier invoices: a. Suppliers that have only initials for the name b. Different suppliers with the same PO Box for an address c. Suppliers who submit sequentially numbered invoices d. Invoices just below a threshold requiring approval; for example, invoices below $1,000 e. Duplicate invoice numbers from the same supplier