Our CEO is looking to increase our future value by investing in RnD. Here are few RnD Projects being considered. Your job is to make sure that we invest in the projects that are projected to bring us the BEST returns. Note: A project with negative NPV will be deemed TOTAL FAILURE and will be written off as expense Required rate of returns : 20%

Calculate in Excel each of the below NPV

Project E Investment

Research Expenditure450,000 (AUD)

Development Expenditure150,000 (AUD)

Budgeted years 7

Evaluation day (after investing) 15

Projected Inflow

Year 1 Projected Inflow350,000 (AUD)

Year 2 Projected Inflow679,000 (AUD)

Year 3 Projected Inflow693,000 (AUD)

Year 4 Projected Inflow676,000 (AUD)

Year 5 Projected Inflow578,000 (AUD)

Year 6 Projected Inflow669,000 (AUD)

Year 7 Projected Inflow634,000 (AUD)

Project C Investment

Research Expenditure350,000 (AUD)

Development Expenditure300,000 (AUD)

Budgeted years8

Evaluation day (after investing)15

Projected Inflow

Year 1 Projected Inflow200,000 (AUD)

Year 2 Projected Inflow366,000 (AUD)

Year 3 Projected Inflow342,000 (AUD)

Year 4 Projected Inflow398,000 (AUD)

Year 5 Projected Inflow390,000 (AUD)

Year 6 Projected Inflow396,000 (AUD)

Year 7 Projected Inflow348,000 (AUD)

Year 8 Projected Inflow362,000 (AUD