* Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 12%. The study period needs to be exactly 9 years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years. Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).

* Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 12%. The study period needs to be exactly 9 years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years. Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter7: Corporate Valuation And Stock Valuation

Section: Chapter Questions

Problem 25SP: Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site....

See similar textbooks

Similar questions

Q. 2 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 12%. The study period needs to be exactly 2 years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years. Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram).
Complete the following 6 Wk 3 Financial Exercises: Problem Set 1, Part 2 problems: 1. Calculate the net present value (NPV) of the following cash flow stream if the required rate is 12%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 2. Calculate the NPV of the following cash flow projections based on a required rate of 10.5%: Insert your NPV calculation. Year Cash Flow Is this a good project for the business to accept? Explain why or why not. Insert your answer. 3. A company needs to decide if it will move forward with 2 new products that it is evaluating. The 2 initiatives have the following cash flow projections: Project A Project B Year Cash Flow Year Cash Flow Based on the risk of each project, the company has a required rate of return of 11% for Project A and 11.5% for Project B. The company has a $1.5 million budget to spend on new projects for the year. Should the company move forward…
Problem #2: Consider an investment where the cash flows are: - $920.33 at time 1 = 0 (negative since this is your initial investment) S407 at time = 1 in years $222 at time = 2 in years $426 at time = 3 in years (a) Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below. (b) What is the value of IRR found by Solver?
Consider an investment where the cash flows are: – $946.21 at time t = 0 (negative since this is your initial investment) $377 at time t = 1 in years $204 at time t = 2 in years $499 at time t = 3 in years (a) Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below. (b) What is the value of IRR found by Solver?
Calculate the internal rates of return of the following investment: Net investment -$1,000 Year 0 Net cash flows +6,000 Year 1 -11,000 Year 2 +6,000 Year 3 Round your answers to the nearest whole number and enter them in ascending order. IRR1: % IRR2: % IRR3: %
Damien offers you a sequence of end-of-year cash flows for an investment as follows: Year 1 2 3 4 4 What is the value of the cash flows if the opportunity cost is 6 percent? (Round to the nearest dollar). Please click on the following link to access a blank worksheet Click to open:: O $8.392 $8.598 Cash Flow $4,000 $3,000 $2,000 $1,000 $8.734 $8.915
QI. KNOWLEDGE AND UNDERSTANDING DRAWING CASH FLOW DIAGRAM Draw the ww m mm cash flow diagram for the following : 1. Assume that you want to deposit an amount (BD120,000.00) into an account three years from now in order to be able to withdraw BD750 per year for ten years starting four years from now. Assume that the interest rate is 4.5% per year. Construct the cash flow diagram. 2. Suppose that you want to make a deposit into your account now such that you can withdraw an equal amount (A1) of BD300 per year for the first five years starting one year after your deposit and a different annual amount (A2) of BD600 per year for the following three years. With an interest rate (i) of 5.5% per year, construct the cash flow diagram. 3. If you deposit BD1,500 now, BD3,600 three years, BD2000 seven years, and BD1,800 nine years from now in a savings account that pays 10% interest, how much would you have at the end of year 25? Construct the cash flow diagram.
2. Consider the following cash flow for an investment. Year Cash Flow -80 1 -30 -20 3 +150 Determine by graphical method the rate of return on this cash flow. Try i = 2% and i= 10%
NPV profile of a project. Given the following cash flow of Project L-2, draw the NPV profile. Hint: Be sure to use a discount rate of zero for one intercept (y-axis) and solve for the IRR for the other intercept (x-axis). (Click on the following icon in order to copy its contents into a spreadsheet.) Year 0 = - $300,000 Year 1= $42,000 Year 2 = $77,000 Year 3 = $111,000 Year 4 = $140,000 What is the NPV of Project L-2 where zero is the discount rate? $ 70000.00 (Round to the nearest dollar.) What is the IRR of Project L-2? % (Round to two decimal places.)
Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site. Selected data for the Derby Corporation are shown here. Use the data to answer the following questions. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. Calculate the estimated Year-0 price per share of common equity.
Reset the Data Section of the CAPBUD2 worksheet to the original values. In requirement 4, you assessed the sensitivity of the investment’s internal rate of return to changes in some of the input data. This was done in a trial-and-error fashion. Click the Chart sheet tab. Presented on the screen is a graphical analysis of the sensitivity of the internal rate of return to changes in annual cash flows. To demonstrate the usefulness of such a chart, note the ease with which you are able to answer the following questions that might be of interest to the owner: What annual cash flow (approximately) is required to: earn 0% rate of return? _______________ earn 10% rate of return? _______________ earn over 20% rate of return? _______________ Approximately, how much is the rate of return reduced for each drop of $10,000 annual cash flow? When the assignment is complete, close the file without saving it again. Worksheet. The CAPBUD2 worksheet handles only cash inflows that are even in amount each year. Many capital projects generate uneven cash inflows. Suppose that the new store had expected cash earnings of $80,000 per year for the first two years, $140,000 for the next four years, and $220,000 for the last four years. The new store will generate the same total cash return ($1,600,000) as in the original problem, but the timing of the cash flows is different. Alter the CAPBUD2 worksheet so that the NPV and IRR calculations can be made whether there are even or uneven cash flows. When done, preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as CAPBUDT. Hint: One suggestion is to label column F in the scratch pad as Uneven cash flows. Enter the uneven cash flows for each year. Modify FORMULA3 to include these cash flows. Modify the formulas in the range E30 to E39 to include the new data. Then set cell E10 (estimated Annual Net Cash Inflow) to zero. When you have even cash flows, use cell E10 and set column F in the scratch pad to zeros. If you have uneven cash flows, set cell E10 to zero and fill in column F in the scratch pad. Note that this solution causes garbage to come out in cells E15 and E16 because those formulas were not altered. Check figure for uneven cash flows: NPV (cell E17), $68,674. Chart. Using the CAPBUD2 file, develop a chart just like the one used in requirement 6 to show the sensitivity of net present value to changes in cost of the investment amount from $440,000 to $500,000 (use $10,000 increments). Complete the Chart Tickler Data Table and use it as a basis for preparing the chart. Enter your name somewhere on the chart. Save the file again as CAPBUD2. Print the chart.
NPV profile of a project. Given the following cash flow of Project L-2, draw the NPV profile. Hint. Be sure to use a discount rate of zero for one intercept (y-axis) and solve for the IRR for the other intercept ( x-axis). (Click on the following icon ◻ in order to copy its contents into a spreadsheet.) Year 0=-$300,000 Year 1=$50,000 Year 2=$79,000 Year 3=$118,000 Year 4=$130,000 What is the NPV of Project L-2 where zero is the discount rate? $ (Round to the nearest dollar.) What is the IRR of Project L-2? % (Round to two decimal places.) Which of the graphs below best fits the NPV profile of the project? Click on the magnifying glass icon to see an enlarged version of each graph. (Select the best response.) B. D.