Category : Lotus and other Spreadsheets
Archive   : WORDPLAN.ZIP
Filename : DEMO1.WP

\clscreen
\comment
\comment READING LOTUS 1-2-3 WORKSHEET
\comment
\ldwks demo1.wks
\comment
\comment setup formatting commands
\comment
\nfill
\rmargin 72
\wrline 1985 ANNUAL REPORT
\indent 6
\center 4
1 9 8 5
A N N U A L
R E P O R T
A C M E C R E D I T U N I O N
\space
P R E S I D E N T ' S M E S S A G E
\space
\pad @C1..@C4
\mask @C1 = #,###
\mask @C2..@C4 = $##
\fill
\tindent 5
1985 has been a year of new programs and services at the Credit
Union. We introduced Share Draft Checking, All Saver
Certificates, Net Check payroll deductions, free travelers
checks, redemption of U.S. Savings Bonds, and Credit Line - a
self-replenishing, revolving line of credit. With the addition of
these programs, the Credit Union is now a more complete,
"one-stop" financial institution.
\space
\tindent 5
The Share Draft program has proven to be a major success story.
We opened more than @C1 accounts this year, and we expect this
number will grow as we add new services to the program. At
year-end, Credit Line was introduced; it provides overdraft
protection for Share Draft accounts, and is a source of immediate
credit. This is accomplished through a single credit application.
\tindent 5
Our other new programs and services have been equally well
received. The All Saver Certificate has proven to be of great
interest to our members. They have invested more than @C2 million
in this tax-free program. Free travelers checks and bond
redemptions are some other services our members are finding
increasingly attractive.
\tindent 5
Our new Individual Retirement Account policy will provide our
members a place to accumulate tax deferred funds. These accounts
will earn high dividends, while members save, augmenting their
retirement income.
\tindent 5
Even though 1985 was again a year of turmoil throughout the
economy, your Credit Union maintained its strong financial
position. We paid over @C3 million in dividends, met all
regulatory reserve requirements, and added to contingency
reserves. As of the end of November, our assets totalled over @C4
million.
\tindent 5
Looking to the future, the Credit Union is planning more new
programs and services. In an effort to increase the convenience
and accessibility of the Credit Union, we are planning to install
automated teller machines within the ACME complex in 1986. These
machines will be an added member service for simple transactions
such as account inquiries, deposits, and withdrawals. They should
help relieve the congestion in our lobby and parking areas. We
are also studying the feasibility of establishing a branch
office.
\tindent 5
In the past 20 years, the Credit Union has seen a large number of
changes and substantial expansion. It is through our professional
staff, dedicated Board of Directors, and especially our loyal
membership that we have been able to increase and improve our
services. We look now to the challenge of 1986 and foresee a year
of further growth and service improvements for you, our members.
\space 2
\tindent 5
John Doe, President
\bpage
\nfill
S T A T E M E N T O F C O N D I T I O N
\space
\comment
\comment SETTING UP DISPLAY FORMAT MASK
\comment
\pad @A1.@B25
\mask @A1.@B40 = ##,###,###,###
\comment
\comment CALCULATING COLUMN SUMS
\comment
\equation @B30 = sum(@B1..@B5)
\equation @A30 = sum(@A1..@A5)
\equation @B31 = sum(@B6..@B12)
\equation @A31 = sum(@A6..@A12)
\comment
\comment display yearly summaries
\comment
December 31 December 31
Assets 1985 1984
--------------------------------------------------------------------
Cash and
Investments @B1........... @A1...........
Loans to Members @B2........... @A2...........
Buildings and
Equipment @B3........... @A3...........
Receivable @B4........... @A4...........
All other Assets @B5........... @A5...........
--------------------------------------------------------------------
Total Assets @B30.......... @A30..........
\space 2
Liabilities and Members' Equity
--------------------------------------------------------------------
Members' Share and
Certificate Accounts @B6........... @A6...........
Accounts Payable @B7........... @A7...........
Notes Payable @B8........... @A8...........
Dividends Payable @B9........... @A9...........
Undivided Earnings @B10.......... @A10..........
Regular and
Contingency
Reserves @B11.......... @A11..........
Accrued Liabilities @B12.......... @A12..........
--------------------------------------------------------------------
Total Liabilities and
Members' Equity @B31.......... @A31..........
--------------------------------------------------------------------
\space
\comment
\comment convert to millions of dollars format
\comment
\equation @B1..@B14,@B30,@B31 = /1000000
\equation @A1..@A14,@A30,@A31 = /1000000
\comment
\comment calculate percent differences
\comment
\equation @A32 = (@B30 - @A30) / @A30 * 100
\equation @A33 = (@B06 - @A06) / @A06 * 100
\equation @A34 = (@B02 - @A02) / @A02 * 100
\equation @A35 = (@B13 - @A13) / @A13 * 100
\equation @A36 = (@b11 - @A11) / @A11 * 100
\equation @A37 = (@B01 - @A01) / @A01 * 100
\equation @A38 = (@B14 - @A14) / @A14 * 100
\comment
\comment set up output masks
\comment
\mask @A01..@B31 = #,###.#
\mask @A32..@A38 = ###.# %
\space
Year-end Financial Results for 1985 and 1984
(in millions)
1985 1984 %Change
--------------------------------------------------------------------
Total Assets @B30... @A30... @A32...
Members Share &
Certificate Accounts @B06... @A06... @A33...
Loans to Members @B02... @A02... @A34...
Delinquent Loans @B13... @A13... @A35...
Reserves @B11... @A11... @A36...
Cash & Investments @B01... @A01... @A37...
Dividends Paid to @B14... @A14... @A38...
\bpage
\equation @A39 = sum(@B15..@B18)
\mask @B15..@B18, @A39 = ###,###,###
\npad @A39
C R E D I T C O M M I T T E E R E P O R T
\space
--------------------------------------------------------------------
\space
\fill
\tindent 5
Throughout this year, lending activity continued at a steady
pace. The Credit Union offered a very diverse program that
included personal loans, auto/truck loans, share secured loans,
and real estate loans. Toward the end of 1985, we offered a new
program called Credit Line. This is a revolving line of credit,
and can be used as overdraft protection for share draft accounts.
\tindent 5
The Board of Directors maintained a continuing review of loan
activity throughout this year, and hopes economic conditions will
soon permit a return to an expanded loan policy. We think our new
line of credit will be a step towards this expansion, as well as
some other new programs now being considered by the Board of
Directors. These programs will be announced as they are
developed.
\tindent 5
Loan activity, although reduced from 1984, maintained a very
steady pace. During 1985, the Credit Union loaned @A39 to its
members. Loans of the following types were made:

\pad @A39
\space
\nfill
Personal @B15.......
Auto/Truck @B16.......
Real Estate @B17.......
Shared Secured @B18.......
TOTAL @A39.......
\space
\fill
\tindent 5
The Credit Committee appreciates your support in the past and
hopes to be able to offer an expanded loan policy in 1986.
\space
\tindent
Peter Doe, Chairman