XLS www.nwoinnovation.ca

Enter ValuesLoan SummaryLoan AmountScheduled Payment=IF(Values_Entered,-PMT(Interest_Rate/Num_Pmt_Per_Year,Loan_Years*Num_Pmt_Per_Year,Loan_Amount),"")Annual Interest RateScheduled Number of Payments=IF(Values_Entered,Loan_Years*Num_Pmt_Per_Year,"")Loan Period in YearsActual Number of Payments=IF(Values_Entered,Number_of_Payments,"")Number of Payments Per YearTotal Early Payments=IF(Values_Entered,SUMIF(Beg_Bal,">0",Extra_Pay),"")Start Date of LoanTotal Interest=IF(Values_Entered,SUMIF(Beg_Bal,">0",Int),"")Optional Extra Payments0Lender Name:PmtNo.Payment DateBeginning BalanceScheduled PaymentExtra PaymentTotal PaymentPrincipalInterestEnding BalanceCumulative Interest=IF(Values_Entered,1,"")=IF(Pay_Num"",DATE(YEAR(Loan_Start),MONTH(Loan_Start)+(Pay_Num)*12/Num_Pmt_Per_Year,DAY(Loan_Start)),"")=IF(Values_Entered,Loan_Amount,"")=IF(Pay_Num"",Scheduled_Monthly_Payment,"")=IF(AND(Pay_Num"",Sched_Pay+Scheduled_Extra_Payments0),Beg_Bal-Sched_Pay,IF(Pay_Num"",0,"")))=IF(AND(Pay_Num"",Sched_Pay+Extra_Pay ................
................

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

Google Online Preview   Download