For the discount rates of 4% and 7%,
1. Find the formula for and compute the present value (in 2004 dollars) of the cost of the Exxon Valdez spill.
2. Suppose that Exxon could have adopted stricter rules to ensure a rested crew and a sober master at the beginning of 1989. Enforcing these rules would have cost Exxon P dollars every subsequent year in the future, and the crash wouldn't have happened. If Exxon could have estimated the cost of the spill in 1989, how much would they have been willing to pay each year to avoid a crash?

*** YOU DO NOT REQUIRE INFLATION INDEX FOR 2004. THE QUESTION JUST ASKS TO FIND PRESENT VALUE (IN 2004 DOLLAR) USING DISCOUNT RATE OF 4% AND 7%**

Please refer to the excel spreadsheet.
I have put down the cash flows that Exxon has incurred after the accident on the spreadsheet. In column I, I have found the present value of cash flows at the rate of 4% , it is $9,413 million and in column J I have calculated the present value of the cash flows at the rate of 7%, it is $8,052.38 million.

Now, if we take the rate of 4% and the present value figure obtained in column I, Exxon would be ...

Understanding Excel formulas for financial analysis. How do I use the Excel financial formulas to calculate present value, future value and discount rates? ...

... time, or 2) you could calculate the present... of illustration, I'll demonstrate calculating the present... very clear instructions for how to calculate the present...

Present Value Concept and Calculating Present and Future Values. ... explain why the concept of present value is so ... 2. Calculate the future value of the following: ...

Calculate the present value of an investment that is ... 8% compounded daily, what is the present value ... The solution presents a spreadsheet with clear explanations ...

Calculating Net Value Present and IRR. ... Use the formula and the financial calculator or Excel ... payback period and project acceptance are calculated and discussed. ...

... Solution describes the steps to calculate present value, future value, periods and rate of interest in given situations. ... Use a financial calculator). ...

Capital Budgeting. ... Please refer attached files for complete solutions. Solution: 1. Calculate the net present value and profitability index of a ...

... worthy of a special grant by calculating the present...Calculate the present value of the estimated benefit stream ... be aware of how inflation is calculated as one ...