| 
June 27th, 2009, 03:09 PM
| | Newbie | | Join Date: Jun 2009
Posts: 3
Country: Thanks: 3
Thanked 0 Times in 0 Posts
| | Find Rate of Return 1. The problem statement, all variables and given/known data
Alternative:
immediate investment: $130,000
first-year expenditure: $6,000
the increase $2,000 and 36,000 annually.
The economic life of the project is forecast to be 12 years
Determine the rate of return of this Plan? 2. Relevant equations
PW = -130,000 + 36,000(P/A, i%, N) – G(A/G, i%, N) - 6000(P/A, i%, N) 3. The attempt at a solution
At i = 10 %
PW = -130,000 + 36,000(P/A, 10%, 12) – G(A/G, 10%, 12) - 6000(P/A, 10%, 12)
Is the PW equation right?
Last edited by 0xCMD; June 29th, 2009 at 09:53 AM.
Reason: Clearing up confusion with the equation.
| 
June 27th, 2009, 04:36 PM
| | Junior Member | | Join Date: Jun 2009
Posts: 31
Country: Thanks: 0
Thanked 8 Times in 8 Posts
| | 0xCMD, I'm not entirely familiar with all of your notation, so I apologize in advance if I overlook something important in your info.
A project's IRR (aka "rate of return", your question's objective) is that rate which creates a zero NPV, when all the cash flows are discounted by such rate.
Unless told otherwise, questions of this type usually have you assume the CFs all occur at the end of each year. Bad news: Solving for the single rate r which creates the requisite -0- NPV comes down to trial-and-error, if there are several cash flows (as in this case). Good news: Programs such as Excel can blaze through the T-and-E iterations in a blink.
Using Excel as the example (but use your favorite weapon of choice), lay out the cash flows and let the IRR function (or its Goal Seek tool, e.g.) do the high-speed heavy lifting for you.
It appears that what you've done to this point is to find the project's NPV (or "NW"), using a discount rate of 12%, a worthy objective in its own right. But what the question is asking requires you to fiddle with that discount rate until you land on a NPV of zero. Hint: the project you've described has an IRR significantly north of that 12%.
Best of luck!
__________________ ...it was early and I was full of no coffee... | | The following users thank LochWulf for this useful post: | |  | 
June 27th, 2009, 04:47 PM
| | Newbie | | Join Date: Jun 2009
Posts: 3
Country: Thanks: 3
Thanked 0 Times in 0 Posts
| | ok thanks
I used trial and error:
PW(18%) = -130,000 - 2,000(A/G, 18%, 12) + 36,000(P/A, 18%, 12)
PW(18%) = -130,000 - 2,000(3.1936) + 36,000(4.4941)
PW(18%) = 230.642
PW(20%) = -130,000 - 2,000(A/G, 20%, 12) + 36,000(P/A, 20%, 12)
PW(20%) = -130,000 - 2,000(3.0739) + 36,000(4.1925)
PW(20%) = -5,112.33
Using Linear Interpolation:
i=18% --> 230.642
x% --> 0
i=20% --> -5,112.33
(18%-x%)/(18%-20%) = (230.642-0)/(230.642-(-5,122.33))
(0.18-x%)/(-0.02) = 0.061984
0.18 - x% = 0.00124
0.18 + 0.00124= x%
x% = 0.18124 or 18.12 %
I'm not sure if the equation for the PW is right based on the cash flows described in the question.
Last edited by 0xCMD; June 29th, 2009 at 09:52 AM.
Reason: Correcting equations, making them more clear.
| 
June 29th, 2009, 08:09 AM
| | Junior Member | | Join Date: Jun 2009
Posts: 31
Country: Thanks: 0
Thanked 8 Times in 8 Posts
| | Yep, your PVs of Project A at 18% and at 20% are good.
And you correctly reasoned that the actual IRR must lie between 18 and 20, hence your approximation via linear interpolation.
Just for grins, though, keep in mind that the relationship between PV and IRR isn't linear, and so a linear interpolation might miss it by more than your desired accuracy degree. Figure the PV at 19%, and then interpolate using 18 and 19% as your range.
It comes down to how much accuracy is appropriate for the situation--your call. But with the 18-19 interpolation, you'll have an idea of how sensitive the answer is to further fine-tuning. If the answer didn't move much, you'll probably be comfortable calling it a day without any further trial-and-error.
Cheers!
__________________ ...it was early and I was full of no coffee... | | The following users thank LochWulf for this useful post: | |  | | Thread Tools | | | | Display Modes | Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | All times are GMT -7. The time now is 09:43 AM. | | |