❖ Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 8.5%. The study period needs to be exactly 5 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 = 8.5%. The study period needs to be exactly 5 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

Free Cash Flow Valuation Dozier Corporation is a fast-growing supplier of office products. Analysts project the following free cash flows (FCFs) during the next 3 years, after which FCF is expected to grow at a constant 7% rate. Dozier’s weighted average cost of capital is WACC = 13%. What is Dozier’s horizon value? (Hint: Find the value of all free cash flows beyond Year 3 discounted back to Year 3.) What is the current value of operations for Dozier? Suppose Dozier has $10 million in marketable securities, $100 million in debt, and 10 million shares of stock. What is the intrinsic price per share?
Fenton, Inc., has established a new strategic plan that calls for new capital investment. The company has a 9.8% required rate of return and an 8.3% cost of capital. Fenton currently has a return of 10% on its other investments. The proposed new investments have equal annual cash inflows expected. Management used a screening procedure of calculating a payback period for potential investments and annual cash flows, and the IRR for the 7 possible investments are displayed in image. Each investment has a 6-year expected useful life and no salvage value. A. Identify which project(s) is/are unacceptable and briefly state the conceptual justification as to why each of your choices is unacceptable. B. Assume Fenton has $330,000 available to spend. Which remaining projects should Fenton invest in and in what order? C. If Fenton was not limited to a spending amount, should they invest in all of the projects given the company is evaluated using return on investment?
Buena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a net cash inflow one year from now of 810,000. Assume the cost of capital is 10 percent. Required: 1. Break the 810,000 future cash inflow into three components: a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. 3. Compute the NPV of the investment. Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV?
Assume that an investment of 100,000 produces a net cash flow of 60,000 per year for two years. The discount factor for year 1 is 0.89 and for year 2 is 0.80. The NPV is a. 0 b. 6,800 c. 1,400 d. (4,000)
Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?
Assume a company is going to make an investment of $450,000 in a machine and the following are the cash flows that two different products would bring in years one through four. Which of the two options would you choose based on the payback method?
Optimal Cash Transfer Barenbaum Industries projects that cash outlays of 4.5 million will occur uniformly throughout the year. Barenbaum plans to meet its cash requirements by periodically selling marketable securities from its portfolio. The firms marketable securities are invested to earn 12%, and the cost per transaction of converting securities to cash is 27. a. Use the Baumol model to determine the optimal transaction size for transfers from marketable securities to cash. b. What will be Barenbaums average cash balance? c. How many transfers per year will be required? d. What will be Barenbaums total annual cost of maintaining cash balances? What would the total cost be if the company maintained an average cash balance of 50,000 or of 0 (it deposits funds daily to meet cash requirements)?
Asap Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 5.5%. The study period needs to be exactly 8 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).
show all excel formulas/ work answering the following: Present Value: Multiple Cash Flows You are considering an investment that will pay you $1,000 in one year, $2,000 in two years and $3,000 in three years. If you want to earn 10% on your money, how much would you be willing to pay?
ENGINEERING ECONOMY - draw a cash flow diagram 1.) A cash flow sequence starts in year 1 at $5,000 and increases by $200 each year through year 10. Determine the present worth of the sequence. Use an interest rate of 10%. 2.) The future worth in year 8 of an arithmetic gradient cash flow series for years 1 through 8 is $500,000. If the gradient increase each year is $5,000, determine the cash flow in year 1 at an interest rate of 10% per year.
This problem is useful for testing the ability of financial calculators or excel. Consider the following cash flows. How many different IRRs are there (Hint: search between 20 percent and 70 percent)? When should we take this project?( u can use Excel) Year Cash Flow 0 -$3,024 1 17,172 2 -36,420 3 34,200 4 -12,000