Finance Project Assignment
vomh1. Access the financial actuals; that is, historical financial data for the past five years for the bank ( Wells Fargo Bank), as well as your bank's competitor. o This may be taken from the commercial bank's web site, or from the SEC web site.
2. Develop a Microsoft Excel 2016 spreadsheet model using data given in the Statement of Financial Position. This should include:
o the balance sheet,
o income statement, and
o five to 10 common industry specific financial ratios for both your selected commercial bank and its competitor.
3. Given your Microsoft Excel spreadsheet, and the information it yields, write a report which discusses your commercial bank's strengths and weaknesses.
o This report must be written using the Microsoft Word 2016
4. Access the prevailing rates set by the Federal Reserve Board.
o Prepare a chart and analyze your selected commercial bank’s historical profitability with the Federal Reserve interest rates over the past five years
o Discuss how these rates affected your bank’s profitability
5. Read the Annual Report of your selected commercial bank. Answer and discuss the following:
o What is the announced mission, and future direction, as stated by the bank’s Chief Executive Officer?
o Is your commercial bank in a good financial position to achieve those objectives?
6. Review and summarize the latest Dodd-Frank Act Stress Test results.
7. Review and summarize the latest BASEL III disclosures.
8. Prepare a forecast of your selected bank’s projected profitability (You forecast this!).
o Assume that the Federal Reserve Board holds the interest rates “as is" or constant
o Discuss the impact this constant interest rate would have on three years of your bank’s profitability
9. Submit the Microsoft Word 2016 document, the Microsoft Excel 2016 spreadsheet files and a narrated Microsoft PowerPoint.
All the work should be properly cited in your paper per Keller policy, and a reference page should be included at the end of your Word document. The narrated PowerPoint must be at least a 10-minute narration summarizing your findings.
- 5 years ago
- 25
Purchase the answer to view it
- WellsFargoFinancialStatementAnalysis.pptx
- WellsFargoFinancialStatementAnalysis.docx
- wellsfargo.xlsx
Purchase the answer to view it
- Order10186798.docx
- EXERCISE 14-11
- HYPOTHESIS TESTING
- Project Management
- Unit 4 Discuss
- for payment
- • Write and analysis paper of approximately 750 words about the variables chosen and also address the following points: o Write a hypothesis and explain how your hypothesis is testable. o Based on the variables chosen, what you would hypothesize about the
- ACC 490 Week 3 Individual Assignment Ch. 5, 6, & 7 Comprehensive Questions
- ECO 365 week 3 DQ 2
- as discussed
- ECE 430 WEEK 2 Assignment - Common Core or Early Learning Standards Lesson Plan