Question
Please show the math formula and work with the Excel answers( show it al) Consider a project that involves the purchase of a $100,000 machine.
Please show the math formula and work with the Excel answers( show it al)
Consider a project that involves the purchase of a $100,000 machine. The machine will last for three years. It is expected to produce 20,000 units per year. The sales price for each unit will be $32, and variable costs will be $25 per unit. The project will also incur fixed labor costs of $45,000 per year. It will require no additional investment in net working capital and is expected to have a salvage value of $5,000 in three years. The machine will be depreciated using the MACRS schedule below (note that this schedule has 4 years of depreciation, but the machine will be sold after 3 years). The tax rate is 40%, and the discount rate is 10%. You may want do this problem in Excel, and then copy the numbers into your Word document.
Year | MACRS % |
1 | 33 |
2 | 44 |
3 | 15 |
4 | 8 |
Construct a table of the relevant cash flows for this project, and compute the NPV and IRR of the project. (14 points)
What is the minimum unit price (to the nearest cent) that would justify investment? You do not need to show all your work, but explain how you arrived at your answer. (2 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
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