Corporate Finance & Valuation
ESG Ratings Methodology: Indicators, Normalisation, Weights & Scores
IntermediateCertificate$9.99
ESG & Carbon Accounting in Excel
GHG Protocol scopes, activity data × emission factors, location- and market-based electricity, travel and commuting, intensity metrics, reduction targets, a marginal abatement cost curve, carbon prices and an ESG KPI dashboard: 8 graded labs for one fictional manufacturer.
- One-time payment
- 14-day money-back guarantee
- Secure checkout with Stripe
What you'll build
What you will be able to do
Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.
- Total Fernhill Furniture's emission sources by scope with SUMIFS, see how much of the footprint sits in the value chain and classify two new sources.
- Turn Fernhill's fuel and electricity data into tonnes of CO2e and report Scope 2 both location-based and market-based.
- Estimate the emissions of Fernhill's business trips and staff commuting, two Scope 3 categories every company can measure.
- Calculate three intensity metrics for Fernhill over three years and compare the fall in intensity with the fall in absolute emissions.
- Set Fernhill's 2030 target from its 2023 baseline, draw the straight-line path to it and check whether the company is on track.
- Rank seven of Fernhill's reduction options by cost per tonne, sort them with SMALL and INDEX/MATCH and chart a simple marginal abatement cost curve.
- Stress-test Fernhill's EBIT under four carbon price scenarios, including costs suppliers pass on, and find the price that would wipe out its profit.
- Turn Fernhill's raw environmental and people data into four ratio KPIs for two years and chart them side by side.
About this course
Carbon reporting begins with a clean inventory, and this course builds one with you. You classify emission sources into scope 1, 2 and 3, multiply fuel and electricity activity data by emission factors, and estimate business travel and employee commuting. Totals are expressed as intensities per revenue, per employee and per unit produced. You set a baseline year and a linear reduction target, then rank abatement options on a marginal abatement cost curve to see which cut emissions most cheaply. A carbon price is applied to show its impact on profit, and a KPI dashboard brings energy, waste and diversity indicators together. Written for sustainability and finance staff, consultants, SME owners and students; factors are illustrative.
Curriculum
Course content
8 lessons · 8 labs · 2 h · final exam
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Unlocked when you buy the course
- Final exam
Certificate
Finish with a certificate you can verify
Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.
- Names the course, your score and the date of issue
- A verification link for your CV or LinkedIn profile
- 12 questions, 75% to pass, unlimited retries.
A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.
Before you buy
Questions about this course
Is this a subscription?
No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.
What exactly do I get?
All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.
Can I get a refund?
Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.
When can I start?
Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.
Do I need Excel or other software?
No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.
Is the certificate an official qualification?
No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.
Full details are in our Terms · hello@tutorvo.com
Corporate Finance & Valuation
Green Bonds & Sustainable Finance: Use of Proceeds, Greenium & Impact Metrics
IntermediateCertificate$9.99