r/financialmodelling • • 1d ago

My first dashboard - reviews

Post image
45 Upvotes

Took a little from this, a little from that and ended up here. My first dashboard.


r/financialmodelling • • 1d ago

Where do I learn practical skills?

4 Upvotes

Hey guys I am a second year college student and I want to build a career in equity research, I am having trouble figuring out where do I learn practical skills from such as financial statement analysis and financial modelling to get started. It would of great help I you guys could suggest relevant videos/playlists or channels.


r/financialmodelling • • 3d ago

WACC: Target capital structure with (growing) capitalised operating leases

26 Upvotes

Hi all, I have a peculiar situation I do not know how to address. For context, I am doing a university level valuation project.

The company:

  • has no debt

  • the only form of debt is operating leases which are treated as debt equivalent

  • The only driver of operating leases are stores (lululemon), which the company has steadily been expanding

  • The share price has dropped significantly over the period.

  • Has no target capital structure, since operating leases are treated as operating leases

How to do a proper target capital structure when:

  1. The store count is growing

  2. Share price is unstable

It makes little sense to me use the current D/E ratio, when the absolute D keeps going up and E % keeps going down as a consequence of price movements.


r/financialmodelling • • 5d ago

Debt schedule

Post image
46 Upvotes

Hey everyone, I was working on a debt schedule for one of the case studies I'm preparing which is about a 6 table cafe restaurant. This schedule takes Principal debt , ROI, tenure as the input and provides closing balance and interest expense as outputs. I'm yet to add a credit line into the model if needed. What are your reviews? Does this fits ur standards?


r/financialmodelling • • 6d ago

Title: Balancing CFA Level II Preparation with Maintaining Financial Modeling Skills

11 Upvotes

Hey everyone!
I’m feeling a bit confused about how to balance my CFA Level II preparation with maintaining my financial modeling skills.
For some background, I have around one year of investment banking experience, but I recently terminated my employment contract and am currently not working.
I’m dedicating around 5 hours a day, 6 days a week to CFA Level II preparation. However, I’m concerned that spending most of my time studying for the CFA might cause me to lose some of my practical financial modeling skills, especially when it comes to building cash flow forecasts, financial models, and handling technical questions in future interviews.
For those who’ve been in a similar situation:
How did you balance CFA preparation with keeping your financial modeling skills sharp?
How much time would you dedicate weekly to practical modeling alongside CFA studies?
Would you recommend working on one financial modeling project regularly or practicing smaller exercises?
I’d really appreciate advice from anyone who has gone through a similar experience, particularly investment banking professionals who prepared for CFA Level II while between jobs.
Thanks!


r/financialmodelling • • 7d ago

Starting out with Financial Modelling & DCF Valuation – Need some guidance from people in the industry

16 Upvotes

Hey everyone,

I'm currently interning at a top-tier CA firm in India, in the M&A / Transaction Advisory space.

A little about my background:

  • Undergraduate student pursuing Economics.

  • Cleared CFA Level 1.

  • Have a basic understanding of Excel and financial analysis.

I've also completed a few practical financial modelling projects as part of my learning, including:

  1. Investment & Loan Decision Analysis: Worked with NPV, IRR, sensitivity analysis, loan EMIs, interest calculations and amortisation schedules.

  2. Advanced Excel Sales Analysis: Used SUMIFS, VLOOKUP, INDEX-MATCH, Goal Seek, PivotTables and data tables.

  3. Sales Performance Dashboard: Built an interactive dashboard using PivotTables, slicers and GETPIVOTDATA.

However, I understand that completing these projects and actually working on financial models in a professional environment are two very different things.

Here's my current situation.

There's an ongoing DCF valuation assignment at my firm. An article assistant is currently working on the model, and she's someone I can approach for guidance whenever I get stuck.

I'm not officially assigned any responsibilities on this project. My opportunity is essentially to study the model, understand the assumptions, follow the valuation process and help out with smaller tasks wherever possible.

For instance, she recently gave me a task (if I could manage it) involving consolidating capital spares. The existing consolidated figure had references running across numerous sheets, with formulas linking to other sheets and those sheets linking further elsewhere. Essentially, I had to make sense of this rather complicated chain of references and see if I could simplify it.

These are the kinds of small but meaningful tasks I'd love to become capable of handling independently.

I'm not expecting to master financial modelling or become an expert overnight. I just want to develop a good enough understanding of DCF valuation, Excel and financial modelling to follow the actual assignment and be useful to the person working on it.

I'd appreciate advice from people who've worked in Valuations, Investment Banking, Transaction Advisory or Equity Research.

In particular, given that I'm not officially assigned to the project, how can I contribute meaningful insights without overstepping my role?

What would you recommend I focus on learning to become useful on an actual live valuation assignment?

Any practical advice or resources would be greatly appreciated.

Thanks!


r/financialmodelling • • 7d ago

Applying the CFI approach to a real-life financial statement

6 Upvotes

Hi everyone,

