Please complete the problem to find the predicted ROA and Probability in addition to finding if the banks next year ROA will be higher or lower if interest rates decline.

Be careful because there are other problems which are similar but the interest rates are different.

Identify the probability distribution of return on assets (ROA) for next year by completing this table:

Predicted Return on Assets Based on Interest Rate.

Interest Rate Scenario (Possible T-Bill Rate) PredictedROA Probability

6%

7%

8%

• Next year, will the bank'sROAbe lower or higher, if market interest rates decline? Support your decision. Note: You can use the T-bill rate to represent market interest rates.

INTEGRATIVE PROBLEM: As an analyst of a medium-sized commercial bank, you have been asked to forecast next year's performance. In June, you were provided with information about the sources and uses of funds for the upcoming year. The bank's sources of funds for the upcoming year are as follows (whereNCDsare negotiable certificates of deposit):

Source of Funds for Coming Year

Source of Funds Dollar Amount(in millions) Interest Rate to be Offered

Deman Deposits $5,000 0% Time Deposits $2,000 6% 1-yearNCD's $3,000 T-Bill rate + 1% 5-yearNCD's $2,500 1-year NCD rate + 1%

The bank also has $1 billion in capital. The bank's uses of funds for the upcoming year are as follows:

Use of Funds for Coming Year

Use of Funds Dollar Amount(in millions) Interest Rate LoanLossPercentage

Loans to small businesses $4,000 T-bill rate +6% 2%

Loans to large businesses $2,000 T-bill rate +4% 1%

Consumer loans $3,000 T-bill rate +7% 4%

Treasury bills $1,000 T-bill rate 0%

Treasury bonds $1,500 T-bill rate + 2% 0%

Corporate bonds $1,100 Treasury bond rate +2% 0%

The bank also has $900 million in fixed assets. The interest rates on loans to small and large businesses are tied to the T-bill rate and will change at the beginning of each new year. The forecasted Treasury bond rate is tied to the future T-bill rate because an upward-sloping yield curve is expected at the beginning of next year. The corporate bond rate is tied to the Treasury bond rate, allowing for a risk premium of 2%. Consumer loans will be provided at the beginning of next year, and interest rates will be fixed over the lifetime of the loan. The remaining time to maturity on all assets except T-bills exceeds three years. As the one-year T-bills mature, the funds are to be reinvested in new one-year T-bills (all T-bills are to be purchased at the beginning of the year). The bank's loan loss percentage reflects the percentage of bad loans. Assume that no interest will be received on these loans. In addition, assume that this percentage of loans will be accounted for as loan loss reserves (i.e, assume that they should be subtracted when determining before-tax income). The bank has forecast its noninterest revenues to be $200 million and its noninterest expenses to be $740 million. A tax rate of 34% can be applied to the before-tax income in order to estimate after-tax income.

The bank has developed the following probability distribution for the one-year T-bill rate at the beginning of next year:

Probability Distribution for one year T-bill at the beginning of next year:

Possible T-Bill Rate Probability

6% 20%

7% 60%

8% 20%