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.
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
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning