The company reported earnings were 100.000.000 EUR. At the beginning of the period the company had 30.000.000 common shares outstanding. At the beginning of the third quarter the company performed a share buyback and the number of common shares was reduced to 20.000.000 Total amount for preferred dividends accounted for 20.000.000 EUR. Moreover, the board recommended dividends for common shareholders (payment of 25% of the outstanding earnings). At the beginning of the year, the general meeting of shareholders approved an option incentive plan for the management and 1.200.000 options with a strike price of 40 EUR were issued. The stock price experienced a high increase in the last two quarters with the average price equal to 50 EUR.

You have an excel workbook labeled Fixed Assets. In the workbook you have two sheets: i) Fixed Assets Items - This sheet has a list of three columns with the headings Fixed Asset Code (A1), Fixed Asset Name (B1) and Fixed Asset Quantity (C1). Fixed Assets Purchase Price - This sheet has two columns with the headings Fixed Asset Code (A1:A72) and Fixed Asset Purchase Price (B1:B72). You wish to write a formula that will reference the Item prices from the sheet Fixed Assets Purchase Price based on the Fixed Asset Code in the Fixed Assets Item Sheet. You add a heading to the Fixed Assets Items Sheet in cell D1 and label the heading Price. You wish to enter the formula directly below the heading in cell D2. You will then copy this formula to the other cells in the column to reference the prices of the other items. Required: Using VLOOKUP, write the excel formula in cell D2 required to achieve your objective. The formula must be able to be copied to the other cells in the column and reference the correct purchase price.