US Bank of Washington case. Assignment: Please prepare a Credit Proposal Memo similar to the one shown in Exhibit 1 of “Note on Bank Loans”. Given the limited information you have from the case, you are not expected to include all components of Exhibit 1 . The following is a suggested structure of your report: Purpose of the credit extension o Keep this part short Financial statement analysis, cash-flow projections, and debt service capacity. O This should be one main part of your report.
You should use an excel spread sheet to induct a sensitivity analysis on the projected cash flows and the ability of the borrower to repay the loan. Assessment of major risks, including impact of forecasted economic trends and the strength of competitors. O This is another main part of your report. In this part, you should examine the credit risk of the loan both as an individual loan and as a part of the banks loan portfolio. You should also consider whether the loan would fit the overall strategy and objective of the bank. Based on you analysis above, make a decision on whether the loan should be granted or not and under what condition.
Please provide a brief reason for your decision and the condition, if any. Regardless of your decision above, assuming that you decide to make the loan, what is your recommended loan structure? O Please specify the maturity and interest rate on the loan. In the last section of the case “Financing the Deal”, the case mentions several things that Mall Harding would do and some of his concerns. That should be taken as a hint on what you should do and what concerns you should have and more. Submission and Due Date: length of the text part of the report is 10 pages. Tables and fugues can be put at the end of the report.
They do not count towards the maximum page. You can save it as either a Microsoft Words file or a PDF file. Besides the report, you should also prepare an excel file that contains your cash flow sensitivity analysis and submit it together with your report. Please remember to list the names and student ID’s of all group members. Each group leader should submit their report together with the excel file by 9:00 pm on October 11 by email to me. Each group should also submit a hard copy of the report (without the excel file) to me at the beginning of the class in Week 1 1 . No late report will be accepted. Page 1 of 1