Forum Replies Created
-
Posts
-
Hi Mike,
I worked in the banking industry for about 8 years in loan ops, various accounting roles as well as a business analyst. I’ve used PowerPivot to calculate and create journal entries, reconcile investments, total loans and total deposits by product type and branch/cost center. I’ve created models to capture ATM activity used by the marketing department, models for HR to calculate commissions for lenders, yield analysis models, variance analysis models, and trend analysis models for ALM . I’ve calculated post-merger purchase accounting balances and created depreciation/amortization/accretion models for the respective balances. At one point I received an audit request to “roll the bank”; which, is just taking a beginning trial balance and adding all the debits and credits to demonstrate that you arrive at the ending trial balance…the model spanned three years and captured 9 million transactions. Yes, I’ve used PowerPivot in the banking industry.
