Your assignment is to create an Excel spreadsheet that will calculate the NPV as well as provide some scenario analysis so James can judge the financial wisdom of his decision. You must create the spreadsheet as well as submit a memo that outlines your analysis (and scenario analysis) of whether or not James should undertake the project based on an NPV analysis.

The cost for a quality barbeque will be $9,400. It is expected to last 20 years, at which time its salvage value is expected to be $500. The discount rate for this project is 10%, but that is a bit uncertain and some analysts feel it could be as low as 6% and as high as 18%. The tax rate will be 30%, and the CCA Rate for the Bar-be-cue will be 20%.

To get assurance of a favorable spot on campus, James has made a