Only need to fill in the yellow boxes which column refer to which orioject and fill in the black boxes

1 o B D E F G H J L M N 3 Format: Boxes that are surrounded by a black border need to be filled in with the appropriate numbers pertaining to the project. 4 Cells Highlighted in yellow are the answer we require. 5 6 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. 7 You have asked your four different engineers to submit different proposals for selection. 8 Any equipment, technology, and capital expenditure will be assumed valueless at the end of the 10 years. 9 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. 10 11 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. 12 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. 13 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 14 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. 15 16 A. Which project has the highest NPV at 10% interest rate 17 B. Which Project has the highest NPV at 15% interest rate 18 C. Which project has the highest NPV at 5% interest rate? 19 D. Which project has the highest NPV at 2% interest rate? 20 21 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. 22 E. Which project (excluding A which has no investment), has the fastest payback? 23 F. What is the simple payback of project C? 24 G. Which project has the highest IRR (exclude A) 25 H. The project manager feels project D is twice as risky (interest risk) as the other options, which project has the highest NPV now? 26 I. The project manager notices that project B can make 10% more, and grow 5% faster. Which NPV is the highest? 27 28 The Following Questions are short answer: 29 I. Why did project A npv change when interest rate changed even though they didn't borrow money? 30 J. Why do you think the payback for project B was always the fastest? (excluding project A) 31 K. Why do you think the simple payback of project C, is greater than its actual paypack? 32 L. What value does IRR provide the project manager? 33 M. The project manager wants a conservative estimate and sets all growth factors at 10%, what flaws does this highlight in project B-D. 34 35 36 37 Proiart A Growth Factor Interest Rata nod > Questions + Growth Factor: Interest Rate 0% 0 1 2 3 4 6 7 8 8 9 10 0% 0% 0% - 0% $ $ 0% $ $ $ 0% $ $ 5 0% $ $ $ - 0% $ $ 37 Project A 38 39 Year 40 Interest Rate 41 Cash Flow $ 42 Discounted $ 43 NPV $ 44 IRR N/A 45 Payback 46 Payback Chart N/A 47 - - - 0% $ $ $ $ - 0% $ $ ises 0% $ $ $ 48 Growth Factor: 0 2 3 4 5 7 8 9 10 1 0% 6 0% 0% 0% 0% $ 0% $ $ 0% - $ $ 0% $ $ 0% $ $ - is en $ $ $ $ 0% $ $ 0% $ $ $ $ - #NUM! $ $ $ $ $ $ $ $ $ $ $ 49 Project B 50 51 Year 52 Interest Rate 53 Cash Flow 54 Discounted $ 55 NPV $ 56 IRR 57 Payback 58 Payback Chart $ 59 60 Project C 61 62 Year 63 Interest Rate 64 Cash Flow 65 Discounted $ 66 NPV $ 67 IRR 68 Payback 69 Payback Chart $ K Growth Factor: 1 2 4 5 6 7 8 9 10 0% 0% 0% 0% $ $ $ 0% $ $ 3 0% - $ $ 0% $ $ 0% $ $ isen $ $ 0% $ $ 0% $ $ 0% $ $ $ #NUM! $ $ $ $ $ $ $ $ $ $ $ Questions + Growth Factor: 0 1 3 4 5 6 7 8 10 0% 0% 0% 0% 0% $ $ 2 0% $ $ - 0% $ $ 0% $ $ 9 0% $ $ $ $ $ - 0% $ $ - $ $ 0% $ $ $ #NUM! $ $ $ $ $ $ - $ $ $ $ $ - $ $ $ - Growth Factor: 0 1 2 3 6 7 9 10 0% 0% 0% 0% 48 49 Project B 50 51 Year 52 Interest Rate 53 Cash Flow 54 Discounted $ 55 NPV $ 56 IRR 57 Payback 58 Payback Chart $ 59 60 Project C 61 62 Year 63 Interest Rate 64 Cash Flow 65 Discounted $ 66 NPV $ 67 IRR 68 Payback 69 Payback Chart $ 70 71 Project D 72 73 Year 74 Interest Rate 75 Cash Flow $ 76 Discounted $ 77 NPV $ 78 IRR 79 Payback 80 Payback Chart $ 81 0% $ $ 0% $ $ 0% $ $ 4 0% $ $ 5 0% $ $ 8 0% $ $ $ $ $ $ 0% $ $ $ #NUM! $ $ $ - $ $ - $ $ $ $ $ - $ Growth Factor: 1 3 10 6 0% 0% 2 0% $ 0 0% $ $ $ 0% 0% $ $ 4 0% $ $ 5 0% $ $ 7 0% $ $ 8 0% $ $ 9 0% $ $ $ $ ? - $ $ #NUM! $ $ - $ $ $ $ - $ $ $ $ $ $ $ 1 o B D E F G H J L M N 3 Format: Boxes that are surrounded by a black border need to be filled in with the appropriate numbers pertaining to the project. 4 Cells Highlighted in yellow are the answer we require. 5 6 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. 7 You have asked your four different engineers to submit different proposals for selection. 8 Any equipment, technology, and capital expenditure will be assumed valueless at the end of the 10 years. 9 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. 10 11 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. 12 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. 13 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 14 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. 15 16 A. Which project has the highest NPV at 10% interest rate 17 B. Which Project has the highest NPV at 15% interest rate 18 C. Which project has the highest NPV at 5% interest rate? 19 D. Which project has the highest NPV at 2% interest rate? 20 21 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. 22 E. Which project (excluding A which has no investment), has the fastest payback? 23 F. What is the simple payback of project C? 24 G. Which project has the highest IRR (exclude A) 25 H. The project manager feels project D is twice as risky (interest risk) as the other options, which project has the highest NPV now? 26 I. The project manager notices that project B can make 10% more, and grow 5% faster. Which NPV is the highest? 27 28 The Following Questions are short answer: 29 I. Why did project A npv change when interest rate changed even though they didn't borrow money? 30 J. Why do you think the payback for project B was always the fastest? (excluding project A) 31 K. Why do you think the simple payback of project C, is greater than its actual paypack? 32 L. What value does IRR provide the project manager? 33 M. The project manager wants a conservative estimate and sets all growth factors at 10%, what flaws does this highlight in project B-D. 34 35 36 37 Proiart A Growth Factor Interest Rata nod > Questions + Growth Factor: Interest Rate 0% 0 1 2 3 4 6 7 8 8 9 10 0% 0% 0% - 0% $ $ 0% $ $ $ 0% $ $ 5 0% $ $ $ - 0% $ $ 37 Project A 38 39 Year 40 Interest Rate 41 Cash Flow $ 42 Discounted $ 43 NPV $ 44 IRR N/A 45 Payback 46 Payback Chart N/A 47 - - - 0% $ $ $ $ - 0% $ $ ises 0% $ $ $ 48 Growth Factor: 0 2 3 4 5 7 8 9 10 1 0% 6 0% 0% 0% 0% $ 0% $ $ 0% - $ $ 0% $ $ 0% $ $ - is en $ $ $ $ 0% $ $ 0% $ $ $ $ - #NUM! $ $ $ $ $ $ $ $ $ $ $ 49 Project B 50 51 Year 52 Interest Rate 53 Cash Flow 54 Discounted $ 55 NPV $ 56 IRR 57 Payback 58 Payback Chart $ 59 60 Project C 61 62 Year 63 Interest Rate 64 Cash Flow 65 Discounted $ 66 NPV $ 67 IRR 68 Payback 69 Payback Chart $ K Growth Factor: 1 2 4 5 6 7 8 9 10 0% 0% 0% 0% $ $ $ 0% $ $ 3 0% - $ $ 0% $ $ 0% $ $ isen $ $ 0% $ $ 0% $ $ 0% $ $ $ #NUM! $ $ $ $ $ $ $ $ $ $ $ Questions + Growth Factor: 0 1 3 4 5 6 7 8 10 0% 0% 0% 0% 0% $ $ 2 0% $ $ - 0% $ $ 0% $ $ 9 0% $ $ $ $ $ - 0% $ $ - $ $ 0% $ $ $ #NUM! $ $ $ $ $ $ - $ $ $ $ $ - $ $ $ - Growth Factor: 0 1 2 3 6 7 9 10 0% 0% 0% 0% 48 49 Project B 50 51 Year 52 Interest Rate 53 Cash Flow 54 Discounted $ 55 NPV $ 56 IRR 57 Payback 58 Payback Chart $ 59 60 Project C 61 62 Year 63 Interest Rate 64 Cash Flow 65 Discounted $ 66 NPV $ 67 IRR 68 Payback 69 Payback Chart $ 70 71 Project D 72 73 Year 74 Interest Rate 75 Cash Flow $ 76 Discounted $ 77 NPV $ 78 IRR 79 Payback 80 Payback Chart $ 81 0% $ $ 0% $ $ 0% $ $ 4 0% $ $ 5 0% $ $ 8 0% $ $ $ $ $ $ 0% $ $ $ #NUM! $ $ $ - $ $ - $ $ $ $ $ - $ Growth Factor: 1 3 10 6 0% 0% 2 0% $ 0 0% $ $ $ 0% 0% $ $ 4 0% $ $ 5 0% $ $ 7 0% $ $ 8 0% $ $ 9 0% $ $ $ $ ? - $ $ #NUM! $ $ - $ $ $ $ - $ $ $ $ $ $ $