XLSX www.excel-easy.com

Years2Payments Per Year12Amount20000Payment NumberPaymentPrincipalInterestBalance1=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A7,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A7,Years*PaymentsPerYear,Amount)=Amount+C72=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A8,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A8,Years*PaymentsPerYear,Amount)=E7+C83=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A9,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A9,Years*PaymentsPerYear,Amount)=E8+C94=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A10,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A10,Years*PaymentsPerYear,Amount)=E9+C105=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A11,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A11,Years*PaymentsPerYear,Amount)=E10+C116=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A12,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A12,Years*PaymentsPerYear,Amount)=E11+C127=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A13,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A13,Years*PaymentsPerYear,Amount)=E12+C138=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A14,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A14,Years*PaymentsPerYear,Amount)=E13+C149=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A15,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A15,Years*PaymentsPerYear,Amount)=E14+C1510=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A16,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A16,Years*PaymentsPerYear,Amount)=E15+C1611=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A17,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A17,Years*PaymentsPerYear,Amount)=E16+C1712=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A18,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A18,Years*PaymentsPerYear,Amount)=E17+C1813=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A19,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A19,Years*PaymentsPerYear,Amount)=E18+C1914=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A20,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A20,Years*PaymentsPerYear,Amount)=E19+C2015=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A21,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A21,Years*PaymentsPerYear,Amount)=E20+C2116=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A22,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A22,Years*PaymentsPerYear,Amount)=E21+C2217=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A23,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A23,Years*PaymentsPerYear,Amount)=E22+C2318=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A24,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A24,Years*PaymentsPerYear,Amount)=E23+C2419=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A25,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A25,Years*PaymentsPerYear,Amount)=E24+C2520=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A26,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A26,Years*PaymentsPerYear,Amount)=E25+C2621=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A27,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A27,Years*PaymentsPerYear,Amount)=E26+C2722=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A28,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A28,Years*PaymentsPerYear,Amount)=E27+C2823=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A29,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A29,Years*PaymentsPerYear,Amount)=E28+C2924=PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount)=PPMT(AnnualInterestRate/PaymentsPerYear,A30,Years*PaymentsPerYear,Amount)=IPMT(AnnualInterestRate/PaymentsPerYear,A30,Years*PaymentsPerYear,Amount)=E29+C30 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download