The paperExchangeCrypto WikiWikiAcademyacademy.notitiaplatform.com
Sign in
● LIVE
CAC 408 080,7▼ 0.81%S&P 5007 254,6▼ 0.94%EURO STOXX6 113,9▼ 0.66%BTC/USD62 734▲ 0.55%ETH/USD1 765,7▲ 1.55%EUR/USD1.10▲ 0.05%BRENT90.38▲ 1.36%GOLD3 690,6▼ 1.37%OAT 10Y5.09%▲ 0.39%VIX24.59▲ 0.12%CAC 408 080,7▼ 0.81%S&P 5007 254,6▼ 0.94%EURO STOXX6 113,9▼ 0.66%BTC/USD62 734▲ 0.55%ETH/USD1 765,7▲ 1.55%EUR/USD1.10▲ 0.05%BRENT90.38▲ 1.36%GOLD3 690,6▼ 1.37%OAT 10Y5.09%▲ 0.39%VIX24.59▲ 0.12%
 
Europe edition
NotitiaAcademy
Back
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.

…

Interest and principal repaid each year (€150,000, 15 years, 3.5%)
13579111315interestprincipal
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
  1. 01Monthly payment€1,072.32
  2. 02Interest in month 1150 000 × 3,5 % / 12€437.50
  3. 03Principal repaid in month 1€634.82
  4. 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
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 ↗