You will need to use the PV function in Excel or a financial calculator. In Excel the present value of a stream of monetary cash flows is given by -PV(rate, number of payments, payment amount) where rate is the interest rate. We enter the payment in Excel as a positive number. You can also compute the carbon cost per year and then discount those five values back to the present.

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)
14th Edition
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Chapter8: Cost Analysis
Section: Chapter Questions
Problem 3E
icon
Related questions
Question

Suppose I have computed the cost of carbon per mile for my car at 0.011 per mile. Assume that the interest rate is 5% and that I drive the car 30,000 miles per year. What is present value of the carbon expense for five years? You will need to use the PV function in Excel or a financial calculator. In Excel the present value of a stream of monetary cash flows is given by -PV(rate, number of payments, payment amount) where rate is the interest rate. We enter the payment in Excel as a positive number. You can also compute the carbon cost per year and then discount those five values back to the present.

Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Tax Rates
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning