Built a desktop valuation app (DCF / DDM / reverse DCF) so I'd stop rebuilding Excel models for every pitch — would value some ER feedback

Long-time lurker. Full disclosure up front: this is my own tool, so flag it if self-promo isn't allowed here — but I think it's genuinely relevant to the people in this forum building pitch and interview models, and what I actually want is methodology feedback.

I kept rebuilding the same DCF in Excel for every company I looked at, and the models got fragile fast — one bad cell reference and the valuation's quietly wrong without you noticing. So I built Aperite, a native desktop app with a C++ engine that puts three models in one place:

  • standard DCF for mature businesses
  • a Dividend Discount Model for banks/financials, where FCF models fall apart
  • a probability-weighted DCF that blends bull/base/bear cases by likelihood instead of betting everything on one forecast

It also has a WACC builder (CAPM cost of equity, after-tax cost of debt, target D/E), a reverse DCF that backs out the growth rate the current price is implying, a historical CAGR/YoY analyzer for baselining projections, and one-click PDF export of the full model — which I'd guess is the most useful part for anyone here putting together a stock pitch for interviews or a pitch competition.

What it deliberately doesn't do: pull live data or auto-fill financials. You enter the assumptions yourself, by design — the point is to force you to reason about the inputs, not hand you a number. So it's a modeling tool, not a screener.

Caveats: Windows-only right now (Mac/Linux on the roadmap), €9.99/mo with a 7-day trial if anyone wants to poke at it.

What I'd genuinely value from this forum: tear apart the methodology. Does the probability-weighting match how you'd actually risk-adjust a forecast? Is the reverse-DCF implementation sound? Anything in the terminal-value or WACC handling you'd do differently? I'd much rather have the math criticized than be told it looks clean.

3 Comments
 

Your tool sounds like a thoughtful and practical solution for streamlining valuation workflows, especially for those in equity research (ER) or preparing stock pitches. Based on the most helpful WSO content, here are some points of feedback and considerations for your methodology:

1. Probability-Weighted DCF

  • Strengths: This approach aligns well with how some professionals in equity research and venture capital handle uncertainty. By blending bull, base, and bear cases with assigned probabilities, you're effectively capturing a range of outcomes rather than relying on a single deterministic forecast. This is particularly useful for industries with high volatility or uncertain growth trajectories, like biotech or tech startups.
  • Considerations: Ensure that the probabilities assigned to each scenario are transparent and adjustable. Users should be able to justify their weighting based on qualitative and quantitative factors. Additionally, you might want to include a sensitivity analysis feature to show how changes in probabilities impact the valuation.

2. Reverse DCF

  • Strengths: Reverse DCF is a powerful tool for understanding market expectations embedded in the current stock price. It forces users to think critically about whether those implied growth rates or margins are realistic.
  • Considerations: Make sure the reverse DCF accounts for nuances like changes in capital structure over time or varying discount rates. Also, providing a visual representation of the implied growth rate versus historical growth rates or industry benchmarks could add significant value.

3. Dividend Discount Model (DDM)

  • Strengths: Including a DDM is a smart move for financials and banks, where free cash flow models often don't work due to regulatory capital requirements and unique cash flow dynamics.
  • Considerations: Ensure the DDM can handle scenarios like fluctuating payout ratios or periods of dividend suspension. Additionally, incorporating a Gordon Growth Model for terminal value calculation is standard, but you might want to allow users to toggle between different terminal value approaches.

4. WACC Builder

  • Strengths: A WACC builder with CAPM, after-tax cost of debt, and target D/E is essential for robust valuation. It’s great that you’re forcing users to input assumptions manually, as this encourages critical thinking.
  • Considerations: Offer guidance or benchmarks for inputs like equity risk premiums, beta, and cost of debt. Many users, especially those newer to valuation, struggle with these assumptions. Including a sensitivity analysis for WACC would also be helpful, as small changes in discount rates can significantly impact valuation.

