Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Business Economics Expert

Q. Sensitivity Analysis: using excel

Lane Construction ltd. is considering the acquisition of a new eighteen wheeler.

-The truck base price is $80,000 and it will cost another $20,000 to modify it for special use by the company.

-This truck falls into MACRS five year class. It will be sold after three years for $30,000.

-The truck purchase will have no effect on revenues, but it is expected to save the firm $45,000 per year in before-tax operating costs, mainly in leasing expenses.

-The firm marginal tax rate (federal plus state) is 40%, and its MARR is 15%.

(a) Is this project acceptable, based on the most likely estimates given in the problem?

(b)If the firm's MARR is increased to 25%, what would be the required savings in leasing so that the project would remain profitable?

Business Economics, Economics

  • Category:- Business Economics
  • Reference No.:- M9158337

Have any Question?


Related Questions in Business Economics

Indifference curve and budget lineannie has an income of

Indifference Curve and Budget Line Annie has an income of $180 an hour. Popcorn costs $6 a bag, and costs $4 a six-pack cola a. Draw a graph of Annie's budget line with six-pack of  cola on the x-axis , and popcorn on th ...

According to the center for disease control the mean total

According to the center for Disease Control, the mean total cholesterol for men between the ages of 20-29 is 180 milligrams per deciliter with a standard deviation of 36.2. A healthy total cholesterol level is less than ...

In your opinion if the government imposes unit sales tax ie

In your opinion, if the government imposes unit sales tax (i.e. $ tax per unit sold) on a product, will the market equilibrium change? Which one, demand or supply will shift? Increase or decrease? Will new tax cause "dis ...

At a college 66 of courses have final exams and 56nbsp of

At a college, 66 % of courses have final exams and 56 % of courses require research papers. Suppose that 45 % of courses have a research paper and a final exam.  Find the probability that a course has NONE of these two r ...

Explain and discuss the following quotepoliticians can be

Explain and discuss the following quote: "Politicians can be strange. They have been calling for the breakup of firms as diverse as energy companies and tech giants like Microsoft and Google because they believe these co ...

Marketing firm specializes in assessments of local

Marketing firm specializes in assessments of local restaurants and have been asked to rate local restaurants. The restaurants are rated as good, fair, or poor. From the firm's rating system, 72% of the restaurants were r ...

A mixture of three water samples will test positive for a

A mixture of three water samples will test positive for a contaminant if at least one of the samples contains it. If the contaminant is present in 7% of samples, find the probability that: 1. The mixture tests positive: ...

Suppose a consumer is trying to make a choice over the

Suppose a consumer is trying to make a choice over the consumption of two goods: x and y. Px = 3, Py = 4 and the income is equal to 50. Assume that the government distributes some stamps that are good to buy 5 units of g ...

The below figure represents the potential outcomes of your

The below figure represents the potential outcomes of your first salary negotiation after graduation. Assuming this is a sequential-move game with the employer moving first, indicate the most likely outcome. Does the abi ...

Out of 140 randomly selected kindergartners who were

Out of 140 randomly selected kindergartners who were surveyed, 32 said that pancakes are their favorite breakfast food. Construct and interpret a 90% confidence interval for the percentage of all kindergartners who say p ...

  • 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