BackInterest and principal repaid each year (€150,000, 15 years, 3.5%) Go further on the technical side · partnerQuantPadTo go from theory to code: auto-graded exercises in Python, SQL and quantitative finance, backtests and mock interviews for quant, data and M&A roles.Train on QuantPad · quantpad.app ↗For your career · partnerKairosKairos finds the roles that fit you every day, scores your CV against each out of 100 and prepares your application.Find my role on Kairos · trykairos.eu ↗
BeginnerCode · 6 h
VBA for Finance
Automate Excel: models, spreadsheets and financial reporting with VBA.
Live chart for this course
■ Portfolio
€108,959
■ Contributions
€53,000
✦ You invest €53,000; compounding adds €55,959 - 51.4 % of the final capital. Waiting 5 more years would add €51,964.
Educational simulation - not investment advice. Returns are not guaranteed.
…
Worked example
Rebuilding Excel’s PMT function in VBA
A €150,000 loan over 15 years at 3.5%. We want the monthly payment and the first line of the amortisation table.
Assumption · PMT = P · i / (1 − (1 + i)^−n), i = 3,5 % / 12
- 01Monthly payment€1,072.32
- 02Interest in month 1150 000 × 3,5 % / 12€437.50
- 03Principal repaid in month 1€634.82
- 04Total cost of credit€43,018
The professional’s reflex
Early on, over 40% of the payment goes to interest. A pro tests the macro against the native function before using it on a real file.
To watchSelected by the newsroom · loads only when you press play
VBA for investment banking
Mergers & Inquisitions · in English
Getting started with Excel VBA
Tuto De Rien · in French