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 “