Recommended Table PivotTables Data from Picture Pictures Shapes Icons > fx B C D E F G Mortgage calculation PV Interest rate Years Payments per year RATE $300,000 6% 30 12 0. Above you will see the calcuclations for a mortgage paym In the first data table (one variable) you will calculate the In the second data table (two variable) you will calculate t (years) and annual interest rates. You must use the Data T