Question

Blooper’s analysts have come up with the following revised estimates for its magnoosium mine:

Range

Pessimistic Optimistic
Initial investment + 30 % 25 %
Revenues 25 % + 20 %
Variable costs + 25 % 15 %
Fixed cost + 50 % 50 %
Working capital + 30 % 45 %

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.)

Excel File Edit Tools Data Window Help 35% D Fri 10:56 PM View Insert Format OUES оос AutoSave OFF Q Spreadsheet_10_1 Acrobat

0 0
Add a comment Improve this question Transcribed image text
Answer #1

revenue variable cost fixed cost 15000 60001 40001 0 1 2 2. 3 4 6 year investment in fixed assets terminal value - 10,000 NPV

please upvote of it helped

thanks

comment for doubts

Add a comment
Know the answer?
Add Answer to:
Blooper’s analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • B H A. Inputs Initial investment ($ thousands) Salvage value ($ thousands) Initial revenues ($ thousands) Variable cost...

    B H A. Inputs Initial investment ($ thousands) Salvage value ($ thousands) Initial revenues ($ thousands) Variable costs (% of revenues) Initial fixed costs ($ thousands) Initial total expenses ($ thousands) Inflation rate (%) 10,000 2,000 15,000 40.0% 4,000 10,000 5.0% 12.0% Discount rate (%) Receivables (% of sales) 16.7% Inventory (% of next year's costs) Tax rate (%) 15.0% 35.0% 31 Year: 0 1 2 4. 5 6 B. Fixed assets Investments in fixed assets 10,000 Sales of fixed...

  • Finefodder's analysts have come up with the following revised estimates for the Gravensteln store

    Finefodder's analysts have come up with the following revised estimates for the Gravensteln store: 15 Investment Sales variable costs as % of Pessimistic Expected Optimistic $5,300,000 $5,100,000 $ 4,680,000 10,000,000 18,000,000 22,000,000 Print 75 73 71 ReferencesFixed cost $ 2.200,000 $ 2.100,000 S 1900,000 Assume the project life is 12 years, the tax rate is 40%, the discount rate is depreciation method is straight-line over the project's life. Conduct a sensitivity analysis for each variable and range and compute the NPV for...

  • Bayside Industries lnc. is evaluating an expansion project to establish its presence in a key market...

    Bayside Industries lnc. is evaluating an expansion project to establish its presence in a key market for its products. you have collected the following data on the proposed project. 1. The project requires $25 million in initial capital investment, and will have an economic life of 5 years. The investment will be straight-line depreciated down to a book value of zero at the end of 5 years. The investment is expected to be salvaged for $5 million at the end...

  • Hello I need the answers to this. 0 5 Documenti - Word 0 - X AutoSave...

    Hello I need the answers to this. 0 5 Documenti - Word 0 - X AutoSave Off File Home 5 5 Insert 0 Share Design Layout References Mailings Review View Help Tell me what you want to do Cash Flow From Assets (CFFA) Problems: Calculate each step of the cash flow from assets: (1) Operating Cash Flow, (2) Net Capital Spending, (3) Changes in Net Working Capital, (4) Cash Flow from Assets, (5) Cash Flow to Creditors, and (6) Cash...

  • You have just been hired by Internal Business Machines Corporation (IBM) in their capital budgeting division....

    You have just been hired by Internal Business Machines Corporation (IBM) in their capital budgeting division. Your first assignment is to determine the free cash flows and NPV of a proposed new type of tablet computer similar in size to an iPad but with the operating power of a high-end desktop system. Development of the new system will initially require an initial capital expenditure equal to 10% of IBM’s Property, Plant, and Equipment (PPE) at the end of fiscal year...

  • please help. File Home Insert Page Layout Formulas Data | - 10-AN = Paste * Cut...

    please help. File Home Insert Page Layout Formulas Data | - 10-AN = Paste * Cut Ca Copy Format Painter Clipboard D23 Font НА ЛИ UBLIC 1 Homework Assignment 2 Data Sheet Assumptions 2017 2016 650 935 50 25 5 Accounts payables 885 6 Accounts receivables 950 7 Net Sales 7,800 5,500 8 Common stock 350 350 9 Operating costs 5,243 3,756 10 Gross fixed assets 4,500 3,500 11 Interest expense 12 Long-term debt 2,000 1,800 13 Depreciation & amortization...

  • A business is analyzing a proposed 5-year project using standard sensitivity analysis. They expects to sell...

    A business is analyzing a proposed 5-year project using standard sensitivity analysis. They expects to sell 23,000 units, ±5 percent. The expected variable cost per unit is $21.20 and the expected fixed costs are $150,000. The fixed and variable cost estimates are considered accurate within a ±5 percent range. The sales price is estimated at $35.60 a unit, ±5 percent. The project requires an initial investment of $324,000 for equipment that will be depreciated using the straight-line method to zero...

  • Agritech Company is analyzing a proposed 5-year project using standard sensitivity analysis. The company expects to...

    Agritech Company is analyzing a proposed 5-year project using standard sensitivity analysis. The company expects to sell 27,000 units, ±5 percent. The expected variable cost per unit is $20.80 and the expected fixed costs are $160,000. The fixed and variable cost estimates are considered accurate within a ±5 percent range. The sales price is estimated at $36.00 a unit, ±5 percent. The project requires an initial investment of $320,000 for equipment that will be depreciated using the straight-line method to...

  • My balance sheet is wrong in part 3 as you can see. I need some help...

    My balance sheet is wrong in part 3 as you can see. I need some help fixing that please. I also need some help in placing the proper things in the income statement. File Home Thselt Page Layout Formulas Data Review View Developer Help Shale Lomments 2 D E' 47 5 Times New Roman ~ 11 BIU - Font A A A- === du SE alle Wrap Text E Merge & Center - General $ -% 3 Insert" Delete Format...

  • Large Manufacturing, Inc. is considering investing in some new equipment whose data are shown below. The...

    Large Manufacturing, Inc. is considering investing in some new equipment whose data are shown below. The equipment has a 3-year class life and will be depreciated by the MACRS depreciation system, and it will have a positive pre-tax salvage value at the end of Year 3, when the project will be closed down. Also, some new working capital will be required, but it will be recovered at the end of the project's life. Revenues and cash operating costs are expected...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT