Financial Analysis and Credit Evaluation Case Study

Interest Rates and Loan Pricing

SBSC bank currently pays 1.55% p.a. on 12-month term deposits and expects to be able to attract similar funds in 12 months’ time at a cost of 1.35%. Accordingly, it has priced a fixed two-year loan of $5,500,000 at 1.0% over the expected cost of funds with interest paid annually. The day following the issue of the loan, the yield on both one- year and two-year maturity government bonds (indicators of market rates) decreased by 0.20% p.a.

• Ignoring all other assets and liabilities calculate the present value of the expected interest margin.
• What is the importance of the loan-to-value ratio (LVR)? If the LVR is 55% for a loan based on a firm’s accounts receivable, is the credit risk of the lender fully covered?

• ESG Prime Bank has an obligation of $750 at the end of the first period and $550 at the end of the second period. It also has $1,528.93 to invest and can choose between zero-coupon bond or the coupon bond. The coupon bond matures in two years, pays an annual coupon of $100, and has a balloon payment of $1,400. The zero-coupon bond has a balloon payment of $1,610 at the end of the second year. The default-free yield on a one-year bond is 10%, and the annualized yield on a two-year bond is also 10%. What is the present value of the bank’s equity?

(ii) Suppose the interest rate at t = 1 is 8%. What will be ESG Prime Bank’s equity if it invests in the zero-coupon bond?

Match Microsoft, Boeing, and Cathay Pacific to their respective 2019 Annual Reports. Provide justification for your selections.  No calculations are required.

The senior lending officer has provided you with the data below and you have to consider what analysis your wish to undertake. Please discuss pertinent questions that you would ask the senior lending officer before you commence the analysis and provide a rationale for the analyses you wish to undertake. Note: CF_TD (cash flow to total debt), NI_TA (net income to total assets), CA_CL (current assets to current liabilities), CA_NS (current assets to net sales) and F_OR_NF (fail or not fail). 

Summarize the pros and cons of judgmental and empirically based credit evaluation systems. What would you recommend? Would your recommendation change if you were evaluating Singapore Airlines for a loan during the COVID-19 pandemic? No calculations are required but your answer must relate to the Statement of Financial Position presented.

A company has a choice between a bullet loan and an equivalent amortized loan with a value of $3,500,000. Calculate the repayment cash flows for a four-year loan with 3.15% pa fixed interest rate bullet loan and the equivalent amortized loan.

Based on your calculations for the bullet loan repayments and amortized loan repayments, explain why the bank recommends that the amortized loan be taken. If interest rates fell to 2.35% fixed rate, would that alter the bank’s recommendation?

The accounts of 4,500 credit card customers out of a sample of 40,000 that were reviewed did not perform satisfactorily. The credit scores assigned to these applicants when originally assessed had a mean of 70 and standard deviation of 8. The scores of the remaining customers had a mean of 87 and a standard deviation of 12. Assuming these distributions are approximately normal, if the cut-off score was revised upward to 82.

• Complete the following table:

(ii) The original default rate on the sample of 40,000 card holders was extremely high. What impact would be setting the cut-off at 82 have on the default rate? Show calculations. Is this adjustment reasonable? Discuss.

(iii) Based on the credit evaluation process. Complete the following table and identify the Type I and Type II errors. All quadrants need to be identified.

Before Neo Goh Hian Distributors approaches the bank for a loan the company has asked their internal credit department to see if the firm can generate any internal funds.

What conclusions can you draw from your analysis?

What supplementary quantitative information is necessary to increase your confidence in your analysis?

How would your focus change if we were considering the COVID-19 crisis period?

Examine pages 118 and 119 of the 2020 Annual Report for OCBC Bank reproduced below and consider how the five C’s discussed in the course have application in the present coronavirus pandemic. Discuss if and how the ranking of the 5Cs change depending on whether you are considering “Consumers and Small Business”, “Corporate and Institutional Customers” or “Private Lending Customers”.