ABC, Bank BANKS' STATEMENTS OF FINANCIAL POSITION ASSETS Funds in U.S. Treasury Investments held-to-maturity Loans receivable Accrued interest receivable Advances to others Total Assets LIABILITIES AND NET POSITION Liabilities: Borrowings: Principal amount Plus unamortized premium Total borrowings Accrued Interest payable Other liabilities Total liabilities Loan commitments Net position Total liabilities BANKS' STATEMENT OF OPERATIONS AND CHANGES Revenue and Financing Sources: Interest on Loans Less legislatively-mandated interest credit Net interest on Loans Interest on Investments Revenue from servicing forms Total Revenue Expenses: Interest on Barrowings Administrative expenses Total Expenses Net Income Net Position:
Begenning of Year Net Income (Loss)gain on borrowing capital transactions End of Year BANKS' STATEMENTS OF CASH FLOW Cash flows from operations: Net Income Adjustments to reconcile net income to net cash provided by operations: Amortization of premium on loans Capitalisation of interest receivable Capitalisation of interest payable Decrease(increase)in accrued interest receivable Decrease(increase)in advances to others Decrease(increase)in accrued interest payable Increase in other liabilities Net cash provided by operations Cash flows from investing activities: Investment purchases Loan disbursements Loan collections Net cash used in investing activities Cash flows from financing activities: Borrowings Repayments of borrowings Net cash provided by financing activities Net increase(decrease)in cash Funds with U.S Treasury-beginning of the period Funds with U.S Treasury-end of the period Supplemental disclosures of cash flow information: Interest paid (net of amount capitalized) Supplemental schedule of noncash investing and financing activities: (Loss)gain on early extinguishment of borrowings treated as capital transactions
C, Bank 0
-1
744,393 29,535 38,476,868 182,884 92 39,433,772
228,114 0 33,992,122 451,930 658 34,672,824
36,036,419 287,953 36,324,372
31,620,998 348,111 31,969,109
205,534 180 36,530,086
338,529 149 32,307,787
2,903,686 39,433,772
2,365,037 34,672,824
0
-1
1,941,407 -97,998 1,843,409
1,977,872 -97,830 1,880,042
43 3,328 1,846,780
0 3,299 1,883,341
1,237,371 5,713 1,243,084 603,696
1,277,987 4,718 1,282,705 600,636
2,365,037 603,696 -65,047 2,903,686
1,753,829 600,636 10,572 2,365,037
0
-1
603,696
600,636
-60,158 -111 83,022 269,046 566 -132,995 31 763,097
-57,591 -1,150 94,322 -6,231 -375 16,199 20 645,830
-29,535 -95,961,408 91,476,773 -4,514,170
0 -15,397,941 13,250,542 -2,147,399
95,990,943 -91,723,591 4,267,352 516,279
15,397,941 -14,569,738 828,203 -673,366
228,114 744,393
901,480 228,114
1,344,743
1,239,045
-65,047
10,572
by operations:
ivities: as capital transactions
%3c%3fxml+version%3d%221.0%22+encoding%3d%22utf-16%22%3f%3e%0d%0a%3cWizardSettin ntSize%3e%0d%0a++++++++++++++++%3cX%3e1%3c%2fX%3e%0d%0a+++++++ fFormat%3e%0d%0a++++++++++++++++%3cWidth%3e87%3c%2fWidth%3 +++++++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d ++++++++++++++%3cX%3e1%3c%2fX%3e%0d%0a++ ++++++++++++++%3c%2fTD%3e%0d%0a++ %3e%0d%0a++++++++++++++++% fWrapText%3e%0d%0a+++++ ++++++++++++%
UEsFBgAAAAAAAAAAAAAAAAAAAAAAAA%3d%3d
+++++++++++++++%3cRowSpan+%2f%3e%0d%0a++++++++++++++++%3cColSpan+%2 lAlign%3e%0d%0a++++++++++++++++%3cCellHasFormula%3eFalse%3c%2fCellHasF FormControls+%2f%3e%0d%0a++++++++++++++++%3cGrid+%2f%3e%0d d%0a++++++++++++++++%3cText+%2f%3e%0d%0a+++++++ 4%3c%2fX%3e%0d%0a++++++++++++++++%3cY%3e3 ++++++++%3cPSCFormated%3efalse%3c%2fPS 0d%0a++++++++++++++++%3cFor CellHasFormula%3eFalse%3c% e%3c%2fWrapText%
7%3c%2fWidth%3e%0d%0a++++++++++++++++%3cText+%2f%3e%0d%0a++++++++++++ eight%3e%0d%0a++++++++++++++++%3cAlign%3eLeft%3c%2fAlign%3e%0d%0a++ fX%3e%0d%0a++++++++++++++++%3cY%3e56%3c%2fY%3e%0d%0a+++ eneral%3c%2fFormat%3e%0d%0a++++++++++++++++%3cWidth a++++++++++++++++%3cText+%2f%3e%0d%0a++++ ++++++++++++++++%3cAlign%3eLeft%3c%2 CellHasFormula%3eFalse%3c%2fCellHas 3e%0d%0a++++++++++++ rmControls+%2f%3e
3eGeneral%3c%2fFormat%3e%0d%0a++++++++++++++++%3cWidth%3e48%3c%2fWidth%3e% t%3eNet+increase(decrease)in+cash%3c%2fText%3e%0d%0a++++++++++++++++% %0a++++++++++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d +++++++++%3cImages+%2f%3e%0d%0a++++++++++++++++ ++++++++++%3cRowSpan+%2f%3e%0d%0a++++++++
%0d%0a++++++++++++++++%3cColSpan+%2f%3e%0d%0a++++++++++++++++%3cFormat%3eGe
++%3cFormat%3eGeneral%3c%2fFormat%3e%0d%0a++++++++++++++++%3cWidth%3e48%3c%2fWidth
h%3e48%3c%2fWidth%3e%0d%0a++++++++++++++++%3cText+%2f%3e%0d%0a++++++++++++++
+++++++++++++++%3cHeight%3e3%3c%2fHeight%3e%0d%0a++++++++++++++++%3cAlign%3eLe
+++%3cAlign%3eLeft%3c%2fAlign%3e%0d%0a++++++++++++++++%3cVerticalAlign+%2f%3e%0d%0a
gn+%2f%3e%0d%0a++++++++++++++++%3cCellHasFormula%3eFalse%3c%2fCellHasFormula%3e%0d%0
asFormula%3e%0d%0a++++++++++++++++%3cFontName%3eCalibri%3c%2fFontName%3e%0d%0a+++
me%3e%0d%0a++++++++++++++++%3cWrapText%3eFalse%3c%2fWrapText%3e%0d%0a+++++++++
0d%0a++++++++++++++++%3cFontSize%3e11%3c%2fFontSize%3e%0d%0a++++++++++++++++%3
+++++++++++%3cX%3e9%3c%2fX%3e%0d%0a++++++++++++++++%3cY%3e90%3c%2fY%3e%0d%
0%3c%2fY%3e%0d%0a++++++++++++++++%3cImages+%2f%3e%0d%0a++++++++++++++++%3cF
++++++++++%3cFormControls+%2f%3e%0d%0a++++++++++++++++%3cGrid+%2f%3e%0d%0a+++
2f%3e%0d%0a++++++++++++++++%3cExport+%2f%3e%0d%0a++++++++++++++%3c%2fTD%3e%
Follow the steps to enable your online Statements for Banks. >>
This template is prepared for creating and publishing statements for banks easily.
1)
Please enter the name of your bank:
ABC, Bank 2)
Type the name or symbol of currency: $
3)
This template may contain the statements of 2 years. Enter the final fiscal year:
4)
Enter the final update date of your statements (if you do not want to display this information, just leave the
2008 3/5/2009 >>
Your Income Stmt, Balance Sheet and Cash Flow are ready to use. Now you can enter your own data (fill on Further steps are for online use.
3)
Visit the site below: http://www.spreadsheetweb.com/getting_started.htm Ignore the downloaded software, you will only need the username and password.
4)
Visit the site below and login with your new account: https://www4.spreadsheetweb.com/SpreadsheetWEB//
5)
Click "Add Web Application" to upload this file. Your Financial Statement will be created automatically. You can simply use your Financial Statement from that link or place it on your website.
>>
Your online Financial Statement will look like:
http://www1.spreadsheetweb.com/SpreadSheetWeb/Output.aspx?ApplicationId=ec81af03-f23e-42d6-835b-ab40e949f443 >>
In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm
Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/
ents for Banks.
nformation, just leave the box below empty):
nter your own data (fill only the unprotected cells).
eated automatically.
3e-42d6-835b-ab40e949f443