I'm trying to build a three-statement model using the steps from the FMVA course, but I always find something like a one-time transaction that I don't know how to deal with. How do you forecast the following line items:

PPE impartments

Gain from the sale of PPE

Other comprehensive income line items

Losses from currency exchange rate

Income from subsidiary

And bad debt expenses

Thanks in advance,


r/financialmodelling • • 7d ago

First DCF (Home Depot) – looking for brutal feedback on structure and assumptions

Thumbnail
gallery
90 Upvotes

Hey all, I'm a recent graduate (history degree) and want to start trying to get into a finance career. This weekend I built my first DCF, valuing Home Depot from its FY2025 10-K. I used Claude to help me with the structure and walk me through it, so I'm sure there are things I'm missing. I'd rather hear critiques and things I should look into more for these kinds of models from real people.

Specific questions:

  1. Is my WACC approach reasonable?

  2. I excluded operating leases and stock-based comp. For a retailer like HD, how much does ignoring leases distort things?

  3. My exit multiple implies 3.5% perpetual growth vs. 2.5% in my perpetuity method. Which would you lead with?

  4. Are these the right comps for HD?

  5. Anything about the layout or formatting that would make this look amateur to someone in the industry?

Thanks in advance. Happy to take harsh feedback.


r/financialmodelling • • 10d ago

What do most entry level or senior level PM’s use for portfolio management in Excel software? V-lookup or Index/Match?

8 Upvotes

I live in Canada, if that makes a difference. I’m trying to brush up on my Excel and Python software skills to apply for roles.


r/financialmodelling • • 10d ago

Comps for the 9 HK-listed automakers (BYD, Geely, NIO, XPeng, Li...). Couldn't find one that wasn't six months old or mixing H and A share caps, so I built it. What would you add?

Post image
9 Upvotes

Wind data, Nov 5 close. Table attached.

The choices, because that's where the arguments are:

- Market cap is the HK line only. BYD and Great Wall also have A-shares. Blending gives a bigger number on a price nobody can actually buy.

- Revenue YoY is computed from the quarterly series, not the vendor's growth field. The field gave BYD 0.0067, which is either 0.67% or a unit bug. The series says +13.6%.

- Net margin is attributable profit over revenue, same reason. Seres is the row where the vendor's margin field and its own quarterly series disagree (-20% vs +5%), so it's flagged instead of picked.

- "Latest quarter" isn't the same for everyone. Five have Q3 in, three are still on Q2. It gets its own column instead of being hidden.

- Leapmotor's quarterly series didn't come back. n/a, not filled from memory.

Quick read: the legacy names sit on 7-10x with mid-teens gross margins. The pure-play EVs are all loss-making on the latest quarter, NIO growing fastest (+69%) and Li shrinking (-15%). Whether 7x Geely is cheap or a China-discount trap is exactly the thing a comps table can't tell you.

Two questions. For cross-listed names, do you show H only, A only, or blended, and do you label it? And is there any source for HK/China consensus that isn't a terminal?

No position.


r/financialmodelling • • 11d ago

Depreciation and Amortization not reconciling with the schedules

2 Upvotes

The breakdown and totals of all the schedules for D&A reconcile with the annual reports of my subject company, but summing the same depreciation and amortization for the Income Statement does not reconcile either in my model or the annual reports. I checked all the footnotes thoroughly and yet cannot figure it out.


r/financialmodelling • • 12d ago

Practicality of Revenue Forcasting using Revenue Drivers vs Historical Base Rate

Thumbnail reddit.com
2 Upvotes

r/financialmodelling • • 13d ago

Hi, can someone please review a sample Financial Model I’ve made?

9 Upvotes

I am planning on applying to an IB firm, I have worked in a VC for a small amount of time. But I have never done Financial Modelling professionally, can someone please review the sample I made to send out to IB/PE firms??

Please comment here or DM me your email, I will send it over
Thanks in advance! :)


r/financialmodelling • • 15d ago

How to separate depreciation and amortization from OPEX and COGS

23 Upvotes

Hi everyone,

I'm trying to build a three-statement model, and I need a separate line in the income statement for depreciation and amortization. The problem is that depreciation and amortization are included in operating expenses and cost of goods sold, and I don't know the exact proportions. How do you separate them from OPEX and COGS to avoid double counting?

Thanks in advance,


r/financialmodelling • • 17d ago

Best AI for Excel Modeling Classess/Tutorials?

21 Upvotes

What are some of the best AI for excel modeling classess/tutorials? What are people currently using in order to get trained in AI for excel modeling? I am looking for courses/tutorials that go beyond just what is available on YouTube - i.e. well articulated, well thought-out material


r/financialmodelling • • 17d ago

Emperical analysis (accounting and finance)

2 Upvotes

