Need to figure out Years and Interest rate.

Complete the table below with the missing values: PV(rate,nper,pmt, (fv) (type)) Present Value Years Interest Rate Future Value 12 4 21 1 2 3 4 5 6 7 18 19 20 21 $10.823.02 $29.411.69 $72,388 42 $3,500.00 $150,000.00 $500.00 $127,000.00 $50,000 $270,000.00 45 000 $35,000.00 ? 45 12 16 15 10 5 4% 9% 11% 12% 3% 4% 5% 12% #NUM! ? $17,328 $41,517 $647,816 $5,000 $500,000 $2.921 $228,074 $306,520 $300,000 $50,000 $350.000 4 Complete the table below with the missing values: 5 6 PV(rate.nper,pmt, (fv). (type)) 7 Present Value Years Interest Rate Future Value 8 9 $10,823.02 12 4% $17,328 10 $29,411.69 4 9% $41,517 11 $72, 388.42 21 11% $647,816 12 $3,500.00 12% $5,000 13 $150,000.00 ? $500.000 14 $500.00 45 4% $2,921 15 $127,000.00 12 5% $228,074 16 $50,000 16 12% $306,520 $270,000.00 15 #NUM! 18 $300,000 45,000 10 ? 19 $50.000 $35,000.00 5 20 ? $350,000 21 3% 5