Due Monday 11/26 Note revised date and submission procedure below.
Fuel cells are a promising new technology for powering electric cars. They are very efficient and produce little pollution, but at the moment they are very expensive to produce. Making them less expensive will take a lot of research and will not pay off for a decade or more. This exercise asks you to use present value calculations to evaluate a potential investment fuel cell research.
Imagine you are the manager of a company in the energy industry. Suppose you know that for a $100 million investment today you could develop a fuel cell technology that you could license to auto companies for $10 million per year forever starting in 10 years. Until then, it would earn nothing (the scientists are still working on it in the lab). For simplicity, assume you would have no costs apart from the initial $100 million.
To raise the $100 million, however, you would have to issue a bond (just as corporations or government agencies do). A bond is basically a legally enforceable IOU: in exchange for money today, your company agrees to make specified payments in the future. In this case, suppose you could raise $100 million today by issuing a bond promising to pay $7 million per year until year 10, at which time you would pay an additional $7 million plus the original $100 million.
Using a spreadsheet program, determine whether it would be a good idea to go ahead with the project if the interest rate were 5%. That is, would it be profitable to borrow the money and make the investment? What is the present value of the project? How would the PV and your decision be affected if the interest rate were 4% or 6% instead? Turn in a your spreadsheet for the 5% case. Make sure there's enough text and documentation that it will be clear how you arrived at your results when the sheet is printed.
To eliminate ambiguities about the timing of payments, here's how to set things up. The investment would cost $100 million in year 0 (today) and would produce $10 million of income per year with the first payment in year 11. The bond would raise $100 million in year 0, would cost you $7 million in years 1-9, and would cost $107 million in year 10 (7+100).
Also, the point of this exercise is to help you learn exactly how present value calculations are done. As a result, please build the worksheet using the fundamental present value formulas from class rather than Excel's built-in present value functions like PV.
Please submit your spreadsheet on Blackboard. If you use a program other than Excel, please save and submit it in XLS or XLSX format. If that's a problem, please send me a note.