Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can someone show the step-by-step for this on exel? Internal Rate of Return (IRR) - show your work, set up each problem with a cash
can someone show the step-by-step for this on exel?
Internal Rate of Return (IRR) - show your work, set up each problem with a cash flow series and/or with the formula 7. Calculate the IRR of a project that requires an initial cash outflow of $5,000 and will be sold at the end of year 5 for $2,500. The project produces the following cash flows: year 1) +$700; year 2) +$600; year 31+$500; year 4)+$400; year 51+300. 8. Calculate the IRR of a machine, which is bought for $10,000, sold at the end of year 5 for $3,500, and produces the following cash flows: year 1)+$300; year 2)+$600; year 3 ) +$1,200; year 4)+$2,400; year 5)+$4,800 9. Calculate the IRR of a machine, which is bought for $5,000, sold at the end of year 5 for $2,000, and produces the following cash flows: year 1}+$2,000; year 2)+$1,750; year 3 ) +$1,500; year 4)+$1,000; year 5)+$500 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