Effects of Both Positive and Negative Salvage Values Assignment | Homework For You
Can you Plot the Graph in Excel with those expressions please.
A renewable energy electricity supply technology has the following characteristics: Lifetime (years) Salvage value ($) Capital cost ($) Annual operating cost ($) Annual electricity supplied (MWh) 380 000 29 500 42 000 80
1. Using the figures in the table as a baseline, work out an expression for Present Worth with real discount rate, assessment period, salvage value, and electricity price as independent variables. Then changing just one variable at a time (other things being kept equal) plot graphs of Present Worth versus each of these variables. Use a range of assessment periods up to the lifetime of the technology. Explore the effects of both positive and negative salvage values. Get Finance homework help today