Excel for Bank Branch Staff: Loans, Deposits, Interest & Fees
20 hands-on labs at a fictional community bank branch: simple vs compound interest, APY with EFFECT, CD maturity values, loan payments and amortization, debt-to-income checks, overdraft fees, cash balancing, cross-sell counts, savings goals, currency exchange and a branch KPI dashboard – plus true loan rates with RATE, home-loan pre-checks with PV, teller staffing, ATM cash, fee waivers, deposit mix, delinquency buckets and a monthly scorecard.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This beginner course teaches the spreadsheet skills used at a bank branch, with a fictional community bank as the example. In 20 hands-on labs you compare simple and compound interest, turn APR into APY with EFFECT, value certificates of deposit with FV, quote loan payments with PMT, split payments with IPMT and PPMT and screen debt-to-income ratios. You calculate overdraft fees, balance a cash drawer, count product holdings, plan savings goals, price foreign currency and build a KPI dashboard. The second part compares loan offers by their true rate with RATE, pre-checks home loans with PV, staffs the teller line by hour, sizes ATM refills, applies fee-waiver rules, analyses the deposit mix, sorts loans into past-due buckets and finishes with a monthly scorecard.
Lessons
- Simple vs Compound Interest on Savings DepositsFree
- APY from APR: Comparing Savings Products with EFFECT Locked
- Certificates of Deposit: Maturity Values with FV Locked
- Personal Loans: Monthly Payment and Total Interest with PMT Locked
- Amortization Schedule: The First Six Payments with IPMT and PPMT Locked
- Loan Applications: The Debt-to-Income Check Locked
- Checking Accounts: Calculating Overdraft Fees Locked
- End of Day: Balancing the Branch Cash Drawer Locked
- Cross-Selling: Counting Product Holdings with COUNTIFS Locked
- Savings Goal Planner: How Long and How Much with NPER and PMT Locked
- Foreign Currency at the Counter: Buy and Sell Rates with a Spread Locked
- Branch KPI Dashboard: Totals, Chart and Target Highlights Locked
- Comparing Loan Offers: Origination Fees & the True Annual Rate with RATE Locked
- Home Loan Pre-Check: Housing Ratio, Maximum Payment & Maximum Loan with PV Locked
- Teller Lines: Arrivals per Hour, Workload & Tellers Needed Locked
- ATM Cash: Average Daily Withdrawals, Days of Cash Left & Refill Amounts Locked
- Monthly Account Fees: Waiver Rules with IF and OR Locked
- Deposit Mix: Balances by Product, Weighted Average Rate & Interest Cost Locked
- Loan Delinquency: Days-Past-Due Buckets, Balances at Risk & a Chart Locked
- Final Project: Branch Monthly Scorecard – Targets, Attainment, Status & a Chart Locked
Learner reviews
Be the first to review this course.