Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help on this question. NOT the regular formula calculation., but in a tabular form like an excel sheet lookalike. Question on Calculating a Bid

Need help on this question. NOT the regular "formula calculation"., but in a tabular form like an excel sheet lookalike.

Question on Calculating a Bid Price:

A) Consider a project to supply 100 million postage stamps per year to the U.S. Postal Service for the next five years. You have an idle parcel of land available that cost $850,000 five years ago; if the land were sold today, it would net you $1,080,000 aftertax. The land can be sold for $1,150,000 after taxes in five years. You will need to install $4.6 million in new manufacturing plant and equipment to actually produce the stamps; this plant and equipment will be depreciated straight-line to zero over the project's five-year life. The equipment can be sold for $400,000 at the end of the project. You will also need $600,000 in initial net working capital for the project, and an additional investment of $50,000 in every year thereafter. Your production costs are .45 cents per stamp, and you have fixed costs of $1,200,000 per year. If your tax rate is 34 percent and your required return on this project is 12 percent, what bid price should you submit on the contract?

B) Your company has been approached to bid on a contract to sell 4,800 voice recognition (VR) computer keyboards per year for four years. Due to technological improvements, beyond that time they will be outdated and no sales will be possible. The equipment necessary for the production will cost $2.9 million and will be depreciated on a straight-line basis to a zero salvage value. Production will require an investment in net working capital of $175,000 to be returned at the end of the project, and the equipment can be sold for $275,000 at the end of production. Fixed costs are $570,000 per year, and variable costs are $115 per unit. In addition to the contract, you feel your company can sell 11,400, 13,500, 17,900, and 10,400 additional units to companies in other countries over the next four years, respectively, at a price of $210. This price is fixed. The tax rate is 40 percent, and the required return is 10 percent. Additionally, the president of the company will undertake the project only if it has an NPV of $100,000. What bid price should you set for the contract?

PLEASE ONLY EXCEL FORMAT. THANKS!

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

Fundamentals of Financial Management

Authors: Eugene F. Brigham, ‎ Joel F. Houston

11th edition

324422870, 324422873, 978-0324302691

More Books

Students also viewed these Finance questions

Question

Describe Haless and Whytts contributions to reflex theory.

Answered: 1 week ago