Purchase Solution

Bid Price for Investment

Not what you're looking for?

Ask Custom Question

Generate spreadsheet that shows best case and worse case prices that the company will consider paying for the investment.

Determine a price estimate for this company via the Net Value technique using the discount rate of 11.2%. Use best case scenario and worse case scenario cash flows given and discount each of those annual cash flows to put them into present value terms. The terminal value is essentially the perpetuity that begins at the end of year 10 of the forecast period. To calculate the terminal value divide year 10 cash flow by the difference between the disount rate and the estimate rate of growth of the perpetuity. (I'm understanding this to be 3% at end of yr 10) Then discount that terminal value number for 9 periods to put into present value terms( I confused right here). Sum the discounted terminal value with the other 9 discounted cash flows and substract the initial investment ( 62.46 million) and you should be ready.

This company has rejected bids of 30-35 million from other companies trying to buy them out. Why? What price should we pay to buy them out according to your calculations (best and worse case)?

---
I need some help making sure my PV's and NPV's are correct for best and worse case scenario forecasts. Also, need help deriving a terminal value and discounting it correctly. Lastly, advice for estimated price bid for best and worse case scenarios. Please see attached spreadsheet and comments. Just the bottom portion of spreadsheet under the blue line is in question. The top part is just information for myself. Mainly need to know terminal value at end ofyr 10 (3% growth to perpetuity), and how to discount that terminal value number for the 9 periods to put into present value terms. I hope I did not leave any vital information out that might be making the problem difficult-if so, i apologize.

Attachments
Purchase this Solution
Solution Summary

The solution explains how to calculate the bid price under the best case and worst case scenarios.

Solution Preview

I have calculated the terminal value. You have to take the year 10 figure ( the free cash flow and not the discounted cash flow) and divided by (.112-0.03) since it is a growing perpetuity. The figure you arrive at is the PV in the year 9. You have to now discount this PV ...

Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

View More Free Quizzes
Related BrainMass Solutions

  • Estimating the appropriate bid price

    The bid price represents a financial break-even level for the project. Solution to given problem depicts the steps to estimate the appropriate bid price in the given case.

  • Calculate the minimum bid value in the given case.

    508650 Calculate the minimum bid value in the given case. A company has posted a request for bid on 230k cases of widgets per year over the next 5 years. Determine what bid price makes the most sense as a potential supplier.

  • Triangle Exchange Opportunity- Foreign Currency Exchange

    Bid price= lowest price a buyer is willing to pay for an asset Ask= highest price a seller is willing to sell an asset for a) Do the above exchange rates present an arbitrage opportunity? Explain?

  • Fundamentals of Corporate Finance

    You also need an initial investment in net working capital of $69,000. If your tax rate is 30 percent and your required return is 11 percent on your investment, what bid price should you submit?

  • Your company has been approached to bid on a contract to sell 16,800 voice recognition.

    What bid price should you set for the contract? Year 0 1 2 3 4 I. Investment Outlay 1. Investment for new equipment -4,032,000 2. Investment in net working capital -126,000 3.

  • Bid price for the contract

    What bid price should you set for the contract? Please see the attached file. The solution explains how to arrive at the bid price for a contract.

  • Bid / ask spreads for currency

    On the left hand side is bid price whereas on the right hand side is the ask price. The ask is greater than the bid price and the difference between the two is called Bid Ask spread.

  • Treasury Bills

    The holder receives the differential between the bid price and the face amount at maturity. Dealer A = bid of $30,100 in interest Dealer B = bid of $30,200 in interest Dealer C = bid of $29,900 in interest.

  • Sheetbend & Halyard Accepting the Contract with the U.S. Navy

    The bid and its supporting documents had been prepared by Sheetbend´s sales staff. It called for Sheet bend to supply 100,000 yards of duffel canvas per year for 5 years. The proposed selling price was fixed at $30 per yard. Mr.

  • Should AVG Use a Traditional IPO or an Online Auction?

    The initial price set by the company is higher that any investor is expected to bid. Once a bid is received, the lower bid price and number of requested shares are accepted.

View More Related Solutions