Worksheet

Loan schedule test sheet

Ten sample loans sit in rows on one worksheet. Columns hold method, rate, day count, tenure, prepayment amount and date, missed instalment, expected schedule total and expected foreclosure quote. A final column records whether the system matches the hand calculation.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “Flat, reducing balance and daily interest: what a loan system models”, www.gullysystem.com/blog/flat-reducing-balance-and-daily-interest-what-a-loan-system-models