The Western Coal, Inc. problem was presented in lecture as an example of Present Worth , Annual Worth , and Rate-of-Return analysis. Based upon the cash flow information from this example and using the EXCEL

A) Plot a cash flow diagram

b) Calculate the present worth of the project at 15% using the cell function NPV(rate, values)

c) Calculate the rate-of-return using the cell function IRR(values, guess)

d) Generate a table of “Interest vs. Present Worth “ in 1% intervals between 0 ≤ i ≤ 25%

e) Generate a plot of “Interest vs. Present Worth “

f) Generate a table of “ N vs. Present Worth “ in 1 year intervals between 0 ≤ N ≤ 20yrs

g) Generate a plot of “ N vs. Present Worth “