HomeworkLib
Question

B H A. Inputs Initial investment ($ thousands) Salvage value ($ thousands) Initial revenues ($ thousands) Variable costs (% oBloopers analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic 25

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 assets 1,300 Cash flow from fixed assets -10,000 1,300 C. Operating cash flow 16,538 6,615 4,410 2,000 15,000 Revenues 15,750 17,364 18,233 Variable expenses 6,300 6,000 6,946 7,293 Fixed expenses 4,631 4,000 4,200 4,862 2,000 Depreciation 2,000 2,000 2,000 Pretax profit 3,513 3,788 4,078 3,000 3,250 1,229 1,138 1,326 Tax 1,050 1,427 Profit after tax 2,462 2,650 1,950 2,113 2,283 4,283 Operating cash flow 3,950 4,113 4,462 4,650 D. Working capital Working capital Change in working capital Cash flow from investment in working capital 4,493 4,279 1,500 4,075 4,717 3,039 0 214 -214 1,500 -1,679 2,575 204 225 -3,039 -1,500 -2,575 -204 -225 1,679 3,039 0.408 0.408 0.408 0.408 0.250 E. Project valuation Total project cash flow 1,375 6,329 -11,500 3,909 4,069 4,238 4,339
Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic 251 polnts 45 Initial investment Revenues Skipped Variable costs Fixed cost Working capital -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 calcu lations. Negative amounts should be indicated by a minus sign. Enter your answers in thousands rounded to the nearest whole dollar.) еВok Print Project NPV Pessimistic Expected Optimistic Initial investment Revenues Variable costs Fixed costs Working capital
business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Answer attached in the Excel Spread Sheet

Year 0 1 2 3 4 5 6 Fixed Asset Investment in Fixed Asset 10000 Sale of Fixed Asset 1300 Cash Flow from Fixed Asset -10000 130Year 4 0 1 5 6. Fived Asset Investment in Fixed Asset Sale of Fixed Asset 14500 1300 -14500 Cash Flow from Fixed Asset 1300 TYear 4 0 1 5 6. Fived Asset Investment in Fixed Asset Sale of Fixed Asset 14500 1300 -14500 Cash Flow from Fixed Asset 1300 TProject NPV Pessimestic Expected Optimestic Initial Investment Revenue Variable Cost Fixed Cost Working Capital 10,000 14,500

0 1
Add a comment
Know the answer?
Add Answer to:
B H A. Inputs Initial investment ($ thousands) Salvage value ($ thousands) Initial revenues ($ thousands) Variable cost...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

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

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

  • A new project will cost $100,000. It will yield new sales revenues of $496,000, but will...

    A new project will cost $100,000. It will yield new sales revenues of $496,000, but will increase annual variable costs by $416,000 and annual fixed costs by $15,000. The project will also require initial investment of $22,000 in net working capital. The project will last for three years, and depreciation will be straight-line to zero. Interest expense will be $5,000. Given that the required rate of return on this project is 18%, and the marginal corporate tax rate is 40%,...

  • Your company is evaluating an investment opportunity that will require an initial cash outlay of $10,000....

    Your company is evaluating an investment opportunity that will require an initial cash outlay of $10,000. It is anticipated that the investment will generate $2,000 in added annual revenues for 10 years. The cost of capital for the project is 10%. Examples of cash flow considerations: (based on the project described above) For each of the project details provided below, indicate whether 1) It should be included in calculating the company’s NPV for the project, and 2 ) How the...

  • A project requires an initial fixed asset investment of $600,000, which will be depreciated straight-line to...

    A project requires an initial fixed asset investment of $600,000, which will be depreciated straight-line to zero over the six-year life of the project. The pre-tax salvage value of the fixed assets at the end of the project is estimated to be $50,001. Projected sales volume for each year of the project is shown below. The sale price is $50 per unit for the first three years, and $45 per unit for years 4 through 1. A $30,000 initial investment...

  • H. Cochran, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment...

    H. Cochran, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2,350,000. The fixed asset will be depreciated straight-line to zero over its three-year tax life. The project is estimated to generate $2,290,000 in annual sales, with costs of $1,310,000. The project requires an initial investment in net working capital of $160,000 and the fixed asset will have a market value of $195,000 at the end of the project. Assume that the tax...

  • Project A $13,000 Project B $13.000 Initial investment (CF) Annual cash inflows (CF) Outcome Pessimistic Most...

    Project A $13,000 Project B $13.000 Initial investment (CF) Annual cash inflows (CF) Outcome Pessimistic Most likely $1,500 $810 1,650 1,650 Optimistic 2.460 1,790 a. Determine the range of annual cash inflows for each of the two projects b.Assume that the firm's cost of capital is 9.8% and that both projects have 19-year lives. Construct a table showing the NPVS for each project for each of the possible outcomes. Include the range of NPVS for each project c. Do parts...

  • Jarstrom, Inc., is considering a project that will require an initial investment of $10,000 and will...

    Jarstrom, Inc., is considering a project that will require an initial investment of $10,000 and will return a perpetual cash flow of $1,200. Compute its NPV assuming k = .10. a. 0 b. $2,000 c. $8,800 d. $10,000 Suppose you are considering a project with $10,000 initial investment. You estimate that the project will generate a level cash flow of $1,200 per year for 15 years. At the end of the 15th year, the project will be liquidated for $3,000....

  • Intro Consider a project with a 4-year life. The initial cost to set up the project...

    Intro Consider a project with a 4-year life. The initial cost to set up the project is $100,000. This amount is to be linearly depreciated to zero over the life of the project and there is no salvage value. The required return is 15% and the tax rate is 34%. You've collected the following estimates: Base case Pessimistic Optimistic Unit sales per year (Q) 7,000 5,000 9,000 Price per unit (P) 50 4 0 Variable cost per unit (VC) 20...

  • Q3. (25 marks) A project requires an initial fixed asset investment of $600,000, which will be...

    Q3. (25 marks) A project requires an initial fixed asset investment of $600,000, which will be depreciated straight-line to zero over the six-year life of the project. The pre-tax salvage value of the fixed assets at the end of the project is estimated to be $50,001. Projected sales volume for each year of the project is shown below. The sale price is $50 per unit for the first three years, and $45 per unit for years 4 through 1. A...

  • A four-year project requires an initial investment of $208,000 for fixed assets and $19,500 for net...

    A four-year project requires an initial investment of $208,000 for fixed assets and $19,500 for net working capital. All of the net working capital will be recouped at the end of the project. The annual operating cash flow is $76,200 and the discount rate is 6.00 percent. I. Create a timeline/chart to identify the relevant Cash Flows and their timing II. Use the Cash Flows for the following analysis: a) What is the Payback Period? b) What is the NPV?...

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