– The following formula structures will come in handy:

• Payment : =PMT(rate,nper,pv,fv,type)
• Future Value : =FV(rate,nper,pmt,pv,type)
• Present Value : =PV(rate,nper,pmt,fv,type)
• Vlookup : =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)