Question

FastTrack Bikes, Inc. is thinking of developing a new composite road bike. Development will take six years and the cost is $200,000 per year. Once in production, the bike is expected to make $300,000 (after expenses) per year for 10 years. The cash inflows begin at the end of year 7.

At FastTrack, there is a difference of opinion as to the "best" decision rule to use. The four rules under consideration are NPV, IRR, Payback Period and Profitability Index (PI).                         

Additional Info: The firm's president has set a maximum acceptable payback period of 8 years for projects and the cost of capital appropriate for this project is 10%.

Using the end of year cash flows as shown in the table (see below), answer each of the following:

Year	Cash Flows
0	$0
1	-$200,000
2	-$200,000
3	-$200,000
4	-$200,000
5	-$200,000
6	-$200,000
7	$300,000
8	$300,000
9	$300,000
10	$300,000
11	$300,000
12	$300,000
13	$300,000
14	$300,000
15	$300,000
16	$300,000

1a        What is the Payback period of the project?   

                                               

1b        Should the project be accepted or rejected based on Payback and why?   

2a        What is the profitability index or PI of the project?

2b        Should the project be accepted or rejected based on PI and why?

3 If the firm's required rate of return increased, what would be the impact on each of the values?                                                    

3a Effect on NPV and why:                                                        

3b Effect on IRR and why:                                                          

3c Effect on Payback period and why:                                                    

3d        Effect on PI and why:

Please show all work.

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -