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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- pdf sample problems with suggested solution keystrokes for the hp
- pdf using the ti ba ii calculator for financial calculations
- pdf amortization schedule
- pdf example of amortization schedule for a note with equal total
- pdf using the hp 10b and ti ba ii plus financial calculators
- pdf mortgage amortization lexisnexis
- pdf quick start reference guide timevalue software
- pdf hp 12c loan amortizations amortization the hp12c amortization
- pdf mini lesson loan tables loan amortization and loan payment
- xls financial calculator v 5 1 ccim
Related searches
- https www municipalonlinepayments
- powershell save xlsx as csv
- xlsx to xls converter microsoft download
- powershell import xlsx convert to csv
- powershell xlsx to csv
- convert xlsx to xls free
- convert xlsx to csv
- powershell import xlsx file
- convert xls to xlsx powershell
- free microsoft xlsx to xls
- xlsx converter for excel 2003
- xlsx to pdf converter