Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

{press ALPHA. RanInt(50shift)90)press =press = press = press= press=} 2/ Use RanInt(50,90) to generate 5 random numbers (press five times = and record the number

image text in transcribed

image text in transcribed

{press ALPHA. RanInt(50shift)90)press =press = press = press= press=} 2/ Use RanInt(50,90) to generate 5 random numbers (press five times = and record the number obtained each time on your notebook in percentage ) as w1, w2, w3, w4 and w5 3/ Generate the series of cash flows on your note book as follows CFt = we*lo Example Year 0 1 your data Year 0 Wt CFt 1 1 2 Wt 1 53% 74% 54% 65% 86% CF -4390129 2326768.37 3248695.46 2370669.66 2853583.85 3775510.94 2 3 Nmlst 3 4 4 5 5 4/ If the required rate of return is 9%, Find 4-1 The pay back period 4-2 The discount pay back period 4-3 The net present value 4-4 The profitability index 4-5 The Equivalent annual annuity 5/ Suppose that you can invest in another project say B (over 10 years) with the same lo and it generates a constant annual cash flow equal to 20% on lo. The required rate of return is 10%. 5-1 Find the annual cash flow 5-2 The net present value 5-3 The profitability index 5-4 The Equivalent annual annuity 6/ Which of the two projects is more profitable? Project A or Project B

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

Financial Crisis Causes Context And Consequences

Authors: Adrian Buckley

1st Edition

1553395417, 9781553395416

More Books

Students also viewed these Finance questions

Question

What is Indian Polity and Governance ?

Answered: 1 week ago