Make tornado diagram from the sensitivity analysis

Assignment Help Finance Basics
Reference no: EM133116995

Sensitivity Analysis

 

Pessimistic 

Optimistic(10% positive) 

Revenue 

2539026.00

=2539026*(1+10%)

=2792928.60

Variable cost

=2539026*40%

=1015610.40

=1015610.4*(1-10%)

=914049.36

Fixed cost

224936

=224936*(1-10%)

=202442.40

Earning (A)

1298479.6

1676436.84

Initial investment (B)

368912

368912

Working capital(C)

-336.44

-336.44

NPV=A-B-C

$929904.04

$1307861.28

Make Tornado diagram from the sensitivity analysis and explain the diagram 

Reference no: EM133116995

Questions Cloud

Perform better than with low profit margin : Some investors believe the stocks with high profit margin should perform better than those with low profit margin. Do you agree? Please examine this notion base
Potential quasi-arbitrage opportunities : Some investors believe QYLD is shorting QQQ put options. Do you agree? Are there any potential quasi-arbitrage opportunities?
Which department should be closed : The $39,000 amount was allocated to A, B, and C on the basis of sales revenue. Which department(s), if any, should be closed if none of the fixed operating cost
Assessing the cash flows after the fifth year : A project's annual (operating) cash flows for the next five years are: R1.2 million, R1.4 million, R1.7 million, R2 million, and R2.5 million.
Make tornado diagram from the sensitivity analysis : Make Tornado diagram from the sensitivity analysis and explain the diagram
Prepare a bank reconciliation for Elloit checking account : The ending cash balance recorded in the bank statement is $13,145. Prepare a bank reconciliation for Elloit's checking account as of February, 28th
Means of reaching the different financial goals : After developing a case providing above mentioned information, prepare a solution to provide answers as to means of reaching the different financial goals by ma
Encouraging financial institutions : 1) What factors are encouraging financial institutions to offer overlapping financial services such as banking, investment banking, brokerage, etc.?
What is the current price of bond : It has a 20-year maturity, its annual coupon rate is 8 percent, and it is selling to yield 6 percent. What is the current price of the bond?

Reviews

Write a Review

Finance Basics Questions & Answers

  Find out the market price of the stock

New common stock for which the most recent dividend was $3.40. The company's dividend per share should continue to increase at a 9 percent growth rate into the

  Steady suppliers is one of the wavemakers category

Steady Suppliers is one of the wavemakers category? Please describe, Steady Suppliers, and give example. How does its role in solution economy today?

  What is the expected return on the dollar investment

Suppose that the annual interest rate on a dollar account in the U.S. is 4%, the interest rate on a euro account in Europe is 6%. The expected future exchange r

  Appropriate valuation for accessline

What is an appropriate valuation for AccessLine? Do analyses using the Venture Capital Method (target discount rate = 60%), the Comparable Companies Method, and

  What was the value of his ira at the end of 6 years

a) What was the value of his IRA at the end of 6 years? b) What was the value of the investment at the end of the next 7 years?

  Find the book value of the asset

A project requires $429,473 of equipment that is classified as 7-year property. What is the book value of this asset at the end of year 3 given the following.

  Who regard it as very well managed and not very risky

Since Giant's management would be running the entire enterprise after a merger, investors would value the resulting corporation based on Giant's P/E. If Micro has 10 million shares outstanding, by how much should the merger increase its share price, ..

  What will your monthly payment be

You want to buy a new sports car from Muscle Motors for $43,000. The contract is in the form of a 60-month annuity due at a 6.25 percent APR.

  You expect to deposit 55000 today and then in 2 years to

you expect to deposit 55000 today and then in 2 years to deposit an additional 24000 into a savings account. how much

  Calculate the volatility of stock returns per annum

Calculate the volatility of stock returns per annum. Use the 252 days per year default.

  What is the present value if the first payment

The interest rate is 8%. What is the present value if the first payment comes immediately?

  What is the present value of cash? flows

If you require a 14 percent rate of? return, what is the present value of these cash? flows? (Round to the nearest whole? dollar)

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