Financial analysis at a mid-sized manufacturing firm

Reference no: EM13208350

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: EM13208350

Questions Cloud

Create an instance variable credit limit to indicate : Create another sub class CreditCustomer. Create an instance variable credit limit to indicate the maximum limit ($500). Credit customers get a markup of 2% on the order price.

What defense or defenses will big petroleum invoke : Current legislation limits the amount of economic-related liabilities to be paid by a company on account of an oil spill to $75 million.

Write an app that uses a foreach statement to sum the values : Write an app that uses a foreach statement to sum the values passed by the command line argument. Hint: Use static method ToDouble of class Convert to covert a string to a double value.

Use the smallest possible array to solve this problem : Use the smallest possible array to solve this problem. Display the complete set of unique value input after the user inputs each new value.

Financial analysis at a mid-sized manufacturing firm : 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

Write a program using dialog boxes to convert a temperature : Write a program using dialog boxes to convert a temperature from degrees Fahrenheit to degree Celsius. The formula for converting the temperature from F to C is: C = (f-32) (5/9) Your program should the user to enter a temperature given in degrees..

Create a program to calculate the average of the class : Define a function "double average(int, int)" to calculate the class average In main function call average function and display the average of the class

Write a recursive method : Write a recursive method that converts an integer into its English language Equivalent. intToEnglish(4500007) -> four million five hundred thousand seven

Draw a circuit using only two-input nand gates : Prove this by showing how you can implement the functions of an inverter, and AND gate, and an OR gate just using NAND gates. That is for each function draw a circuit using only two-input NAND gates that implements the operation.

User Account

All Pages