Question
Question 2 Really 30 PointsCorby Models is trying to select the best investment from among four alternatives.Each alternativel involves an initial outlay of $80,000. Their
Question 2
Really 30 PointsCorby Models is trying to select the best investment from among four alternatives.Each alternativel involves an initial outlay of $80,000. Their cash flows follow:YearIdaJackKellyLinda1$ 16,000$ 48,000$ 24,000$ -2$ 20,000$ 28,000$ 24,000$ -3$ 20,000$ 24,000$ 24,000$ 36,0004$ 36,000$ -$ 24,000$ 52,0005$ 44,000$ -$ 24,000$ 51,000Evaluate and rank each alternative based on a) payback period, b) net present value (use a 13% discount rate), and c) internal rate of return.Be sure to show your work in an excel file!Cost$80,000Discount Rate13%a) What is the Payback Period for for each alternative?IdaBlank 1JackBlank 2KellyBlank 3LindaBlank 4 Which alternative would you choose using the payback period?Blank 5b) What is the Net Present Value for each project using a 13% discount rate?IdaBlank 6JackBlank 7KellyBlank 8LindaBlank 9 Which alternative would you choose using the NPV using a 13% discount rate?Blank 10c) What is the IRR for each Project?IdaBlank 11JackBlank 12KellyBlank 13LindaBlank 14 Which alternative would you choose using the IRR
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started