Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

These are the three multiple-choice questions of the first question. Please help me to answer these three multiple-choice questions. Thank you very much. The equation

These are the three multiple-choice questions of the first question. Please help me to answer these three multiple-choice questions. Thank you very much.

image text in transcribed

The equation for working out the present value of a future cash flow is: PV(X) (1+r)" Which of the terms in the above equation represents the 'discount factory? X O (1+r)" O (1+r) Cash Flow Model Discount rate Year 0 1 2 Initial outlay Year 1 Year 2 Year 3 Year 4 Year 5 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 3 4 5 0 Acceptable minimum value Chances of a positive NPV 13.9% =SIMULATIONRESULT(C10,012) 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. Several of the cells have been calculated using a triangular distribution using parameters of 400, 600, and 800. What does this mean? O All the expected values will be between 400 and 800 with a mean value of 600 All the expected values will be between 400 and 800 with a mode of 600 The median expected value is 600 and the standard deviation is 200 The mean expected value is 600 and the standard deviation is 200 A company is using sensitivity analysis to analyse the risk of a two year investment opportunity. The following cash flow model is available: Net cash Year Capital expenditure Revenue Costs flow 0 (20,000) 1 40,000 40,000 24,800 24,800 (20,000) 15,200 15,200 2 The relevant discount rate used is 14% and the net present value of the project has been calculated as 5,029. Is this project sensitive to changes in revenue? The project is sensitive at both the 5% level and the 10% level. The project is sensitive at the 10% level, but not at the 5% level. The project is sensitive at the 5% level, but not at the 10% level. The project is not sensitive to changes in revenue

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

The Oxford Handbook Of Private Equity

Authors: Douglas Cumming

1st Edition

0195391586, 978-0195391589

More Books

Students also viewed these Finance questions

Question

1. describe what makes up personality and why it is important,

Answered: 1 week ago