Business Decision:investment in new machine
Not what you're looking for?
Need help with this problem.
Karl is planning to buy a new ZZZ machine for the club. Members have told him the new ZZZ machine will raise the club's annual revenues by $1000 per year.
Karl's club is a taxable: tax rate is 36%. He plans to depreciate the new ZZZ machine on a straight line basis to a zero salvage value at the end of five years. The cost of the new equipment is $1999. A spare parts inventory investment of $200 will have to be made at the time of purchase. He doesn't think this inventory will have any salvage value at the end of five years.
Using Excel:
1. Prepare a table of annual cash flows for the new investment. Show your calculations in detail.
2. Calculate the payback period.
3. Calculate the IRR.
4. Calculate the NPV, using discount rates of 10% and 20% per year.
5. Comment on the given the results above.
Purchase this Solution
Solution Summary
Excel file contains calculations of annual cashflow, NPV, IRR and pay back period.
Purchase this Solution
Free BrainMass Quizzes
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Operations Management
This quiz tests a student's knowledge about Operations Management
Introduction to Finance
This quiz test introductory finance topics.