Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For Decision Makers

Authors: Peter Atrill, Eddie McLaney

9th Edition

1292251255, 9781292251257

More Books

Students also viewed these Accounting questions

Question

14. Now reconcile what you answered to problem 15 with problem 13.

Answered: 1 week ago