The Total Cost and Benefits Calculator ?                                                     Expense Categories                                                                                                 Quickly determine the total net financial benefit of owning any property over a selected number of years     Loan Amount =   P&I Payment =         Interest Only Option Real Estate Tax Table Maintenance Cost Table Insurance Cost Table Loan Parameter Table Interest Only Loan Interest Amortizing Loan Interest Interest Table on Selected Loan Condo or Coop Fees Deductible Portion of Condo or Coop Fees Lists Year R.E. Taxes Increase Cumulative Year Annual Cost Inflation Increase Cumulative Year Annual Inflation Increase Cumulative Year IO true/false Start Finish Rate Term Loan Amount Year Yearly Interest Accrued Int. Year Annual Accrued Int. Year Annual Int. on Accrued Int. on Year Inflation Monthly Yearly with Accrued with Year Deductible Deductible Yearly Accrued Enter and Select the Property Information and Settings Years State List DP % Months Percentage Values Costs % Term Rates Tax Bracket Taxes Ins factor Condo fee PMI Rent Expense Rate Cost Rate Cost Month Month Interest Only Interest Only Interest Amortizing Selected Loan Selected Loan Rate Cost Inflation Inflation % Cost Deductible Deductible Property Sale Price or Value Annual New Relays Appreciation Total benefits 1 AK 5.24% 0.00% 1.00% $ - 0.0000 5 1.000% 0% $ 1,000 0 $ - 0 $ - 1 $ 2,250.00 1 $ 750.00 1 $540 1 1 12 1 1 $5,357 1 1 $1,200 1 Lost Opportunity Tax Savings/R.E. Taxes Total Costs 2 AL 4.69% 3.00% 2.00% $ 5,000 0.0050 10 1.250% 5% $ 1,500 0.1 $ 50 0.19 $ 300 2 $ 4,545.00 2 $ 1,515.00 2 $1,091 2 2 2 $10,617 2 2 $2,424 2 Homeowners Insurance Factor annual Condo/Coop Insurance Tax Savings/ Interest Net Benefit 3 AR 4.81% 5.00% 3.00% $ 10,000 0.0100 15 1.500% 10% $ 2,000 0.2 $ 100 0.21 $ 350 3 $ 6,885.00 3 $ 2,295.00 3 $1,652 3 3 3 $15,776 3 3 $3,672 3 Annual Maintenance Expense Factor PMI' Maintenance Tax Savings/Condo Fee 4 AZ 6.99% 10.00% 4.00% $ 15,000 0.0150 20 2.000% 15% $ 2,500 0.3 $ 150 0.22 $ 400 4 $ 9,271.80 4 $ 3,090.30 4 $2,225 4 4 4 $20,830 4 4 $4,946 4 Tax Deductible % Closing Costs Condo/Coop Fees Housing Value 5 CA 9.25% 15.00% 5.00% $ 20,000 0.0200 25 2.500% 20% $ 3,000 0.4 $ 200 0.23 $ 450 5 $ 11,706.34 5 $ 3,901.20 5 $2,809 5 5 5 $25,775 5 5 $6,245 5 FALSE Annual IO Value Other Expenses 6 CO 6.42% 20.00% 6.00% $ 25,000 0.0250 30 3.000% 25% $ 3,500 0.5 $ 250 0.32 $ 500 6 $ 14,189.56 6 $ 4,728.01 6 $3,404 6 6 6 $30,606 6 6 $7,570 6 Interest Rate PMI/MIP 7 CT 7.10% 25.00% 7.00% $ 30,000 0.0300 40 4.000% 28% $ 4,000 0.6 $ 300 0.33 $ 600 7 $ 16,722.45 7 $ 5,571.03 7 $4,011 7 7 7 $35,319 7 7 $8,921 7 Annual Taxes Cost of Sale Cash Invested Graph 8 DC 8.48% 30.00% 8.00% $ 35,000 0.0350 50 4.125% 30% $ 4,500 0.7 $ 350 0.37 $ 700 8 $ 19,306.00 8 $ 6,430.59 8 $4,630 8 8 8 $39,909 8 8 $10,300 8       Enter and Select the Loan Information and Settings             R.E. Taxes     down payment     9 DE 6.63% 35.00% 9.00% $ 40,000 0.0400   4.250% 33% $ 5,000 0.8 $ 400 0.41 $ 800   9 $ 21,941.22   9 $ 7,307.01   9 $5,261   9   9   9 $44,371   9   9 $11,706   9 Interest Closing Costs 10 FL 6.73% 40.00% 10.00% $ 45,000 0.0450 4.375% 35% $ 5,500 0.9 $ 450 0.52 $ 900 10 $ 24,629.15 10 $ 8,200.62 10 $5,904 10 10 10 $48,700 10 10 $13,140 10 Term & Loan Amount Total = 11 GA 5.02% 45.00% 11.00% $ 50,000 0.0500 4.500% 36% $ 6,000 1 $ 500 0.54 $ 1,000 11 $ 27,370.83 11 $ 9,111.76 11 $6,560 11 11 11 $52,889 11 11 $14,602 11 Rate & Payment (check box for interest only) 12 HI 9.21% 50.00% 12.00% $ 75,000 0.0550 4.625% 38% $ 6,500 1.1 $ 550 0.56 $ 1,200 12 $ 30,167.35 12 $ 10,040.78 12 $7,229 12 12 12 $56,935 12 12 $16,095 12       Interest Only Savings (check box if investing this)                       Pre-Paid Expense Calculation           13 IA 4.46% 55.00% 13.00% $ 100,000 0.0600   4.750% 40% $ 7,000 1.2 $ 600 0.61 $ 1,500   13 $ 33,019.79   13 $ 10,988.01   13 $7,911   13   13   13 $60,830   13   13 $17,616   13                                 Periodic   Due at Closing           14 ID 5.68% 60.00% 14.00% $ 125,000 0.0650   4.875% 45% $ 7,500 1.3 $ 650 0.65 $ 1,800   14 $ 35,929.29   14 $ 11,953.83   14 $8,607   14   14   14 $64,569   14   14 $19,169   14 15 IL 5.74% 65.00% 15.00% $ 150,000 0.0700 5.000% 50% $ 8,000 1.4 $ 700 0.67 $ 2,000 15 $ 38,896.98 15 $ 12,938.59 15 $9,316 15 15 15 $68,145 15 15 $20,752 15 Total Initial Cash Investment = Monthly Insurance Cost 16 IN 4.64% 70.00% 16.00% $ 175,000 0.0750 5.125% $ 8,500 1.5 $ 750 0.77 $ 2,500 16 $ 41,924.02 16 $ 13,942.66 16 $10,039 16 16 16 $71,551 16 16 $22,367 16                                   Insurance @ Months               17 KS 4.34% 75.00% 17.00% $ 200,000 0.0800   5.250%   $ 9,000 1.6 $ 800 0.78 $ 3,000   17 $ 45,011.60   17 $ 14,966.43   17 $10,776   17   17   17 $74,781   17   17 $24,014   17       Enter and Select the Financial Settings                                               18 KY 4.87%   18.00% $ 225,000     5.375%   $ 9,500 1.7 $ 850 0.8 $ 3,500   18 $ 48,160.93   18 $ 16,010.29   18 $11,527   18   18   18 $77,828   18   18 $25,695   18 Daily Interest Expense 19 LA 4.96% 19.00% $ 250,000 5.500% $ 10,000 1.8 $ 900 0.81 $ 4,000 19 $ 51,373.25 19 $ 17,074.62 19 $12,294 19 19 19 $80,684 19 19 $27,409 19 Marginal Tax Bracket Per Diem @ Days 20 MA 8.17% 20.00% $ 275,000 5.625% $ 10,500 1.9 $ 950 0.85 $ 5,000 20 $ 54,649.81 20 $ 18,159.82 20 $13,075 20 20 20 $83,341 20 20 $29,157 20 Lost Opportunity Rate 21 MD 7.10% $ 300,000 5.750% $ 11,000 2 $ 1,000 0.88 $ 6,000 21 $ 57,991.91 21 $ 19,266.31 21 $13,872 21 21 21 $85,791 21 21 $30,940 21 Alternative Investment Rate Monthly Real Estate Taxes 22 ME 6.76% $ 325,000 5.875% $ 11,500 2.1 $ 1,050 0.92 $ 7,000 22 $ 61,400.85 22 $ 20,394.51 22 $14,684 22 22 22 $88,026 22 22 $32,759 22 Lookup List Taxes @ Months 23 MI 5.62% $ 350,000 6.000% $ 12,000 2.2 $ 1,100 0.96 $ 8,000 23 $ 64,877.96 23 $ 21,544.84 23 $15,512 23 23 23 $90,037 23 23 $34,614 23 Cost of Future Sale 24 MN 5.95% $ 375,000 6.125% $ 12,500 2.3 $ 1,150 1.06 $ 9,000 24 $ 68,424.62 24 $ 22,717.73 24 $16,357 24 24 24 $91,815 24 24 $36,506 24 Monthly PMI Expense 25 MO 5.08% $ 400,000 6.250% $ 13,000 2.4 $ 1,200 1.1 $ 10,000 25 $ 72,042.21 25 $ 23,913.62 25 $17,218 25 25 25 $93,350 25 25 $38,436 25 MI/PMI @ Months 26 MS 4.29% $ 425,000 6.375% $ 13,500 2.5 $ 1,250 1.17 $ 11,000 26 $ 75,732.16 26 $ 25,132.98 26 $18,096 26 26 26 $94,632 26 26 $40,405 26       Transaction Details and Results:                                           27 MT 6.22%     $ 450,000     6.500%   $ 14,000 2.6 $ 1,300 1.21 $ 12,000   27 $ 79,495.90   27 $ 26,376.25   27 $18,991   27   27   27 $95,652   27   27 $42,413   27             Costs                     Fuel Adjustments             28 NC 5.06%     $ 475,000     6.625%   $ 14,500 2.7 $ 1,350   $ 13,000   28 $ 83,334.92   28 $ 27,643.91   28 $19,904   28   28   28 $96,398   28   28 $44,461   28 Closing Costs 29 ND 4.54% $ 500,000 6.750% $ 15,000 2.8 $ 1,400 $ 14,000 29 $ 87,250.72 29 $ 28,936.44 29 $20,834 29 29 29 $96,859 29 29 $46,551 29 Lost Opportunity Value of Invested Cash Other 30 NE 4.42% $ 525,000 6.875% $ 15,500 2.9 $ 1,450 $ 15,000 30 $ 91,244.83 30 $ 30,254.31 30 $21,783 30 30 30 $97,024 30 30 $48,682 30 Total Cost of Insurance 31 NH 7.07% $ 550,000 7.000% $ 16,000 3 $ 16,000 31 $ 95,318.83 31 $ 31,598.04 31 $22,751 31 31 31 $97,024 31 31 $50,855 31 Total Pre-Paid Expenses 32 NJ 7.77% $ 575,000 7.125% $ 16,500 3.1 $ 17,000 32 $ 99,474.31 32 $ 32,968.13 32 $23,737 32 32 32 $97,024 32 32 $53,072 32 Cash to Close Graph 33 NM 5.96% $ 600,000 7.250% $ 17,000 3.2 $ 18,000 33 $ 103,712.89 33 $ 34,365.09 33 $24,743 33 33 33 $97,024 33 33 $55,334 33 Total Other Expenses First Year's Insurance Premium 34 NV 6.85% $ 625,000 7.375% $ 17,500 3.3 $ 19,000 34 $ 108,036.25 34 $ 35,789.45 34 $25,768 34 34 34 $97,024 34 34 $57,641 34 Total Cost of Private Mortgage Insurance (PMI) Closing Costs 35 NY 7.27% $ 650,000 7.500% $ 18,000 3.4 $ 20,000 35 $ 112,446.07 35 $ 37,241.75 35 $26,814 35 35 35 $97,024 35 35 $59,993 35 Grand Total Pre-Paid Expenses Down Payment 36 OH 4.77% $ 675,000 7.625% $ 18,500 3.5 36 $ 116,944.10 36 $ 38,722.54 36 $27,880 36 36 36 $97,024 36 36 $62,393 36 Total Real Estate Tax over Term First Year's Insurance 37 OK 4.20% $ 700,000 7.750% $ 19,000 3.6 37 $ 121,532.08 37 $ 40,232.38 37 $28,967 37 37 37 $97,024 37 37 $64,841 37 Total Interest Paid Insurance to Escrow 38 OR 7.30% $ 725,000 7.875% $ 19,500 3.7 38 $ 126,211.82 38 $ 41,771.83 38 $30,076 38 38 38 $97,024 38 38 $67,338 38 Monthly Payment Graph Per Diem Interest