In: Finance
Inside vs Outside Recruiter | |||||||
Outsource recruitment of programmers costs $250,000 annually. | |||||||
Hiring an internal recruiter costs you $175,000 annually. | |||||||
Tax rate is 40%. | |||||||
You have to buy out his business for $150,000. | |||||||
What is the NPV and IRR over a 5 year period? | |||||||
WACC is 11%. | |||||||
If you can not meet his asking price, how much would you be willing to pay him in order | |||||||
to meet your cost of capital? |
Year | after tax savings from hiring a internal recruiter = (cost of outsourcing-cost of internal hiring)*(1-tax rate) | present value of after tax savings = after tax savings/(1+r)^n r = 11% |
0 | -150000 | -150000 |
1 | 45000 | 40540.54054 |
2 | 45000 | 36523.0095 |
3 | 45000 | 32903.61216 |
4 | 45000 | 29642.89384 |
5 | 45000 | 26705.30976 |
NPV | Sum of present value of cash flow | 16315.36579 |
IRR= Using IRR function in MS excel | irr(cell reference year 0 cash flow: cell reference cash 5 cash flow) | 15.24% |
If you can not meet his asking price, how much would you be willing to pay him in order | ||
Year | after tax savings from hiring a internal recruiter = (cost of outsourcing-cost of internal hiring)*(1-tax rate) | present value of after tax savings = after tax savings/(1+r)^n r = 11% |
1 | 45000 | 40540.54054 |
2 | 45000 | 36523.0095 |
3 | 45000 | 32903.61216 |
4 | 45000 | 29642.89384 |
5 | 45000 | 26705.30976 |
If you can not meet his asking price, how much would you be willing to pay him in order | sum of present value of cash inflow | 166315.3658 |