A B C E F G | | J L M 1 2 Crain's Morgatage Calulator $ 150,000.00 $ 10,000.00 4.00% 30 12 3 Input Area 4 Cost of home 5 Down Payment 6 APR 7 No. Years for Loan 8 Payments Per Year 9 10 Output Area 11 Amount of Loan 12 Periodic Rate 13 No. Payment Periods 14 Monthly Payment 15 Total to Repay Loan 16 Total Interest Paid 17 One-Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total Interest 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% Two-Variable Data Table: APR and Cost of Home Monthly Payment by Cost/APR APR $ 200,000.00 $ 225,000.00 $ 250,000.00 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75% 7.00% 7.25% 7.50% 7.75% 8.00% 18 19 20 21 22 23 24 25 26 Note: Always replace my name with yours at the Top! 27 This spreadsheet requires a Date Function! 28 HERE! 29 30