XLSX www.mortgagecalculator.org

This Excel spreadsheet makes it easy to view the amortization of a home loan with optional extra monthly payments. Want more features? View our website to see interactive graphs for your loan.Our website allows you to share calculations, see local mortgage rates & generate printable loan amortization tables. can also include other expenses including property taxes, homeowners' insurance & HOA fees on our website.MORTGAGE AMORTIZATION SCHEDULEENTER VALUESLOAN SUMMARYLoan amount200000Scheduled payment=IF(LoanIsGood,-PMT(InterestRate/PaymentsPerYear,ScheduledNumberOfPayments,LoanAmount),"")Interest rate* SEE CURRENT *0.05Scheduled number of payments=IF(LoanIsGood,LoanPeriod*PaymentsPerYear,"")Loan term in years30Actual number of payments=ActualNumberOfPaymentsPayments made per year12Years saved off original loan term=(I9-I10)/E11Loan repayment start date=TODAY()Total early payments=TotalEarlyPaymentsTotal interest=TotalInterestOptional extra payments100LENDER NAMEYour BankPMT NOPAYMENT DATEBEGINNING BALANCESCHEDULED PAYMENTEXTRA PAYMENTTOTAL PAYMENTPRINCIPALINTERESTENDING BALANCECUMULATIVE INTEREST=IF(LoanIsGood,IF(ROW()-ROW(PaymentSchedule[[#Headers],[PMT NO]])>ScheduledNumberOfPayments,"",ROW()-ROW(PaymentSchedule[[#Headers],[PMT NO]])),"")=IF(PaymentSchedule[[#This Row],[PMT NO]]"",EOMONTH(LoanStartDate,ROW(PaymentSchedule[[#This Row],[PMT NO]])-ROW(PaymentSchedule[[#Headers],[PMT NO]])-2)+DAY(LoanStartDate),"")=IF(PaymentSchedule[[#This Row],[PMT NO]]"",IF(ROW()-ROW(PaymentSchedule[[#Headers],[BEGINNING BALANCE]])=1,LoanAmount,INDEX(PaymentSchedule[ENDING BALANCE],ROW()-ROW(PaymentSchedule[[#Headers],[BEGINNING BALANCE]])-1)),"")=IF(PaymentSchedule[[#This Row],[PMT NO]]"",ScheduledPayment,"")=IF(PaymentSchedule[[#This Row],[PMT NO]]"",IF(PaymentSchedule[[#This Row],[SCHEDULED PAYMENT]]+ExtraPayments0,PaymentSchedule[[#This Row],[BEGINNING BALANCE]]-PaymentSchedule[[#This Row],[SCHEDULED PAYMENT]],0)),"")=IF(PaymentSchedule[[#This Row],[PMT NO]]"",IF(PaymentSchedule[[#This Row],[SCHEDULED PAYMENT]]+PaymentSchedule[[#This Row],[EXTRA PAYMENT]] ................
................

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

Google Online Preview   Download