How does irr vary when differential resale value is given

Assignment Help Engineering Mathematics
Reference no: EM131507153

Question: Refer to Problem. Set up a spreadsheet to answer various "what if" questions such as "How does the IRR vary as the cost of gasoline takes on these values: $3.00 per gallon, $4.00 per gallon, and $5.00 per gallon?" Also, how does IRR change when the ownership period changes across this range: 3 years, 4 years, 5 years, 6 years, and 7 years? How does the IRR vary when the differential resale value is $1,000, $2,000, $3,000, and $4,000?

Problem: Are you thinking of bypassing a gasoline fueled car in favor of a hybrid (gasoline and electric) automobile? Let's take a look at the relative economics of your possible choice. The gasoline-fueled car sells for $20,000 and gets 25 miles per gallon (mpg) of fuel. The alternative hybrid vehicle sells for $25,000 and averages 46 mpg. The resale value of the hybrid car is $2,000 more than that of the gasoline-only car after five years of anticipated ownership. If you drive 15,000miles per year and gasoline costs $4.00 per gallon, what is the internal rate of return on the incremental investment in the hybrid automobile?

Reference no: EM131507153

Questions Cloud

Applying for a cashback credit card : A person with a FICO credit score of 790 is applying for a cashback credit card.
What the expected earnings per share under each alternative : What are the earnings per share under each estimated level of EBIT if shares are issued? What are the expected earnings per share under each alternative
Interface by using the debug feature : Save your application (in Visual Basic), test your interface by using the DEBUG feature, and apply edits as needed. Save the file after applying any edits.
Create a new application and apply : Create a new application and apply what you learned in this unit to the new application. Be sure to add the following to your interface:
How does irr vary when differential resale value is given : Refer to Problem. Set up a spreadsheet to answer various "what if" questions such as "How does the IRR vary as the cost of gasoline takes on these values.
Administrator for a large manufacturing enterprise : You're the head network administrator for a large manufacturing enterprise that's completing its support for IPv6.
The four year installment plan do not start for full year : How will your answer change if the payments on the 4-year installment plan do not start for a full year?
Design lifecycle of a website : Outline the role played by the user in the design Lifecycle of a website:
What is yield to maturity : what is its yield to maturity?

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Prime number theorem

Dirichlet series

  Proof of bolzano-weierstrass to prove the intermediate value

Every convergent sequence contains either an increasing, or a decreasing subsequence.

  Antisymmetric relations

How many relations on A are both symmetric and antisymmetric?

  Distributed random variables

Daily Airlines fies from Amsterdam to London every day. The price of a ticket for this extremely popular flight route is $75. The aircraft has a passenger capacity of 150.

  Prepare a system of equations

How much money will Dave and Jane raise for charity

  Managing ashland multicomm services

This question is asking you to compare the likelihood of your getting 4 or more subscribers in a sample of 50 when the probability of a subscription has risen from 0.02 to 0.06.]  Talk about the comparison of probabilities in your explanation.

  Skew-symmetric matrices

Skew-symmetric matrices

  Type of taxes and rates in spokane wa

Describe the different type of taxes and their rates in Spokane WA.

  Stratified random sample

Suppose that in the four player game, the person who rolls the smallest number pays $5.00 to the person who rolls the largest number. Calculate each player's expected gain after one round.

  Find the probability density function

Find the probability density function.

  Develop a new linear programming for an aggregate production

Linear programming applied to Aggregate Production Planning of Flat Screen Monitor

  Discrete-time model for an economy

Discrete-time model for an economy

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