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.)

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.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 45P: A project does not necessarily have a unique IRR. (Refer to the previous problem for more...

See similar textbooks

Similar questions

A project does not necessarily have a unique IRR. (Refer to the previous problem for more information on IRR.) Show that a project with the following cash flows has two IRRs: year 1, 20; year 2, 82; year 3, 60; year 4, 2. (Note: It can be shown that if the cash flow of a project changes sign only once, the project is guaranteed to have a unique IRR.)
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?
Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment during thecoming year depends on whether the economy has a goodor a bad year (see Table 17). It is equally likely that theeconomy will have a good or a bad year.a If Rollo is risk-neutral, how should he invest hismoney?b For $10,000, Rollo can hire a consulting firm toforecast the state of the economy. The consulting firm’sforecasts have the following properties:P(good forecast|economy good) .80P(good forecast|economy bad) .20Should Rollo hire the consulting firm? What are EVSIand EVPI? Economy EconomyHas Good Has BadYear YearYield on stocks 22% 10%Yield on bonds 16% 14%
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.
The purpose of liquidity analysis is to estimate if: A. the supply of labor will be sufficient to carry out the plan B. the supply of irrigation water will be sufficient C. cash inflows will be sufficient to meet expected cash outflows D. net farm income will be positive or negative
Your job pays you only once a year for all the work you didover the previous 12 months. Today, December 31, you just received your salaryof $65,000, and you plan to spend all of it. However, you want to start saving forretirement beginning next year. You have decided that one year from today youwill begin depositing 5 percent of your annual salary in an account that will earn10 percent per year. Your salary will increase at 4 percent per year throughout yourcareer. How much money will you have on the date of your retirement 40 years fromtoday?
Explain in some detail how the PrecisionTree calculations in Figure 6.11 for the Acme problem are exactly the same as those for the hand-drawn decision tree in Figure 6.6. In other words, explain exactly how PrecisionTree gets the monetary values in the colored cells in Figure 6.11. If your answer is negative number, enter "minus" sign. Market EMV Great ( $18 × - $ ) = $ Fair ( $18 × - $ ) = $ Awful ( $18 × - $ ) = $ Total 0.45 × __ $ + 0.35 × ___$ + 0.20 × ___ $ = ___ $
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
Aurillo Equipment Company (AEC) projected that its ROE for next year would be just 6 percent.However, the financial staff has determined that the firm can increase its ROE by refinancing somehigh interest bonds currently outstanding. The firm’s total debt will remain at $200,000 and the debtratio will hold constant at 80 percent, but the interest rate on the refinanced debt will be 10 percent.The rate on the old debt is 14 percent. Refinancing will not affect sales, which are projected to be$300,000. EBIT will be 11 percent of sales and the firm’s tax rate is 40 percent. If AEC refinances itshigh interest bonds, what will be its projected new ROE?
You have recently won the super jackpot in the WashingtonState Lottery. On reading the fine print, you discover that you have the following twooptions:a. You will receive 31 annual payments of $250,000, with the first payment beingdelivered today. The income will be taxed at a rate of 28 percent. Taxes will bewithheld when the checks are issued.b. You will receive $530,000 now, and you will not have to pay taxes on this amount.In addition, beginning one year from today, you will receive $200,000 each yearfor 30 years. The cash flows from this annuity will be taxed at 28 percent.Using a discount rate of 7 percent, which option should you select?
A. Write a document with the following information: 1. What do you expect your job to pay when you start? 2. What benefits are musts for you? 3. What benefits would you like to have even though they are not musts? 4. Include the graph you generate in step B below. B. Create a spreadsheet and a graph of life vs funds For each year of your remaining life specify the amount you plan to save/invest/withdraw that year and how much you expect that amount to increase during the year (base on actual data – typical savings interest rate, typical stock market interest rate, typical CDs, typical…). Calculate how much your funds will increase/decrease over your life and create a life (x-axis) vs funds (y-axis) plot.
You currently own 600 shares of JKL, Inc. JKL is an all-equity firm that has 75,000 shares of stock outstanding at a market price of $40 a share. The company’s earnings before interest and taxes are $140,000. JKL has decided to issue $1 million of debt at 8 percent interest. This debt will be used to repurchase shares of stock. If the cost of equity is 25%, the WACC is 16% and cost of debt is 10%, what will be the implied D/E ratio?