Caselet on scenario analysis

Assignment Help Finance Basics
Reference no: EM13828467

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.

a) What is the estimated OCF for this project? The NPV? Should you pursue this project?

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

The format of the report is to be as follows:

  • Typed, double spaced, Times New Roman font (size 12), one inch margins on all sides, APA format.
  • In addition to the 2-3 pages required, a title page is to be included. The title page is to contain the title of the assignment, your name, the course title, and the date.

Additional Information:

The assignment in finance is related to cash flow as well as net present value. This is a case study about 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: EM13828467

Questions Cloud

Caselet on analysing the implications to a firm : Task Name: Phase 2 Individual Project Deliverable Length: 4 slides each with 300 words of speaker notes Details: Your meeting is with Toto Matsui, the head of treasury, to discuss the international impact to the firm's capital structure.
Strategic planning longitudinal study strategic development : Strategic Planning Longitudinal Study In Strategic Development
Case study-bill miller-value trust : Description: The case study will combine elements of problem solving as well as requiring students to make a series of recommendations to the client.
Discuss the subject matter relevant to the class and issues : Critique the movie "CRASH." Discuss the subject matter relevant to the class and issues related to diversity, e.g. race/ethnicity, stereotypes, gender, class, policing, public service
Caselet on 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.
Assessment of corporate social responsibility : Assessment Of Corporate Social Responsibility And Its Implications On Corporate Law And Governance
Define foreign company acquisition : Define foreign company acquisition. What firm will ACME acquire in Europe
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

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