NPV, IRR, Profitability Index and Payback
Not what you're looking for?
18. You are thinking about acquiring a new company. The company is at a bargain asking price of $400,000. You have your expert accountants project a 10 year income statement (see below) based on how well you think you could run this new venture. Now you need to project a ten year cash flow and determine if you should acquire this new entity. You are currently using a 15% discount rate in your calculations. (use at least two decimal places in all calculations)
Net Present Value $_____________________
Internal rate of return _____________________%
Profitability Index _____________________
Payback _____________________ yrs.
Should you acquire the new company? __________
Net Income
Depreciation After Taxes Net Cash Flow
Year 1 42,870 184,278 ___________
Year 2 73,470 159,018 ___________
Year 3 52,470 162,159 ___________
Year 4 37,470 158,752 ___________
Year 5 26,790 149,365 ___________
Year 6 26,760 129,707 ___________
Year 7 26,790 105,576 ___________
Year 8 13,380 84,448 ___________
Year 9 0 57,539 ___________
Year 10 0 16,053 ___________
Please respond in Excel.
Purchase this Solution
Solution Summary
Calculates Net Present Value, Internal rate of return, Profitability Index and Payback.
Purchase this Solution
Free BrainMass Quizzes
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.