how would i go about finding the values in Excel?

rather lost in this course from doing zoom.

Aa to ES ALI 2AEEEE 1 No Spac. Heading 1 Heading 2 1 Normal Title Goer A se 5 Styles 12 Edit Paragraph Capital Budgeting Case Suppose you are the risk manager for a company considering a $4,000,000 investment in a new 13-year project. The $4,000,000 cost of the project will be depreciated on a straight-line basis over 5 years. The project is expected to generate positive operating cash flows equal to $1,360,000 per year (not including the effect of depreciation or taxes). The company's tax rate is 31%. Ignoring any risk management considerations, evaluate the project by calculating its net present value and internal rate of return. Assume the company has a required return of 14%. As risk manager, you are concerned about the additional liability exposure the firm will face if it accepts the project. You obtain an estimate of the annual total loss distribution from an insurance company that has many years of experience dealing with these types of exposures. The annual total loss distribution has a mean of $320,000, a standard deviation of $50,000, and a skewness coefficient of 2. The management team is worried about how the potential liability losses will be financed. The company decides to establish a loss reserve such that it can be 92% confident that its actual losses can be met by the fund. Determine the size of the required loss reserve using the normal power approximation. Recalculate the net present value and internal rate of return for the project taking into consideration the potential liability exposure and assuming a loss reserve is set up to handle the losses. Any funds set aside in the reserve will earn interest at 2% per year. Aa to ES ALI 2AEEEE 1 No Spac. Heading 1 Heading 2 1 Normal Title Goer A se 5 Styles 12 Edit Paragraph Capital Budgeting Case Suppose you are the risk manager for a company considering a $4,000,000 investment in a new 13-year project. The $4,000,000 cost of the project will be depreciated on a straight-line basis over 5 years. The project is expected to generate positive operating cash flows equal to $1,360,000 per year (not including the effect of depreciation or taxes). The company's tax rate is 31%. Ignoring any risk management considerations, evaluate the project by calculating its net present value and internal rate of return. Assume the company has a required return of 14%. As risk manager, you are concerned about the additional liability exposure the firm will face if it accepts the project. You obtain an estimate of the annual total loss distribution from an insurance company that has many years of experience dealing with these types of exposures. The annual total loss distribution has a mean of $320,000, a standard deviation of $50,000, and a skewness coefficient of 2. The management team is worried about how the potential liability losses will be financed. The company decides to establish a loss reserve such that it can be 92% confident that its actual losses can be met by the fund. Determine the size of the required loss reserve using the normal power approximation. Recalculate the net present value and internal rate of return for the project taking into consideration the potential liability exposure and assuming a loss reserve is set up to handle the losses. Any funds set aside in the reserve will earn interest at 2% per year