Parallels The Growth Rate In Total Assets example essay topic

On an overall basis, total assets increased from a projected balance of $115 MM on January 1, 2002 to $159 MM on December 31, 2002. The investment securities portfolio is anticipated to be $19 MM as of December 31, 2002. Projected loan volume increase during 2002 is from $92 MM to $127 MM. Cash and Cash Equivalents Due From Banks - With the loan portfolio increasing by nearly $35 MM and total deposits projected to increase by $27 MM, a larger cash letter is anticipated. Due From Banks - Int Bearing - These funds are primarily FHLB deposits. The budget reflects a decrease in the balance by $100 M per month during the entire year. The decrease is due to servicing interest on the advances netted against security interest payments.

Fed Funds Sold - Plug. Pending Loan Disbursements - With the increase in loan production for 2002, the % of PLD to total cash and cash equivalents is anticipated to double from 14% at 1/1/02 to 28% at 12/31/02. Investment Securities With the exception of Equity Securities, each security type retains its pro rata share of the entire portfolio at both the beginning of the year and at year end. No assumptions are made for called securities.

Each security type reflects the maturing schedule as provided by HFW. Securities are added to the portfolio randomly. Equity Securities are increased when a new FHLB advance is added. Loans Commercial Loans - The total C / L portfolio reflects new loan volume of $23.5 million during 2002. This growth is reduced by an anticipated prepayment rate of 21.28%. Consumer / H.E. Loans - Growth in this area parallels the growth in total assets (39.13%).

Mortgage Loans - The total M / L portfolio reflects new loan volume of $42 MM during 2002. Again, this growth is reduced by an anticipated prepayment rate of 21.28%. Mortgage Loan Pools - One new pool ($300,000 per pool) is added to the portfolio from April through December. In addition, the prepayment rate of 21.28% applies. Other Loans and Overdrafts - Growth in this category parallels the growth in total assets (39.13%).

Reserve for Loan Losses - Computed at 1.5% of Gross Loans. Fixed Assets & Other Assets Bank Premises & Equipment - Monthly activity reflects a $40,000 increase reflecting beginning of year purchases. Subsequent purchases are slated in April, June, September, and December at $10,000 for each quarter. Monthly depreciation is estimated at approximately $15,000 per month. ORE - Other Real Estate is calculated at 2% of net loans. Interest Earned not Collected - The monthly balance is a percentage of gross loans.

In the first quarter, I ENC is 1.25% of gross loans. The factor increases by 25 bps each quarter. Prepaid's & Other Assets - Growth parallels the growth rate in total assets (39.13%). Total Deposits Each account category within the Total Deposits section reflects a growth rate that parallels the growth rate in total assets (39.13%). FHLB Advances - New advances increase by $12.5 million during the course of the year.

The advances are required to reflect new loan growth and liquidity. The advances are spread throughout the year and range in size from $1 MM to $2 MM in size. Accrued Int. & Other Lab. - Growth for this line item reflects a growth rate that parallels the growth rate in total assets (39.13). Total Equity Current YTD Income - The monthly growth rate for net income is slightly less than 5% per month.

Unrealized Securities Gains / Losses - Balance represents 1.5% of total investment securities portfolio. Income Statement Interest Income Income from Securities - Interest income is calculated using the following rates on a 360-day basis: U.S. Treasury 6.10% U.S. Agency 5.25% Corporates 6.85% Municipals 6.55% PEF CO 6.20% Equity (FHLB) 7.00%With the exception of the FHLB rate, each of the above rates was obtained from HFW's monthly reports. Loan Income - Interest & fee income is calculated using the following rates on an actual over 365-day basis: Commercial Loans 11.61% Consumer / HE 11.28% Mortgage Loans 11.73% Mort. Pools & Other 10.85%Each of the above rates represents the monthly average rate during 2001 as calculated on the Interest Yield Analysis in the Monthly Financial Package.

Interest Expense Expense from Deposits - Interest expense is calculated using the following rates on an actual over 365-day basis: Interest Bearing DDA - Jan. - July 4.75%; Reduced to 4.50% in August for balance of year. IRA's - Jan. - May 6.18%, June & July 6.15%, August 6.10%, Sept & Oct. 6.05%, Nov. & Dec. 6.00%. 11, 2002 and December 30, 2002, four advances with an average rate of 6.60% will mature and be replaced with advances with a dramatically lower rate. Provision for Loan Losses The monthly incremental change in the Provision for Loan Losses reflects the month-to-month change involving the loan loss reserve and an additional $25,000 per month increase for anticipated charge-offs. Non-Interest Expense Salaries and Benefits - Using January as a base month, the following increases from the preceding month are in place: Nov. & Dec. 1% Feb., March, Sept., Oct. 2% April, May, June, July, Aug. 4%FASB Loan Origination - Over the course of 2002,168 Commercial Loans and 550 Mortgage Loans are expected to be originated.

The flow of this volume is assumed to be spread evenly during the year. FASB rates for 2002 are as follows: C / L $2,309 for the entire year M / L $1,425 for the first quarter $1,375 for the second quarter $1,325 for the third quarter $1,275 for the fourth quarter Occupancy Expense - January and February expenses are expected to be consistent with the monthly expenses for 2001. In March, the monthly expense with increase by 5% for the balance of the year as provided in our lease with Realvesco. Furniture & Fixture - January and February expenses are expected to be consistent with the monthly expenses for 2001. In this budget, this expense is projected to increase by 1% per quarter during 2002. Professional Services - These expenses will continue to accrue at $6,000 per month for the first quarter.

For each subsequent quarter, the monthly expense will increase by 1% per quarter. Advertising & Marketing - In the first quarter, expenses will continue to accrue in the $15,000 to $16,000 per month range. This monthly expense will increase by $5,000 per month for the second quarter. In July and August, the monthly expense increases by additional $5,000 and subsequently lowers to 20,800 per month for the balance of the year. Provision for Income Taxes - Assumed rate is 34% of net income before taxes.