Question

Project Details

John and Jane Doe are newlyweds with executive track careers at ACME Gadget Company. In five years, the Does would like to have a family, envisioning two young children, Jack and Jill. With an eye for the future, John and Jane are now looking to ensure that their future family has a place to call home, that their future children will have access to all the education they desire, and that they themselves will be able to enjoy retirement when the time comes. As such, they’ve come to your financial planning company for advice for purchasing a house, planning for retirement, setting up a RESP and for your perspective on a side venture. They’ve provided you with the background and questions below.

A side-venture

Jane is an inventor, working for the ACME Gadget Company in research and development. She recently proposed the development of an advanced technology, but it was deemed too risky for R&D at ACME. However, ACME has agreed that if Jane successfully develops the technology on her own, ACME will acquire a license to use the technology for a period of 10 years. To develop the technology will require an initial expenditure of $150,000 and an additional expenditure of $150,000 at the end of each of the next 2 years. When the patent is approved in Year 4, it is expected to be licensed to the ACME Gadget Company for an upfront fee of 100,000 plus an additional fee of $90,000/year for 10 years. At that time the product that uses the technology will be replaced by a new model. What is the rate of return on the Jane’s advanced technology?

Please include calculations and diagrams.

Answer 1

Years	Amount
0	$ -1,50,000.00
1	$ -1,50,000.00
2	$ -1,50,000.00
3	$                    -
4	$ 1,00,000.00
5	$      90,000.00
6	$      90,000.00
7	$      90,000.00
8	$      90,000.00
9	$      90,000.00
10	$      90,000.00
11	$      90,000.00
12	$      90,000.00
13	$      90,000.00
14	$      90,000.00
Rate of return	11.32%

The rate of return will be the Internal Rate of Return of all the cashflow and it will be 11.32%

Formulas:

Years	Amount
0	-150000
1	-150000
2	-150000
3	0
4	100000
5	90000
6	90000
7	90000
8	90000
9	90000
10	90000
11	90000
12	90000
13	90000
14	90000
Rate of return	=IRR(B3:B17)