BioCom was founded in 1993, When several scientists and engineers at a large fiber optic-cable company began to see that optical fiber for the telecommunications industry was becoming a cheap commodity. They decided to start their own firm, which would specialize in cutting edge applications of optical fiber for research in the life sciences and medical instruments. BioCm is now one of the leading firms in its niche field. BioCom's management attributes the firm's success to its ability to stay one step ahead of the market's fast-changing technological needs. Almost as important is BioCom's ability to select high-value-added projects and avoid commercial disasters. Over lunch, BioCom's director of research and development (R&D) mentioned to the CFO that one of his best young scientists had recently left the company because his line manager had rejected his project . Although not a pattern, R&D had experienced similar losses in the past. The two executives discussed the problem and agreed that if the R&D people understood the selection process better, they might come up with more commercially viable projects and understand the project's financial implications. The CFO then asked his assistant, Jane Donato, to prepare a retreat for the R&D department to explain the company's project selection procedures. Jane is encouraged by the thought that this group will have no trouble following the math! BioCom' standard capital request form includes a narrative description of the project and the customer need that the company must fulfill. If the request originates with R&D, it then goes to the marketing department for a preliminary sales forecast and then to the production manager and cost analysts for cost estimates. If a proposal shows promise after these steps, it goes to the CFO, who has a staff member enter the data into a spreadsheet template. The template computes payback, discounted payback, net present value, internal rate of return, and modified internal rate of return. BioCom uses net present value as its primary decision criterion, but company executives believe that the other statistics provide some useful additional perspectives To explain BioCom's capital budgeting techniques, Jane has decided to present the cash flows from two recent (mutually exclusive) proposals: the Nano Test Tube project and the Microsurgery Kit Project. All figures are in thousands of dollars: Cash Flow Nano Test Tubes Microssurgery Kits Investment (Year 1) $ (11,000.00) (11,000.00) Cash Flow (Year 1) $ 2,000.00 $ 4,000.00 Cash Flow (Year 2) $ 3,000.00 4,000.00 Cash Flow (Year 3) $ 4,000.00 $ 4,000.00 Cash Flow (Year 4) $ 5,000.00 4,000.00 Cash Flow (Year 5) $ 7,000.00 $ 4,000.00 Part A 1. (5 pts) Help Jane create a template in excel to compute payback, discounted payback, t present value, internal rate of return, and modified internal rate of return for both Nano Test Tube and the Microsurgery Kit projects with a discount rate of 9% 2. (3 pts) Explain how BioCom should use the 5 methods (payback, discounted payback, net present value, internal rate of return, and modified internal rate of return) to choose between the Nano Test Tube and the Microsurgery Kit Project
