Please include the excel spreadsheet or the math behindeach solution. Thanks
The CEO of Dynamic Manufacturing was at a conference and talkedto a supplier about a new piece of
equipment for its production process that she believes willproduce ongoing cost savings. As the
Operations Manager, your CEO has asked for your perspective onwhether or not to purchase the
machinery.
After talking to the supplier and meeting with your Engineersand Financial Analysts, youâve gathered the
following pieces of data:
⢠Cost of Machine: $150,000
⢠Estimated Annual After Tax Savings: $65,000
⢠Estimated machinery life: 3 years (after which there will bezero value for the equipment and no
further cost savings)
⢠You seem to recall that Dynamicâs Finance organizationrecommends either a 10% or a 15%
discount rate for all Cost Savings Projects. You are fairly sureit is 10%.
You understand that you need to understand the projectfinancials to ensure that
this investment will be economically attractive to DynamicManufacturingâs shareholders.
Calculate the Nominal Payback, the Discounted Payback, the NetPresent Value and the IRR
assuming:
⢠Part A, BASE CASE: 3 year project life, flat annual savings,10% discount rate
⢠Part B. Saving Growth Scenario: BASE CASE but with 10%compounded annual savings growth
in years 2 & 3.
⢠Part C, Higher Discount Rate Scenario: 3 year project life,flat annual savings, 15% discount rate
⢠Part D, 5 Year Equipment Life:5 year project and savings life,flat annual savings, 10% discount
rate
Discussion â in a Word Document in paragraph form, respond tothe following:
1) From a Financial perspective, would you recommend thispurchase to Management? Which
scenario would you present and why?
2) In your opinion, which scenario is the most aggressive (i.eis based on the most aggressive
assumptions)? If you were to select this scenario as the basisfor your proposal, how would you
justify the more aggressive assumptions?
3) In SIMPLE English (as in talking to a non-Finance and non-MBAperson), explain why there was
a difference in outcome between Part A and Part B.
4) Beyond Financial measures, what other considerations wouldyou want to consider, before
making a recommendation to Management?
5) If you were the CEO, would you approve this proposal? Why orwhy not?
Please include the excel spreadsheet or the math behindeach solution. Thanks
The CEO of Dynamic Manufacturing was at a conference and talkedto a supplier about a new piece of
equipment for its production process that she believes willproduce ongoing cost savings. As the
Operations Manager, your CEO has asked for your perspective onwhether or not to purchase the
machinery.
After talking to the supplier and meeting with your Engineersand Financial Analysts, youâve gathered the
following pieces of data:
⢠Cost of Machine: $150,000
⢠Estimated Annual After Tax Savings: $65,000
⢠Estimated machinery life: 3 years (after which there will bezero value for the equipment and no
further cost savings)
⢠You seem to recall that Dynamicâs Finance organizationrecommends either a 10% or a 15%
discount rate for all Cost Savings Projects. You are fairly sureit is 10%.
You understand that you need to understand the projectfinancials to ensure that
this investment will be economically attractive to DynamicManufacturingâs shareholders.
Calculate the Nominal Payback, the Discounted Payback, the NetPresent Value and the IRR
assuming:
⢠Part A, BASE CASE: 3 year project life, flat annual savings,10% discount rate
⢠Part B. Saving Growth Scenario: BASE CASE but with 10%compounded annual savings growth
in years 2 & 3.
⢠Part C, Higher Discount Rate Scenario: 3 year project life,flat annual savings, 15% discount rate
⢠Part D, 5 Year Equipment Life:5 year project and savings life,flat annual savings, 10% discount
rate
Discussion â in a Word Document in paragraph form, respond tothe following:
1) From a Financial perspective, would you recommend thispurchase to Management? Which
scenario would you present and why?
2) In your opinion, which scenario is the most aggressive (i.eis based on the most aggressive
assumptions)? If you were to select this scenario as the basisfor your proposal, how would you
justify the more aggressive assumptions?
3) In SIMPLE English (as in talking to a non-Finance and non-MBAperson), explain why there was
a difference in outcome between Part A and Part B.
4) Beyond Financial measures, what other considerations wouldyou want to consider, before
making a recommendation to Management?
5) If you were the CEO, would you approve this proposal? Why orwhy not?
Related questions
Demonstrate your understanding of capital investment techniquesby evaluating the following three case studies. Pleaseinclude the excel spreadsheet or the math behind each solution.Thanks
Case Analysis 1:
You work for a small, local telecommunications company. In fiveyears, the company plans to undertake a major upgrade to itsservers and other IT infrastructure. Management estimates that itwill need up to
$450,000 to cover all related costs; however, as a fairly youngcompany, the goal is to pay for the
upgrade with cash and not to take out loans.
Right now, you have $300,000 in a bank account established forCapital Investments. This account pays
6% interest, compounded annually.
A member of the finance department has approached you with aninvestment opportunity for the
$300,000 that covers a five-year period and has the followingprojected after-tax cash flows:
Year Projected Cash Flow
1 $94,000
2 $114,000
3 $134,000
4 $114,000
5 $94,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 until you need it in five
years?
2) If you undertake the investment opportunity, what is theNominal Payback Period?
3) Using the factors for 6%, what is the Discounted PaybackPeriod?
4) What is the Present Value of the benefits from this 5-yearinvestment opportunity?
5) What is the Net Present Value of this investmentopportunity?
6) If you leave the money in the bank and earn 6% compoundedannually, will you have at least
$450,000 in 5 years to fund the server and IT upgrades? By howmuch will you be âoverâ or âshortâ of
what you need?
7) If you undertake the investment, will you have at least$450,000 in your checking account in 5 years?
By how much will you be âoverâ or âshortâ?
Case Analysis 2 :
The CEO of Dynamic Manufacturing was at a conference and talkedto a supplier about a new piece of
equipment for its production process that she believes willproduce ongoing cost savings. As the
Operations Manager, your CEO has asked for your perspective onwhether or not to purchase the
machinery.
After talking to the supplier and meeting with your Engineersand Financial Analysts, youâve gathered the
following pieces of data:
⢠Cost of Machine: $150,000
⢠Estimated Annual After Tax Savings: $65,000
⢠Estimated machinery life: 3 years (after which there will bezero value for the equipment and no
further cost savings)
⢠You seem to recall that Dynamicâs Finance organizationrecommends either a 10% or a 15%
discount rate for all Cost Savings Projects. You are fairly sureit is 10%.
You understand that you need to understand the projectfinancials to ensure that
this investment will be economically attractive to DynamicManufacturingâs shareholders.
Calculate the Nominal Payback, the Discounted Payback, the NetPresent Value and the IRR
assuming:
⢠Part A, BASE CASE: 3 year project life, flat annual savings,10% discount rate
⢠Part B. Saving Growth Scenario: BASE CASE but with 10%compounded annual savings growth
in years 2 & 3.
⢠Part C, Higher Discount Rate Scenario: 3 year project life,flat annual savings, 15% discount rate
⢠Part D, 5 Year Equipment Life:5 year project and savings life,flat annual savings, 10% discount
rate
Discussion â in a Word Document in paragraph form, respond tothe following:
1) From a Financial perspective, would you recommend thispurchase to Management? Which
scenario would you present and why?
2) In your opinion, which scenario is the most aggressive (i.eis based on the most aggressive
assumptions)? If you were to select this scenario as the basisfor your proposal, how would you
justify the more aggressive assumptions?
3) In SIMPLE English (as in talking to a non-Finance and non-MBAperson), explain why there was
a difference in outcome between Part A and Part B.
4) Beyond Financial measures, what other considerations wouldyou want to consider, before
making a recommendation to Management?
5) If you were the CEO, would you approve this proposal? Why orwhy not?
Case Analysis 3:
You are the General Manager at the Bicker, Slaughter and LynchLaw Firm. There is an opportunity to
buy out a small law firm that was just started by a young MBA/JDand you believe the firm can be grown
and become a lucrative part of your Firm.
With help from your Finance leader, you have estimated thefollowing benefit streams for this new
division:
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | |
Before Tax Cash Flow FromOperations | $(149,000) | $- | $51,380 | $88,760 | $114,100 | $129,780 | $143,640 | $167,300 |
After Tax Net Income FromOperations | $(103,500) | $(50,500) | $36,700 | $63,400 | $81,500 | $92,700 | $102,600 | $119,500 |
After Tax Cash Flow FromOperations | $(85,600) | $15,000 | $48,600 | $72,200 | $95,550 | $101,300 | $125,200 | $140,200 |
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, anadditional $20,000 in year 2 and then
$20,000 in year 5.
In addition to the purchase price, you would ask that yourAdvertising budget of $275,000 be increased by
an incremental one time amount of $50,000 in advertising in year0 to publicize the firmâs expansion.
Your Finance leader has indicated that the firm has access to acredit line and could borrow the funds at
a rate of 6%. He also mentions that when he runs Projecteconomics for Capital budgeting (such as a
new copier or a company car), he recommends a standard 10% ratediscount but the one other time they
looked at an acquisition of a smaller firm he used a 12% ratediscount.
At the end of 8 years, the plan will be to sell this division.The estimated terminal value (the sale and the
return of working capital) is conservatively estimated to be$300,000 of after tax cash flow help.
Calculate the N Nominal Payback, the Discounted Payback, the NetPresent Value and the IRR for this
potential acquisition.
Discussion â in a Word Document in paragraph form, respond tothe following:
1) From a Financial perspective, would you recommend thispurchase to Management? Why?
2) What are some of the non-financial elements that need to beconsidered for this proposal?
3) Assumptions in Project Economics can have a huge impact onthe result. Identify 3 financial
elements/assumptions in your analysis that would make thisproject not be financially attractive?
(E.g. Answer the question, what would have to be true for thisto be a bad investment?)
4) If you were the CEO would you approve this proposal? Why orwhy not?
Management Accounting Application
In this assignment you will demonstrate your understanding ofcapital investment techniques by
evaluating the following three case studies.
Case Analysis 1:
You work for a small, local telecommunications company. In fiveyears, the company plans to undertake a major upgrade to itsservers and other IT infrastructure. Management estimates that itwill need up to
$450,000 to cover all related costs; however, as a fairly youngcompany, the goal is to pay for the
upgrade with cash and not to take out loans.
Right now, you have $300,000 in a bank account established forCapital Investments. This account pays
6% interest, compounded annually.
A member of the finance department has approached you with aninvestment opportunity for the
$300,000 that covers a five-year period and has the followingprojected after-tax cash flows:
Year Projected Cash Flow
1 $94,000
2 $114,000
3 $134,000
4 $114,000
5 $94,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 until you need it in five
years?
2) If you undertake the investment opportunity, what is theNominal Payback Period?
3) Using the factors for 6%, what is the Discounted PaybackPeriod?
4) What is the Present Value of the benefits from this 5-yearinvestment opportunity?
5) What is the Net Present Value of this investmentopportunity?
6) If you leave the money in the bank and earn 6% compoundedannually, will you have at least
$450,000 in 5 years to fund the server and IT upgrades? By howmuch will you be âoverâ or âshortâ of
what you need?
7) If you undertake the investment, will you have at least$450,000 in your checking account in 5 years?
By how much will you be âoverâ or âshortâ?
Case Analysis 2 :
The CEO of Dynamic Manufacturing was at a conference and talkedto a supplier about a new piece of
equipment for its production process that she believes willproduce ongoing cost savings. As the
Operations Manager, your CEO has asked for your perspective onwhether or not to purchase the
machinery.
After talking to the supplier and meeting with your Engineersand Financial Analysts, youâve gathered the
following pieces of data:
⢠Cost of Machine: $150,000
⢠Estimated Annual After Tax Savings: $65,000
⢠Estimated machinery life: 3 years (after which there will bezero value for the equipment and no
further cost savings)
⢠You seem to recall that Dynamicâs Finance organizationrecommends either a 10% or a 15%
discount rate for all Cost Savings Projects. You are fairly sureit is 10%.
You understand that you need to understand the projectfinancials to ensure that
this investment will be economically attractive to DynamicManufacturingâs shareholders.
Calculate the Nominal Payback, the Discounted Payback, the NetPresent Value and the IRR
assuming:
⢠Part A, BASE CASE: 3 year project life, flat annual savings,10% discount rate
⢠Part B. Saving Growth Scenario: BASE CASE but with 10%compounded annual savings growth
in years 2 & 3.
⢠Part C, Higher Discount Rate Scenario: 3 year project life,flat annual savings, 15% discount rate
⢠Part D, 5 Year Equipment Life:5 year project and savings life,flat annual savings, 10% discount
rate
Discussion â in a Word Document in paragraph form, respond tothe following:
1) From a Financial perspective, would you recommend thispurchase to Management? Which
scenario would you present and why?
2) In your opinion, which scenario is the most aggressive (i.eis based on the most aggressive
assumptions)? If you were to select this scenario as the basisfor your proposal, how would you
justify the more aggressive assumptions?
3) In SIMPLE English (as in talking to a non-Finance and non-MBAperson), explain why there was
a difference in outcome between Part A and Part B.
4) Beyond Financial measures, what other considerations wouldyou want to consider, before
making a recommendation to Management?
5) If you were the CEO, would you approve this proposal? Why orwhy not?
Case Analysis 3:
You are the General Manager at the Bicker, Slaughter and LynchLaw Firm. There is an opportunity to
buy out a small law firm that was just started by a young MBA/JDand you believe the firm can be grown
and become a lucrative part of your Firm.
With help from your Finance leader, you have estimated thefollowing benefit streams for this new
division:
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | |
Before Tax Cash Flow FromOperations | $(149,000) | $- | $51,380 | $88,760 | $114,100 | $129,780 | $143,640 | $167,300 |
After Tax Net Income FromOperations | $(103,500) | $(50,500) | $36,700 | $63,400 | $81,500 | $92,700 | $102,600 | $119,500 |
After Tax Cash Flow FromOperations | $(85,600) | $15,000 | $48,600 | $72,200 | $95,550 | $101,300 | $125,200 | $140,200 |
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, anadditional $20,000 in year 2 and then
$20,000 in year 5.
In addition to the purchase price, you would ask that yourAdvertising budget of $275,000 be increased by
an incremental one time amount of $50,000 in advertising in year0 to publicize the firmâs expansion.
Your Finance leader has indicated that the firm has access to acredit line and could borrow the funds at
a rate of 6%. He also mentions that when he runs Projecteconomics for Capital budgeting (such as a
new copier or a company car), he recommends a standard 10% ratediscount but the one other time they
looked at an acquisition of a smaller firm he used a 12% ratediscount.
At the end of 8 years, the plan will be to sell this division.The estimated terminal value (the sale and the
return of working capital) is conservatively estimated to be$300,000 of after tax cash flow help.
Calculate the N Nominal Payback, the Discounted Payback, the NetPresent Value and the IRR for this
potential acquisition.
Discussion â in a Word Document in paragraph form, respond tothe following:
1) From a Financial perspective, would you recommend thispurchase to Management? Why?
2) What are some of the non-financial elements that need to beconsidered for this proposal?
3) Assumptions in Project Economics can have a huge impact onthe result. Identify 3 financial
elements/assumptions in your analysis that would make thisproject not be financially attractive?
(E.g. Answer the question, what would have to be true for thisto be a bad investment?)
4) If you were the CEO would you approve this proposal? Why orwhy not?
Capital Budgeting Decision
Here is Project 2:
Hampton Company: The production department has beeninvestigating possible ways to trim total production costs. Onepossibility currently being examined is to make the cans instead ofpurchasing them. The equipment needed would cost $1,000,000, with adisposal value of $200,000, and would be able to produce 27,500,000cans over the life of the machinery. The production departmentestimates that approximately 5,500,000 cans would be needed foreach of the next 5 years.
The company would hire six new employees. These six individualswould be full-time employees working 2,000 hours per year andearning $15.00 per hour. They would also receive the same benefitsas other production employees, 15% of wages in addition to $2,000of health benefits.
It is estimated that the raw materials will cost 30¢ per can andthat other variable costs would be 10¢ per can. Because there iscurrently unused space in the factory, no additional fixed costswould be incurred if this proposal is accepted.
It is expected that cans would cost 50¢ each if purchased fromthe current supplier. The company's minimum rate of return (hurdlerate) has been determined to be 11% for all new projects, and thecurrent tax rate of 35% is anticipated to remain unchanged. Thepricing for the companyâs products as well as number of units soldwill not be affected by this decision. The unit-of-productiondepreciation method would be used if the new equipment ispurchased.
Required:
1. Based on the above information and using Excel, calculate thefollowing items for this proposed equipment purchase.
Annual cash flows over the expected life of the equipment
Payback period
Simple rate of return
Net present value
Internal rate of return
The check figure for the total annual after-tax cash flows is$271,150.
2. Would you recommend the acceptance of this proposal? Why orwhy not? Prepare a short, double-spaced paper in MS Wordelaborating on and supporting your answer.
| ACCT505 | ||||||||
| Project 2 | ||||||||
| Data: | ||||||||
| Cost of new equipment | ||||||||
| Expected life of equipment inyears | ||||||||
| Disposal value in 5 years | ||||||||
| Life productionânumber ofcans | ||||||||
| Annual production or purchaseneeds | ||||||||
| Initial training costs | ||||||||
| Number of workers needed | ||||||||
| Annual hours to be worked peremployee | ||||||||
| Earnings per hour foremployees | ||||||||
| Annual health benefits peremployee | ||||||||
| Other annual benefits peremployeeâ% of wages | ||||||||
| Cost of raw materials percan | ||||||||
| Other variable productioncosts per can | ||||||||
| Costs to purchase cansâpercan | ||||||||
| Required rate of return | ||||||||
| Tax rate | ||||||||
| Make | Purchase | |||||||
| Cost toProduce | ||||||||
| Annual cost ofdirect material: | ||||||||
| Need of 1 million cans peryear | ||||||||
| Annual cost ofdirect labor for new employees: | ||||||||
| Wages | ||||||||
| Health benefits | ||||||||
| Other benefits | ||||||||
| Total wagesand benefits | ||||||||
| Other variableproduction costs | ||||||||
| Total annualproduction costs | ||||||||
| Annual cost topurchase cans | ||||||||
| Part 1Cash Flows Over the Life of the Project | ||||||||
| Before Tax | Tax | After Tax | ||||||
| Item | Amount | Effect | Amount | |||||
| Annual cash savings | ||||||||
| Tax savings due todepreciation | ||||||||
| Total after-tax annual cashflow | ||||||||
| Part 2Payback Period | ||||||||
| Part 3Simple Rate of Return | ||||||||
| Accounting incomeas result of decreased costs | ||||||||
| Annual cash savings | ||||||||
| Less depreciation | ||||||||
| Before tax income | ||||||||
| Tax at 35% rate | ||||||||
| After tax income | ||||||||
| Part 4Net Present Value | ||||||||
| Before Tax | After Tax | 10% PV | Present | |||||
| Item | Year | Amount | Tax % | Amount | Factor | Value | ||
| Cost of machine | ||||||||
| Cost of training | ||||||||
| Annual cash savings | ||||||||
| Tax savings due todepreciation | ||||||||
| Disposal value | ||||||||
| Net Present Value | ||||||||
| Part 5Internal Rate of Return | ||||||||
| Excel function method tocalculate IRR | ||||||||
| This functionrequires that you have only one cash flow per period (Period 0through Period 5, for our example). | ||||||||
| This means that noannuity figures can be used. The chart for our example can berevised as follows. | ||||||||
| After Tax | ||||||||
| Item | Year | Amount | ||||||
| Cost of machine andtraining | 0 | |||||||
| Year 1 inflow | 1 | |||||||
| Year 2 inflow | 2 | |||||||
| Year 3 inflow | 3 | |||||||
| Year 4 inflow | 4 | |||||||
| Year 5 inflow | 5 | |||||||
