Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer in excel format. thank you! The Salida Salt Company is considering making a bid to supply the highway department with rock salt to

please answer in excel format. thank you! image text in transcribed
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 winter. The contract will guarantee a minimum of 50,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 80,000 tons per year. The firm will need an initial $1,600,000 investment in processing equipment to get 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 costs will be $500,000 and that variable costs should be about $45 per ton of the final product. The new equipment will be depreciated using MACRS with a class life of five years. At the end of the prolect, it is estimated that the equipment could be sold for $150,000. The marketing department estimates that the state will grant the contract at a selling price of $60 per ton, though it may get some lower 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 10%, and the marginal tax rate is 35%. - Set up all the relevant information, cash flows for each year. Calculate NPV, IRR, MIRR. Is this project acceptable

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_2

Step: 3

blur-text-image_3

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

Money Talks Explaining How Money Really Works

Authors: Nina Bandelj ,Frederick F. Wherry ,Viviana A. Zelizer

1st Edition

0691202893, 978-0691202891

More Books

Students also viewed these Finance questions

Question

3-27. General purpose:

Answered: 1 week ago

Question

3-26. Was the senders purpose realistic?

Answered: 1 week ago