Audio Partners needs to invest in the next level of technology in order to be competitive. The company is exploring the purchase of a new
Audio Partners needs to invest in the next level of technology in order to be competitive. The company is exploring the purchase of a new piece of equipment that will cost $1,500,000, at an expected discount rate of 8%. The equipment is expected to return net cash inflows of $250,000 over the next 10 years.
Please show your work in the Excel template (see below) and provide a thorough explanation to the following questions.
- Please use the following link to review the Excel template and to show your work: https://docs.google.com/spreadsheets/d/1d-y3N676Dj9Wiwy_Z1pNx4xC93L8PCOznA0_edrWjyY/edit?usp=sharing
Question:
Based on the above information and using the provided Excel template (https://docs.google.com/spreadsheets/d/1d-y3N676Dj9Wiwy_Z1pNx4xC93L8PCOznA0_edrWjyY/edit?usp=sharing), calculate the following items for this proposed equipment purchase:
- Net Present Value
- Internal Rate of Return
- Payback Period
- Would you recommend the company invest in this equipment? Why or why not?
- Explain the importance or significance of the calculations prepared in Part 1 of this assignment. Do not explain how the numbers were calculated, this is what your formulas in Excel will show.
- Recommend whether the equipment should be purchased based solely on the calculations in Part 1.
- Discuss a minimum of three other non-quantitative factors that should be considered when making a capital budgeting decision such as the one in this scenario.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Part 1 Calculations Using the provided Excel template I calculated the following items 1 Net Present Value NPV Discounted cash inflows 250000 1 0081 2...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