How to waste a lot of money. The spreadsheet below shows what would happen if you got hooked on cigarettes, a package a day, at the age of 15 . Now I have started with a package costing $9.50 and have let inflation 2.00% up the price of cigarettes each year. You cannot use your TVM Solver app for this type of problem, so I have shown, in this spreadsheet, that over the years from 15 to 55 , the smoker actually has "Burned" (or breathed air through burning leaves) $1162,007.05 in total. See the question below the spreadsheet for you. Note when the Cost per Year for the smoker is passed by the Interest they would have earned per year. After about age 35 this is huge! Now use a TVM Solver and, with these values: 7.5% interest compounded yearly, For 40 years. What would a person have to invest each month to get this same amount ($1,162,007.05)? The smoker has invested $217,100.25 in total, but the smoker's investment has gone up in smoke! After 40 years they have nothing. You have over one million dollars! What have you invested over the 40 years? Work