Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Based on the cash flow numbers in the Excel assignment. Imagine and describe the projects and reasons behind the forecasted cash flows. What might each

image text in transcribed

image text in transcribed

Based on the cash flow numbers in the Excel assignment. Imagine and describe the projects and reasons behind the forecasted cash flows. What might each of the projects have been ? What might the cash outflow have been spent on? Why might the expected future cash flows vary so much? Why should/should not the businessperson proceed with the projects?

Example: First set of cash flows: The outflow represents the costs of building a greenhouse to grow hydroponic tomatoes. The first cash flow might be small because the idea of hydroponically grown tomatoes may not catch on right away. The second cash flow may be bigger because some grocery stores buy the tomatoes to sell. The third cash flow may be huge because the tomatoes will likely be a hit with consumers. The businessperson should not adopt the idea because the PV is negative.

Second set of cash flows: Do the same thing but make up a completely different project.

Make your description of each project's cash flows about 150 words (300 total words) and upload it to the second dropbox created for this week's work. Be creative! The goal of the assignment is for you to get comfortable interpreting numbers. Get comfortable imagining lots of different types of projects businesspeople think about pursuing.

Finally: attach Google images of what each of the two projects would look like.

please ignore that part that says to upload it. Please upload it on chegg as normal.

ok

Consider the following two mutually exclusive projects. Whichever project you choose, any, you require a return of 15 percent on your investment Annual cash flows: Year 0 Year 1 Year 2 Year 3 Year 4 (350,000) 45,000 65,000 65,000 440,000 (50,000) 24,000 22.000 19,500 14,600 Required return 15% Complete the following analysis. Do not hard code values in your calculations. What is the NPV of each project? NPV of Project A NPV of Project B $ 32,589.76 $ 8,673.89 What is the IRR of each project? IRR of Project A IRR of Project B 18.14% 24.08% Consider the following two mutually exclusive projects. Whichever project you choose, any, you require a return of 15 percent on your investment Annual cash flows: Year 0 Year 1 Year 2 Year 3 Year 4 (350,000) 45,000 65,000 65,000 440,000 (50,000) 24,000 22.000 19,500 14,600 Required return 15% Complete the following analysis. Do not hard code values in your calculations. What is the NPV of each project? NPV of Project A NPV of Project B $ 32,589.76 $ 8,673.89 What is the IRR of each project? IRR of Project A IRR of Project B 18.14% 24.08%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions