Answered step by step
Verified Expert Solution
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
{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
Get Instant Access to Expert-Tailored 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