could you show the excel formulas aswell please

The difectors of Company d would like to assess a new invesment propposaing using a Net Fresent value simustion. The finance director has set up some inital information inte a template and would like you to complete the calcubtion. Part (a) Uving the information provided, please complete the following remaining sections of the Net fresent Value calculation: - Revenue $ costs (with random values generated within the limits you have been given) - Net trading cash fliows - Corporation tax charges Part (b) Using appropriate formulas, please set up the spreadsheet to ideotify the following values from the NPV simulation table: - Average NPV - Maximum NPV - Minimum NPV - Probability of failure Please ensure that you use formula wherever appropriate, so that the answers automatically update if any of the information changes Plesse nete shat any random values wilt automatically refresh on a regular basis. So the most important thing will be to ensure your Sormuls has been set up correctly so that your answees will aho update autematically. Part (a) Fiease complete the remaining sections of the Net Preseet Value calculation Bevenue Costs Net trading ca Corporation U Equipment Disposal prock Capital atlowances Net cadh flews 3,000,0000135,000135,000110,700110,70090,774590,774288,526238,526 Cost of capital 16N Part [b] Please complete the following calculations from the NPV simulation table