Risk is an important factor when valuing financial assets an proposals.

You are to complete the work sheet and compute the correct values (part 1 = 80 pts))

And make a risk assessment (part 2 = 20 pts)

Chapter 5 does an excellent job presenting this topic. Maybe Kingman has a file posted.

Also, Please do your calculations within Excel including cell references. It is the true value of an electronic spreadsheet in that you an reuse it with other inputs.