Required: $1.$Calculate teh WACC for the company. $2.$Calculate the rate of debt for the company. $3.$Calculate the cost of equity for the company. $4.$Using the information from the problem $($above$),$ create a partial income statement incremental cash flows from this project in the black template worksheet using the tab below. $5.$Enter formulas to calculate the NPV by finding the PV of cash flows over the next four years. $($You can either use the EXCEL formula PV$)$ or use mathmatical formula for PV of a lump sum.$)6.$Be sure to set up the EXCEL worksheet so that you are able to change the parameters in E$3$ to E$12.$ Also, link as much as you can in the partial income statement so that the numbers will automatically change. THIS WILL HELP YOU LATER! $7.$Create a NPV profile for the most likely case scenario. $8.$State whether the company should accept or reject the project for each case senario$.$