Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

High Frequency Financial Econometrics

Authors: Yacine Aït Sahalia, Jean Jacod

1st Edition

0691161437, 978-0691161433

More Books

Students also viewed these Finance questions