Conduct sensitivity analysis for revenues

Assignment Help Financial Management

Reference no: EM131303686

Conduct a sensitivity analysis for revenues by increasing revenues by 10% above the best estimate, and then by decreasing revenues by 10% below the best estimate. MAXIMIZE THE USE OF FORMULAS! The SCFE Co. wants to add a production line. To do this, the company must spend $200,000 to expand its current building and purchase $1 million in new equipment. The new production line is expected to produce 100,000 units per year of a new product, which has a projected sales price of $7.75 per unit and a variable cost of $3.90 per unit. Introducing the new product is expected to cause sales of existing products to decrease by $89,000 per year and existing costs to decline by $49,000 per year. Fixed costs of the new line will be $142,000 annually. The company expects net working capital to increase by $1,800,000 when the new line is added, and then decrease by that amount when the project ends in five years. SCFE also expects to sell the equipment and building space at the end of the project in five years to net $320,990.36 after taxes. The company has a 34 percent marginal tax rate. SCFE’s cost of capital is 11%. Depreciation would be as follows, • Year 1: $206,349.20 • Year 2: $326,349.20 • Year 3: $198,349.20 • Year 4: $121,549.20 • Year 5: $121,549.20 NOTE: Always remember to maximize the use of formulas!

Reference no: EM131303686

Questions Cloud

Computes the inner product of two lists : Write and test a function shuffle(myList) that scrambles a list into a random order, like shuffling a deck of cards.

A force f is applied at the tip of the uniform bar element : A force F is applied at the tip of the uniform bar element shown in the figure.- Compare the tip displacement with that from the linear elastic model when (a) E = 700 MPa and (b) E = 70GPa.

Fixed costs of this product and variable costs per unit : Gork Musical Instruments produces several products, one of which is facing increasing competition from cheaper, plastic alternatives. It expects that in coming years the number of units sold will fall by 10% pa. Gork expects that in the coming years..

Provide an analysis of technologies social implications : Social and ethical implications. Without disclosing your personal view about this technology, provide an analysis of its social and ethical implications.

Conduct sensitivity analysis for revenues : Conduct a sensitivity analysis for revenues by increasing revenues by 10% above the best estimate, and then by decreasing revenues by 10% below the best estimate. MAXIMIZE THE USE OF FORMULAS! The SCFE Co. wants to add a production line.

The relevant market interest rate for both bonds : Consider 2 bonds, A and B. The coupon rates are 10% and the face values are $1,000 for both bonds. Both bonds have annual coupons. Bond A has 20 years to maturity while Bond B has 10 years to maturity. What are the prices of the 2 bnds if the relevan..

Write a program that prompts a user for n : The algorithm continues by announcing that 5 is prime and removing it from the list. Finally, 7 is announced and removed, and we're done.

Calculate the tip displacement : Calculate the tip displacement by solving the total Lagrangian variational equation with the St. Venant-Kirchhoff nonlinear elastic material model.

Physicians on staff at metropolis health system : John Whitten is one of the physicians on staff at Metropolis Health System. His practice is six years old. He has set up an office savings account to accumulate the funds to replace equipment in his practice. Today John is trying to figure what his e..

User Account

All Pages