Your Bank’s Name Here
Rating: Buy, Hold, or Sell HereAnalyst:Your Name Here
Date of Report HereCurrent Stock Price$
Price/Earnings (ttm) Target Price Fiscal Year-End$
Price/Book
Dividend Yield%EPS (ttm)$
Market Capitalization$BMy Estimated 2022 EPS$
Company Overview:
Recent Significant News:
Asset and Loan Distribution Analysis: Include a table directly above of major asset categories and major loan types compared with the peer group, using FDIC SDI, % of Assets, don’t paste a screenshot! Provide brief discussion. The peer group you should use is “All Institutions Assets $10 Bil – $250 Bil”.
Delete all the red text in this template. Submit single-side hard copies.
Use a 12pt Times New Roman font throughout the report. Do not change the margins. Do not extend anything beyond the page it is meant to appear on.
Data sources for report: (limit yourself to these sources)
Company web page
Company 10-K reports at
FDIC SDI at
Yahoo Finance
Finra
Capital Analysis: Include a table directly above, using FDIC SDI compared with the peer group, don’t paste a screenshot! Provide brief discussion.
Asset Quality Analysis: Include a table directly above, using FDIC SDI compared with the peer group, don’t paste a screenshot! Provide brief discussion.
Liquidity Analysis: Include a table directly above, using FDIC SDI compared with the peer group, don’t paste a screenshot! Provide brief discussion.
Earnings/ROE Analysis: Include a table directly above, using FDIC SDI ‘Performance and Condition Ratios’ data, illustrating net interest margin, non-interest income/assets, non-interest expense/assets, credit loss provision/assets, and ROE over the past 4 years, 2018, 2019, 2020, and 2021 in that order, for your bank. Provide brief discussion.
Interest Rate Risk Analysis: Include long-term assets (5+ years) comparison versus peer group using FDIC SDI, and include a brief simulation/scenario analysis summary from the 10-K, not a screenshot. Given what you know about the composition of the bank’s assets and liabilities, does the simulation appear reasonable?
Key Assumptions of Discounted Cash Flow Analysis: (with your brief reasoning for each)
Total Assets Growth Rate:
Interest Income/Avg TA:
Interest Expense/Avg TL:
Provision for Loan Loss/Avg TA:
Non-Interest Income/Avg TA:
Non-Interest Expense/Avg TA:
Income Tax Rate:
Common Equity/Total Assets:
Estimate of Future Beta:
It is important that all the data entered/forecasted in the spreadsheet is from/based on the 10-K, which is for the bank holding company. When you own the stock, you own (part of) the holding company. The FDIC SDI data is for the bank subsidiary only.
On this page, provide a printout of your DCF valuation model, printing cells A1:L33 on a single page, landscape (sideways) orientation. Make it as big as possible while still fitting on the page.
Recommendation: Here is where you discuss your DCF model and make your recommendation (buy, sell, hold), based on your analysis in the report. What are the key investment risks for this stock (why might your price target not be achieved, apart from general fluctuations in the stock market)?
