/2 min read
IPO Underwriting Syndicate
Financial Model Best Practices
0/4
Color-code inputs and outputs
Blue for hardcodes, black for formulas.
Use named ranges
tax_rate beats Sheet1!$C$45.
Always include error checks
Balance sheet balances; sum of percentages = 100%.
Document assumptions
Notes column or separate tab — future you needs to know.
Master Financial Modeling at Noble Desktop
Noble Desktop's Financial Analyst Training Program covers financial modeling, valuation, accounting, and Excel for finance.
Delve into the roles and mechanics of an underwriting syndicate, learn about the selection of the lead left book runner, and understand how the offering price is determined and how fees are charged.