Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bloopers analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic Initial investment + 45 % 25 % Revenues

Bloopers analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic Initial investment + 45 % 25 % Revenues 15 % + 25 % Variable costs + 25 % 25 % Fixed cost + 20 % 25 % Working capital + 20 % 30 % Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanying data as a starting point for the analysis. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answers in thousands rounded to the nearest whole dollar.) Bloopers analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic Initial investment + 45 % 25 % Revenues 15 % + 25 % Variable costs + 25 % 25 % Fixed cost + 20 % 25 % Working capital + 20 % 30 % Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanying data as a starting point for the analysis. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answers in thousands rounded to the nearest whole dollar.) Spreadsheet info: Initial investment 15000 Salvage value 2000 Initial revenues 15000 Variable costs (% of revenues) 40.0% Internal fixed costs 4000 Inflation rate 5.0% Discount rate 12.0% Receivables (% of sales) 16.7% Inventory (% of next years costs) 15.0% Tax rate 21.0%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Trade In Stocks

Authors: Jesse Livermore

1st Edition

0071469796, 9780071469791

More Books

Students also viewed these Finance questions