A firm has the opportunity to make a capital investment with the expectation that the investment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A firm has the opportunity to make a capital investment with the expectation that the investment will add economic value to the firm, increase customer satisfaction, and increase shareholder return. The investment is for a new supply chain inventory system, using state of the art 5G technologies and tracking capabilities. This system was recently developed and very few of your industry competitors are currently using it. To complete this case you will use Excel to format and solve a capital budget problem. Then you will answer a series of questions based on your calculations. Finally, you'll prepare a analysis of the project using both derived data and qualitative factors. The data for the project is as follows: Year 1 2 345 69 8 9 10 Current cost of capital: Initial investment Project life Cash inflows $600,000 $1,000,000 $1,000,000 $2,000,000 $3,000,000 $3,500,000 $4,000,000 $6,000,000 $8,000,000 $12,000,000 13% $15,000,000 10 years For the case analysis, you are to: 1. Create an Excel spreadsheet to format and solve for each of the capital budget calculations. a. All calculations are to be completed using Excel formulas b. Format all dollar values w/ corresponding currency symbol c. Use whole dollar amounts, so no decimal or cents figures 2. Answer all budget questions thoroughly. Prepare the narrative in Word or similar program, and cut and paste the narrative into the Excel spreadsheet. Please note: do not type the narrative answers directly into the spreadsheet cells. Capital budget questions: 1. Calculate the project's net present value. Is the project acceptable under the NPV decision-rule? Explain. 2. Calculate the project's internal rate of return. Is the project acceptable under the IRR decision- rule? Explain. 3. Compare the NPV and IRR result for this investment. Given the result, is the project favorable and meet the economic considerations of the firm? Is there typically a preference between the NPV and IRR techniques? Explain. 4. Calculate the payback period for the project. If the firm accepts projects with payback at 7 years or less, is the project acceptable? Capital Budget Analysis As the finance manager, the capital budget numerical analysis provides a quantitative decision-rule for the project. Discuss in detail two qualitative factors and considerations related to this investment that the firm should consider in addition to the quantitative and economic aspects of the project. Support your narrative analysis with information from the text and any other sources. Identify the sources used to support your analysis. A firm has the opportunity to make a capital investment with the expectation that the investment will add economic value to the firm, increase customer satisfaction, and increase shareholder return. The investment is for a new supply chain inventory system, using state of the art 5G technologies and tracking capabilities. This system was recently developed and very few of your industry competitors are currently using it. To complete this case you will use Excel to format and solve a capital budget problem. Then you will answer a series of questions based on your calculations. Finally, you'll prepare a analysis of the project using both derived data and qualitative factors. The data for the project is as follows: Year 1 2 345 69 8 9 10 Current cost of capital: Initial investment Project life Cash inflows $600,000 $1,000,000 $1,000,000 $2,000,000 $3,000,000 $3,500,000 $4,000,000 $6,000,000 $8,000,000 $12,000,000 13% $15,000,000 10 years For the case analysis, you are to: 1. Create an Excel spreadsheet to format and solve for each of the capital budget calculations. a. All calculations are to be completed using Excel formulas b. Format all dollar values w/ corresponding currency symbol c. Use whole dollar amounts, so no decimal or cents figures 2. Answer all budget questions thoroughly. Prepare the narrative in Word or similar program, and cut and paste the narrative into the Excel spreadsheet. Please note: do not type the narrative answers directly into the spreadsheet cells. Capital budget questions: 1. Calculate the project's net present value. Is the project acceptable under the NPV decision-rule? Explain. 2. Calculate the project's internal rate of return. Is the project acceptable under the IRR decision- rule? Explain. 3. Compare the NPV and IRR result for this investment. Given the result, is the project favorable and meet the economic considerations of the firm? Is there typically a preference between the NPV and IRR techniques? Explain. 4. Calculate the payback period for the project. If the firm accepts projects with payback at 7 years or less, is the project acceptable? Capital Budget Analysis As the finance manager, the capital budget numerical analysis provides a quantitative decision-rule for the project. Discuss in detail two qualitative factors and considerations related to this investment that the firm should consider in addition to the quantitative and economic aspects of the project. Support your narrative analysis with information from the text and any other sources. Identify the sources used to support your analysis.
Expert Answer:
Related Book For
South-Western Federal Taxation 2018 Comprehensive
ISBN: 9781337386005
41st Edition
Authors: David M. Maloney, William H. Hoffman, Jr., William A. Raabe, James C. Young
Posted Date:
Students also viewed these finance questions
-
Since Ryanair DAC's2 emergence as an upstart challenger to the Aer Lingus Ltd.-British Airways plc duopoly in the late 1980s, it had been both a consumer champion and antagonist; a technological...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
In a survey of 1,002 people, 701 (or 70%) said that they voted in the last presidential election (based on data from ICR Research Group). The margin of error was 3 percentage points. However, actual...
-
Find three examples of ions in the periodic table that have an electron configuration of nd8 (n = 3, 4, 5...).
-
A shoe manufacturer with a marginal cost of capital of 7% is evaluating new equipment that would custom fit athletic shoes. The new equipment costs $90,000 and will generate $35,000 in net cash flows...
-
What is the difference between null and alternative hypothesis?
-
Elijah Inc. produces accent stripes for automobiles in 50-inch rolls. Each roll passes through three departments (Striping, Adhesion, and Packaging) before it is ready for shipment to customers....
-
What are the FASB codifications regarding auction rate securities, collateralized debt obligations, fixed-for-float OTC gas swap, and auction rate securities?
-
Two-period Model Consider the two-period model. The households receive exogenous income y in the first period and y' in the second period. Remember that N is the number of households. The government...
-
Explain the concept of demand-pull inflation.
-
Explain three possible causes of a decrease in the SRAS curve.
-
Distinguish between equity and equality.
-
A university professor who has conducted research for many years submitted a grant to the NIH to request funding to integrate a Spanish-language video about hospice care in the discharge planning...
-
Explain what determines the equilibrium nominal interest rate.
-
Hammurabi's Code is not the oldest known legal code, but it is the oldest that is nearly complete. Hammurabi was the sixth Babylonian king. The code was written in Akkadian using the cuneiform script...
-
Write a paper detailing a geographic information system (GIS) of your own design that would utilize data in an original manner.
-
In the research on leader behaviors, which style of leadership describes the preferred high-high combination? (a) transformational (b) transactional (c) laissez-faire (d) democratic
-
When managers use offers of rewards and threats of punishments to try to get others to do what they want them to do, they are using which type of power? (a) formal authority (b) position (c) referent...
-
In terms of leadership behaviors, someone who focuses on doing a very good job of planning work tasks, setting performance standards, and monitoring results would be described as _________. (a) task...
Study smarter with the SolutionInn App