Last problem (the depreciation problem) is pretty easy. Put a slider in for t years it takes for it to depreciate in value. (If it takes 5 years, put 5 in denominator). Then plug in 1 for t to calculate annually. So if you plug in the original value 100, after 1 year, it depreciates down to 87. So that means it is 13% less in value.