Statements For Banks

  • Uploaded by: SpreadsheetZONE
  • 0
  • 0
  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Statements For Banks as PDF for free.

More details

  • Words: 623
  • Pages: 23
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

Related Documents

Statements For Banks
June 2020 6
Banks
November 2019 39
For Banks -kyc Norms
June 2020 9
Banks
May 2020 21
Statements
December 2019 33
Banks
May 2020 23

More Documents from ""