I need to calculate the price for both the best and worst case scenarios. I have attached a spreadsheet with the best and worst cases. I want to calculate each using a discount rate of 9.7% and then also using 11.2%. This is the hint the teacher gave us, but i still cant figure it out:

Your first step is to determine the appropriate discount rate to use. I encourage you to have that discussion in the discussion area and decide as a group.

Next, using the best case scenario cash flows you produced for Blue Mesa Task 3, and the worst case which are provided, you need to discount each of those annual cash flows to put them into present value terms.

The terminal value is essentially a growing perpetuity that begins in year 10 of the forecast period. To calculate the terminal value, divide the year 10 cash flow by the difference between the discount rate and the estimated rate of growth of the perpetuity. Then, discount that terminal value number for 9 periods to put it into present value terms.

Sum the discounted terminal value with the other 9 discounted cash flows, and subtract the initial investment, which is the Laredo debt payoff, and you should be good to go!

Suppose you retire at age 70, with a life expectancy of 20 more years, and you expect to spend $55,000 a year during your retirement. How much money do you need to save by age 70 to support this consumption plan? Assume an interest rate of 7%.

Please help with the following problem.
What are the cash flows associated with calculating the present value of preferred stock? What are the cash flows associated with calculating the present value of common stock? Why is it more difficult to calculate the present value of common stock than it is to calculate the value of

Develop a worksheet simulation for the following problem. The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $30,000. The variable cost for the product is uniformly distributed between $16 and $24 per unit. The product will se

An investor is considering a bond that currently sells at a discount ($953) to the face value of $1,000. The coupon rate is 9.25% paid semiannually. If there are 15 years left on the bond what is the yield to maturity?

Calculating Interest Rate. Find the interest rate implied by the following combinations of
present and future values:
Present Value Years Future Value
$400 11 $648
$183 4 $249
$300 7 $300
Please show me how you calculated the problem so I can do it for my paper. These are not the

Suppose the December CBOT Treasury bond futures contract has a quoted price of 80-07. The T-bond is a 20-year 6% coupon bond and the interest is paid semi-annually. What is the implied annual interest rate inherent in the futures contract?
a) 6.86
b) 7.22
c) 7.60
d) 8.00
e) 8.40