Technical Updates

AMT's Technical Updates provide a leading insight into the world of finance and current affairs. Find out how we are solving new challenges in the financial sector.

Are Swaps Helping Companies Meet Debt Covenant Ratios? - July 2010

What happens if the swap “rubber band” snaps back? Swaps are headlining market news because the rates, at some maturities, are lower than the US Treasuries’. This is saying a default-possible rate is lower than the default-free rate, how can th...

New M&A Accounting Rules that Every Investment Banker Should Know - June 2010

By now, you should be aware that there were some significant changes in M&A accounting last year. If you are not, then you will certainly see the effects of these changes in annual reports for the year to 2009 which are now being published. Here ...

Secret Tricks for Summarizing Multiple Sheets in Excel - May 2010

Are you tired of manually linking similar outputs from different tabs in an Excel model to a summary sheet? Many of you will have spent time doing this, wishing for a magic formula to complete the task quickly and accurately. I have some good news fo...

EPS - The holy grail or red herring of M&A analysis - February 2010

EPS (earnings per share) is an important piece of financial information investors focus on. Management teams are congratulated when they grow EPS. The P/E multiple, a popular valuation metric, is based on EPS. But what is the real significance of EPS...

A Death Knell for Creative Accounting? - January 2010

A new accounting standard has recently been published, which has significant implications for companies, analysts and investors. Many large companies owned privately, including those controlled by private equity funds, are likely to adopt the new sta...

Expand the Limits of Excel - Building of Three Variable Data Tables - December 2009

Data tables are one of the most useful tools for sensitivity analysis in financial modeling. They are both powerful and easy to implement. The majority of sensitivity tables are built using one or two variable inputs. While there is no direct way ...

Expand the Limits of Excel - Building of Three Variable Data Tables - December 2009

Data tables are one of the most useful tools for sensitivity analysis in financial modeling. They are both powerful and easy to implement. The majority of sensitivity tables are built using one or two variable inputs. While there is no direct way ...

Microsoft Excel 2007 - Good or Bad? - November 2009

Microsoft Excel's user interface has undergone a major revamp for the 2007 version and several of AMT's clients have migrated across to the new system. Not all of them have however and although most people have used it in some capacity, opinion is divided as to whether it really is an improvement on the Excel 2003 version. Edward Ascoli, the author of AMT's Modeling and Power Modeling Midnight Manuals has reviewed Excel 2007 against the 2003 version.

Convertible Bond Issuance up four-fold... - August 2009

Convertible bonds issuance has risen and fallen over time, we currently seem to be on a rising wave.

Distress and Restructuring: Corporates in the Emergency Room - April 2009

Are you aware of: current trends in distressed debt and corporate restructuring, the causes of distress, the legal framework for restructuring in the UK vs. the US, If not then read on... The current outlook: the message is clear In 2008, 101 Moody'...
UK Store Online Now
AMT's Financial Training Portal

AMT Online

Distance training made easy!

AMT provides online testing, recorded sessions and learning materials through our financial training portal, AMT Online.

AMT Training's Public Courses
Contact Us Now