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...

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 Present Values of future cash flows. ... We have to calculate the rate of increase. ... for an Annuity They can be read from tables or calculated using the ...

Calculating present/future values of given cash flows. Problem 1 Toadies, Inc., has identified an investment project with the following cash flows. ...

Calculating Present Value of Cash Flow Stream. ... Next we calculate the present value of annuity of $1000 ... Value of a cash flow stream is calculated and explained. ...

... d) In all the three cases we are calculating present worth (in terms of ... Solution to each problem discusses the steps to calculate present worth of future cash ...

... find annual withdrawal=R=? Sum accumulated at the age of 70=Present Value of ... Solutions to these problems explain the methodology to calculate PV & FV of ...

...Calculate the Internal Rate of Return of each of the following potential investments and recommend ... The expert calculates the net present value, internal ...