Eat whole foods: Whole foods are foods that havenât been tampered with, in the lab or the manufacturing plant. The foods you eat on this plan are straight from the farm: whole fruits and vegetables, whole grains, grass-fed and free-range meats, low fat dairy products, unsalted nuts, and seeds.
You need to replace its results with values. Just follow the simple steps below: 1  Select all the cells with formulas that you want to convert. 2  Press Ctrl + C or Ctrl + Ins to copy formulas and their results to clipboard.  3. Press Shift+F10 and then V to paste only values back to Excel cells.
Present Value and CAGR Formula. PV = FV / (1 + r)Y. CAGR = (FV / PV)1 / Y - 1. where PV is the present value (= starting principal), FV is the future value, r and CAGR are the annual interest rate, and Y is the number of years invested. The formula for present value is simple; just take the formula for future value and solve for starting principal: