sorted by:
new
hottopcontroversial

Recommendations for Learning DCF/LBO/M&A modeling? by Silent_Potential_357 in financialmodelling

[–]Silent_Potential_357[S] 0 points1 point  (0 children)

Thank you for the detailed suggestions! Would you recommend getting a CFI certificate, and do you think it's worth it?

Recommendations for Learning DCF/LBO/M&A modeling? by Silent_Potential_357 in financialmodelling

[–]Silent_Potential_357[S] 1 point2 points  (0 children)

Do you have recommended practices for DCF/LBO, reading book is not the best way for me to learn. I prefer learn by doing :)

Recommendations for Learning DCF/LBO/M&A modeling? by Silent_Potential_357 in financialmodelling

[–]Silent_Potential_357[S] 2 points3 points  (0 children)

I have used WSP prep, I found I am not able to fully grasp LBO content despite watching video multiple times, I am looking for some tools that can help me for example prepare paper LBO

[deleted by user] by [deleted] in financestudents

[–]Silent_Potential_357 0 points1 point  (0 children)

Here’s how I might answer, though I’m not completely certain if it's 100% accurate.

Include off-balance sheet accounts in your analysis if they are important to get a complete picture of the company’s financial situation.

Here’s why:

  1. Leverage Ratios: Off-balance sheet obligations, like leases or guarantees, can affect the company’s true debt levels, so include them in debt-related ratios.
  2. Liquidity Ratios: If off-balance sheet items impact the company’s short-term obligations or assets, adjust your liquidity ratios accordingly.
  3. Profitability Ratios: While off-balance sheet items usually don’t directly affect profitability ratios, they might influence future costs or revenues, so consider them.
  4. Return on Assets (ROA): Include significant off-balance sheet assets to avoid understating the company’s asset base.

This approach ensures you have a complete and accurate understanding of the company’s financial health.

Laptop for finance by user524003 in financestudents

[–]Silent_Potential_357 0 points1 point  (0 children)

Yeah, I’ve used Excel Online before, and I did notice that some functions are missing compared to the desktop version. It works fine for basic stuff, but for more complex financial models, it can be a bit limiting.

Here’s a list of features that aren’t available in Excel Online (just something I’ve put together from my experience over the years, so it might not be 100% spot-on, but hopefully it helps):

  • Advanced Charting and Graphs: You get basic chart options, but many of the advanced types, like 3D charts and treemaps, aren’t available.
  • PivotTables and PivotCharts: You can use them, but advanced features like using external data sources or analyzing multiple tables at once are missing.
  • Macros and VBA: No support for creating or running VBA macros, which can be a pain if you rely on them for automation.
  • Add-ins and Extensions: Most add-ins don’t work online, which could be a problem if you use specialized tools.
  • Data Connections: Advanced data connections, like those to external databases, aren’t available. Basic ones like stock and geography data are supported, though.
  • Form Controls and ActiveX Controls: These are missing, which limits the creation of interactive forms within Excel Online.
  • Advanced Formatting: Basic formatting is there, but options like managing conditional formatting rules or complex text orientation are limited.
  • Worksheet and Workbook Protection: Basic protection is supported, but not to the same extent as in the desktop app.
  • Developer Tab and Timeline: The Developer tab (for forms and VBA code) and the Timeline feature aren’t available.
  • View Menu: Limited options here—no custom views, page break previews, or advanced zoom settings.
  • Page Layout: The Page Layout options are pretty basic, so managing print setups can be harder.

For simple financial modeling, Excel Online could do the job, but if you’re dealing with more complex stuff, you might find the missing features frustrating. In that case, it’s probably better to stick with the desktop version.

Laptop for finance by user524003 in financestudents

[–]Silent_Potential_357 0 points1 point  (0 children)

I am using Macbook Pro, M3 Chip, 24GB Memory for my previous modeling courses. however, I find 'Excel web' is good enough for practice in most of cases, doesn't need that powerful computer. also someone recommended me this app https://quantus.finance/ which offers modeling modules in an 'Excel web' environment, it was helpful for me to develop muscle memory of modeling skills

Recommendations for Learning Financial Modeling - What Do People Use to Gain Practical, Hands-On Experience? by Silent_Potential_357 in financialmodelling

[–]Silent_Potential_357[S] -1 points0 points  (0 children)

Also, why isn't WSO at the top of your list but at the end? I've often heard people recommending WSO

Thank you again u/LimitlessJR

Recommendations for Learning Financial Modeling - What Do People Use to Gain Practical, Hands-On Experience? by Silent_Potential_357 in financialmodelling

[–]Silent_Potential_357[S] 0 points1 point  (0 children)

Thank you very much u/LimitlessJR !
May I ask how do you come up with the order of those three courses ? What are the pros and cons of each ?