During his internship at Mazda Toyota Manufacturing, Travis McGuire made a significant positive impact on the company's monthly interest income forecasting process. By thoroughly reviewing over a year of data and closely analyzing forecasted versus actual results, Travis introduced innovative formulas and enhanced communication with the bank, helping to resolve major variances. He developed a new forecasting system, established consistent contact with JP Morgan for timely rate updates, and leveraged Excel and PowerBI to highlight measurable improvements. Thanks to his proactive approach and dedication, the accuracy of interest income forecasting improved by an impressive 66%.
“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
Travis describes his internship as “priceless,” noting the professional and personal growth he gained through APC and MTM. His success led to a full-time role as an Accounting & Finance Specialist at Mazda Toyota Manufacturing, responsible for Revenue Recognition, Accounts Receivable, and Accounting Policies.