The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
📊 Completed an IFRS 9 Financial Instruments Model in Excel
One of the biggest challenges I faced was building the Stage 1, Stage 2 & Stage 3 classification logic correctly.
A small error in SICR, days-past-due, or credit-risk conditions could change an exposure from 12-month ECL to Lifetime ECL and materially affect the impairment calculation.
I solved this by building a formula-driven staging engine that connects the credit-risk inputs directly with the ECL calculation.
The model also covers:
• AC / FVOCI / FVTPL classification
• Probability-weighted ECL scenarios
• Trade Receivables Provision Matrix
• ECL Allowance Rollforward
• Hedge Effectiveness & Journal Entries
• IFRS 7 Disclosures & Sensitivity Analysis
This project was a great combination of accounting logic + Excel automation + financial modeling.
#IFRS9 #Excel #FinancialModeling #ECL #Accounting #FinancialReporting
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
Cleaned and standardized customer order dataset in Excel, including data validation, formatting, and consistency checks.
Hello guys, I am Bharat professional Bookkeeper where I take data from the client clean it and give the proper consistent and Structured Data
Today I had Data of WellCare Health Clinic where I get the Messy and Inconsistent data of the clinic which I had fixed the problem
What was the problem:
1.Was it Structured ❌
2.Is the data provided Consistent and Not Broken ❌
3.Is the data easily Recognisable by looking at it (like can we Identify it is expense, Utilities or Income ❌
4.Is it maintained in proper format ❌
How I fixed it using Excel:
1.First, I categorize the data properly in a Structure ✅
2.Then I put the data into proper format (Like 1/4/24 to 01-04-2024) ✅
3.I just take out the Inconsistent, Broken and duplicate data into Consistent data ✅
4.I made data easily Recognisable by looking it (Like We can easily identify expense utility and income by highlighting them. ✅
Left one is the messy and Inconsistent data and right one is Proper structured and Consistent Data
If you are someone looking for Bookkeeping service, I will do it with proper analysis and with a proper disciplined structure.
Thank you
#Bookkeeping #Dataentry #India #USA #Datacleaning #Australia #UAE
