Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need work process, plz do not just show excel format. Problem 1 (20 points): Tony Cirillo is back in Las Vegas and is searching for
need work process, plz do not just show excel format.
Problem 1 (20 points): Tony Cirillo is back in Las Vegas and is searching for good investments. He is the CEO and president of Wise Guys Poultry Co. Tony needs your help to decide which of the following projects to undertake. Due to limited time, he can only implement one project. On the next page, you can see the initial investments and cash flows (in thousand $) of the projects. For all the projects, the appropriate discount rate is 14%. Use Excel to do the following calculations and show your output. a. Rank the projects using the NPV criterion. (10 points) b. Suppose cash flows for all projects are expected to grow at the inflation rate of 5%. What is the NPV of the projects now? Does the previous ranking change? (10 points) Project4 Project 1 Waste Management Project 2 Real Estate Property Project 3 Fast Food Restaurant Night Club Initial Investment at t=0 Cashflows at Year -4000 -5000 -3000 -4000 Year 2 Year 3 Year 4 Year 5 Year 6 800 800 800 800 800 800 800 3,000 Year 7 160 200 350 395 432 440 500 600 700 800 900 1000 1000 1000 2,000 800 800 800 800 800 800 800 800 280 280 280 280 280 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15 280 30,000 280
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