Project Analysis and Evaluation

Project Details

PLEASE read the excel file carefully and follow the instructions. For IRR of project A, when you get N/A, do not worry as project A has no capex, therefore there is nothing to have a rate of return based off of. As well, for project D, the cell for year two should be highlighted in black, not for year 1. As the question states, project D cash flows start in year 2. The actual payback is taken into consideration the growth factors, the interest rate, and the discounting given a true sense of the word payback. For simple payback, you simple take the cost of the project, divided by its yearly un-adjusted cash flow i.e the first cash flow. Keep in mind that project D has its CF start in year 2.

Format: Boxes that are surrounded by a black border need to be filled in with the appropriate numbers pertaining to the project. Cells Highlighted in yellow are the answer we require. You are the project manager of medical manufacturing line. During covid, you have shifted a portion of your facility to aid in the production of N95 masks You have asked your four different engineers to submit different proposals for selection. Any equipment, technology, and capital expenditure will be assumed valueless at the end of the 10 years. Remember that interest rate is the cost of borrowing money. This rate is used normally as the discount rate. This rate is often tied to perceptions of project and market risk.

Project A Zero up front expenses, re-tool your own machinery and retrain internally. Profit of $260,000 a year starts in year 1, grows at a 12% annual rate.
Project B Capital expenditures of $1.3M for new equipment and staff to expand operations. Profit of $300,000 a year starts in year 1, grows at a 15% annual rate.
Project C Capital expenditure of $1.5M for new equipement and staff, but also $700,000 (one time) for continious process R&D. Profit of $220,000 a year starts in year 1, grows at a 30% annual rate
Project D Capex and new building change of to focus on new business segment. Cost of $4M, profit of $450,000 starts in year 2, grows at 25% annual.

A. Which project has the highest NPV at 10% interest rate
B. Which Project has the highest NPV at 15% interest rate
C. Which project has the highest NPV at 5% interest rate?
D. Which project has the highest NPV at 2% interest rate?

Note: Continue the remainder of the questions at a base interest rate of 2%. When a variable changes in a question, continue the rest of the questions without changing them back.
E. Which project (excluding A which has no investment), has the fastest payback?
F. What is the simple payback of project C?
G. Which project has the highest IRR (exclude A)
H. The project manager feels project D is twice as risky ((interest risk) as the other options, which project has the highest NPV now?
I. The project manager notices that project B can make 10% more, and grow 5% faster. Which NPV is the highest?
The Following Questions are short answer:
I. Why did project A npv change when interest rate changed even though they didn’t borrow money?
J. Why do you think the payback for project B was always the fastest? (excluding project A)
K. Why do you think the simple payback of project C, is greater than its actual paypack?
L. What value does IRR provide the project manager?
M. The project manager wants a conservative estimate and sets all growth factors at 10%, what flaws does this highlight in project B-D.