The directors of Company J would like to assess a new investment proposal using a Net Present Value simulation. The finance director has set up some initial information into a template and would like you to complete the calculation. Part (a) Using the information provided, please complete the following remaining sections of the Net Present Value calculation: - Revenue \& costs (with random values generated within the limits you have been given) - Net trading cash flows - Corporation tax charges Part (b) Using appropriate formulas, please set up the spreadsheet to identify the following values from the NPV simulation table: - Average NPV - Maximum NPV - Minimum NPV - Probability of failure Part (a) Please complete the remaining sections of the Net Present Value calculation The directors of Company J would like to assess a new investment proposal using a Net Present Value simulation. The finance director has set up some initial information into a template and would like you to complete the calculation. Part (a) Using the information provided, please complete the following remaining sections of the Net Present Value calculation: - Revenue \& costs (with random values generated within the limits you have been given) - Net trading cash flows - Corporation tax charges Part (b) Using appropriate formulas, please set up the spreadsheet to identify the following values from the NPV simulation table: - Average NPV - Maximum NPV - Minimum NPV - Probability of failure Part (a) Please complete the remaining sections of the Net Present Value calculation