Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Statistics and Probability Expert

Please calculate in an excel document:

Your company is evaluating new equipment that will cost $2,000,000. The equipment is in the MACRS 3-year class and will be sold after 3 years for $150,000. Use of the equipment will increase net working capital by 200,000.   The equipment will save $900,000 in operating costs each year for 3 years. The company's tax rate is 35 percent and its cost of capital is 12%.

Part a. Calculate the cash flow in Year 0.

Part b. Calculate the incremental operational cash flows.

Reference: MACRS Depreciation Percentages for three-year class life assets:

0.3333 0.4445 0.1481 0.0741

c. Calculate the non-operating terminal year cash flow.

Part d. Calculate the project's payback period.

Part e. Calculate the project's NPV.

Part f. Calculate the project's IRR.

Part g. Calculate the project's MIRR.

Part h. Investment Decision: Should the project be accepted or rejected? Why or why not?

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M92469418
  • Price:- $20

Priced at Now at $20, Verified Solution

Have any Question?


Related Questions in Statistics and Probability

A company that manufactures gasoline station pumps must

A company that manufactures gasoline station pumps must ensure that it pumps at least 1 gallon of gasoline 84% of the time. If the population of pump amounts for a particular pump is normally distributed with mean μ and ...

David barnes and his fianceacutee valerie shah are visiting

David Barnes and his fiancée Valerie Shah are visiting Hawaii. There are 38 guests registered for orientation. It is announced that 20 randomly selected registered guests will receive a free lesson of the Tahitian dance. ...

1 summary statistics for returns on two stocks x and y are

1. Summary statistics for returns on two stocks X and Y are listed below. Mean Variance Stock X 2.83% 0.006000 Stock Y 5.98% 0.003000 The covariance of returns on stocks X and Y is 0.001500. Consider a portfolio of 80% s ...

A coin is flipped five times in an experiment if x is the

A coin is flipped five times in an experiment. If x is the number of heads that turn out in the experiment, what is the set of possible values of variable x?

Jen and barry perform a survey of consumers about home meal

Jen and Barry perform a survey of consumers about home meal salad preferences ("fresh" or "fast"). 395 consumers said they prefer to make fresh salad. 426 said they prefer to make salad fast (out of a bag). 331 said they ...

Given the probability distribution functionx 0 1

Given the probability distribution function: x 0 1 2 Probability 0.25 0.50 0.25 a. Graph the probability distribution function. b. Calculate and graph the cumulative probability distribution. c. Find the mean of the rand ...

Taylor found that 8 of the recipients of loans from a

Taylor found that 8% of the recipients of loans from a particular mortgage lending institute default within the first 3 years. If he takes a random sample of 4 customers, who received loans 3 years ago, what is the proba ...

A national center for health statistics report based on

A National Center for Health Statistics report based on 1985 data states that 30 percent of American adults smoke. Consider a simple random sample of 17 adults. Find the probability that the number of smokers in the samp ...

Parents who did not finish high school have sat math scores

Parents who did not finish high school have SAT math scores X with mean 451 and standard deviation 103. Scores Y of children of parents with graduate degrees have mean 567 and standard deviation 104. Perhaps we should st ...

Jen and barry get sued by ben amp jerrys for trademark

Jen and Barry get sued by "Ben & Jerry's" for trademark infringement. Jen and Barry lose, and they need a LOT of money. They decide to play Tennetucky's "Mega-6" lottery. They'll win the jackpot if they correctly choose ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As