學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Deloitte Recommends Client Selection to Regency Bank
內容大綱
A large financial institution has acquired a sizable portfolio of new clients of travel (corporate expense) cards. The bank must decide on the optimal mix of clients to retain in order to achieve the goals of maximizing profitability, entering a new product market successfully, and maintaining reputation. The optimal mix depends on a number of different factors, including annual account spending level, complexity of serving the account, the number of cards in each account, account risk, and account retention level. The selection and number of clients chosen will affect the bank’s future profitability and long-term strategy. The bank is limited by attempting to achieve a three-year payback, and facing costs that can vary significantly and are not in the bank’s control.
學習目標
This case is primarily focused on spreadsheet and simulation modelling. It includes concepts and methods such as:<ul><li>Annual costs/revenues, one-time investment costs, default risk, retention, projection and adjustment over multiple years, sensitivity analysis.</li><li>Probabilities, expected value, simulation, normal distribution, chance for making profit/loss.</li><li>Vlookup, rand(), norminv, datatables, histogram.</ul></li>