Banco Toyota do Brasil
The Challenge
Banco Toyota do Brasil has three product categories: “Floor-plan Program”, to help Brazilian dealers to buy cars from Toyota; “CDC/Lease” that helps end customers to buy cars from the dealers; and “Insurance”, specifically dedicated to providing insurance to customers.
The financial services organization could not plan at a detailed product (car type) level and could not guarantee maximum accuracy and visibility throughout the entire process. They found themselves in “Excel hell” trying to manage and manually update up to 40 multiple files to perform the necessary calculations.
CCH Tagetik Solution
One of the main challenges and objectives of the project was to calculate the global amount that Banco Toyota do Brasil will need to finance each month to optimize the company’s credit balance & interest revenue resulting from early pay-off and delinquency ratio assumptions which can significantly impact the bottom line. As part of a comprehensive financial reengineering process, the project implementation at Banco Toyota do Brasil also included debt projection (funding run-off and run-on) & cash revenues as well as a collaborative data collection of SG&A expenses by cost center, payroll expenses by employee and IT Projects (OPEX, CAPEX, and Depreciation). In particular, payroll was very complex and needed to be optimized.
Benefits
Table title
End of the "Excel hell" |
No more 40 complex spreadsheets to manually manage and update |
Monthly rolling forecasts |
Monthly rolling forecasts for analysis and visibility at the local level |
Rapid portfolio projection |
Portfolio projection at product level detail takes only 5 minutes to run |
Reduction of budget to actual variance |
Budget to actual variance reduced to 5% maximum (compared to 10% before) |
Fast budgeting & forecasting |
30% time reduction in our budgeting and forecasting processes |
Automated debt projection & cash forecasting |
Automatic calculation of assets/liabilities and their impact on interest revenues/expenses |