Hi everyone, I'm working on my this and just got worried about something here. I'm calculating per patent outcomes and this forces the calculation to only survive with patenting firms. I am worried because I do not have enough time to fix it by coming up with new hypothesis to code. I can acknowledge this bias, limit interpretation to the coverage and run some robustness tests, but is that emperically allowed? I just hate seeing my H1 drop at H2 to be honest. It gets worse... Research doesn't allow you to use R&D intensity as a moderator if some values are imputed, so my H3 reduced even further. Any suggestions?


r/financialmodelling • • 19d ago

Quarterly Update

Thumbnail
gallery
43 Upvotes

Please Rate my equity research report


r/financialmodelling • • 21d ago

proctoring FMVA final exam

4 Upvotes

Question to those who passed FMVA this week

Is it true that the final exam becomes proctored ?


r/financialmodelling • • 22d ago

Please help me, I want to learn FMVA on my own to break into Asset Management. Need guidance!

2 Upvotes

Hi everyone, I recently completed my 4-year B.Com (Hons) degree this year from a below-average college, and I’m really passionate about breaking into Asset Management as a fresher. Since I don't have a strong academic brand or elite college name behind me, I know I need to rely entirely on my skills to stand out, but I'm feeling a bit overwhelmed about how to structure my preparation. I’m torn between whether I should start giving interviews right now or focus first on clearing NISM and learning financial modeling and valuation. Budget constraints mean paid courses like CFI's FMVA are out of the question, so I'm relying on free self-study content. Would you recommend learning through core books like Simon Benninga’s Financial Modeling, or watching Aswath Damodaran's lectures and Parth Verma’s The Valuation School videos . On top of that, I often struggle to articulate finance concepts formally in interviews, I understand the core idea intuitively, but I go blank or oversimplify things when explaining them. Any advice on bridging that gap would be so helpful. Lastly, I’m deeply fascinated by Luxury Asset Management and alternative investments (regularly reading reports like Knight Frank’s The Wealth Report). Does anyone know of any companies or firms in this space that hire freshers purely based on skill and enthusiasm rather than college tag or background?


r/financialmodelling • • 22d ago

Funding structures in financial models for different industries - Say, real estate housing

3 Upvotes

Hi
I’ve mostly been exposed to project finance models mostly in the power sector. I’ve just switched roles, and my new one requires me to understand a lot of different industries and create opportunity analysis or growth models for the client.

I wanted to understand for an example in real estate, housing development models, the sources of funds / the use of funds is completely different than what I’m used to it is not a simple capital structure calling let’s say 30-40% of equity remaining debt draws with a debts being sculpted.

For the RealEstate sector, specially the housing ones there is an element of homebuyers giving advances, as well as as more upfront payment before the house is handover, and it is aligned to the construction timeline.
What I wanted to understand, was the sources of funds and how do I structure for this particular case?

Do I take in equity first of the agreed-upon amount and then utilize it then I go with buyer collections and then finally any shortfall would be served by debt?
Or does it make more sense to draw down first, use collections later, and then think about any equity plug-ins?
Or is there any particular way which I’m not thinking about because I’m new to this industry and there is a more standard type of it

TIA!


r/financialmodelling • • 24d ago

Completely new to the financial modeling world. I want tips on where to begin in order to become industry ready.

29 Upvotes

Hi,

I’m 20 years old, currently studying an AAS in a non-relevant field (Health Administration, more specifically Medical Billing and Coding). I want to learn financial modeling and get myself into an analyst role at a decent company. I am genuinely interested in the subject, and have found myself studying basic financial concepts on my own for hours at a time since I decided this was where I wanted to go. I am fascinated by the concept and I want to learn more!

A little about myself:

For education, my university’s reputation is below average, as I don’t have the ability to get myself into a prestigious university and pay for one. I also don’t have the money to switch degrees. So, I’m all on my lonesome in this aspect.

As for experience, I do have foundational knowledge in banking and any relevant policies as I worked for a bank as a teller for less than a year around a month into turning 18. I then moved onto a registration position at a hospital and learned about insurance and its endless types, and how they work. I worked in this for about a year. Now I’m unemployed (for about two months now) due to family circumstances.

I have two family members who work for an international bank, my mother began as an analyst, and is now working in fraud/anti money laundering. My aunt is an AVP for Payments and Clearing at a different international bank. Both of them tell me that it’s completely possible for me to get into my desired position.

Obviously, I don’t expect this to be handed out to me, especially if I don’t know anything! I want to learn! What can I do to increase my chances for employment, and where should I begin?

I am willing to pay for certifications that would help me get foundational knowledge or employer recognition. I just can’t afford a prestigious degree. My aunt says I should get CAMS for the hell of it, since she claims it gets you some employer recognition, but I don’t think that’s feasible if I’m looking into analysis and financial modeling. Still, what do I know?

Anyways, focusing on the financial modeling part — where can I start to learn, and what can I do to increase my chances as much as possible? Thank you so much! I’m sorry if this is too specific of a subreddit to ask, but I can’t post in r/financialcareers since I have no karma… :(


r/financialmodelling • • 25d ago

Please help me from were can i learn sum of parts excel model building from scratch

Thumbnail reddit.com
1 Upvotes