1. Sue now has $125. How much would she have after 8 years if she leaves it invested at 8.5% with annual compounding? $205.83 $216.67 $228.07 $240.08 $252.08 2. Suppose you have $1,500 and plan to purchase a 5-year certificate of deposit (CD) that pays 3.5% interest, compounded annually. How much will you have when the CD matures? $1,781.53

1. Sue now has $125. How much would she have after 8 years if she leaves it invested at 8.5% with annual compounding? $205.83 $216.67 $228.07 $240.08 $252.08 2. Suppose you have $1,500 and plan to purchase a 5-year certificate of deposit (CD) that pays 3.5% interest, compounded annually. How much will you have when the CD matures? $1,781.53

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 37P

See similar textbooks

Similar questions

It is January 1 of year 0, and Merck is trying to determine whether to continue development of a new drug. The following information is relevant. You can assume that all cash flows occur at the ends of the respective years. Clinical trials (the trials where the drug is tested on humans) are equally likely to be completed in year 1 or 2. There is an 80% chance that clinical trials will succeed. If these trials fail, the FDA will not allow the drug to be marketed. The cost of clinical trials is assumed to follow a triangular distribution with best case 100 million, most likely case 150 million, and worst case 250 million. Clinical trial costs are incurred at the end of the year clinical trials are completed. If clinical trials succeed, the drug will be sold for five years, earning a profit of 6 per unit sold. If clinical trials succeed, a plant will be built during the same year trials are completed. The cost of the plant is assumed to follow a triangular distribution with best case 1 billion, most likely case 1.5 billion, and worst case 2.5 billion. The plant cost will be depreciated on a straight-line basis during the five years of sales. Sales begin the year after successful clinical trials. Of course, if the clinical trials fail, there are no sales. During the first year of sales, Merck believe sales will be between 100 million and 200 million units. Sales of 140 million units are assumed to be three times as likely as sales of 120 million units, and sales of 160 million units are assumed to be twice as likely as sales of 120 million units. Merck assumes that for years 2 to 5 that the drug is on the market, the growth rate will be the same each year. The annual growth in sales will be between 5% and 15%. There is a 25% chance that the annual growth will be 7% or less, a 50% chance that it will be 9% or less, and a 75% chance that it will be 12% or less. Cash flows are discounted 15% per year, and the tax rate is 40%. Use simulation to model Mercks situation. Based on the simulation output, would you recommend that Merck continue developing? Explain your reasoning. What are the three key drivers of the projects NPV? (Hint: The way the uncertainty about the first year sales is stated suggests using the General distribution, implemented with the RISKGENERAL function. Similarly, the way the uncertainty about the annual growth rate is stated suggests using the Cumul distribution, implemented with the RISKCUMUL function. Look these functions up in @RISKs online help.)
Suppose you are borrowing 25,000 and making monthly payments with 1% interest. Show that the monthly payments should equal 556.11. The key relationships are that for any month t (Ending month t balance) = (Ending month t 1 balance) ((Monthly payment) (Month t interest)) (Month t interest) = (Beginning month t balance) (Monthly interest rate) Of course, the ending month 60 balance must equal 0.
In the financial world, there are many types of complex instruments called derivatives that derive their value from the value of an underlying asset. Consider the following simple derivative. A stocks current price is 80 per share. You purchase a derivative whose value to you becomes known a month from now. Specifically, let P be the price of the stock in a month. If P is between 75 and 85, the derivative is worth nothing to you. If P is less than 75, the derivative results in a loss of 100(75-P) dollars to you. (The factor of 100 is because many derivatives involve 100 shares.) If P is greater than 85, the derivative results in a gain of 100(P-85) dollars to you. Assume that the distribution of the change in the stock price from now to a month from now is normally distributed with mean 1 and standard deviation 8. Let EMV be the expected gain/loss from this derivative. It is a weighted average of all the possible losses and gains, weighted by their likelihoods. (Of course, any loss should be expressed as a negative number. For example, a loss of 1500 should be expressed as -1500.) Unfortunately, this is a difficult probability calculation, but EMV can be estimated by an @RISK simulation. Perform this simulation with at least 1000 iterations. What is your best estimate of EMV?
You are managing a portfolio of $1 million. Your target duration is 11 years, and you can choose from two assets: a zero coupon bond with maturity 5 years, and a perpetuity, the yield is: A. .688 B. .417 C. .583 D. .312
It is important to get the bank to grant you the loan you need. What do you think the bank will consider before granting it if it only had to focus on one thing? Of the three alternatives, which one do you consider to be the most relevant for the bank? a. sales volume b. confirming that the sum of the expected profit after taxes plus depreciation exceeds the annual repayment. c. Ensuring that profit before interest and taxes is approximately 5% of sales
A 5-year annuity of ten $5,300 semiannual paymentswill begin 9 years from now, with the first payment coming 9.5 years from now. If thediscount rate is 12 percent compounded monthly, what is the value of this annuityfive years from now? What is the value three years from now? What is the currentvalue of the annuity?
You are saving for the college education of your two children. They aretwo years apart in age; one will begin college 15 years from today and the otherwill begin 17 years from today. You estimate your children’s college expenses to be$45,000 per year per child, payable at the beginning of each school year. The annualinterest rate is 7.5 percent. How much money must you deposit in an account eachyear to fund your children’s education? Your deposits begin one year from today.You will make your last deposit when your oldest child enters college. Assume fouryears of college.
Scenario Your corporation has just approved an 8-year expansion plan to grow its market share. The plan requires an influx of cash in each of the 8 years. Management wants to develop a financial plan to ensure the cash needed for the expansion will be available at the beginning of each of the 8 years. The corporation has the following investment options: Security Price per unit Return Rate (%) Years to Maturity 1 $1,200 10.255 5 2 $1,000 6.7550 6 3 $1,175 12.110 7 Savings Account 5.500 Each unit of security 1, 2, and 3 guarantees to pay $1,000 at maturity. Investments in these securities must take place only at the beginning of year 1 and will be held until maturity. Any funds not invested in securities will be invested in a savings account that pays the annual interest rates noted above. The following table summarizes the cash needs for the expansion plan for each of the 8 years: Year 1 = $250,000 Year 5 = $295,000…
a.Use the appropriate formula to find the value of the annuity. b.Find the interest. Periodic Deposit Rate Time $6000 at the end of each year 5.5% compounded annually 20 years Click the icon to view some finance formulas. a.The value of the annuity is $_______. (Do not round until the final answer. Then round to the nearest dollar as needed.) b.The interest is $________. (Use the answer from part (a) to find this answer. Round to the nearest dollar as needed.)
Suppose you are 45 and have a $410,000 face amount, 15-year, limited-payment, participating policy (dividends will be used to build up the cash value of the policy). Your annual premium is $1,435. The cash value of the policy is expected to be $16,400 in 15 years. Using time value of money and assuming you could invest your money elsewhere for a 7 percent annual yield, calculate the net cost of insurance. Use (Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D)
9.3 Consider another set of net cash flows: Year Cash Flow ($) 0 2,000 1 2,000 2 0 3 1,500 4 2,500 5 4,000 What is the net present value of the stream if the opportunity cost of capital is 10 percent? What is the value of the stream at the end of year 5 if the cash flows are invested in an account that pays 10 percent annually? What cash flow today (time 0), in lieu of the $2,000 cash flow, would be needed to accumulate $20,000 at the end of year 5? (Assume that the cash flows for years 1 through 5 remain the same.)
You are planning to save for retirement over the next 30 years.To do this, you will invest $800 a month in a stock account and $350 a month in abond account. The return of the stock account is expected to be 11 percent, and thebond account will pay 6 percent. When you retire, you will combine your money intoan account with an 8 percent return. How much can you withdraw each month fromyour account assuming a 25-year withdrawal period?