C++ :: Amortization Of 500,000 Loans
Jun 24, 2014My task is to find a quick method to calculate the cash flow on nearly 500,000 loans. However, this problem cannot be solved with a simple amortization schedule. The loans have a variety of attributes like periodic reset dates, caps, floors and balloon dates. Some are variable, some fixed rate and nearly all of them are aged to some degree (months or years). Let’s ramp it up a bit, after running the amortization schedules, I need to input different sets of prepayment speed assumptions, then run it all again… 20 more times!
I am very familiar with Excel/VBA and have created a code ‘loop’ which works flawlessly. Trouble is that Excel doesn't have the capacity to perform these tasks quickly. A recent test of 10,000 loans took nearly 5 minutes.
For starters, I’d like to know: Is C++ generally used for financial analysis? Where do I start? (Basics: books, training class, etc.)