Dakota Hi-C Steel signed a contract that will generate revenue of $210,000 now, $226,800 in year 1, and amounts increasing by 8% per year through year 5. Calculate the future worth of the contract at an interest rate of 8% per year. Also, develop the FV function that will correctly determine F for revenues placed in cells B2 through B7.

Dakota Hi-C Steel signed a contract that will generate revenue of $210,000 now, $226,800 in year 1, and amounts increasing by 8% per year through year 5. Calculate the future worth of the contract at an interest rate of 8% per year. Also, develop the FV function that will correctly determine F for revenues placed in cells B2 through B7.

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter9: Capital Budgeting Techniques

Section: Chapter Questions

Problem 12PROB

See similar textbooks

Similar questions

Consolidated Aluminum is considering the purchase of a new machine that will cost $308,000 and provide the following cash flows over the next five years: $88,000, 92,000, $91,000, $72,000, and $71,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel, see Appendix C.
Caduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.
Mason, Inc., is considering the purchase of a patent that has a cost of $85000 and an estimated revenue producing lite of 4 years. Mason has a required rate of return that is 12% and a cost of capital of 11%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the following cash flows over the next five years: $99,000, $88,000, $92,000. $87,000, and $72,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel. see Appendix C.
Falkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated revenue producing life of 4 years. Falkland has a cost of capital of 8%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Manzer Enterprises is considering two independent investments: A new automated materials handling system that costs 900,000 and will produce net cash inflows of 300,000 at the end of each year for the next four years. A computer-aided manufacturing system that costs 775,000 and will produce labor savings of 400,000 and 500,000 at the end of the first year and second year, respectively. Manzer has a cost of capital of 8 percent. Required: 1. Calculate the IRR for the first investment and determine if it is acceptable or not. 2. Calculate the IRR of the second investment and comment on its acceptability. Use 12 percent as the first guess. 3. What if the cash flows for the first investment are 250,000 instead of 300,000?
Redbird Company is considering a project with an initial investment of $265,000 in new equipment that will yield annual net cash flows of $45,800 each year over its seven-year life. The companys minimum required rate of return is 8%. What is the internal rate of return? Should Redbird accept the project based on IRR?
A restaurant is considering the purchase of new tables and chairs for their dining room with an initial investment cost of $515,000, and the restaurant expects an annual net cash flow of $103,000 per year. What is the payback period?
The Rodriguez Company is considering an average-risk investment in a mineral water spring project that has an initial after-tax cost of 170,000. The project will produce 1,000 cases of mineral water per year indefinitely, starting at Year 1. The Year-1 sales price will be 138 per case, and the Year-1 cost per case will be 105. The firm is taxed at a rate of 25%. Both prices and costs are expected to rise after Year 1 at a rate of 6% per year due to inflation. The firm uses only equity, and it has a cost of capital of 15%. Assume that cash flows consist only of after-tax profits because the spring has an indefinite life and will not be depreciated. a. What is the present value of future cash flows? (Hint: The project is a growing perpetuity, so you must use the constant growth formula to find its NPV.) What is the NPV? b. Suppose that the company had forgotten to include future inflation. What would they have incorrectly calculated as the projects NPV?
On March 1, 2019, Elkhart enters into a new contract to build a specialized warehouse for 7 million. The promise to transfer the warehouse is determined to be a performance obligation. The contract states that if the warehouse is usable by November 30, 2019, Elkhart will receive a bonus of 600,000. For every week after November 30 that the warehouse is not usable, the bonus will decrease by 150,000. Elkhart provides the following completion schedule: Required: 1. Assume that Elkhart uses the expected value approach. What amount should Elkhart use for the transaction price? 2. Assume that Elkhart uses the most likely amount approach. What amount should Elkhart use for the transaction price? 3. Next Level What is the purpose of assessing whether a constraint on the variable consideration exists?
XYZ is evaluating a project that would require the purchase of a piece of equipment for $440,000 today. During year 1, the project is expected to have relevant revenue of $786,000, relevant costs of $201,000, and relevant depreciation of $132,000. XYZ would need to borrow $440,000 today to pay for the equipment and would need to make an interest payment of $33,000 to the bank in 1 year. Relevant net income for the project in year 1 is expected to be $337,000. What is the tax rate expected to be in year 1? A rate equal to or greater than 21.96% but less than 26.61% A rate less than 21.96% or a rate greater than 46.34% A rate equal to or greater than 31.02% but less than 38.39% A rate equal to or greater than 38.39% but less than 46.34% A rate equal to or greater than 26.61% but less than 31.02%
A build-to-operate (BTO) company signed a contract to operate Alamosa County industrial wastewater treatment plants for the next 20 years. The contract will pay the company $2.5 million now and amounts increasing by $200,000 each year through year 20. At an interest rate of 10% per year, what is the present worth now? Solve using (a) tabulated factors, and (b) a spreadsheet