5. Terminal Value

  • Strengths: Terminal value is often the largest component of a DCF, so getting this right is crucial. If you’re using a perpetuity growth model, ensure users can input a range of growth rates and see the impact on valuation.
  • Considerations: You might want to include an option for an exit multiple approach as an alternative to the perpetuity growth model. This is particularly useful for industries where long-term growth rates are hard to estimate.

6. Manual Input Design

  • Strengths: By requiring manual input, you’re encouraging users to think critically about their assumptions, which is a key skill in valuation.
  • Considerations: While avoiding live data integration is intentional, consider allowing users to import historical financials from a CSV or Excel file. This could save time without compromising the reasoning process.

7. Export and Presentation

  • Strengths: One-click PDF export is a fantastic feature for users preparing stock pitches or interview materials. Clean, professional outputs can make a big difference in these settings.
  • Considerations: Ensure the exported models are customizable in terms of layout and branding. Users might want to add their own logos or adjust formatting for specific audiences.

8. General Feedback

  • Pricing: €9.99/month seems reasonable for the functionality offered, especially with the trial period. However, consider offering a discounted annual plan or a one-time purchase option for users who prefer not to commit to a subscription.
  • Platform Limitation: Windows-only might be a barrier for some users, especially in finance where Mac usage is common. Prioritizing Mac compatibility could expand your user base significantly.

9. Additional Features to Consider

  • Scenario Analysis: Allow users to run multiple scenarios side-by-side and compare outputs visually.
  • Error Checking: Include built-in checks for common modeling errors, like mismatched growth rates and discount rates or unrealistic terminal value assumptions.
  • Educational Content: Embed brief explanations or tooltips for key concepts (e.g., “What is WACC?” or “How to estimate terminal growth rate?”). This could make the tool more accessible to less experienced users.

Your focus on methodology and user-driven inputs is commendable. By addressing the considerations above, you could make Aperite even more robust and user-friendly for the ER and finance community.

Sources: Biotech finance part 2: valuation methodologies and modeling considerations, A Guide on How to Navigate On-Cycle PE Recruiting, PE Associate Questions Recieved - On-cycle 2022, Flexibility of Valuation Methods in ER?, DCF Modeling Course ~ Pre-training text.pdf

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 
Most Helpful

Tech bros have this unique skill to describe the most mundane, uninspiring and useless part of a job/workflow as if it’s the greatest technical feat of humanity. My brother in Christ you simply just described building an excel template. This is something every group on the street has thousands of examples of.

To make matters worst, you’ve shifted the actual manual labor to the only part of the workflow worth automating that NOBODY gets value out of doing — entering input data automatically. Now instead of automating that part so I can think about how I’d want to customize a DCF/any model beyond the cookie cutter template faster, I manually input the data, turn on your black box model and voila - the formulas are complete! You do not understand what’s valuable to automate and what’s not, and it’s obvious.

 
Funniest

Nisi porro est rerum iusto facilis fugit. Repellendus deleniti ut ea sit. Provident amet nesciunt maxime ad ut praesentium similique rerum. Alias ut enim laudantium tenetur corporis omnis rem.

Totam id ut enim placeat. Vel dolorem perspiciatis tempora eveniet omnis. Eum sed est illo accusamus commodi. Alias vel facere optio.

Sed eius fugiat corporis dolorem nostrum voluptas. Et mollitia non cupiditate fuga eum sit. Quia porro neque dolorem harum.

Ipsam repellendus tempore nobis autem. Ut temporibus praesentium qui deleniti inventore illum delectus. Omnis quo quia nostrum. Aut et enim dolores ut qui dolor omnis. Eveniet unde doloremque corporis ex ut. Aut commodi totam illo. Repellendus corporis repellat voluptatibus repudiandae quod.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
DrApeman's picture
DrApeman
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Mimbs's picture
Mimbs
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”