Given the following can you check my image for correctness?Economic Feasibility Workbook

This is an individual assignment. Do your own work. Do not compare with other students' work.

Benefits Worksheet

Examine the 'Benefits' worksheet. Note that there are not any expected one$-$time benefits for this project. There are, however, significant recurring benefits. We will use the total

recurring benefits in the analysis on the 'Analysis' worksheet.

One Time Costs Worksheet

Examine the one$-$time costs on the 'One Time Cost' worksheet. You will use the total one$-$time costs in the analysis on the 'Analysis' worksheet.

Recurring Costs Worksheet

Examine the recurring costs on the 'Recurring Cost' worksheet. You will use the total recurring costs in the analysis on the 'Analysis' worksheet.

Analysis Worksheet

Notice that tables have been created to help you with your analysis.

Investment Rate $($cell B$3)$: This is the investment $($discount$)$ rate to be used in the time value of money calculations on this analysis.

One$-$time benefits $($cell B$6)$: There are no one$-$time benefits.

Recurring benefits $($range C$7$:G$7)$: This row contains the total recurring benefits for each year. In reality, this value will probably start low, spike, plateau, and perhaps decline on a

"real" project, but for the purposes of this analysis, the recurring benefits are consistent each year. Enter or reference the total recurring benefits for each year.

Discount Factor $($range C$8$:G$8)$: Notice the investment rate in cell D$2.$ Calculate the discount factor for each year. For Year $0,$ the rate is $1\mathrm{.}000($or a factor of $100\%)$ of the discount

rate. To find the discount factor use the formula:

$-1$

$(1+i{)}^n$

where $i$ is the cell containing the discount rate, and $n$ is the year number $($in row $5).$ Enter the first formula in cell C$8$ for Year $1.$ Reuse the formula to calculate the discount factor

for years $1-5.$

Yearly PV of Benefits $($range B$9$:G$9)$: Multiply the discount rate factor by the net economic benefit for each year. This calculates each year's benefits in today's dollars. For

example, $$44,643$ today is worth $$50,000$ at the end of Year $1$ due to the time value of money.

Cumulative PV of all benefits $($range B$11$:G$11)$: Calculate a running total of the benefits across years $0-5.$

One$-$time Costs $($cell B$13)$: Reference the total one$-$time costs from the One Time Cost worksheet in cell B$13.$ Make sure the value is a negative value, since it is a cost.

Recurring Costs $($range C$14$:G$14)$: Reference the total recurring costs from he 'Recurring Costs' worksheet. The values should be negative, since they are costs.

Discount Factor $($range B$15$:G$15)$: Copy the formulas from row $8$ to this row $($assuming you have appropriate absolute references in your formulas$)$ or use a similar calculation to

generate the discount factor. You should end up with the same values in row $15$ as you did in row $8.$