I NEED TO EXTRACT DATA FROM 3 DIFFERENT SHEETS FROM 150000 FILES ONTO A SINGLE NEW WORKBOOK.
FIRST SHEET IS 'INFO' I NEED 'B9' 'B11' AND 'C2'
SECOND SHEET IS 'fSC COMM' RANGE 'H9:H79'
THIRD IS 'PCF COMM' RANGE 'H15:H84'
THE MASTER WORKBOOK NEEDS TO HAVE THE FILE NAMES AS FIRST COLUMN AND EVERY ROW FROM THE THREE SHEETS (FSCCOMM,PCF COMM AND INFO) NEEDS TO BE A SEPERATE COLUMN.
[TABLE="width: 9102"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Total Estimated Risk of Guarantor Support Needed on Contingent Liabilities (from column 6 of CONLB worksheet)[/TD]
[TD] Cash & Equivalents[/TD]
[TD]Public Equities[/TD]
[TD]Domestic Stocks - unrestricted, diversified[/TD]
[TD]Domestic & International Stocks - unrestricted, concentrated[/TD]
[TD]Domestic Stocks - Rule 144 (liquid portion)[/TD]
[TD]International Stocks, diversified[/TD]
[TD]Executive Stock Options - vested[/TD]
[TD]REITs[/TD]
[TD]Fixed Income:[/TD]
[TD]Government & Municipal Obligations[/TD]
[TD]Domestic Corporate Bonds[/TD]
[TD]Convertible Bonds[/TD]
[TD]International Bonds/Domestic High Yield Bonds[/TD]
[TD]Investment Accounts with No Detail[/TD]
[TD]Other Liquidity (liquid portion of Hedge Funds/Alternative Investments)[/TD]
[TD]Total Liquid Assets[/TD]
[TD]Total Liquid Assets (Scorecard definition)[/TD]
[TD]Encumbered Liquidity[/TD]
[TD]Intermediate/Alternative Investments:[/TD]
[TD]Restricted/Illiquid Public Securities[/TD]
[TD]Rule 144 shares not considered liquid[/TD]
[TD]REIT Operating Partnership (OP) units[/TD]
[TD]Hedge Funds (illiquid portion)[/TD]
[TD]Private Equity Funds[/TD]
[TD]Closely Held Companies/Privately Held Sec.[/TD]
[TD]Receivables:[/TD]
[TD]Notes & Mortgages[/TD]
[TD]Accounts Receivable[/TD]
[TD]Real Estate:[/TD]
[TD]Personal Residence - Primary residence[/TD]
[TD]Personal Residence(s) - non-primary[/TD]
[TD]Residential Lot(s)[/TD]
[TD]Other 100% Owned Real Estate:[/TD]
[TD]Recreational Real Estate/Land[/TD]
[TD]Income Producing Properties[/TD]
[TD]Equity in RE Ptnrshps and/or partially owned RE[/TD]
[TD]Equity in Partnerships (Excluding Real Estate)[/TD]
[TD]Cash Value of Ins. & Annuities[/TD]
[TD]Retirement Plans, Deferred Comp., IRAs[/TD]
[TD]Personal Property[/TD]
[TD]Other Assets[/TD]
[TD]Fine Art or Farm Equipment[/TD]
[TD]Yachts, Aircraft[/TD]
[TD]Less: Est. Taxes Payable on Unrealized Asset Appreciation[/TD]
[TD]Total Assets[/TD]
[TD]Total Assets (Scorecard definition)[/TD]
[TD]Credit Cards[/TD]
[TD]Installment Accounts[/TD]
[TD]Other Accounts Payable[/TD]
[TD]Notes Payable to Bank[/TD]
[TD]Unsecured[/TD]
[TD]Secured (Non-R/E)[/TD]
[TD]Other Notes Payable[/TD]
[TD]To Related Parties (Non-R/E)[/TD]
[TD]Other (Non-R/E)[/TD]
[TD]Real Estate Liabilities[/TD]
[TD]Mortgages on Primary Residence[/TD]
[TD]Mortgages on Non-primary Residence(s)[/TD]
[TD]Mortgages on Residential Lot(s)[/TD]
[TD]Morts./Notes secured by other 100% owned R/E[/TD]
[TD]Morts. on Recreational Real Estate/Land[/TD]
[TD]Income Producing Properties[/TD]
[TD]Notes Due to R/E Partnership/Corps[/TD]
[TD]Other Direct R/E Debt[/TD]
[TD]Taxes Payable[/TD]
[TD]Income Taxes[/TD]
[TD]Margin Acct / Due to Brokers[/TD]
[TD]Loans against Insurance / other Policies[/TD]
[TD]Other Direct Liabilities[/TD]
[TD]Total Liabilities[/TD]
[TD]Total Liabilities (Scorecard definition)[/TD]
[TD]STATED NET WORTH:[/TD]
[TD]Contingent Liabilities (not to be used, use RAV version)[/TD]
[TD]Name of Borrower:[/TD]
[TD]Preparation Date (for the entire spread workbook)[/TD]
[TD]Financial Statement Date (corresponding date for each year of financial data)[/TD]
[TD]Actual Year[/TD]
[TD]Salaries[/TD]
[TD]Bonuses[/TD]
[TD]Dividends[/TD]
[TD]Interest[/TD]
[TD]Recurring Real Estate Inflows:[/TD]
[TD]Net Rents-NOI[/TD]
[TD]R/E Partnership Distributions[/TD]
[TD]Other Recurring - NOI[/TD]
[TD]Other Partnership Distributions[/TD]
[TD]Other (incl. Bus. Income, Trust Income)[/TD]
[TD]Other (incl. Retirement income/annuities)[/TD]
[TD]Other (verifiable income to be generated from asset purchased w/loan proceeds)[/TD]
[TD]Recurring Cash Sources SUBTOTAL[/TD]
[TD]Recurring Cash Sources (Scorecard definition)[/TD]
[TD]R/E Taxes for non-income prop.[/TD]
[TD]Planned Investments, Partnership[/TD]
[TD]Contributions & Capital Calls[/TD]
[TD]Estimated Living Expenses[/TD]
[TD]Federal Income Taxes[/TD]
[TD]State Income Taxes[/TD]
[TD]Other[/TD]
[TD]Recurring Cash Uses SUBTOTAL[/TD]
[TD]Recurring Cash Uses (Scorecard definition)[/TD]
[TD]CASH FL. AVAIL. FOR DEBT SERV.[/TD]
[TD]Subject Request debt (based on actual maturity)[/TD]
[TD]Subject Request debt[/TD]
[TD]Bank of America- revolving debt[/TD]
[TD]Bank of America- term debt[/TD]
[TD]Residential Mortgage debt[/TD]
[TD]Non-BoA debt[/TD]
[TD]Other CBI debt[/TD]
[TD]Sched. Cont. Liab. Pymts.[/TD]
[TD]DEBT SERVICE SUBTOTAL[/TD]
[TD]Debt Service (Scorecard definition)[/TD]
[TD]SUBTOTAL - RECURRING USES + DEBT SERVICE[/TD]
[TD]NET RECURRING CASH FLOW[/TD]
[TD]DEBT SERVICE COVERAGE[/TD]
[TD]Real Estate Sales[/TD]
[TD]New Real Estate Investment[/TD]
[TD]Sale of Mkt. Sec.[/TD]
[TD]Purchase of Mkt. Sec.[/TD]
[TD]Other purch. & capital outlays[/TD]
[TD]Other[/TD]
[TD]NON-RECURRING SOURCES (USES) SUBTOTAL[/TD]
[TD]NET CASH FLOW BEFORE FINANCING ACTIVITIES[/TD]
[TD]Real Estate Financing[/TD]
[TD]Margin Financing[/TD]
[TD]Homestead Financing[/TD]
[TD]Discretionary Debt Payments[/TD]
[TD]Contingent Liability Payments[/TD]
[TD]Other[/TD]
[TD]FINANCING SOURCES (USES) SUBTOTAL[/TD]
[TD]NET CASH FLOW (DEFICIT)[/TD]
[TD]Scorecard Federal Taxes[/TD]
[TD]Scorecard State Taxes[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PCF F79 FSC H80 M SU[/TD]
[TD="align: right"]$1,207.98[/TD]
[TD="align: right"]583.65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1996.177[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2579.827[/TD]
[TD="align: right"]2579.827[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]563[/TD]
[TD="align: right"]4140[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5250[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]41253[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]624[/TD]
[TD="align: right"]15100[/TD]
[TD="align: right"]17700[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5204.342[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5204.342[/TD]
[TD="align: right"]5204.342[/TD]
[TD="align: right"]84705.49[/TD]
[TD="align: right"]9081.883[/TD]
[TD]Mark E Salzberg[/TD]
[TD="align: right"]5/7/2014[/TD]
[TD="align: right"]2/25/2014[/TD]
[TD]Various[/TD]
[TD="align: right"]1254.238[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2.442[/TD]
[TD="align: right"]52.004[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6236.688[/TD]
[TD="align: right"]13.779[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7559.151[/TD]
[TD="align: right"]7559.151[/TD]
[TD="align: right"]64.764[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]801.485[/TD]
[TD="align: right"]2267.745[/TD]
[TD="align: right"]5.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3139.194[/TD]
[TD="align: right"]3139.194[/TD]
[TD="align: right"]4419.957[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]209[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]32.412[/TD]
[TD="align: right"]168.304[/TD]
[TD="align: right"]409.716[/TD]
[TD="align: right"]409.716[/TD]
[TD="align: right"]3548.91[/TD]
[TD="align: right"]4010.241[/TD]
[TD="align: right"]10.78786[/TD]
[TD="align: right"]272[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2170.379[/TD]
[TD="align: right"]-260.838[/TD]
[TD="align: right"]2181.541[/TD]
[TD="align: right"]6191.782[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6191.782[/TD]
[TD="align: right"]392.6052[/TD]
[TD="align: right"]5.2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PCF F79 FSC H80 M SU[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]750[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]750[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6900[/TD]
[TD="align: right"]6900[/TD]
[TD="align: right"]25050[/TD]
[TD="align: right"]0[/TD]
[TD]Klentner Family Trust[/TD]
[TD="align: right"]7/24/2012[/TD]
[TD="align: right"]8/12/2012[/TD]
[TD]Various[/TD]
[TD="align: right"]99.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1.881[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]66.379[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13.7[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]184.46[/TD]
[TD="align: right"]184.46[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]177.3143[/TD]
[TD="align: right"]1.941[/TD]
[TD="align: right"]6.174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]185.4293[/TD]
[TD="align: right"]185.4293[/TD]
[TD="align: right"]-0.96925[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]64.92[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]364.9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17.76[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]447.58[/TD]
[TD="align: right"]447.58[/TD]
[TD="align: right"]633.0093[/TD]
[TD="align: right"]-448.549[/TD]
[TD="align: right"]-0.00217[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]180.288[/TD]
[TD="align: right"]-152.277[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]28.011[/TD]
[TD="align: right"]-420.538[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-420.538[/TD]
[TD="align: right"]1.941[/TD]
[TD="align: right"]6.174[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PCF F79 FSC H80 M SU[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]6303.135[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2413.251[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]118479.6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]127196[/TD]
[TD="align: right"]127196[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]34000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"]161305[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5000[/TD]
[TD="align: right"]-5000[/TD]
[TD="align: right"]-5000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]58000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]14000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11583.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]43000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]126783.2[/TD]
[TD="align: right"]126783.2[/TD]
[TD="align: right"]242217.8[/TD]
[TD="align: right"]1788.8[/TD]
[TD]Adam Lindemann[/TD]
[TD="align: right"]1/31/2014[/TD]
[TD="align: right"]9/30/2013[/TD]
[TD]Various[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1496.179[/TD]
[TD="align: right"]152.338[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]402.082[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2050.599[/TD]
[TD="align: right"]2050.599[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1027.19[/TD]
[TD="align: right"]80.991[/TD]
[TD="align: right"]96.447[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1204.628[/TD]
[TD="align: right"]1204.628[/TD]
[TD="align: right"]845.9712[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2600[/TD]
[TD="align: right"]2800[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]907.572[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]117.5853[/TD]
[TD="align: right"]6425.157[/TD]
[TD="align: right"]6425.157[/TD]
[TD="align: right"]7629.785[/TD]
[TD="align: right"]-5579.19[/TD]
[TD="align: right"]0.131665[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15905.85[/TD]
[TD="align: right"]-4997.33[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3612.91[/TD]
[TD="align: right"]14521.42[/TD]
[TD="align: right"]8942.238[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8942.238[/TD]
[TD="align: right"]80.991[/TD]
[TD="align: right"]96.447[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PCF F79 FSC H80 M [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]3187.628[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2675.907[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]201713.3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5.75[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]207582.6[/TD]
[TD="align: right"]207582.6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17000[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]175000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]127966[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]14000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11383.16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]153349.2[/TD]
[TD="align: right"]153349.2[/TD]
[TD="align: right"]336733.4[/TD]
[TD="align: right"]1684.8[/TD]
[TD]Adam Lindemann[/TD]
[TD="align: right"]9/23/2014[/TD]
[TD="align: right"]6/30/2014[/TD]
[TD]Various[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1496.179[/TD]
[TD="align: right"]152.338[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]402.082[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2050.599[/TD]
[TD="align: right"]2050.599[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1021.261[/TD]
[TD="align: right"]80.991[/TD]
[TD="align: right"]96.447[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1198.699[/TD]
[TD="align: right"]1198.699[/TD]
[TD="align: right"]851.9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2800[/TD]
[TD="align: right"]2600[/TD]
[TD="align: right"]904.836[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]116.6147[/TD]
[TD="align: right"]6421.451[/TD]
[TD="align: right"]6421.451[/TD]
[TD="align: right"]7620.15[/TD]
[TD="align: right"]-5569.55[/TD]
[TD="align: right"]0.132665[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15905.85[/TD]
[TD="align: right"]-4997.33[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3612.91[/TD]
[TD="align: right"]14521.42[/TD]
[TD="align: right"]8951.873[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8951.873[/TD]
[TD="align: right"]80.991[/TD]
[TD="align: right"]96.447[/TD]
[/TR]
</tbody>[/TABLE]
FIRST SHEET IS 'INFO' I NEED 'B9' 'B11' AND 'C2'
SECOND SHEET IS 'fSC COMM' RANGE 'H9:H79'
THIRD IS 'PCF COMM' RANGE 'H15:H84'
THE MASTER WORKBOOK NEEDS TO HAVE THE FILE NAMES AS FIRST COLUMN AND EVERY ROW FROM THE THREE SHEETS (FSCCOMM,PCF COMM AND INFO) NEEDS TO BE A SEPERATE COLUMN.
[TABLE="width: 9102"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Total Estimated Risk of Guarantor Support Needed on Contingent Liabilities (from column 6 of CONLB worksheet)[/TD]
[TD] Cash & Equivalents[/TD]
[TD]Public Equities[/TD]
[TD]Domestic Stocks - unrestricted, diversified[/TD]
[TD]Domestic & International Stocks - unrestricted, concentrated[/TD]
[TD]Domestic Stocks - Rule 144 (liquid portion)[/TD]
[TD]International Stocks, diversified[/TD]
[TD]Executive Stock Options - vested[/TD]
[TD]REITs[/TD]
[TD]Fixed Income:[/TD]
[TD]Government & Municipal Obligations[/TD]
[TD]Domestic Corporate Bonds[/TD]
[TD]Convertible Bonds[/TD]
[TD]International Bonds/Domestic High Yield Bonds[/TD]
[TD]Investment Accounts with No Detail[/TD]
[TD]Other Liquidity (liquid portion of Hedge Funds/Alternative Investments)[/TD]
[TD]Total Liquid Assets[/TD]
[TD]Total Liquid Assets (Scorecard definition)[/TD]
[TD]Encumbered Liquidity[/TD]
[TD]Intermediate/Alternative Investments:[/TD]
[TD]Restricted/Illiquid Public Securities[/TD]
[TD]Rule 144 shares not considered liquid[/TD]
[TD]REIT Operating Partnership (OP) units[/TD]
[TD]Hedge Funds (illiquid portion)[/TD]
[TD]Private Equity Funds[/TD]
[TD]Closely Held Companies/Privately Held Sec.[/TD]
[TD]Receivables:[/TD]
[TD]Notes & Mortgages[/TD]
[TD]Accounts Receivable[/TD]
[TD]Real Estate:[/TD]
[TD]Personal Residence - Primary residence[/TD]
[TD]Personal Residence(s) - non-primary[/TD]
[TD]Residential Lot(s)[/TD]
[TD]Other 100% Owned Real Estate:[/TD]
[TD]Recreational Real Estate/Land[/TD]
[TD]Income Producing Properties[/TD]
[TD]Equity in RE Ptnrshps and/or partially owned RE[/TD]
[TD]Equity in Partnerships (Excluding Real Estate)[/TD]
[TD]Cash Value of Ins. & Annuities[/TD]
[TD]Retirement Plans, Deferred Comp., IRAs[/TD]
[TD]Personal Property[/TD]
[TD]Other Assets[/TD]
[TD]Fine Art or Farm Equipment[/TD]
[TD]Yachts, Aircraft[/TD]
[TD]Less: Est. Taxes Payable on Unrealized Asset Appreciation[/TD]
[TD]Total Assets[/TD]
[TD]Total Assets (Scorecard definition)[/TD]
[TD]Credit Cards[/TD]
[TD]Installment Accounts[/TD]
[TD]Other Accounts Payable[/TD]
[TD]Notes Payable to Bank[/TD]
[TD]Unsecured[/TD]
[TD]Secured (Non-R/E)[/TD]
[TD]Other Notes Payable[/TD]
[TD]To Related Parties (Non-R/E)[/TD]
[TD]Other (Non-R/E)[/TD]
[TD]Real Estate Liabilities[/TD]
[TD]Mortgages on Primary Residence[/TD]
[TD]Mortgages on Non-primary Residence(s)[/TD]
[TD]Mortgages on Residential Lot(s)[/TD]
[TD]Morts./Notes secured by other 100% owned R/E[/TD]
[TD]Morts. on Recreational Real Estate/Land[/TD]
[TD]Income Producing Properties[/TD]
[TD]Notes Due to R/E Partnership/Corps[/TD]
[TD]Other Direct R/E Debt[/TD]
[TD]Taxes Payable[/TD]
[TD]Income Taxes[/TD]
[TD]Margin Acct / Due to Brokers[/TD]
[TD]Loans against Insurance / other Policies[/TD]
[TD]Other Direct Liabilities[/TD]
[TD]Total Liabilities[/TD]
[TD]Total Liabilities (Scorecard definition)[/TD]
[TD]STATED NET WORTH:[/TD]
[TD]Contingent Liabilities (not to be used, use RAV version)[/TD]
[TD]Name of Borrower:[/TD]
[TD]Preparation Date (for the entire spread workbook)[/TD]
[TD]Financial Statement Date (corresponding date for each year of financial data)[/TD]
[TD]Actual Year[/TD]
[TD]Salaries[/TD]
[TD]Bonuses[/TD]
[TD]Dividends[/TD]
[TD]Interest[/TD]
[TD]Recurring Real Estate Inflows:[/TD]
[TD]Net Rents-NOI[/TD]
[TD]R/E Partnership Distributions[/TD]
[TD]Other Recurring - NOI[/TD]
[TD]Other Partnership Distributions[/TD]
[TD]Other (incl. Bus. Income, Trust Income)[/TD]
[TD]Other (incl. Retirement income/annuities)[/TD]
[TD]Other (verifiable income to be generated from asset purchased w/loan proceeds)[/TD]
[TD]Recurring Cash Sources SUBTOTAL[/TD]
[TD]Recurring Cash Sources (Scorecard definition)[/TD]
[TD]R/E Taxes for non-income prop.[/TD]
[TD]Planned Investments, Partnership[/TD]
[TD]Contributions & Capital Calls[/TD]
[TD]Estimated Living Expenses[/TD]
[TD]Federal Income Taxes[/TD]
[TD]State Income Taxes[/TD]
[TD]Other[/TD]
[TD]Recurring Cash Uses SUBTOTAL[/TD]
[TD]Recurring Cash Uses (Scorecard definition)[/TD]
[TD]CASH FL. AVAIL. FOR DEBT SERV.[/TD]
[TD]Subject Request debt (based on actual maturity)[/TD]
[TD]Subject Request debt[/TD]
[TD]Bank of America- revolving debt[/TD]
[TD]Bank of America- term debt[/TD]
[TD]Residential Mortgage debt[/TD]
[TD]Non-BoA debt[/TD]
[TD]Other CBI debt[/TD]
[TD]Sched. Cont. Liab. Pymts.[/TD]
[TD]DEBT SERVICE SUBTOTAL[/TD]
[TD]Debt Service (Scorecard definition)[/TD]
[TD]SUBTOTAL - RECURRING USES + DEBT SERVICE[/TD]
[TD]NET RECURRING CASH FLOW[/TD]
[TD]DEBT SERVICE COVERAGE[/TD]
[TD]Real Estate Sales[/TD]
[TD]New Real Estate Investment[/TD]
[TD]Sale of Mkt. Sec.[/TD]
[TD]Purchase of Mkt. Sec.[/TD]
[TD]Other purch. & capital outlays[/TD]
[TD]Other[/TD]
[TD]NON-RECURRING SOURCES (USES) SUBTOTAL[/TD]
[TD]NET CASH FLOW BEFORE FINANCING ACTIVITIES[/TD]
[TD]Real Estate Financing[/TD]
[TD]Margin Financing[/TD]
[TD]Homestead Financing[/TD]
[TD]Discretionary Debt Payments[/TD]
[TD]Contingent Liability Payments[/TD]
[TD]Other[/TD]
[TD]FINANCING SOURCES (USES) SUBTOTAL[/TD]
[TD]NET CASH FLOW (DEFICIT)[/TD]
[TD]Scorecard Federal Taxes[/TD]
[TD]Scorecard State Taxes[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PCF F79 FSC H80 M SU[/TD]
[TD="align: right"]$1,207.98[/TD]
[TD="align: right"]583.65[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1996.177[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2579.827[/TD]
[TD="align: right"]2579.827[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]563[/TD]
[TD="align: right"]4140[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5250[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]41253[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]624[/TD]
[TD="align: right"]15100[/TD]
[TD="align: right"]17700[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5204.342[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5204.342[/TD]
[TD="align: right"]5204.342[/TD]
[TD="align: right"]84705.49[/TD]
[TD="align: right"]9081.883[/TD]
[TD]Mark E Salzberg[/TD]
[TD="align: right"]5/7/2014[/TD]
[TD="align: right"]2/25/2014[/TD]
[TD]Various[/TD]
[TD="align: right"]1254.238[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2.442[/TD]
[TD="align: right"]52.004[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6236.688[/TD]
[TD="align: right"]13.779[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7559.151[/TD]
[TD="align: right"]7559.151[/TD]
[TD="align: right"]64.764[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]801.485[/TD]
[TD="align: right"]2267.745[/TD]
[TD="align: right"]5.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3139.194[/TD]
[TD="align: right"]3139.194[/TD]
[TD="align: right"]4419.957[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]209[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]32.412[/TD]
[TD="align: right"]168.304[/TD]
[TD="align: right"]409.716[/TD]
[TD="align: right"]409.716[/TD]
[TD="align: right"]3548.91[/TD]
[TD="align: right"]4010.241[/TD]
[TD="align: right"]10.78786[/TD]
[TD="align: right"]272[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2170.379[/TD]
[TD="align: right"]-260.838[/TD]
[TD="align: right"]2181.541[/TD]
[TD="align: right"]6191.782[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6191.782[/TD]
[TD="align: right"]392.6052[/TD]
[TD="align: right"]5.2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PCF F79 FSC H80 M SU[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]750[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]25000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]150[/TD]
[TD="align: right"]750[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6900[/TD]
[TD="align: right"]6900[/TD]
[TD="align: right"]25050[/TD]
[TD="align: right"]0[/TD]
[TD]Klentner Family Trust[/TD]
[TD="align: right"]7/24/2012[/TD]
[TD="align: right"]8/12/2012[/TD]
[TD]Various[/TD]
[TD="align: right"]99.5[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1.881[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]66.379[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]13.7[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]184.46[/TD]
[TD="align: right"]184.46[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]177.3143[/TD]
[TD="align: right"]1.941[/TD]
[TD="align: right"]6.174[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]185.4293[/TD]
[TD="align: right"]185.4293[/TD]
[TD="align: right"]-0.96925[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]64.92[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]364.9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17.76[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]447.58[/TD]
[TD="align: right"]447.58[/TD]
[TD="align: right"]633.0093[/TD]
[TD="align: right"]-448.549[/TD]
[TD="align: right"]-0.00217[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]180.288[/TD]
[TD="align: right"]-152.277[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]28.011[/TD]
[TD="align: right"]-420.538[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-420.538[/TD]
[TD="align: right"]1.941[/TD]
[TD="align: right"]6.174[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PCF F79 FSC H80 M SU[/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]6303.135[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2413.251[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]118479.6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]127196[/TD]
[TD="align: right"]127196[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]34000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"]161305[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]-5000[/TD]
[TD="align: right"]-5000[/TD]
[TD="align: right"]-5000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]58000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]14000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11583.2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]43000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]126783.2[/TD]
[TD="align: right"]126783.2[/TD]
[TD="align: right"]242217.8[/TD]
[TD="align: right"]1788.8[/TD]
[TD]Adam Lindemann[/TD]
[TD="align: right"]1/31/2014[/TD]
[TD="align: right"]9/30/2013[/TD]
[TD]Various[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1496.179[/TD]
[TD="align: right"]152.338[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]402.082[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2050.599[/TD]
[TD="align: right"]2050.599[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1027.19[/TD]
[TD="align: right"]80.991[/TD]
[TD="align: right"]96.447[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1204.628[/TD]
[TD="align: right"]1204.628[/TD]
[TD="align: right"]845.9712[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2600[/TD]
[TD="align: right"]2800[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]907.572[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]117.5853[/TD]
[TD="align: right"]6425.157[/TD]
[TD="align: right"]6425.157[/TD]
[TD="align: right"]7629.785[/TD]
[TD="align: right"]-5579.19[/TD]
[TD="align: right"]0.131665[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15905.85[/TD]
[TD="align: right"]-4997.33[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3612.91[/TD]
[TD="align: right"]14521.42[/TD]
[TD="align: right"]8942.238[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8942.238[/TD]
[TD="align: right"]80.991[/TD]
[TD="align: right"]96.447[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]PCF F79 FSC H80 M [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]3187.628[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2675.907[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]201713.3[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5.75[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]207582.6[/TD]
[TD="align: right"]207582.6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35500[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]17000[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]175000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]127966[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]14000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11383.16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]153349.2[/TD]
[TD="align: right"]153349.2[/TD]
[TD="align: right"]336733.4[/TD]
[TD="align: right"]1684.8[/TD]
[TD]Adam Lindemann[/TD]
[TD="align: right"]9/23/2014[/TD]
[TD="align: right"]6/30/2014[/TD]
[TD]Various[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1496.179[/TD]
[TD="align: right"]152.338[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]402.082[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2050.599[/TD]
[TD="align: right"]2050.599[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1021.261[/TD]
[TD="align: right"]80.991[/TD]
[TD="align: right"]96.447[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1198.699[/TD]
[TD="align: right"]1198.699[/TD]
[TD="align: right"]851.9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2800[/TD]
[TD="align: right"]2600[/TD]
[TD="align: right"]904.836[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]116.6147[/TD]
[TD="align: right"]6421.451[/TD]
[TD="align: right"]6421.451[/TD]
[TD="align: right"]7620.15[/TD]
[TD="align: right"]-5569.55[/TD]
[TD="align: right"]0.132665[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]15905.85[/TD]
[TD="align: right"]-4997.33[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3612.91[/TD]
[TD="align: right"]14521.42[/TD]
[TD="align: right"]8951.873[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8951.873[/TD]
[TD="align: right"]80.991[/TD]
[TD="align: right"]96.447[/TD]
[/TR]
</tbody>[/TABLE]
Last edited:
