Qsensitivity analysis using excellane construction ltd is, Ask an Expert

Economics

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?

View complete question

Business Economics, Economics

Category:- Business Economics
Reference No.:- M9723495

Have any Question?Write your Review or question?

Related Questions in Business Economics

The demand for salt is relatively price inelastic while the

The demand for salt is relatively price inelastic, while the demand for pretzels is relatively price elastic. How can you best explain why and elaborate your answer.

I need some help trying to understand this statistics

I need some help trying to understand this Statistics question For a normal distribution, identify the z -score location that would separate the distribution into two sections, as determined by the following percentages ...

Pure gasoline has an energy density of 115600 btu per

Pure gasoline has an energy density of 115,600 BTU per gallon, while ethanol has an energy density of 75,670 BTU per gallon. Gasoline cost $3.70 per gallon. What would the price of E85 (85% ethanol, 15% gasoline) have to ...

If two samples a and b had the same mean and sample size

If two samples A and B had the same mean and sample size, but sample A had a larger standard deviation, which sample would have the wider 95% confidence interval?

With most of the worlds nations either having moved to

With most of the world's nations either having moved to market economies, does the nationalization of foreign industries and property have its place?

Consider the market for small business loans in the context

Consider the market for small business loans. In the context of this market. How adverse selection impact lenders. How does adverse selection impact borrowers? In the context of this market provide 2 things that a lender ...

Magenta corporation wants to raise 508 million in a

Magenta corporation wants to raise 50.8 million in a seasoned equity offering, net of all fees. Magenta stock currently sells for $14 per share. The underwriters will require a spread of $.50 per share, and indicate that ...

A sample of 100 randomly selected students found that the

A sample of 100 randomly selected students found that the proportion of students planning to travel home for Thanksgiving is 0.68. What is the Standard Deviation of the sampling distribution?

A forced-choice design is often used to compare the

A forced-choice design is often used to compare the attractiveness of pheromones to insects. A Y-tube is used. The pheromone is place on one branch; the control on the second branch; and the insect on the third branch. T ...

A firm undergoes a learning curve over its first few years

A firm undergoes a learning curve over its first few years of existence In its first year, its cost function is C(Q)= 128 + 3Q + 2q 2 with MC= 3 + 4Q In its second year, its cost function is C(Q)= 100 + 2Q + q 2 with ...

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

Recent Questions

Ask Business Economics Expert