Corporate Finance

You have becri offered a unique investicijaturnily. If you invest $10,000 kway, you will receive 5500 on your fim W, 51,500 two years from now. and $10,000 ILTI years from now. Complete the steps below using cell references to given dota or previous calculations. In some cases, o simple cell reference is all you need to copypaste a formulo across o ror or down o colom, ou obsolut cell reference or o mixed cell reference moy be preferred. If a specific tixcel fimction is to be used, the directions will specifi the use of that fimction. Do not type in merical data into o cell or fiction. Justeod, make a reference to the cell in which the data is found. Make your computatious only in the blue cells highlighted below. In all coses, was orherwise directed, use the earliest appearance of the dato in your formulos, usually the Cem Dato section. 2. What is the NIV or the opportunity if the cost of capital is 'n per ycar? Should you take the tunity? What is the NIV of the opporumly if the axl of capital is 2% per year'? Should you take it w? b. Initial investment Cash flow year 1 Cash flow year 2 Cash flow year 10 S S S S 10,000 SOCI 1,500 10,000 1. What is the NIV of the opporlumily if the cost of capital is Gopet ycar? Should you take the runtunity? Cost of capital 1 NPV Take oppominity (Yes No b. What is the NIV of the opporluny if the cost of capital is 29 per year? Should you take it Kw? Cost of capital 26 NIV Tako puoluity (Yes.'Na) 1 2 Requirements Ini cell 017, by using cell relocnices, write an expression to calculate the NIV of the investment