Question: PART 3A: Use the Excel cells from Part 1 above to run a sensitivity analysis on revenue growth. Recall from above the high case has

PART 3A: Use the Excel cells from Part 1 above to run a sensitivity analysis on revenue growth. Recall from above the high case has 8% revenue growth, base case is 5% and low case is 2%. Re-calculate NPV, IRR and Payback period for the high and low case and correctly fill out this table.
Sensitivity Analysis Table Growth (%) NPV ($'s) IRR (%) Payback
Low Growth 2% 527,634.86 11.27% 4.26
Base Case (from part 1A) 5% 536,312.48 12.67% 4.20
High Growth 8% 545,320.32 14.07% 4.14

As the firm's CFO, how would you explain the sensitivity analysis on revenue growth? What insights do you see?

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 General Management Questions!

Q:

A soil element is shown in Figure 10.33. Determine the following: a. Maximum and minimum principal stresses b. Normal and shear stresses on plane AB Use Eqs. (10.3), (10.4), (10.6), and (10.7). 128...

Q:

PART 3A: Use the Excel cells from Part 1 above to run a sensitivity analysis on revenue growth. Recall from above the high case has 8% revenue growth, base case is 5% and low case is 2%. Re-calculate...

Q:

1) Useful life of the equipment (years) 4 2) New equipment cost* $(200,000) 3) Equipment ship & install costs* $ (35,000) 4) Related equipment start-up costs* $ (5,000) 5) Inventory increase $ 25,000...

Q:

B 15 16 1) Useful life of the equipment (years) 17 2) New equipment cost* 18 3) Equipment ship & install costs* C 19 4) Related equipment start-up costs* 20 5) Inventory increase. 21 6) Accounts...

Q:

Assignment Learning Objectives: (a) Develop a proforma project income statement using an Excel spreadsheet (b) Compute net project cash flows, NPV, IRR and Payback period (c) Perform sensitivity and...

Q:

I need hlep with formula to input the nubers thank you PART 1A: Use the Excel cells below to calculate all estimated project cash flows for the BASE CASE revenue growth. Then solve for the NPV, IRR...

Q:

In this assignment, you are evaluating a potential capital investment project that has a 4 year life. The financial details are as follows: 1) Useful life of the equipment (years) 4 2) New equipment...

Q:

Assignment Leaming Objectlves: (a) Develop a proforma project income statement using an Excel spreadsheet (b) Compute net project cash flows, NPV, IRR and Payback period (c) Perlorm sensitivity and...

Q:

00 100 growty base case is 5% and low case is 2%. Re-calculate NPV, IRR and Payback period for the High and low cute and correctly fill out this tablo. Sensitivity Analysis Table Growth (%) NPV ($'s)...

Q:

please fill in andwers in the yellow cells Toefield Inc. has developed a powerful efficient snow remover that is significantly less polluting than existing snow removers currently on the market. The...

Q:

Please show XL work and how you plugged it in thanks. 4 12 13 5 Webmasters.com has developed a powerful new server that would be used for corporations' Internet 6 activities. It would cost $10...

Q:

On December 31, 2010, Ramey Associates owned the following securities, held as a long-term investment. The securities are not held for influence or control of the investee. On December 31, 2010, the...

Q:

"If two separate companies were each to lease identical capital assets under identical lease terms, the finance lease criteria used under International Financial Reporting Standards will ensure that...

Q:

7. Discuss the accounting for sales allowances and how they relate to the concept of variable consideration.

Q:

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...