XLS Daily Loan Principal & Interest Calculation Spreadsheet

=MID(CELL("filename"),FIND("[",CELL("filename"))+1,(FIND("]",CELL("filename"))+1)-FIND("[",CELL("filename"))-2)=NOW()D-H & Associates ConsultingThis spreadsheet shows in daily detail the effect of amounts and timing of fees and loan payments on a fixed rate loan. This sheet can be helpful in understanding the effects of late and early payments and fees. This spreadsheet is intended to be an educational tool. It is not intended to be a basis for financial or other important decisions. A financial institution’s computer system may output slightly different results based on how that system has been programmed to calculate. As with any utility tool like this the user should validate it before using it to make decisions. The inputs to the table are highlighted in blue text. ................
................

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

Google Online Preview   Download