This information is needed to complete the spreadsheet below.

Alternative "C" Economic Analysis - Contains: 1. Tangible Benefits Worksheet 2. One Time Cost Worksheet 3. Recurring Cost Worksheet 4. Discount rates - Used to create Cost/Benefit Analysis Spreadsheets for possible alternative solutions. Cost/Benefit Analysis 3. Recurring Cost Worksheet - Nova spreadsheet is located in Files. - Description of Alternative C-Nova Corporation. 1. Industry Leader in CRM solutions 2. Large and complex 3. Pricing only based on modules purchased 4. License for the use of the system is middle of the row 1. Tangible Benefits Worksheet - Nova 4. Discount Rate =12% Need to let Management Team know what: 1. What the Overall NPV is. 2. What the Return on Investment is. 3. What the Break Even Point is. Also discuss in the Baseline Project Plan Report. 2. One Time Cost Worksheet - Nova Cost Benefit Analysis Spreadsheet For NOVA Calculating the Break Even Point Break-even Analysis 1. Find the last year row 30 is negative; go up the column to the year listed in row 6. Write down that result as the whole year. Then do Steps 2 and 3 below to Yearly NPV Cash Flow $0 $0 \begin{tabular}{|l|r|r} $0 & $0 & $0 \\ \hline$0 & $0 & $0 \end{tabular} calculate fraction to add to the whole year value. Overall NPV Cash Flow $0 0 2. First year row 30 is positive, take row 29 , and subract row 30 in same column, and then divide the Use the first year of positive cash flow to calculate break-even fraction. result by the row 29 value/row 29. Actual break-even occurs at Post Step 3 here! 3. ADD Step 1 (full year value) with Step 2 (fractional year value) =