Excel 5 - Alternative Capital Investments The investment committee of Granny's Restaurants Inc. is evaluating two restaurant sites. The sites have different useful lives, but each requires an investment of $1,200,000. The estimated net cash flows from each site are as follows: Year 1 2 3 4 5 6 Net Cash Flows Helena Butte $375,000 $500,000 $375,000 $500,000 $375,000 $500,000 $375,000 $500,000 $375,000 $375,000 The committee has selected a rate of 20% for purposes of net present value analysis. It also estimates that the residual value at the end of each restaurant's useful life is $0, but at the end of the fourth year, Helena's residual value would be $500,000. Instructions: Using formulas/functions wherever available, complete the following on the Input tab... 1) For each site, compute the net present value, using the Present Value of an Annuity table. Ignore the unequal lives of the projects. For each site, compute the net present value, assuming that Helena is adjusted to a four-year life for 2 purposes of analysis. For this use the Present Value of $1 table. Having completed the analysis above, provide a brief recap of what you found in your analysis. Include in 3) the recap, did the results show each project to be positive? Negative? And if Granny's can only do one project, which one should be done and why? Net Present Value Analysis Helena: Annual net cash flow (at the end of each of 6 years) Present value of an annuity of $1 at 20% for 6 years Present value of annual net cash flows Amount to be invested Net present value Butte: Annual net cash flow (at the end of each of 4 years) Present value of an annuity of $1 at 20% for 4 years Present value of annual net cash flows Amount to be invested Net present value Net Present Value Analysis Net Cash Flow Helena Butte Present Value of Net Cash Flow Helena Butte Present Value of $1 at 20% Year 1 Year 2 Year 3 Year 4 Year 4 (resid. value) Total Amount to be invested Net present value