Worksheet 2: Net Return of Assets
	Federal Funds Sold	Fixed-Rate Loan	Floating-Rate Loan	Installment Loan	Mortgage Loan	Government Bonds
	1-quarter	1-quarter	2-quarter	4-quarter	8-quarter	8-quarter
1. Contract Rate
2. Operating Costs
3. Advertising
4. Default Rate
Net Return on Individual Assets

incase that C/P is hard to read

Estimate the Net Return on Assets (Loans and government bonds) Fill in worksheet 2 to estimate the net returns on loans and government bonds using the output for quarter 1. 1. The contract rate is the rate quoted by the bank for loans and government bonds, expressed as an annual percentage rate (enter twelve percent as 12.00). See the full balance sheet for the rates. 2. Operating costs should all be multiplied by 4 for all loans except government bonds which should be divided by 2 because it incurs only a one-time fee. 3. Advertising expenses. For installment loans, divide advertising expenses by NEW installment loans (T+4) and for mortgages divide advertising expenses by new mortgages (T+8) and divide by 2. There are several ways to estimate the expected default rate. For this assignment, use 75% of the nonperforming rate as the expected default rate. Multiply default rate of fixed-rate loans by 4, floating-rate loans by 2, installment loans by 1 and divide mortgage loans by 2. Worksheet 2: Net Return of Assets Federal Funds Sold Fixed-Rate Loan Floating-Rate Loan Installment Loan Mortgage Loan Government Bonds 1-quarter 1-quarter 2-quarter 4-quarter 8-quarter 8-quarter 1. Contract Rate 2. Operating Costs 3. Advertising 4. Default Rate Net Return on Individual Assets 00 01 00 0 1 $25.000.00 423% $18,313.76 $0.00 $0.00 $99.452.00 5263,24739 5235,328.13 $265,94784 $120,000.00 $14,739.00 $3,500 29 $1,013,927.84 Summary HelseSheet ASSETS Required Reserves the Federal Reserve) Excers Reserve Balances Federal Funds Soul Fixed Corporate Loans Floating-rate Corporat Loans Consumer Loms Mortgage Loans Government Bonds Fixed Assets Loa Loss Allowance TOTAL ASSETS LIABILITIES Federal Funds Purchased Retail Demand Deposis Corporate Demand Deposits Nerable CDs Savings Depois Retail CDs Long-term Time Deposits Discount Window Advances Net Worth and Retined Earnings TOTAL LIABILITIES AND NET WORTH $17,79763 $0.00 $0.00 $109,468.62 5286,567 23 $231,176.39 $26168166 $120,000.00 $14.3 70.33 53.84158 $1,037.220.48 5 89936.17 0.00% S88040.15 0.00% 400 T2 $25,000.00 $99.44739 $33.000.00 $33.000.00 5.23% $33.000.00 5.23% $3000.00 523% $50.000.00 523% $64.266.51 6.00% T3 $25,000.00 $89,936.17 SR8,040.15 $149,000.00 $64.26661 $251,694.98 $216.63.68 561,375 57 $91,43832 $1,037.220.48 $132,000.00 $58,294 50 5235,816.95 $210,945.86 $75.463.21 $91,269.72 $1.013.92784 S120,743.01 6.00% $130,95197 7.00% 08 Baak Balance Sheet 01 Hak Balance Show ASSETS Required Reeves SI5513.76 $17.79763 LIABILITIES Excess Reserves SO DO S0.00 Federal Funds Purct 525 000 00 Faleral Funds Sold SO DO 50 00 Falaal Funds Purd Federal Funds Rate) 423% 423% Demand Deposit Fixed-rate Corporal $99 45200 109468 62 Rei $9944739 Fixed-rate Corporate 9.00% Real rate) 0.00% Floating-rate Corporate Loans, maring startof: Corporate $35.690.19 T+1 $130 675 66 $132571.74 Corporate) 0.00% T+1 (ratel 4.00% Negetables, maung surtof: T+2 $132.571.74 $153.99549 T+1 533 000.00 T+2 (at) 4.00% 3.70% T+1 (rade) 523% Consumer Loms, matering startof: $33.00000 $62 374 50 $5131391 "T+2 (rade) 5.23% T rade 1 100% 11.00% T+3 55131391 56662209 T rade) 523% T+2 rate) 11.00% 11.00% TH4 $33,000.00 T3 $66.622 09 55521762 T 4 (rate 523% T+1( e) 11.00% 1100% Savings Deposits $58,294.50 $55217.62 558,022.77 Savings Deposit (ra 500% T+4 ( ) 1 100% 10.70% Reals, maaring sorter Read Morte e Loans, maturing startot: T+ $115.073.94 53960230 535.190 68 T 1 (rar) 6.00% T+1 (Tue) 9.00% 9.00% T+2 $120.743.01 $35.190.68 S32.83430 T42 (rate 600% T+2 ( e) 9.00% 900% Long Time Deposis, maaring starter T+3 S32.83430 $28.647.09 T+1 $26.651.00 T+3 ) 900% | 9 | : T he 750% $28.647.09 $34,01286 T+2 $25,47753 T 4( e) 9.00% 9.00% T2 (rade) 7.50% T+5 $34.01286 $33 561 60 T+3 $26.094.26 T+5 rate 9.00% 9.0056 T rate) 7.50% 533 56160 53123488 T+4 $26,308 81 T+6 (Tue) 9.00% 9.00% T rade 730% $312348 $30 864 13 T S $2788983 T+7 (Tue) 9006 90046 T5 (re) 750% $30,864.13 S35 336.11 T46 $26,745.50 T+ ( re) 9.00% 8.70% T+6 (re) 7.50% Government bonds, matering surtof: $26.436.12 S1500000 $1 5 000 00 T 7(rak) 750% $15.000.00 $15.000.00 T+8 $25,342.70 $15.000.00 $15.000 00 T 8(rate) 7.50% T+4 $15,000.00 $15.000 no Discount Window A $75.463.21 $15.000.00 $15.000.00 Discount Window A 51 5000 00 SI 5000 no TQUITY CAPITAL $15.000.00 $15.000.00 Net Worth and Bear $91.269.72 $15.000 DO $15.000 00 TOTAL LIABLITT S1013.927.84 Fixed Assess $14.739.00 $1437053 Loan Loss Allowanc $3500 29 S3.N4158 TOTAL ASSETS $1013.92784 S 103722045 T42 $74536 $32134 544968 $264.12 T+6 $2,309.09 $5,400.01 $6,41348 $5,977.96 $1.869.00 $0.00 $0.00 $23,036.73 $2,459.30 $5,759.01 $6,249.93 $5,555.40 51 869 00 $0.00 $25,47733 7.50% $26,094.26 7.50% $26,308 31 7.30% $2788983 7.30% 526.745.60 750% $26.416.12 750% $25.342.70 750% $32,17382 8 50% $61,375.57 $22,90644 Income and Expense Report CURRENT REVENUE Posis.com Ratu Dand Doposis Corporate Demand Depost Interest Income Fixed Corporate Loans Floating Corporate Loans Consumer Los Mortgage Loans Government Bonds Federal Funds Sold Realized Gain Loss on Bonds TOTAL REVENUE CURRENT EXPENSES Interest Expos Federal Funds Purchased Retail Demand Deposits Corporate Demand Depos Negosable CDs Savings Deposs Long-term Time Deposits Real CDs Discount Window Advances Provision for Loan Losses Advertising Consumer Loans Mortgage Loms Retail Demand Deposis Corporate Demand Deposits Real CDs Savings Depos Long-term Time Deposits Other Non-interest Operaeg Cost FDIC Inverno Premium Federal Funds Fixed-rate Corporate Loans Floating-rate Corporate Loans Consumer Loms Mortgage Loans Government Bonds Retail Demand Deposits Corporate Demand Deposits DD Costs Offset by Excess Reserves Nezoubkan 923% $264.38 50.00 $0.00 $1,725.90 5728 68 $3,955.23 53.537.25 $1,741.31 $634.85 $264.38 50.00 $0.00 $1.948.18 $96400 $4,139.22 54,102 80 $1,416.14 $1.291.75 39143832 $1.037.220.48 $150.00 SRO,00 $410.00 5580.00 $290.00 $140.00 $60.00 SI50.00 SNO.00 $410.00 $580.00 $290.00 $140.00 56000 $575.54 $27.50 $198.90 $52649 $1,162.98 5601.58 $247.50 SI54.90 $376 48 528920 $1.661.77 $30.00 544968 $266.47 50.00 SS5.00 $38.11 $141.73 S113.76 52.368.48 $1584 $22.647.05 5259.39 590.79 $0.00 $0.00 $90.79 $16860 $30.00 $74754 $32114 $0.00 $3630 $76.06 $30894 $26368 $3,099.61 $10525 $22,18734 5849.40 $297.29 50.00 30.00 529729 5552.11 Long-term Time Deposits Premises and Faxed Assets Other Train Cast TOTAL EXPENSES NET CURRENTOPERATING EARNINGS Realized Capital Gans Taxes Applicables Capital Gains Total Taxes TOTAL NET INCOME 01 $120,000.00 $120,758 20 $99,452.00 $129.02 0.13% 0.15% $166.56 $1,000.00 $ 15,000.00 $1,004.95 4.23% $62.30 $15,000.00 $130.675.66 $27421 0.21% 0.37% $1,070.54 $1,006.88 4,83% $62.30 $ 15,000.00 an Performance Rer 0 0 Fixed-Rate Corporate Loans Matured Last Qual $111,402.64 Defaulted ($1,000 $96.44 Peront Defaulted 0.09% Percent Nonperfo 0.14% Nonperforming $136.41 Floating-Rate Corporate Loans Matured Last Qual $148,501.26 Defaulted ($1,001 $27957 Peront Defaulted 0.19% Percent Nonperfo 0.30% Nonperforming $ 792.40 Consumer Loans Matured Last Qual $62.438.61 Defaulted ($1,001 $49030 PercentDefaulted 0.79% Percent Nonperfo 0.98% Nonperforming $2,310.58 Mortgage Loans Matured Last Ouan $34.82221 Defaulted ($1,000 $24.50 PeroentDefaulted 0.07% Percent Nonperfa 0.10% Nonperforming $260.90 . TOTAL Matured 1 $357,164.72 TOTAL Defaulted $890.81 TOTAL Nonperf $3,500.29 $62 374.50 $517.56 0.83% 1.01% $2,339.65 $1.008.78 5.03% $62.30 $15,000.00 $39.602.30 $29.66 0.07% 0.10% $264.84 $1,009.68 5.23% $62.30 $15,000.00 $332,104.46 $950.46 $3,841.58 $1,009.00 5.48% $62.30 $15,000.00 01 $1,007.14 5.73% $62.30 $ 15,000.00 $1,004.12 5.98% $62.30 $15,000.00 lond Portfolio Repo Q0 Book Value of Port $120,000.00 Market Value of Poi $120,775.74 Maturing startof: Quarter T Market Price (T) $1,000.00 Bank Holdings $15,000.00 Quarter T+1 Market Price (T+1 $1,004.95 Market Yield (T+1 4.23% Coupon Amount $6230 Bank Holdings $15,000.00 Quarter T+2 Market Price (T+2 $1,006,90 Market Yield (T+2 4.83% Coupon Amount $62.30 Bank Holdings $15,000.00 Quarter T+3 Market Price (T+3 $1,008.82 Market Yield (T+3 5.03% Coupon Amount $62.30 Bank Holdings $ 15,000.00 Quarter T+4 Market Price (T+4 $1,009.77 Market Yield (T+4 5.23% Coupon Amount $62.30 Bank Holdings $15,000.00 Quarter T+5 Market Price (T+5 $1,009.18 Market Yield (T+5 5.48% Coupon Amount $6230 Bank Holdings $15,000.00 Quarter T+6 Market Price (T+6 $1,007.46 Market Yield (T+6 5.73% Coupon Amount $6230 Bank Holdings $15,000.00 Quarter T+7 Market Price (T+7 $1,004.63 Market Yield (T+7 5.98% Coupon Amount $62.30 Bank Holdings $ 15,000.00 Quarter T+8 Market Price (T+8 $1,000.00 Market Yield (T+8 6.23% Coupon Amount $6230 Capitalization Repo Price Per Share Current quarter $20.75 Prior quarter $19.38 Market Value of Equity Currentquarter $20,746.97 Prior quarter $19,384.26 Book Value of Equity Current quarter $91,269.72 Prior quarter $91,269.72 Number of Shares Outstanding Currentquarter 1,000,000 Prior quarter 1,000,000 Number of shares Sold by Management Current quarter Prior quarter Price of Shares Sold by Management Current quarter $0.00 Prior quarter $0.00 Number of shares Sold by Regulators Current quarter Prior quarter Price of Shares Sold by Regulators Current quarter $0.00 Prior quarter $0.00 Dividends Paid Current quarter $0.00 Prior quarter $0.00 Net Total Assets Current quarter $1,013,927.84 Prior quarter $1,053,390.55 Risk-weighted Assets Current quarter $745,94044 Prior quarter $783,020.64 $783,020.04 Basel Tier I Ratio Current quarter 12.24% Prior quarter 11.66% Basel Tier I+II Ratio Current quarter 12.70% Prior quarter 12.14% Capital Asset Ratio Currentquarter 9.00% Prior quarter 8.66% $25,000.00 $100,000.00 $25,000.00 $0.00 $0.00 $50,000.00 $15.000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,000.00 6.23% $62.30 01 00 $17.37 $20.75 Decisions 00 Quantities Initial Reserve Alla $0.00 Federal Funds So $0.00 Federal Funds Pu $25,000.00 90-day Negotiabl $0.00 180-day Negotial $0.00 360-day Negotial $33,000.00 New 8-quarter Bo $15,000.00 Bonds to Scil duc $0.00 Bonds to Sell duc $0.00 Bonds to Scll. duc $0.00 Bonds to Sell duc $0.00 Bonds to Sell, duc $0.00 Bonds to Sell. duc $0.00 Bonds to Scll. duc $0.00 Rates Fixed-rate Corpoi 9.30% Floating-rate Loan 4.00% Consumer Loans 11.00% Mortgage Loans 9.00% Corporate Deman 0.00% Retail Demand Da 0.00% Savings Deposits 5.00% Retail CDs 6.00% Long-term Time I 7.50% Advertising Consumer Loans $150.00 Mortgage Loans $80.00 Retail Demand De $410.00 Corporate Deman $580.00 Retail CDs $290.00 Savings Deposits $140.00 Long-term Time I $60.00 Other Miscellaneous Decisions Number of Share Provision for Los $1.00 Corporate Loans Corporate Loan S Total Dividends $0.00 Peroen tof Cost Ch 100.00% Percentof Cost Ch 100.00% $17,369.58 $20,746.97 9.00% 3.70% 10.70% 8.70% 0.00% 0.00% 6.00% 7.00% 8.50% $91,43832 $91,269.72 1,000,000 1,000,000 $150.00 $80.00 $410.00 $580.00 $290.00 $140.00 $60.00 $0.00 $0.00 $500.00 $0.00 $0.00 $0.00 100.00% 100.00% $0.00 $0.00 $1,037,220.48 $1,013,927.84 $772.423.60 3 7 $745,940.44 11.84% 12.24% 12.34% 12.70% 882% 9.00% Estimate the Net Return on Assets (Loans and government bonds) Fill in worksheet 2 to estimate the net returns on loans and government bonds using the output for quarter 1. 1. The contract rate is the rate quoted by the bank for loans and government bonds, expressed as an annual percentage rate (enter twelve percent as 12.00). See the full balance sheet for the rates. 2. Operating costs should all be multiplied by 4 for all loans except government bonds which should be divided by 2 because it incurs only a one-time fee. 3. Advertising expenses. For installment loans, divide advertising expenses by NEW installment loans (T+4) and for mortgages divide advertising expenses by new mortgages (T+8) and divide by 2. There are several ways to estimate the expected default rate. For this assignment, use 75% of the nonperforming rate as the expected default rate. Multiply default rate of fixed-rate loans by 4, floating-rate loans by 2, installment loans by 1 and divide mortgage loans by 2. Worksheet 2: Net Return of Assets Federal Funds Sold Fixed-Rate Loan Floating-Rate Loan Installment Loan Mortgage Loan Government Bonds 1-quarter 1-quarter 2-quarter 4-quarter 8-quarter 8-quarter 1. Contract Rate 2. Operating Costs 3. Advertising 4. Default Rate Net Return on Individual Assets 00 01 00 0 1 $25.000.00 423% $18,313.76 $0.00 $0.00 $99.452.00 5263,24739 5235,328.13 $265,94784 $120,000.00 $14,739.00 $3,500 29 $1,013,927.84 Summary HelseSheet ASSETS Required Reserves the Federal Reserve) Excers Reserve Balances Federal Funds Soul Fixed Corporate Loans Floating-rate Corporat Loans Consumer Loms Mortgage Loans Government Bonds Fixed Assets Loa Loss Allowance TOTAL ASSETS LIABILITIES Federal Funds Purchased Retail Demand Deposis Corporate Demand Deposits Nerable CDs Savings Depois Retail CDs Long-term Time Deposits Discount Window Advances Net Worth and Retined Earnings TOTAL LIABILITIES AND NET WORTH $17,79763 $0.00 $0.00 $109,468.62 5286,567 23 $231,176.39 $26168166 $120,000.00 $14.3 70.33 53.84158 $1,037.220.48 5 89936.17 0.00% S88040.15 0.00% 400 T2 $25,000.00 $99.44739 $33.000.00 $33.000.00 5.23% $33.000.00 5.23% $3000.00 523% $50.000.00 523% $64.266.51 6.00% T3 $25,000.00 $89,936.17 SR8,040.15 $149,000.00 $64.26661 $251,694.98 $216.63.68 561,375 57 $91,43832 $1,037.220.48 $132,000.00 $58,294 50 5235,816.95 $210,945.86 $75.463.21 $91,269.72 $1.013.92784 S120,743.01 6.00% $130,95197 7.00% 08 Baak Balance Sheet 01 Hak Balance Show ASSETS Required Reeves SI5513.76 $17.79763 LIABILITIES Excess Reserves SO DO S0.00 Federal Funds Purct 525 000 00 Faleral Funds Sold SO DO 50 00 Falaal Funds Purd Federal Funds Rate) 423% 423% Demand Deposit Fixed-rate Corporal $99 45200 109468 62 Rei $9944739 Fixed-rate Corporate 9.00% Real rate) 0.00% Floating-rate Corporate Loans, maring startof: Corporate $35.690.19 T+1 $130 675 66 $132571.74 Corporate) 0.00% T+1 (ratel 4.00% Negetables, maung surtof: T+2 $132.571.74 $153.99549 T+1 533 000.00 T+2 (at) 4.00% 3.70% T+1 (rade) 523% Consumer Loms, matering startof: $33.00000 $62 374 50 $5131391 "T+2 (rade) 5.23% T rade 1 100% 11.00% T+3 55131391 56662209 T rade) 523% T+2 rate) 11.00% 11.00% TH4 $33,000.00 T3 $66.622 09 55521762 T 4 (rate 523% T+1( e) 11.00% 1100% Savings Deposits $58,294.50 $55217.62 558,022.77 Savings Deposit (ra 500% T+4 ( ) 1 100% 10.70% Reals, maaring sorter Read Morte e Loans, maturing startot: T+ $115.073.94 53960230 535.190 68 T 1 (rar) 6.00% T+1 (Tue) 9.00% 9.00% T+2 $120.743.01 $35.190.68 S32.83430 T42 (rate 600% T+2 ( e) 9.00% 900% Long Time Deposis, maaring starter T+3 S32.83430 $28.647.09 T+1 $26.651.00 T+3 ) 900% | 9 | : T he 750% $28.647.09 $34,01286 T+2 $25,47753 T 4( e) 9.00% 9.00% T2 (rade) 7.50% T+5 $34.01286 $33 561 60 T+3 $26.094.26 T+5 rate 9.00% 9.0056 T rate) 7.50% 533 56160 53123488 T+4 $26,308 81 T+6 (Tue) 9.00% 9.00% T rade 730% $312348 $30 864 13 T S $2788983 T+7 (Tue) 9006 90046 T5 (re) 750% $30,864.13 S35 336.11 T46 $26,745.50 T+ ( re) 9.00% 8.70% T+6 (re) 7.50% Government bonds, matering surtof: $26.436.12 S1500000 $1 5 000 00 T 7(rak) 750% $15.000.00 $15.000.00 T+8 $25,342.70 $15.000.00 $15.000 00 T 8(rate) 7.50% T+4 $15,000.00 $15.000 no Discount Window A $75.463.21 $15.000.00 $15.000.00 Discount Window A 51 5000 00 SI 5000 no TQUITY CAPITAL $15.000.00 $15.000.00 Net Worth and Bear $91.269.72 $15.000 DO $15.000 00 TOTAL LIABLITT S1013.927.84 Fixed Assess $14.739.00 $1437053 Loan Loss Allowanc $3500 29 S3.N4158 TOTAL ASSETS $1013.92784 S 103722045 T42 $74536 $32134 544968 $264.12 T+6 $2,309.09 $5,400.01 $6,41348 $5,977.96 $1.869.00 $0.00 $0.00 $23,036.73 $2,459.30 $5,759.01 $6,249.93 $5,555.40 51 869 00 $0.00 $25,47733 7.50% $26,094.26 7.50% $26,308 31 7.30% $2788983 7.30% 526.745.60 750% $26.416.12 750% $25.342.70 750% $32,17382 8 50% $61,375.57 $22,90644 Income and Expense Report CURRENT REVENUE Posis.com Ratu Dand Doposis Corporate Demand Depost Interest Income Fixed Corporate Loans Floating Corporate Loans Consumer Los Mortgage Loans Government Bonds Federal Funds Sold Realized Gain Loss on Bonds TOTAL REVENUE CURRENT EXPENSES Interest Expos Federal Funds Purchased Retail Demand Deposits Corporate Demand Depos Negosable CDs Savings Deposs Long-term Time Deposits Real CDs Discount Window Advances Provision for Loan Losses Advertising Consumer Loans Mortgage Loms Retail Demand Deposis Corporate Demand Deposits Real CDs Savings Depos Long-term Time Deposits Other Non-interest Operaeg Cost FDIC Inverno Premium Federal Funds Fixed-rate Corporate Loans Floating-rate Corporate Loans Consumer Loms Mortgage Loans Government Bonds Retail Demand Deposits Corporate Demand Deposits DD Costs Offset by Excess Reserves Nezoubkan 923% $264.38 50.00 $0.00 $1,725.90 5728 68 $3,955.23 53.537.25 $1,741.31 $634.85 $264.38 50.00 $0.00 $1.948.18 $96400 $4,139.22 54,102 80 $1,416.14 $1.291.75 39143832 $1.037.220.48 $150.00 SRO,00 $410.00 5580.00 $290.00 $140.00 $60.00 SI50.00 SNO.00 $410.00 $580.00 $290.00 $140.00 56000 $575.54 $27.50 $198.90 $52649 $1,162.98 5601.58 $247.50 SI54.90 $376 48 528920 $1.661.77 $30.00 544968 $266.47 50.00 SS5.00 $38.11 $141.73 S113.76 52.368.48 $1584 $22.647.05 5259.39 590.79 $0.00 $0.00 $90.79 $16860 $30.00 $74754 $32114 $0.00 $3630 $76.06 $30894 $26368 $3,099.61 $10525 $22,18734 5849.40 $297.29 50.00 30.00 529729 5552.11 Long-term Time Deposits Premises and Faxed Assets Other Train Cast TOTAL EXPENSES NET CURRENTOPERATING EARNINGS Realized Capital Gans Taxes Applicables Capital Gains Total Taxes TOTAL NET INCOME 01 $120,000.00 $120,758 20 $99,452.00 $129.02 0.13% 0.15% $166.56 $1,000.00 $ 15,000.00 $1,004.95 4.23% $62.30 $15,000.00 $130.675.66 $27421 0.21% 0.37% $1,070.54 $1,006.88 4,83% $62.30 $ 15,000.00 an Performance Rer 0 0 Fixed-Rate Corporate Loans Matured Last Qual $111,402.64 Defaulted ($1,000 $96.44 Peront Defaulted 0.09% Percent Nonperfo 0.14% Nonperforming $136.41 Floating-Rate Corporate Loans Matured Last Qual $148,501.26 Defaulted ($1,001 $27957 Peront Defaulted 0.19% Percent Nonperfo 0.30% Nonperforming $ 792.40 Consumer Loans Matured Last Qual $62.438.61 Defaulted ($1,001 $49030 PercentDefaulted 0.79% Percent Nonperfo 0.98% Nonperforming $2,310.58 Mortgage Loans Matured Last Ouan $34.82221 Defaulted ($1,000 $24.50 PeroentDefaulted 0.07% Percent Nonperfa 0.10% Nonperforming $260.90 . TOTAL Matured 1 $357,164.72 TOTAL Defaulted $890.81 TOTAL Nonperf $3,500.29 $62 374.50 $517.56 0.83% 1.01% $2,339.65 $1.008.78 5.03% $62.30 $15,000.00 $39.602.30 $29.66 0.07% 0.10% $264.84 $1,009.68 5.23% $62.30 $15,000.00 $332,104.46 $950.46 $3,841.58 $1,009.00 5.48% $62.30 $15,000.00 01 $1,007.14 5.73% $62.30 $ 15,000.00 $1,004.12 5.98% $62.30 $15,000.00 lond Portfolio Repo Q0 Book Value of Port $120,000.00 Market Value of Poi $120,775.74 Maturing startof: Quarter T Market Price (T) $1,000.00 Bank Holdings $15,000.00 Quarter T+1 Market Price (T+1 $1,004.95 Market Yield (T+1 4.23% Coupon Amount $6230 Bank Holdings $15,000.00 Quarter T+2 Market Price (T+2 $1,006,90 Market Yield (T+2 4.83% Coupon Amount $62.30 Bank Holdings $15,000.00 Quarter T+3 Market Price (T+3 $1,008.82 Market Yield (T+3 5.03% Coupon Amount $62.30 Bank Holdings $ 15,000.00 Quarter T+4 Market Price (T+4 $1,009.77 Market Yield (T+4 5.23% Coupon Amount $62.30 Bank Holdings $15,000.00 Quarter T+5 Market Price (T+5 $1,009.18 Market Yield (T+5 5.48% Coupon Amount $6230 Bank Holdings $15,000.00 Quarter T+6 Market Price (T+6 $1,007.46 Market Yield (T+6 5.73% Coupon Amount $6230 Bank Holdings $15,000.00 Quarter T+7 Market Price (T+7 $1,004.63 Market Yield (T+7 5.98% Coupon Amount $62.30 Bank Holdings $ 15,000.00 Quarter T+8 Market Price (T+8 $1,000.00 Market Yield (T+8 6.23% Coupon Amount $6230 Capitalization Repo Price Per Share Current quarter $20.75 Prior quarter $19.38 Market Value of Equity Currentquarter $20,746.97 Prior quarter $19,384.26 Book Value of Equity Current quarter $91,269.72 Prior quarter $91,269.72 Number of Shares Outstanding Currentquarter 1,000,000 Prior quarter 1,000,000 Number of shares Sold by Management Current quarter Prior quarter Price of Shares Sold by Management Current quarter $0.00 Prior quarter $0.00 Number of shares Sold by Regulators Current quarter Prior quarter Price of Shares Sold by Regulators Current quarter $0.00 Prior quarter $0.00 Dividends Paid Current quarter $0.00 Prior quarter $0.00 Net Total Assets Current quarter $1,013,927.84 Prior quarter $1,053,390.55 Risk-weighted Assets Current quarter $745,94044 Prior quarter $783,020.64 $783,020.04 Basel Tier I Ratio Current quarter 12.24% Prior quarter 11.66% Basel Tier I+II Ratio Current quarter 12.70% Prior quarter 12.14% Capital Asset Ratio Currentquarter 9.00% Prior quarter 8.66% $25,000.00 $100,000.00 $25,000.00 $0.00 $0.00 $50,000.00 $15.000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,000.00 6.23% $62.30 01 00 $17.37 $20.75 Decisions 00 Quantities Initial Reserve Alla $0.00 Federal Funds So $0.00 Federal Funds Pu $25,000.00 90-day Negotiabl $0.00 180-day Negotial $0.00 360-day Negotial $33,000.00 New 8-quarter Bo $15,000.00 Bonds to Scil duc $0.00 Bonds to Sell duc $0.00 Bonds to Scll. duc $0.00 Bonds to Sell duc $0.00 Bonds to Sell, duc $0.00 Bonds to Sell. duc $0.00 Bonds to Scll. duc $0.00 Rates Fixed-rate Corpoi 9.30% Floating-rate Loan 4.00% Consumer Loans 11.00% Mortgage Loans 9.00% Corporate Deman 0.00% Retail Demand Da 0.00% Savings Deposits 5.00% Retail CDs 6.00% Long-term Time I 7.50% Advertising Consumer Loans $150.00 Mortgage Loans $80.00 Retail Demand De $410.00 Corporate Deman $580.00 Retail CDs $290.00 Savings Deposits $140.00 Long-term Time I $60.00 Other Miscellaneous Decisions Number of Share Provision for Los $1.00 Corporate Loans Corporate Loan S Total Dividends $0.00 Peroen tof Cost Ch 100.00% Percentof Cost Ch 100.00% $17,369.58 $20,746.97 9.00% 3.70% 10.70% 8.70% 0.00% 0.00% 6.00% 7.00% 8.50% $91,43832 $91,269.72 1,000,000 1,000,000 $150.00 $80.00 $410.00 $580.00 $290.00 $140.00 $60.00 $0.00 $0.00 $500.00 $0.00 $0.00 $0.00 100.00% 100.00% $0.00 $0.00 $1,037,220.48 $1,013,927.84 $772.423.60 3 7 $745,940.44 11.84% 12.24% 12.34% 12.70% 882% 9.00%