Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need excel solution please. Thanks PV A four-year software development project has estimates of net cash flows shown in the following table: Year Pessimistic

I need excel solution please. Thanks

image text in transcribed

PV A four-year software development project has estimates of net cash flows shown in the following table: Year Pessimistic Most Likely Optimistic Cost/Profit Estimate 2020 $ -85.000,00 $ -85.000,00 $ -85.000,00 2021 $ 24.000,00 $ 30.000,00 $ 42.000,00 2022 $ 28.000,00 $ 36.000,00 $ 50.000,00 2023 $ 46.000,00 $ 50.000,00 $ 60.000,00 2024 $ 52.000,00 $ 60.000,00 $ 80.000,00 Rate 20% It will cost $85,000 to implement the project, all of which must be invested at the beginning of the project. After the fourth year, the project will have no residual value. Numbers given on the table are found after long discussions including people from sales, finance and accounting departments too, so the values given are the net values after all expenses and tax. Using the most likely estimates of cash flows; a- Calculate cash flow for each year assuming beta distribution. b- Conduct a discounted cash flow calculation assuming a 20 percent hurdle rate with assuming no inflation. C- What is NPV of the project? Is the project acceptable? d- What is the discounted profitability index of the project? Is the project acceptable? You should do both Excel and paper and pencil calculation

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

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

Recommended Textbook for

Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert J. Hughes

11th International Edition

1259094901, 9781259094903

More Books

Students also viewed these Finance questions