Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash Flow Model Discount rate Year Initial outlay 0 Year 1 1 Year 2 2 Year 3 3 Year 4 4 Year 5 5

image text in transcribed

Cash Flow Model Discount rate Year Initial outlay 0 Year 1 1 Year 2 2 Year 3 3 Year 4 4 Year 5 5 NPV Acceptable minimum value Chances of a positive NPV CELL FORMULAE 15% APPLIED UNIFORM CHOICE(0.12,0.13,0.14,0.15,0. Cash flow (110,614)-APPLIED TRIANGULAR_VALUE(75000,81000,8500 3,775 APPLIED TRIANGULAR VALUE(400,600,800)*6 6,703 APPLIED TRIANGULAR VALUE(400,600,800)*12 7,338 APPLIED TRIANGULAR_VALUE(400,600,800)*12 7,644 APPLIED TRIANGULAR_VALUE(400,600,800)*12 146,986 APPLIED TRIANGULAR_VALUE(400,600,800)*12+A (19,990) NPV(C2,C5.09)+C4 0 13.9% SIMULATIONRESULT(C10,D12) The above is an extract from a spreadsheet produced after a monte carlo simulation of 500 iterations. The formulae used in each cell are printed to the right of the cell. What does the figure of 13.9% mean? There is a 0.139 chance that the project will make the investor better off There is a 0.139 chance that the project will make the investor worse off There is zero chance that the project will generate a return of 13.9% There is a 0.139 chance that the NPV of the project will be zero

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

Cost Accounting Foundations and Evolutions

Authors: Michael R. Kinney, Cecily A. Raiborn

9th edition

9781285401072, 1111971722, 1285401077, 978-1111971724

More Books

Students also viewed these Accounting questions