Question
Elly Balance Company is evaluating a possible Rock Salt Contract. The contract runs 5 years with 23,000 tons to be delivered per year. The revenue
Elly Balance Company is evaluating a possible Rock Salt Contract. The contract runs 5 years with 23,000 tons to be delivered per year. The revenue per ton is $135 and the variable cost per ton is $105. The machinery will cost $1,490,000 and is to be depreciated using MACRS 5 year class. FC per year are $350,000. After 5 years the equipment can be sold for $105,000 in salvage value. There is an $85,000 investment needed in net working capital that will be recovered in year 5. The required return is 10% and the company tax rate is 36%. 1. Calculate the Annual Cash Flows for the project. 2. Calculate the NPV. 3. Calculate the payback and discounted payback 4. Calculate the IRR and MIRR. 5. Should the company pursue the contract?
Please show complete excel formulas.
|
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