NPV Calculations Output You are a program manager for the procurement function of a global company....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
NPV Calculations Output You are a program manager for the procurement function of a global company. You are building a case for a new training program that will net financial benefits as well as improve departmental morale. Cash flows include: inflow in years 2020, 2021, 2023, 2025, 2027, 2028, and 2030 of $15k, $19k, $38k, $190k, $507k, $1.45M, and $5.29M respectively; initial outflow of $2M at the beginning of 2018 followed by $450k in 2022, $130k in 2026, and $90k in 2029. The hurdle rate is 9% and inflation is expected to average 2.25% per year. Ignoring competing projects, should this project be funded? Hurdle Rate/ROI/IRR: Estimated inflation: Year A 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total Inflow B Outflow Net Flow с (B-C) Discount Factor 1/(1+k+ p)t 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 NPV D* E '' 1 You subsequently argue that turnover reduction has not been accounted for. Your Director agrees and includes a $25k/yr savings beginning in 2019. Should this project now be funded? Hurdle Rate/ROI/IRR: Estimated inflation: Year A 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total Inflow B Savings B.1 Outflow с Net Flow (B + B.1-C) 1 I 1 Discount Factor 1/(1+k+p)t 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 NPV D* E 1 1 L I NPV Calculations Output You are a program manager for the procurement function of a global company. You are building a case for a new training program that will net financial benefits as well as improve departmental morale. Cash flows include: inflow in years 2020, 2021, 2023, 2025, 2027, 2028, and 2030 of $15k, $19k, $38k, $190k, $507k, $1.45M, and $5.29M respectively; initial outflow of $2M at the beginning of 2018 followed by $450k in 2022, $130k in 2026, and $90k in 2029. The hurdle rate is 9% and inflation is expected to average 2.25% per year. Ignoring competing projects, should this project be funded? Hurdle Rate/ROI/IRR: Estimated inflation: Year A 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total Inflow B Outflow Net Flow с (B-C) Discount Factor 1/(1+k+ p)t 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 NPV D* E '' 1 You subsequently argue that turnover reduction has not been accounted for. Your Director agrees and includes a $25k/yr savings beginning in 2019. Should this project now be funded? Hurdle Rate/ROI/IRR: Estimated inflation: Year A 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total Inflow B Savings B.1 Outflow с Net Flow (B + B.1-C) 1 I 1 Discount Factor 1/(1+k+p)t 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 NPV D* E 1 1 L I
Expert Answer:
Answer rating: 100% (QA)
First cost of capital is calculated based on given Hurdle rate exp... View the full answer
Related Book For
Managerial Accounting Creating Value in a Dynamic Business Environment
ISBN: 978-0078025662
10th edition
Authors: Ronald Hilton, David Platt
Posted Date:
Students also viewed these accounting questions
-
Cincinnati Cylinder Company began operations on January 1 to produce pneumatic cylinders used in a variety of machines. It used an absorption costing system with a planned production volume of...
-
The Holiday Corporation, a private company, began operations on January I, 2011. During its first three years of operations, Holiday reported net income and declared dividends as follows: The...
-
Yellowstone Company began operations on January 1 to produce a single product. It used an absorption costing system with a planned production volume of 100,000 units. During its first year of...
-
What is the leading cause of death among people with HIV / AIDS in Africa?
-
Describe how following tools would be used by a company hosting a web site:
-
Find the energy stored in the hemispherical region r < 2 m, 0 < < , where E = 2r sin cos ar + r cos cos a r sin a V/m exists.
-
A stream of water from the faucet strikes the bottom of the sink. Estimate the maximum acceleration experienced by the water particles. List all assumptions and show calculations.
-
High-low method and regression analysis. Happy Business College has recently opened a restaurant as part of its hospitality major. For the first 10 weeks the manager did not estimate any costs, but...
-
An arrow is shot from a height of 1.95 m toward a cliff of height H . It is shot with a velocity of 25 m/s at an angle of 60 above the horizontal. It lands on the top edge of the cliff 3.67 s later....
-
A blue ball is thrown upward with an initial speed of 23 m/s, from a height of 0.6 meters above the ground. 2.8 seconds after the blue ball is thrown, a red ball is thrown down with an initial speed...
-
provide instructions on how to solve this on Profile app. Please provide step-by-step guidance Mr. Slim Trim (SIN 527-000-061) is a married, Accountant living in Markham, Ontario. His wife, Mrs....
-
What information can we obtain from linear or planar strain markers?
-
The analysis accompanying Figure 23.3 investigates the impacts of an increase in cigarette prices. Use the fi gure to show both the short-run and the long-run impacts of a cigarette price decrease....
-
Many economists feel that markets are effi cient unless characteristics are present that lead to market failure. What sorts of market failure in the health economy can be used to justify adoption of...
-
Why do joints typically first form in the stiffest layers?
-
What physical factors control the state of stress in a rock that is being uplifted through the upper crust?
-
Please find an organisation online to use as a reference. Find one (1) insurance product your company offers, briefly summarise the role of the following terms: '-"Standard cover and deviations...
-
In the busy port of Chennai, India, the number of containers loaded onto ships during a 15-week period is as follows: 1. Develop a linear trend equation to forecast container loadings. 2. Using the...
-
Fiber Technology, Inc., manufactures glass fibers used in the communications industry. The companys materials and parts manager is currently revising the inventory policy for XL-20, one of the...
-
Huron Chalk Company manufactures sidewalk chalk which it sells online by the box at $25 per unit. Huron uses an actual costing system, which means that the actual costs of direct material, direct...
-
EduSoft Corporations president, Mark Fletcher, was looking forward to seeing the performance reports for October because he knew the companys sales for the month had exceeded budget by a considerable...
-
Someone who exposes the ethical misdeeds of others in an organization is usually called a/an _________. (a) whistleblower (b) ethics advocate (c) ombudsman (d) stakeholder
-
If a manager fails to enforce a late-to-work policy for all workersthat is, by allowing some favored employees to arrive late without penaltiesthis would be considered a violation of _________. (a)...
-
According to research on ethics in the workplace, _________ is/are often a major and frequent source of pressures that create ethical dilemmas for people in their jobs. (a) declining morals in...
Study smarter with the SolutionInn App