{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Model Inputs","Profit and Loss","Balance Sheet","Cash Flow"],"not_rendered":{"macros":1,"external_links":1,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Model Inputs","index":0,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[6,1,11,4]],"flags":["formulas_cached_only"]}
[null,"<Company Name>"]
[null,"Five Year Plan (Service Industry)"]
[null,"Model Inputs and Investor Scenario"]
[]
[]
[null,"General Notes and Assumptions"]
{"$rows_empty":8}
[null,"Year One Model Inputs"]
[]
[null,"1. Year One Revenue Expectancy"]
[null,null,"<Product 1>","<Product 2>","<Product 3>","<Product 4>"]
[null,"Annual revenue per financial product",{"v":300000,"d":"$300,000"},{"v":600000,"d":"$600,000"},{"v":750000,"d":"$750,000"},{"v":0,"d":"$0"}]
[]
[null,"Total year one product (noninterest) revenue",{"v":1650000,"d":"$1,650,000"}]
[]
[null,"2. Credit Loss Provision Factor",{"v":0.03,"d":"3%"}]
[]
[null,"3. Annual Tax Rate",{"v":0.3,"d":"30%"}]

{"sheet":"Profit and Loss","index":1,"n_rows":59,"n_cols":9,"rows_kept":59,"flags":["formulas_cached_only"]}
[null,"<Company Name>"]
[null,"Five Year Plan (Service Industry)"]
[null,"Profit and Loss Projections"]
[]
[]
[null,"Year-by-Year Profit and Loss Assumptions"]
[{"$nulls":4},"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Annual cumulative price (revenue) increase",null,"—",{"v":0.02,"d":"2.00%"},{"v":0.04,"d":"4.00%"},{"v":0.06,"d":"6.00%"},{"v":0.08,"d":"8.00%"}]
[null,null,"Annual cumulative inflation (expense) increase",null,"—",{"v":0.02,"d":"2.00%"},{"v":0.04,"d":"4.00%"},{"v":0.06,"d":"6.00%"},{"v":0.08,"d":"8.00%"}]
[null,null,"Interest rate on ending cash balance",null,{"v":0.005,"d":"0.50%"},{"v":0.005,"d":"0.50%"},{"v":0.005,"d":"0.50%"},{"v":0.005,"d":"0.50%"},{"v":0.005,"d":"0.50%"}]
[]
[]
[{"$nulls":4},"Year 1","Year 2","Year 3","Year 4","Year 5"]
[]
[null,"Interest Income"]
[null,null,"Loans, including fees",null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,null,"Interest on federal funds sold",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Interest and dividends on investment securities",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Taxable",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Nontaxable",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Other (from <source>)",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Interest Income",null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Interest Expense"]
[null,null,"Interest on deposits",null,{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"}]
[null,null,"Interest on other borrowings",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Other",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Interest Expense",null,{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"},{"v":1500000,"d":"$1,500,000"}]
[]
[null,"Net Interest Income Before Provision for Credit Losses",null,null,{"v":-1500000,"d":"($1,500,000)"},{"v":-1500000,"d":"($1,500,000)"},{"v":-1500000,"d":"($1,500,000)"},{"v":-1500000,"d":"($1,500,000)"},{"v":-1500000,"d":"($1,500,000)"}]
[null,null,"Provision for credit losses",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Net Interest Income",null,{"v":-1500000,"d":"($1,500,000)"},{"v":-1500000,"d":"($1,500,000)"},{"v":-1500000,"d":"($1,500,000)"},{"v":-1500000,"d":"($1,500,000)"},{"v":-1500000,"d":"($1,500,000)"}]
[]
[null,"Noninterest Income"]
[null,null,"Service charges",null,{"v":40000,"d":"$40,000"},{"v":40800,"d":"$40,800"},{"v":42432,"d":"$42,432"},{"v":44977.920000000006,"d":"$44,978"},{"v":48576.15360000001,"d":"$48,576"}]
[null,null,"Product revenue (not fee-related)",null,{"v":1650000,"d":"1,650,000 "},{"v":1683000,"d":"1,683,000 "},{"v":1716000,"d":"1,716,000 "},{"v":1749000,"d":"1,749,000 "},{"v":1782000.0000000002,"d":"1,782,000 "}]
[null,null,"Loan placement fees",null,{"v":60000,"d":"60,000 "},{"v":60299.99999999999,"d":"60,300 "},{"v":60601.499999999985,"d":"60,602 "},{"v":60904.50749999998,"d":"60,905 "},{"v":61209.03003749997,"d":"61,209 "}]
[null,null,"Gain on sale of securities",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Gain on sale of other real estate owned",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Gain on sale of fixed assets",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Other",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Noninterest Income",null,{"v":1750000,"d":"$1,750,000"},{"v":1784100,"d":"$1,784,100"},{"v":1819033.5,"d":"$1,819,034"},{"v":1854882.4275,"d":"$1,854,882"},{"v":1891785.1836375003,"d":"$1,891,785"}]
[]
[null,"Noninterest Expense"]
[null,null,"Salaries and employee benefits",null,{"v":600000,"d":"$600,000"},{"v":612000,"d":"$612,000"},{"v":636480,"d":"$636,480"},{"v":674668.8,"d":"$674,669"},{"v":728642.3040000001,"d":"$728,642"}]
[null,null,"Occupancy fees",null,{"v":65000,"d":"65,000 "},{"v":66300,"d":"66,300 "},{"v":68952,"d":"68,952 "},{"v":73089.12000000001,"d":"73,089 "},{"v":78936.24960000001,"d":"78,936 "}]
[null,null,"Equipment",null,{"v":25000,"d":"25,000 "},{"v":25500,"d":"25,500 "},{"v":26520,"d":"26,520 "},{"v":28111.2,"d":"28,111 "},{"v":30360.096,"d":"30,360 "}]
[null,null,"Data processing",null,{"v":80000,"d":"80,000 "},{"v":81600,"d":"81,600 "},{"v":84864,"d":"84,864 "},{"v":89955.84000000001,"d":"89,956 "},{"v":97152.30720000002,"d":"97,152 "}]
[null,null,"Professional fees",null,{"v":50000,"d":"50,000 "},{"v":51000,"d":"51,000 "},{"v":53040,"d":"53,040 "},{"v":56222.4,"d":"56,222 "},{"v":60720.192,"d":"60,720 "}]
[null,null,"Director fees",null,{"v":40000,"d":"40,000 "},{"v":40800,"d":"40,800 "},{"v":42432,"d":"42,432 "},{"v":44977.920000000006,"d":"44,978 "},{"v":48576.15360000001,"d":"48,576 "}]
[null,null,"Amortization",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Litigation",null,{"v":50000,"d":"50,000 "},{"v":51000,"d":"51,000 "},{"v":53040,"d":"53,040 "},{"v":56222.4,"d":"56,222 "},{"v":60720.192,"d":"60,720 "}]
[null,null,"Other",null,{"v":5000,"d":"5,000 "},{"v":5100,"d":"5,100 "},{"v":5304,"d":"5,304 "},{"v":5622.240000000001,"d":"5,622 "},{"v":6072.019200000002,"d":"6,072 "}]
[null,"Total Noninterest Expense",null,null,{"v":915000,"d":"$915,000"},{"v":933300,"d":"$933,300"},{"v":970632,"d":"$970,632"},{"v":1028869.92,"d":"$1,028,870"},{"v":1111179.5136000002,"d":"$1,111,180"}]
[null,null,"Income before taxes on income",null,{"v":-665000,"d":"($665,000)"},{"v":-649200,"d":"($649,200)"},{"v":-651598.5,"d":"($651,599)"},{"v":-673987.4925,"d":"($673,987)"},{"v":-719394.3299624999,"d":"($719,394)"}]
[]
[null,null,"Taxes on income",{"v":0.3,"d":"30%"},{"v":-199500,"d":"(199,500)"},{"v":-194760,"d":"(194,760)"},{"v":-195479.55,"d":"(195,480)"},{"v":-202196.24775,"d":"(202,196)"},{"v":-215818.29898874997,"d":"(215,818)"}]
[]
[null,"Net Income or Loss",null,null,{"v":-465500,"d":"($465,500)"},{"v":-454440,"d":"($454,440)"},{"v":-456118.95,"d":"($456,119)"},{"v":-471791.24475000007,"d":"($471,791)"},{"v":-503576.03097374993,"d":"($503,576)"}]

{"sheet":"Balance Sheet","index":2,"n_rows":51,"n_cols":9,"rows_kept":51,"flags":["formulas_cached_only"]}
[null,"<Company Name>"]
[null,"Five Year Plan (Service Industry)"]
[null,"Balance Sheet Projections"]
[]
[]
[null,"Assets",null,"Initial Balance","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Cash and due from banks",{"v":500000,"d":"$500,000"},{"v":34500,"d":"$34,500"},{"v":-419940,"d":"($419,940)"},{"v":-876058.95,"d":"($876,059)"},{"v":-1347850.19475,"d":"($1,347,850)"},{"v":-1851426.22572375,"d":"($1,851,426)"}]
[null,null,"Federal funds sold and securities purchased",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Cash and Cash Equivalents",{"v":500000,"d":"$500,000"},{"v":34500,"d":"$34,500"},{"v":-419940,"d":"($419,940)"},{"v":-876058.95,"d":"($876,059)"},{"v":-1347850.19475,"d":"($1,347,850)"},{"v":-1851426.22572375,"d":"($1,851,426)"}]
[]
[null,null,"Securities available for sale",{"v":200000,"d":"$200,000"},{"v":200000,"d":"$200,000"},{"v":200000,"d":"$200,000"},{"v":200000,"d":"$200,000"},{"v":200000,"d":"$200,000"},{"v":200000,"d":"$200,000"}]
[null,null,"Securities held to maturity",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "}]
[null,null,"Total Investment Securities",{"v":250000,"d":"$250,000"},{"v":250000,"d":"$250,000"},{"v":250000,"d":"$250,000"},{"v":250000,"d":"$250,000"},{"v":250000,"d":"$250,000"},{"v":250000,"d":"$250,000"}]
[]
[null,null,"Loans and leases",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[null,null,"Unearned fees",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Allowance for credit losses",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Loans",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[]
[null,null,"Accrued interest receivable",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,null,"Premises and equipment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Other real estate owned",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Intangible assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Cash surrender value of life insurance",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Net amortized assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Deferred income taxes",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Other assets",{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "}]
[null,null,"Total Assets",{"v":1300000,"d":"$1,300,000"},{"v":834500,"d":"$834,500"},{"v":380060,"d":"$380,060"},{"v":-76058.94999999995,"d":"($76,059)"},{"v":-547850.19475,"d":"($547,850)"},{"v":-1051426.22572375,"d":"($1,051,426)"}]
[]
[null,"Liabilities and Shareholders' Equity",null,"Initial Balance","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Deposits"]
[null,null,"Noninterest-bearing",{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"},{"v":500000,"d":"$500,000"}]
[null,null,"Interest-bearing",{"v":500000,"d":"500,000 "},{"v":500000,"d":"500,000 "},{"v":500000,"d":"500,000 "},{"v":500000,"d":"500,000 "},{"v":500000,"d":"500,000 "},{"v":500000,"d":"500,000 "}]
[null,null,"Total Deposits",{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"}]
[]
[null,null,"Federal funds purchased and securities sold",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,null,"Other borrowings",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Accrued interest payable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Accounts payable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Other liabilities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Liabilities",{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"},{"v":1000000,"d":"$1,000,000"}]
[]
[null,null,"Common stock",{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"}]
[null,null,"Preferred stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Additional paid-in capital",{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "},{"v":200000,"d":"200,000 "}]
[null,null,"Retained earnings",{"v":0,"d":"0 "},{"v":-465500,"d":"(465,500)"},{"v":-919940,"d":"(919,940)"},{"v":-1376058.95,"d":"(1,376,059)"},{"v":-1847850.19475,"d":"(1,847,850)"},{"v":-2351426.22572375,"d":"(2,351,426)"}]
[null,null,"Unearned employee stock option shares",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Accumulated other comprehensive income",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Equity",{"v":300000,"d":"$300,000"},{"v":-165500,"d":"($165,500)"},{"v":-619940,"d":"($619,940)"},{"v":-1076058.95,"d":"($1,076,059)"},{"v":-1547850.19475,"d":"($1,547,850)"},{"v":-2051426.22572375,"d":"($2,051,426)"}]
[]
[null,null,"Total Liabilities and Equity",{"v":1300000,"d":"$1,300,000"},{"v":834500,"d":"$834,500"},{"v":380060,"d":"$380,060"},{"v":-76058.94999999995,"d":"($76,059)"},{"v":-547850.19475,"d":"($547,850)"},{"v":-1051426.22572375,"d":"($1,051,426)"}]

{"sheet":"Cash Flow","index":3,"n_rows":48,"n_cols":9,"rows_kept":48,"flags":["formulas_cached_only"]}
[null,"<Company Name>"]
[null,"Five Year Plan (Service Industry)"]
[null,"Cash Flow"]
[]
[]
[null,"Operating Activities",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[null,null,"Net income",{"v":-465500,"d":"($465,500)"},{"v":-454440,"d":"($454,440)"},{"v":-456118.95,"d":"($456,119)"},{"v":-471791.24475000007,"d":"($471,791)"},{"v":-503576.03097374993,"d":"($503,576)"},{"v":-2351426.22572375,"d":"($2,351,426)"}]
[null,null,"Adjustments to reconcile net earnings to cash\n   provided by operating activities"]
[null,null,"Provision for credit losses",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,null,"Depreciation and amortization",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Gain on sale of securities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Increase in accrued interest payable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Increase in unearned fees",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Increase in income taxes payable",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Increase in accounts payable and accrued liabilities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Write-down of other real estate owned",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Gain on sale of other real estate owned",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Gain on sale of assets",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Increase in surrender value of life insurance",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Operating Activities",{"v":-465500,"d":"($465,500)"},{"v":-454440,"d":"($454,440)"},{"v":-456118.95,"d":"($456,119)"},{"v":-471791.24475000007,"d":"($471,791)"},{"v":-503576.03097374993,"d":"($503,576)"},{"v":-2351426.22572375,"d":"($2,351,426)"}]
[]
[null,"Investing Activities",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[null,null,"Purchase of available-for-sale securities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,null,"Redemption of other stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Maturities and calls of available-for-sale securities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Maturities and calls of held-to-maturity securities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Proceeds from sales of available-for-sale securities",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Net increase in loans",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Proceeds from sales of other real estate owned",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Capital expenditures for other real estate owned",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Capital expenditures for premises and equipment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Proceeds from sales of premises and equipment",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Investing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Financing Activities",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
[null,null,"Increase in demand and savings account",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[null,null,"Increase in certificates of deposit",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Increase in federal funds purchased",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Increase in repurchase agreements",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Employee stock options exercised",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Repurchase of common stock",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Payment of dividends",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,null,"Total Financing Activities",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
[]
[null,"Cumulative Cash Flows",null,{"v":-465500,"d":"($465,500)"},{"v":-454440,"d":"($454,440)"},{"v":-456118.95,"d":"($456,119)"},{"v":-471791.24475000007,"d":"($471,791)"},{"v":-503576.03097374993,"d":"($503,576)"},{"v":-2351426.22572375,"d":"($2,351,426)"}]
[]
[null,"Beginning Cash Balance",null,{"v":500000,"d":"$500,000"},{"v":34500,"d":"$34,500"},{"v":-419940,"d":"($419,940)"},{"v":-876058.95,"d":"($876,059)"},{"v":-1347850.19475,"d":"($1,347,850)"}]
[null,"Ending Cash Balance",null,{"v":34500,"d":"$34,500"},{"v":-419940,"d":"($419,940)"},{"v":-876058.95,"d":"($876,059)"},{"v":-1347850.19475,"d":"($1,347,850)"},{"v":-1851426.22572375,"d":"($1,851,426)"}]