Cashback Offer from 16th to 19th October 2021. Get Flat 10% Cashback credited to your account for a minimum transaction of $80. Post Your Question Today!

Question DetailsNormal
$ 30.00

The Salida Salt Company is considering making a bid to supply the highway department

Question posted by
Online Tutor Profile
request

The Salida Salt Company is considering making a bid to supply the highway department with rock salt to drop on roads in the county 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 that the actual quantity will average 40,00 tons per year. The firm will need an initial $2,300,000 investment in processing equipment to the project started. The contract will last for five years and is not expected to be renewed. The accounting department has estimated that annual fixed cost 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 MARCS with a class life of five years. At the end of the project, it is estimated that the state will grant the contract bids if the contract is opened for competitive bidding. The engineering department estimates that the project will need an initial net working capital investment of $115.000. The firm's WACC is 12% and the marginal tax rate is 35%.

 

A. Set up a worksheet containing all of the relevant information in this problem, and operating cvash flow statement that shows the total annual cash flows for each yearm including the initial outlay.

 

B. Calculate the payback period, NPV, IRR, and MIRR of this project, Is this project acceptable.

 

C, IF the state decided to open the project for competitive bidding, what is the lowest bid price that you can enter without reducing shareholder wealth? Explain why your answer is correct.

 

D. Perform a Monte Carlo simulation with 1,000 trials to determine the expected NPV and the standard deviation of the expected NPV. The uncertain variables and their probability distribution are given below. The quantity of rock salt sold should be simulated for each year independently of the others (i.e., it is five separate variables)

 

Variable- Tons of rock salt in each year. Distribution- Triangular with a minimum of 25,000, most likely of 40,000, and maximum of 50.000

 

Variable- Variable cost per ton. Distribution- Normal with a mean of $95 and a standard deviation of $5.

 

Variable- Salvage value of equipment. Distribution- Uniform with a minimum of $70,000 and a maximum of $200,000.

 

E. Create a histogram showing the probability of distribution of NPV.

 

Using the output of the simulation, what is the probability that the NPV will be less than or equal to Zero? Would you suggest that the project be accepted?

Available Answer
$ 30.00

[Solved] The Salida Salt Company is considering making a bid to supply the highway department

  • This Solution has been Purchased 1 time
  • Submitted On 10 May, 2017 06:23:57
Answer posted by
Online Tutor Profile
solution
Please see atta...
Buy now to view the complete solution
Other Similar Questions
User Profile
Beam7...

The Salida Salt Company is considering making a bid to supply the highway department

Please see attached Thank you!...................................

The benefits of buying study notes from CourseMerit

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35