Question
Please include all formulas with answers, Thank You. I need the formulas to solve how each number is calculated, there's also a show formulas option
Please include all formulas with answers, Thank You. I need the formulas to solve how each number is calculated, there's also a show formulas option on the Formulas tab on Excel.
1) (a) Suppose you are the risk manager for a company considering a $5,000,000 investment in a new 8-year project. The $5.0 million cost of the project will be depreciated on a straight-line basis over 4 years. The project is expected to generate positive operating cash flows equal to $1,900,000 per year (not including the effect of depreciation or taxes). The company's tax rate is 20%. 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 10%. (b) 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 $120,000, a standard deviation of $60,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 91% confident that its actual losses can be met by the fund. Determine the size of the required loss reserve using the normal power approximation. (c) 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 3% per year.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started