Finance question scenario analysis

Assignment Help Finance Basics
Reference no: EM13828460

Problem:

Scenario Analysis

Consider a project to supply Detroit with 55,000 tons of machines screws annually for automobile production. You will need an initial $1,700,000 investment in threading equipment to get the project started. The project will last for 5 years.

The accounting department estimates that annual fix cost will be $520,000 and that variable costs should be $220 per ton; accounting will depreciate the initial fixed asset investment straight line to zero over the 5 year project life. It also estimates a salvage value of $300,000 after dismantling costs.

The marketing department estimates that the auto makers will let the contract at a selling price of $245 per ton. The engineering department estimates you will need an initial net working capital investment of 600,000. You require a 13 percent return and a face a marginal tax rate of 30 percent in this project.

  • What is the estimated OCF for this project? The NPV? Should you pursue this project?
  • Suppose you believe that the accounting department's initial cost and salvage projection are accurate only to within +/- 15 percent; the marketing department price estimate is accurate to within +/- 10 percent; and the engineering department's net working capital estimate is only accurate only to within +/- 5 percent. What is your worst case scenario for this project? Your best case scenario? Do you still want to pursue the project

Scenario Analysis

Students will read the scenario and then prepare a 3-4 page analysis that addresses the following:

  1. Calculate the estimated operating cash flow and net present value for this project.
  2. Explain how these calculations may impact the project.
  3. Based on the above information, recommend whether or not the project should be pursued. Provide a detailed rationale.
  4. Suppose you believe that the accounting department's initial cost and salvage value projections are accurate only to within + or - 15%; the marketing department's price estimate is accurate only to within + or - 10%; and the engineering department's net working capital estimate is accurate only to within + or - 5%. Discuss the best and worst case scenarios for this project.
  5. Based on the above information, recommend whether or not to pursue the project. Provide a detailed rationale.

Additional Information:

The assignment in finance is related to the cash flow and net present value. This is a case study regarding Detroit, a screw manufacturing company. The company is planning to invest on threading equipment and it desires to know how much of cash flow and net present value can be expected from this move. The company also desires to know the best, normal and worst case scenarios from this investment. All these have been computed in MS Excel sheet and stated in a document.

Reference no: EM13828460

Questions Cloud

Executive summary for your business plan : Write a one to three (1-3) page executive summary for your business plan, in which you justify: A clear and concise business concept. A thoroughly planned business concept
Combating external fraud through computer technology : Banking Security and Biometrics: Combating External Fraud through Computer Technology
Importance of quality in strategy formulation : Importance Of Quality In Strategy Formulation
Information audit in an organization : Information Audit In An Organization
Finance question scenario analysis : Consider a project to supply Detroit with 55,000 tons of machines screws annually for automobile production. You will need an initial $1,700,000 investment in threading equipment to get the project started. The project will last for 5 years.
Research project of company named conocophillips : Write a one paragraph summary about ConocoPhillips. Calculate the beta of the company.
Discuss the e-business model of al-jazeera english : Analyze and discuss the E-business model of Al-Jazeera English
Financial management multiple choice question : 1. High inventory turnover may signal poor efficiency or overstocking.
Corporate social responsibility explain : Corporate Social Responsibility Explain

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd