# This model file is a sample of a SquirrelCalc Spreadsheet. # # (c) 1986 Minihouse Research dimension 28 {of 28 rows} 10 {of 10 columns} global frame 2 global display 2 global format [F2L] width c1 16 width c2 2 width c3 9 width c4 4 width c5 23 width c6 2 text na "N/A" r0c0 = "sample1.sc" lock r0c0 lock r0c1 lock r0c2 r0c3 = "Maximum Loan Amount Table" lock r0c3 lock r0c4 lock r0c5 r0c6 = date(today) lock r0c6 lock r0c7 r1c0 = [G2*] "-" lock r1c0 r1c1 = [G2*] "-" lock r1c1 r1c2 = [G2*] "-" lock r1c2 r1c3 = [G2*] "-" lock r1c3 r1c4 = [G2*] "-" lock r1c4 r1c5 = [G2*] "-" lock r1c5 r1c6 = [G2*] "-" lock r1c6 r1c7 = [G2*] "-" lock r1c7 r2c0 = " Assumptions" lock r2c0 lock r2c1 lock r2c2 lock r2c3 lock r2c4 r2c5 = " Results" lock r2c5 lock r2c6 lock r2c7 r3c0 = [G2*] "-" lock r3c0 r3c1 = [G2*] "-" lock r3c1 r3c2 = [G2*] "-" lock r3c2 r3c3 = [G2*] "-" lock r3c3 r3c4 = [G2*] "-" lock r3c4 r3c5 = [G2*] "-" lock r3c5 r3c6 = [G2*] "-" lock r3c6 r3c7 = [G2*] "-" lock r3c7 r4c0 = "Monthly Income" lock r4c0 lock r4c1 r4c2 = ":" lock r4c2 r4c3 = [$2L] 3500 lock r4c4 r4c5 = "Maximum Loan Amount" lock r4c5 r4c6 = ":" lock r4c6 r4c7 = r25c1 lock r4c7 lock r5c0 lock r5c1 lock r5c2 lock r5c3 lock r5c4 lock r5c5 lock r5c6 lock r5c7 r6c0 = "% of Income towards Repay" lock r6c0 lock r6c1 r6c2 = ":" lock r6c2 r6c3 = [%1L] 0.3 lock r6c4 r6c5 = "Affordable House" lock r6c5 r6c6 = ":" lock r6c6 r6c7 = r4c7+r15c3 lock r6c7 lock r7c0 lock r7c1 lock r7c2 lock r7c3 lock r7c4 lock r7c5 lock r7c6 lock r7c7 r8c0 = "Percentage of Loan Payment" lock r8c0 lock r8c1 lock r8c2 lock r8c3 lock r8c4 r8c5 = "Required Down Payment" lock r8c5 r8c6 = ":" lock r8c6 r8c7 = r6c7*r17c3 lock r8c7 r9c0 = "towards Tax, Ins, Assmnts" lock r9c0 lock r9c1 r9c2 = ":" lock r9c2 r9c3 = [%1L] 0.35 lock r9c4 lock r9c5 lock r9c6 lock r9c7 lock r10c0 lock r10c1 lock r10c2 lock r10c3 lock r10c4 r10c5 = "Maximum Monthly Paymnt" lock r10c5 r10c6 = ":" lock r10c6 r10c7 = r4c3*r6c3 lock r10c7 r11c0 = "Term of the Loan in Years" lock r11c0 lock r11c1 r11c2 = ":" lock r11c2 r11c3 = [I2L] 29 lock r11c4 lock r11c5 lock r11c6 lock r11c7 lock r12c0 lock r12c1 lock r12c2 lock r12c3 lock r12c4 r12c5 = "Max. Loan Paymnt/Month" lock r12c5 r12c6 = ":" lock r12c6 r12c7 = r10c7/(1+r9c3) lock r12c7 r13c0 = "Interest of the Loan" lock r13c0 lock r13c1 r13c2 = ":" lock r13c2 r13c3 = [%2L] 0.1475 lock r13c4 lock r13c5 lock r13c6 lock r13c7 lock r14c0 lock r14c1 lock r14c2 lock r14c3 lock r14c4 lock r14c5 lock r14c6 lock r14c7 r15c0 = "Available for Down Payment" lock r15c0 lock r15c1 r15c2 = ":" lock r15c2 r15c3 = [$2L] 25000 lock r15c4 lock r15c5 lock r15c6 lock r15c7 lock r16c0 lock r16c1 lock r16c2 lock r16c3 lock r16c4 lock r16c5 lock r16c6 lock r16c7 r17c0 = "Required down Payment" lock r17c0 lock r17c1 r17c2 = ":" lock r17c2 r17c3 = [%1L] 0.1 lock r17c4 r17c5 = "Adapted from: \"VisiCalc Home and" lock r17c5 lock r17c6 lock r17c7 lock r18c0 lock r18c1 lock r18c2 lock r18c3 lock r18c4 r18c5 = " Office Companion\"" lock r18c5 lock r18c6 lock r18c7 r19c0 = "Payments per Year" lock r19c0 lock r19c1 r19c2 = ":" lock r19c2 r19c3 = [I2L] 12 lock r19c4 r19c5 = date(31320,"Date created: %d-%h-%Y") lock r19c5 lock r19c6 lock r19c7 lock r20c0 lock r20c1 lock r20c2 lock r20c3 lock r20c4 lock r20c5 lock r20c6 lock r20c7 r21c0 = " Workspace" lock r21c0 lock r21c1 lock r21c2 lock r21c3 lock r21c4 lock r21c5 lock r21c6 lock r21c7 r22c0 = "Calc 1:" lock r22c0 r22c1 = r4c3*r6c3/(1+r9c3)*r19c3 lock r22c1 lock r22c2 lock r22c3 lock r22c4 lock r22c5 lock r22c6 lock r22c7 r23c0 = "Calc 2:" lock r23c0 r23c1 = 1/(r13c3/r19c3+1)^(r11c3*r19c3) lock r23c1 lock r23c2 lock r23c3 lock r23c4 lock r23c5 lock r23c6 lock r23c7 r24c0 = "Calc 3:" lock r24c0 r24c1 = 1-r23c1 lock r24c1 lock r24c2 lock r24c3 lock r24c4 lock r24c5 lock r24c6 lock r24c7 r25c0 = "Calc 4:" lock r25c0 r25c1 = r22c1/r13c3*r24c1 lock r25c1 lock r25c2 lock r25c3 lock r25c4 lock r25c5 lock r25c6 lock r25c7 r26c0 = "" r26c1 = " " r27c0 = " " r27c1 = "" goto r0c0 model on