Mazda Toyota Manufacturing
Success Story Spotlight
Improving Treasury Forecasting Through Data Analysis
During his internship at Mazda Toyota Manufacturing, Travis McGuire helped improve the company's monthly interest income forecasting process.
By reviewing more than a year of financial data and comparing forecasted results with actual performance, Travis identified opportunities to improve forecasting accuracy and reduce major variances.
Driving Impact Through Treasury Forecasting
Building a More Accurate Forecasting Process
Travis conducted a detailed review of historical interest income data and analyzed the differences between forecasted and actual results.
He introduced new forecasting formulas, established consistent communication with JPMorgan to receive timely rate updates, and created a more structured forecasting system.
Travis also used Excel and Power BI to organize the information, visualize performance, and demonstrate measurable improvement in the forecasting process.
Measurable Results
Forecasting Accuracy Improved
66%
Improvement in interest income forecasting accuracy
Mentor Perspective
Travis left a vital impact on the Accounting & Finance Department. His analytical skills were critical in creating new processes for improving forecasting metrics on the Treasury side. He also provided vital support in many Treasury activities critical to maintaining proper company standing.
Theodore Kubista
Financial Reporting, Insurance & Treasury Specialist
Career Growth
Turning an Internship Into a Full-Time Career
Travis described the internship as priceless because of the professional and personal growth he gained through APC and Mazda Toyota Manufacturing.
His successful internship led to a full-time position as an Accounting & Finance Specialist at Mazda Toyota Manufacturing. In that role, he became responsible for revenue recognition, accounts receivable, and accounting policies.
Explore More APC Success Stories
Learn how APC internships help students build practical skills, improve business processes, and launch successful careers.
