You are the senior financial analyst at a mid-sized

Assignment Help Corporate Finance

Reference no: EM13381559

You are the senior financial analyst at a mid-sized manufacturing firm in the Chicago area. Your supervisor, the VP of Finance, has asked your help in choosing between two capital projects. Each project represents a new manufacturing method to be used for a new line of products to be introduced in the firm's current markets. Below are the expected cash flows for the two projects:

Year	Project 1	Project 2
0	(5,250,000)	(6,500,000)
1	850,000	1,250,000
2	900,000	1,400,000
3	1,000,000	1,500,000
4	1,000,000	1,500,000
5	1,000,000	1,400,000
6	900,000	1,250,000
7	800,000	1,100,000
8	700,000	1,000,000
9	600,000
10	500,000

These figures have been checked and approved by your supervisor. Your assignment is to decide which of the two mutually exclusive projects should be chosen, or if neither one is a good investment. To complicate matters, your supervisor believes that the firms WACC is either 9% or 11%, but he is not sure, and the CFO (the only one who knows for sure what the WACC is) is on a cruise ship in Greece for the next two weeks. The analysis needs to be done immediately.

In order to make the decision between these two capital investments, you must provide the following analysis items:

The NPV for both projects at discount rates of 9% and 11%;
The IRR for both projects;
The MIRR for both projects at WACC of 9% and 11%;
The Payback Period for both projects;
The Discounted Payback Period for both projects at discount rates of 9% and 11%.

Based on those analysis items, you must make a recommendation to your supervisor on whether either of the two mutually exclusive investments is worthwhile. You must provide an Excel workbook showing all of the analysis indicated above, and write a one page paper giving your recommendation based on the analysis. The paper is to be in the form of a business memo to your boss (me) outlining the results of your analysis and your recommendation.

Reference no: EM13381559

Questions Cloud

Liam chan is 25 years and a recent graduate of jmsb he : liam chan is 25 years and a recent graduate of jmsb. he works for the bank of montreal as a junior account manager

1 there exists a special kind of bond investment called a : 1 there exists a special kind of bond investment called a zero coupon bond. a zero coupon bond pays the owner of the

Create an equally weighted portfolio of five computer : create an equally weighted portfolio of five computer software stocks. is such a portfolio a diversified portfolio?

Myworld inc is an all-equity firm whose current business : myworld inc. is an all-equity firm whose current business involves manufacturing and selling software. the company is

You are the senior financial analyst at a mid-sized : you are the senior financial analyst at a mid-sized manufacturing firm in the chicago area. your supervisor the vp of

Discuss the following topicdoes purchasing power parity ppp : discuss the following topicdoes purchasing power parity ppp eliminate concerns about long-term exchange rate risk? one

Hickock mining is evaluating when to open a gold mine the : hickock mining is evaluating when to open a gold mine. the mine has 67000 ounces of gold left that can be mined and

Assume a project has the following forecasted cash : assume a project has the following forecasted cash flowsyearamount in 0-400015002400360045005750answer the

Hype ltd produces four types of clothes with the use of a : hype ltd produces four types of clothes with the use of a special machine. each labor hour in the special machine costs

User Account

All Pages