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