The Modeller's Miscellany is a weekly bulletin of cool stuff for financial modellers.
Sign up below to receive it in your inbox every Sunday.
Excel Performance Improvements
The Excel innovation train is showing no signs of slowing down. Microsoft have released improvements which will speed up Real Time Data functions, and User Defined functions.
For Real Time Data functions, Microsoft has removed bottlenecks in the underlying memory and data structures and also made them “thread safe”. The result is a significant performance improvement on sheets with lots of RTD functions. A new User Defined Function cache has been introduced to speed up loading time for workbooks containing UDFs. Read more.
We are working on a systematic comparison of Excel speed and performance changes across recent versions and will share in a future Miscellany.
Spreadsheet errors continue to make headlines
From COVID-19 track and trace to the US elections, spreadsheet errors have been in the news lately. And now this one - a discounted cash flow spreadsheet error in a spreadsheet used to value Tesla's acquisition of SolarCity.
The spreadsheet double-counted some of SolarCity’s projected indebtedness. This led to Lazard valuing SolarCity’s equity between $14.75-$30.00 per share instead of $18.75-$37.75 per share. This resulted in SolarCity being discounted by $400M in the deal.
ICAEW takes on sign convention
Smart copy coming to Microsoft Edge
And finally . . .
How many Excel users does it take to get the number formatting right in a cell?
Get the Miscellany delivered to your inbox every Sunday
No spam. No silliness. Just modelling goodness.