Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

In this assignment, you'll be writing a business case in which you will recommend to DBVac which of the three vacuums to bring to market, give them a sense for what to expect from its release in...

Executive Summary (write this last!) 5 points a. Write a half-page summary providing highlights of your business case such that the companys CEO can, at a glance, understand what the recommendation...

Calculate the NPV for all three options using the data provided in the background section and using the expected initial cost of development (as calculated in 3a) for each of the three options. Use a...

Background 5 points a. Describe the problem and opportunity that the company is facing. You should be re-stating the problem in your own words so that the company knows that you understand their...

Analysis a. Calculate the expected initial cost of development for all three options using weighted values. (15 points) i. Include your calculations (i.e., a screenshot of the part of the Excel...

Conduct a sensitivity analysis using the product with the highest NPV as calculated in 3b. In the sensitivity analysis, provide three different calculations of NPV: (1) based on the expectations...

(Questions from Lecture and Article) - Discussion Board Activity I need to read the following Lecture Note and the ?Wall Street Journal? articles that I uploaded, and writeanswers for theDiscussion...

Please advise if you can answer all the questions in attached questionnaire as per the attachedcase of IVEY PUBLISHING: 9B14N013. (HUDBAY MINERALS: ACQUISITION OF NORSEMONT MINING. If answering all...

b. Draw the most parsimonious cladogram for the above taxa. Be sure to map all sven characters onto the tree. No Jaw CHAPTER 17 Cladistics and Taxonomy 215 NO JAW NO EYE TAIL PRESENT NOTAIL FIN...

What are the most common cash outflows related to investing and financing activities?

What is the unkind term for authoritarian governments that were sponsored by and supported by corporations in the United States? Hint: two words.

3. (10 points) Lakey Corporation has an activity-based costing system with three activity cost pools--Machining, Setting Up, and Other. The company's overhead costs have already been allocated to the...