Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use excel and show formulas behind each cell. The Big Salt Company is considering making a bid to supply the highway department with rock

Please use excel and show formulas behind each cell. image text in transcribed
The Big Salt Company is considering making a bid to supply the highway department with rock salt during the winter. The contract will guarantee a minimum of 25,000 tons in each year, but the actual quantity may be above that amount if conditions warrant. Management believes the actual quantity will average 40,000 tons per year. The firm will need an initial $1,500,000 investment in processing equipment to get the project started. The contract will last for 5 years and is not expected to be renewed. The accounting department has estimated that annual fixed costs will be $500,000 and that variable costs should be about $94 per ton of the final product. The new equipment will be depreciated using MACRS with a 3-year class life. At the end of the project, it is estimated that the equipment could be sold for $90,000. The marketing department estimates that the state will grant the contract at a selling price of $150 per ton. The engineering department estimates that the project will need an initial net working capital investment of $126,000. The firm's WACC is 12% and the marginal tax rate is 35%. a. Calculate the Net Initial Investment b. Calculate Net after-tax Operating Cash Flows c. Calculate any Terminal Value d. What is the Net Present Value and the Internal Rate of Return? Based on your calculations, would you recommend moving forward with the project or not? Why

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance

Authors: Harvey S Rosen

6th Edition

0072374055, 978-0072374056

More Books

Students also viewed these Finance questions

Question

Are assessments of candidate attractiveness relevant? Discuss.

Answered: 1 week ago