Corporate Finance

www.ped. The pandelte Killer cop pyar, yap eneste for your site www.sante disloysi diyor be of ER Complete with proper al is a rema Pred Yercuffie en drie www I wild worldwide Mar Ridwal.com ww ww ws na What the cash for the entir yang the NP pre karte interest Wut sepse tegelevad of gilio NPV petek power Best year 1 Berdedigen 5 Fantasy 14 SA 150.00 1. 5 With the years of 1 Year Here from in the North West NPV 194 259 1999 ar 49 c. What's New con captain CR Requirements 1 In cell range D20:120, by using cell references, calculate the revenues of the project for years 0:5, respectively. Note: For year 0.type 0 (zero) for Revenues. (6 pt.). 2 In cell range D21:121, by using cell references, calculate the variable costs of the project for years 0:5, respectively (6 pt.). Note: (1) The outputs of the expressions or functions you typed in these cells are expected as negative numbers. (2) For year 0, type 0 (zero) for Variable Cost. 3 In cell range D22:122, by using cell references, calculate the fixed costs of the project for years 0:5, respectively (6 pt.). Note: (1) The outputs of the expressions or functions you typed in these cells are expected as negative numbers. (2) For year 0, type 0 (zero) for Fixed Cost. 4 In cell range D23:123. by using cell references, calculate the investments of the project for years 0:5, respectively (6 pt.). Note: (1) The outputs of the expressions or functions you typed in these cells are expected as negative numbers. (2) For years 1 to 5, type 0 (zero) for Investments. 5 In cell range D24:124, by using the SUM function and cell references, calculate the total cash flows of the project for years 0:5, respectively (6 pt.). 6 In cell range E30:E40, by using the NPV function and cell references, calculate the NPV of the investment opportunity for cost of capital 0% : 50%, respectively (11 pt.). 7 In cell range C42:G53, insert a Line chart to plot the NPV profile of the investment opportunity with the cost of capital (cell range D30:040) on the horizontal axis and the NPV (cell range E30:540) on the vertical axis. Use the following labels: title: NPV Profile, horizontal axis label: Cost of Capital and vertical axis label: NPV. (5 pt.) In cell E57, by using cell references, calculate the NPV of the investment opportunity for a 10% cost of capital (1 pt.). In cell E61, by using cell references, calculate the IRR of the investment opportunity (1 pt.). 8 9 www.ped. The pandelte Killer cop pyar, yap eneste for your site www.sante disloysi diyor be of ER Complete with proper al is a rema Pred Yercuffie en drie www I wild worldwide Mar Ridwal.com ww ww ws na What the cash for the entir yang the NP pre karte interest Wut sepse tegelevad of gilio NPV petek power Best year 1 Berdedigen 5 Fantasy 14 SA 150.00 1. 5 With the years of 1 Year Here from in the North West NPV 194 259 1999 ar 49 c. What's New con captain CR Requirements 1 In cell range D20:120, by using cell references, calculate the revenues of the project for years 0:5, respectively. Note: For year 0.type 0 (zero) for Revenues. (6 pt.). 2 In cell range D21:121, by using cell references, calculate the variable costs of the project for years 0:5, respectively (6 pt.). Note: (1) The outputs of the expressions or functions you typed in these cells are expected as negative numbers. (2) For year 0, type 0 (zero) for Variable Cost. 3 In cell range D22:122, by using cell references, calculate the fixed costs of the project for years 0:5, respectively (6 pt.). Note: (1) The outputs of the expressions or functions you typed in these cells are expected as negative numbers. (2) For year 0, type 0 (zero) for Fixed Cost. 4 In cell range D23:123. by using cell references, calculate the investments of the project for years 0:5, respectively (6 pt.). Note: (1) The outputs of the expressions or functions you typed in these cells are expected as negative numbers. (2) For years 1 to 5, type 0 (zero) for Investments. 5 In cell range D24:124, by using the SUM function and cell references, calculate the total cash flows of the project for years 0:5, respectively (6 pt.). 6 In cell range E30:E40, by using the NPV function and cell references, calculate the NPV of the investment opportunity for cost of capital 0% : 50%, respectively (11 pt.). 7 In cell range C42:G53, insert a Line chart to plot the NPV profile of the investment opportunity with the cost of capital (cell range D30:040) on the horizontal axis and the NPV (cell range E30:540) on the vertical axis. Use the following labels: title: NPV Profile, horizontal axis label: Cost of Capital and vertical axis label: NPV. (5 pt.) In cell E57, by using cell references, calculate the NPV of the investment opportunity for a 10% cost of capital (1 pt.). In cell E61, by using cell references, calculate the IRR of the investment opportunity (1 pt.). 8 9