Solve using Excel please! Determine the rate of return for the following cash flow. Year نہ...

Question

Question

Determine the rate of return for the following cash flow. Year نہ سا Net cash flow -80000 -9000 40000 70000

Solve using Excel please!

Answer 1

Answer #1

Net cash inflow = -80000-9000+40000+70000 = $21,000

Rate of Return = $21000 / 80000 = 26.25%

Answer 2

Similar Homework Help Questions

Problem 1-10 points Determine the rate of return for the following cash flow. Year Net cash flow -80000 -9000 40000 700...

Problem 1-10 points Determine the rate of return for the following cash flow. Year Net cash flow -80000 -9000 40000 70000
2. Consider the following cash flow. Year Cash Flow - 100 +50 نہ دیا و +40...

2. Consider the following cash flow. Year Cash Flow - 100 +50 نہ دیا و +40 +30 Determine by graphical method the rate of return on this cash flow. Try i = 2% and i = 10%.
Solve using excel please! For the cash flows shown below, determine the present worth in year...

Solve using excel please! For the cash flows shown below, determine the present worth in year 0 at an interest rate of 6% per year compounded monthly Cost ($1000) Year $300 0 $275 1 $250 2 $225 3 $200 4 $175 5

Problem a) Use Excel to find the rate of return for the following cash flow. (5...

Problem a) Use Excel to find the rate of return for the following cash flow. (5 points) 12,000 1 2 3 4 5 6 7 8 Year 100 100 100 300 300 300 300 4000
For the net cash flow series, find the external rate of return (EROR) using the MIRR...

For the net cash flow series, find the external rate of return (EROR) using the MIRR method with an investment rate of 25% per year and a borrowing rate of 12% per year Net Cash Flow, $ -6.000 The external rate of return is %
For the net cash flow series, find the external rate of return (EROR) using the MIRR...

For the net cash flow series, find the external rate of return (EROR) using the MIRR method with an investment rate of 18% per year and a borrowing rate of 12% per year. Year 1 2 3 4 5 6 Net Cash Flow, $ 5,000 -5,000 -9,000 11,000 -1,500 4,000 The external rate of return is %.

Year Cash Flow -$9,400 4,800 3,900 3,000 نہ دن Required: (a) What is the profitability index...

Year Cash Flow -$9,400 4,800 3,900 3,000 نہ دن Required: (a) What is the profitability index for the cashflows if the relevant discount rate is 9 percent? (Click to select) (b) What is the profitability index for the cashflows if the relevant discount rate is 18 percent? (Click to select) (c) What is the profitability index for the cashflows if the relevant discount rate is 23 percent? (Click to select)
Find the rate of return for the following cash flow. Year Cash Flow -$25,000 15.000 -4.000...

Find the rate of return for the following cash flow. Year Cash Flow -$25,000 15.000 -4.000 8.000 | 15,000 14
Please solve this using an Excel Spreadsheet (that's what it asks for in the question) 1....

Please solve this using an Excel Spreadsheet (that's what it asks for in the question) 1. You are asked to choose the more profitable alternative from the two options shown in the table below. Option A requires an initial investment of $100,000 while Option B requires an initial investment of $200,000. a. Please use a spreadsheet to show the present value of the cost annual cost and benefit flows for each option. - 10 pts b. Use the Net Present...

EXCEL SOLUTION NEEDED: EXCEL FORMULA ONLY PLEASE The internal rate of return (IRR) is the rate...

EXCEL SOLUTION NEEDED: EXCEL FORMULA ONLY PLEASE The internal rate of return (IRR) is the rate of return for a series of cash flows that results in a zero NPV. Excel's IRR function easily computes the IRR for a series of cash flows. What is the IRR for the project with the following cash flows? t Cash flow 0 $ (30,000) 1 8,000 2 10,000 3 11,000 4 17,000 5 12,000 IRR: