Explore BrainMass
Share

Nominal & Discounted Payback, Net Present Value, IRR

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

See the attachment for tables.

1. A company has $300,000 in a bank account established for Capital Investments. This account pays 4% interest, compounded annually. A member of the finance department has approached you with an investment opportunity for the $300,000 that covers a five-year period and has the following projected after-tax cash flows:

Based on this information, answer the following questions:

1) How much money will be in the bank account if you leave the $300,000 alone (earning 4% compounded interest) until you need it in five years?

2) If you undertake the investment opportunity, what is the Nominal Payback Period?

3) Using the Present Value factors for 7% (which can be found on any PV Factor table), what is the discounted Payback Period of the investment opportunity?

4) What is the Net Present Value at 7% of the investment opportunity?

5) Which option (make the investment or leave the money in a savings account) would you recommend to your CEO? Why? What additional factors/information might make you change your point of view?

2. The CEO of a company was at a conference and talked to a supplier about a new piece of equipment for its production process that she believes will produce ongoing cost savings. As the Operations Manager, your CEO has asked for your perspective on whether or not to purchase the machinery.
After talking to the supplier and meeting with your Engineers and Financial Analysts, you've gathered the following pieces of data:
• Cost of Machine: $140,000
• Estimated Annual After Tax Cash Flow Savings: $60,000 (which may or may not grow)
• Estimated machinery life: 3-5 years (after which there will be zero value for the equipment and no further cost savings)
• You seem to recall that Dynamic's Finance organization recommends either a 10% or a 15% discount rate for all Cost Savings Projects

Calculate the Nominal Payback, the Discounted Payback, the Net Present Value and the IRR for each
scenario, assuming:
A. Person (A) recommends using the base assumptions above: 3 year project life, flat annual savings, 10% discount rate.
B. Person (B) recommends savings that grow each year: 3 year project life, 10% discount rate and a 10% compounded annual savings growth in years 2 & 3. In other words, instead of assuming savings stay flat, assume that they will grow by 10% in year 2, and then grow another 10% over year 3 in year.
C. Person (C) believes we use a higher Discount Rate because of the risk of this type of project: 3 year project life, flat annual savings, 15% discount rate.
D. Person (D) is convinced the machine will last longer than 3 years. He recommends using a 5 Year Equipment Life: 5 year project and savings life, flat annual savings, 10% discount rate. In other words, assume that the machine will last 2 more years and deliver 2 more years of savings.

1) Which person's scenario would you present to management and why? From a strictly financial (numbers) perspective, would you recommend this purchase to management?
2) In your opinion, which person's scenario is based on the most aggressive assumptions? If you were to select this scenario as the basis for your proposal, how would you justify the more aggressive assumptions?
3) In SIMPLE English (as in talking to a non-Finance and non-MBA person), explain why there is value to management in running all 4 of these scenarios.
4) Beyond financial measures, what other factors would you want to consider, before making a recommendation to management?
5) If you were the CEO, would you approve this proposal? Why or why not?

3. The general manager is looking to do a buy out of a smaller firm.
With help from your finance leader, you have estimated the following benefit streams for this new division:

• You estimate that the purchase price for this firm would be $200,000 and that additional net working capital would be needed in the amount of $60,000 in year 0, an additional $15,000 in year 2 and then
$15,000 in year 5.
• Your company usually spends about $275,000 per year in advertising. If you make this acquisition, you would ask that advertising spending be increased by an incremental one-time amount of $45,000 in year 0 to publicize the firm's expansion.
• Your finance leader has indicated that the firm has access to a credit line and could borrow the funds at a rate of 6%. He also mentions that when he runs project economics for capital budgeting (such as a new copier or a company car), he recommends a standard 10% rate discount, but the one other time they looked at an acquisition of a smaller firm, he used a 13% rate discount. Obviously you will want to select the most appropriate discount rate for this type of project.
• At the end of 8 years, the plan is to sell this division. The estimated terminal value (the sale and the return of working capital) is conservatively estimated to be $350,000 of after-tax cash flow help.

Using the data that you need (and ignoring the extraneous information), for this potential acquisition, calculate each of the following items:
o the Nominal Payback
o the Discounted Payback
o the Net Present Value
o the IRR

1) From a purely financial (numbers) perspective, would you recommend this purchase to management? Why?
2) What are some of the non-financial elements that need to be considered for this proposal?
3) Assumptions in project economics can have a huge impact on the result. Identify 3 financial elements/assumptions in your analysis that would make this project financially unattractive? In other words, what would have to be true for this to be a bad investment?
4) If you were the CEO, would you approve this proposal? Why or why not?

© BrainMass Inc. brainmass.com March 22, 2019, 3:46 am ad1c9bdddf
https://brainmass.com/business/net-present-value/nominal-discounted-payback-net-present-value-irr-643383

Attachments

Solution Preview

NOTE: The attached file also contains the answers.

1. company has $300,000 in a bank account established for Capital Investments. This account pays 4% interest, compounded annually. A member of the finance department has approached you with an investment opportunity for the $300,000 that covers a five-year period and has the following projected after-tax cash flows:

Year Projected Cash Flow

1
$90,000

2
$115,000

3
$135,000

4
$110,000

5
$90,000

Based on this information, answer the following questions:

1) How much money will be in the bank account if you leave the $300,000 alone (earning 4% compounded interest) until you need it in five years?
F = (F/P) ( 4%, 5) x $300,000 = 1.21665 x 300,000 = $364,996.

2) If you undertake the investment opportunity, what is the Nominal Payback Period?
Payback period is number of years to break even with the initial investment of $300,000.
Receipts of years 1 and 2 sum to $90,000 + 115,000 = $205,000 leaving a short fall of $95,000 which will come from year 3.
If all 3 years' receipts are added, sum = $340,000. So, crudely speaking , the payback period is 3 years. However, since only $95,000 is missing and year 3 receipts are $135,000 and if receipts are proportional to time, then it will take 95/135 of a year to earn the $95,000 needed after 2 years. That is about 0.70 years or about 8 months. So, to be mathematically accurate, the payback period is 2 years and 8 months.

3) Using the Present Value factors for 7% (which can be found on any PV Factor table), what is the discounted Payback Period of the investment opportunity?

For the discounted payback period, all cash flows will have to be discounted or brought to their present using an annual interest rate of 7%. The payback period occurs in that year when the sum of the discounted or present values add up to $300,000. (Note that the payback period is that when NPV = 0).
The discounted values of the receipts of years 1, 2, 3, 4, 5 are:

84,112
100,441
110,201
83,919
64,170

From this we see that the sum of the PV of the first 3 years sum to $294,754. That leaves $5,246 to come from year 4. If year 4's income is added, the sum of the discounted values of all 4 years will be $378,673. So the answer could be 4 years although it will takes only 22 day of year 4 to earn $5,246. Again, mathematically speaking the payback period with discounted values will be 3 years and 22 days.

4) What is the Net Present Value at 7% of the investment opportunity?

NPV = -Initial investment + Sum of all PV of income from years 1-5.
= -$300,000 + $ 442,843 = $142,843

5) Which option (make the investment or leave the money in a savings account) would you recommend to your CEO? Why? What additional factors/information might make you change your point of view?
If the investor's required return is 7%, the NPV of the investment is $142,843
The PV at 7 % of the $364,996 in the bank account is $260,237.
Its NPV is -$39,763
Clearly investing at 7% is better than leaving the money in a bank account.

2. The CEO of a company was at a conference and talked to a supplier about a new piece of equipment for its production process that she believes will produce ongoing cost savings. As the Operations Manager, your CEO has asked for your perspective on whether or not to purchase the machinery.
After talking to the supplier and meeting with your Engineers and ...

Solution Summary

CFOs often must decide on whether to accept or reject a project. They compare the various projects' IRR, NPV, Payback periods as well the risk associated with each to select the "best". In the end all financial managers analyze the trade-offs involving return, risk, IRR as well as payback.

$2.19