Capital Budgeting Calculations

Jun 10th, 2014
DotaCN
Category:
Price: \$60 USD

Question description
 1 Excel spreadsheet; 1,750–2000 words The President of EEC recently called a meeting to announce that one of the firm’s largest suppliers of component parts has approached EEC about a possible purchase of the supplier. The President has requested that you and your staff analyze the feasibility of acquiring this supplier. Based on the following information, calculate net present value (NPV), internal rate of return (IRR), and payback for the investment opportunity: EEC expects to save \$500,000 per year for the next 10 years by purchasing the supplier.EEC’s cost of capital is 14%.EEC believes it can purchase the supplier for \$2 million.

Capital Budgeting Calculations MUST BE IN THE BELOW FORMAT

You are to calculate NPV, IRR and Payback for the supplier purchase and decide based on your calculations whether or not you should purchase the supplier.  You also need to discuss which of the three methods is the most reliable and explain why.  You need to revise your calculations based on the new data.

I.  Introductory Paragraph

II.  Capital Budgeting Calculations – Original Data

a.  NPV

b.  IRR

c.  Payback

d.  Analysis and Decision of whether to accept or reject the project

III.  Capital Budgeting Calculations – Increased Cost of Capital

a.  NPV

b.  IRR

c.  Payback

d.  Analysis and Decision of whether to accept or reject the project

IV.  Capital Budgeting Calculations – Less than 500,000 in Savings

a.  NPV

b.  IRR

c.  Payback

d.  Analysis and Decision of whether to accept or reject the project

V.  Capital Budgeting Calculations – Paying more than 2 million

a.  NPV

b.  IRR

c.  Payback

d.  Analysis and Decision of whether to accept or reject the project

VI.  Discuss how much savings can decrease and you accept the project,  and how much more you will be willing to pay to accept the  project

VII.  Conclusion

VIII.  References

(Top Tutor) Daniel C.
(997)
School: Carnegie Mellon University

Studypool has helped 1,244,100 students

Review from our student for this Answer

FratBro23
Jun 15th, 2014
"Thanks, good work"

Type your question here (or upload an image)

1828 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors