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. 5 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? IG. Which project has the highest IRR (exclude A) H. The project manager feels project Dis twice as risky ((interest risk) as the other options, which project has the highest NPV now? 1. 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: 1. 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. Growth Factor: Interest Rate 0% 0 5 6 8 10 1 1 0% 2 0% 3 0% 4 0% 7 0% 9 0% 0% 0% 0% 0% 0% 5 Project A 3 Year Interest Rate Cash Flow $ Discounted $ NPV $ IRR N/A Payback 5 Payback Chart N/A $ - $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - - - - 3 Project B Growth Factor: Year 0 1 2 4 5 6 7 8 9 3 0% 10 0% 0% 0% 0% 0% 0% 0% 0% 0% $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - $ - - $ - Interest Rate 0% Cash Flow Discounted $ NPV $ IRR #NUM! Payback Payback Chart $ $ $ $ $ $ $ - $ $ - $ $ $ Project C Growth Factor: 1 2 4 5 6 7 8 3 0% 9 0% 10 0% 0% 0% 0% 0% 0% 0% 0% $ $ $ - $ $ $ $ is in $ $ $ $ $ $ $ $ - $ $ $ $ - - Year 0 Interest Rate 0% Cash Flow Discounted $ NPV $ IRR #NUM! Payback Payback Chart $ - $ $ $ $ $ $ $ $ $ - $ Project D Growth Factor: Year 0 1 C 2 3 3 4 4 7 9 10 8 0% Find & Select 0% 0% 0% 0% 0% 0% 0% 0% - -- - $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - $ $ - - Interest Rate Cash Flow $ Discounted $ NPV $ $ IRR Payback Payback Chart $ #NUM! - $ $ $ $ $ $ $ $ $ $ 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. 5 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? IG. Which project has the highest IRR (exclude A) H. The project manager feels project Dis twice as risky ((interest risk) as the other options, which project has the highest NPV now? 1. 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: 1. 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. Growth Factor: Interest Rate 0% 0 5 6 8 10 1 1 0% 2 0% 3 0% 4 0% 7 0% 9 0% 0% 0% 0% 0% 0% 5 Project A 3 Year Interest Rate Cash Flow $ Discounted $ NPV $ IRR N/A Payback 5 Payback Chart N/A $ - $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - - - - 3 Project B Growth Factor: Year 0 1 2 4 5 6 7 8 9 3 0% 10 0% 0% 0% 0% 0% 0% 0% 0% 0% $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - $ - - $ - Interest Rate 0% Cash Flow Discounted $ NPV $ IRR #NUM! Payback Payback Chart $ $ $ $ $ $ $ - $ $ - $ $ $ Project C Growth Factor: 1 2 4 5 6 7 8 3 0% 9 0% 10 0% 0% 0% 0% 0% 0% 0% 0% $ $ $ - $ $ $ $ is in $ $ $ $ $ $ $ $ - $ $ $ $ - - Year 0 Interest Rate 0% Cash Flow Discounted $ NPV $ IRR #NUM! Payback Payback Chart $ - $ $ $ $ $ $ $ $ $ - $ Project D Growth Factor: Year 0 1 C 2 3 3 4 4 7 9 10 8 0% Find & Select 0% 0% 0% 0% 0% 0% 0% 0% - -- - $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - $ $ - - Interest Rate Cash Flow $ Discounted $ NPV $ $ IRR Payback Payback Chart $ #NUM! - $ $ $ $ $ $ $ $ $ $