I worked closely with Terry Armstrong during the Spring of last year to help her use SurvivalWare in her financial analysis engagements, often under considerable time pressure. She was most appreciative of the help, and graciously agreed to spend time with Kelly relating her experience with the software. I am happy to announce that several enhancements found in SurvivalWare version 3.0 are a direct result of Terry’s insights and “dumb questions.”
Some excerpts:
“due diligence .. financial analysis .. projection analysis”
What I was doing was working with a company that linked up businesses who were interested in going public with hedge funds for finances. And what we did was we did due diligence work to assess companies’ operations and we did some past financial analysis and some projection analysis for the hedge funds to look at and determine whether this company was a viable operation for them to invest in.
“Spreadsheet .. was just full of errors”
I was engaging with a company that had 250 general ledger accounts that needed to be boiled down into 24 categories of income expense categories and consistently reporting how they did versus how they said they were going to do. So, I would be trying to take all of these account balances and push them into this 24 account format every time I was going to be reporting. And it was crazy to do that with a spreadsheet. It was just full of errors and I started searching on the internet for a tool that would allow me to do that and I knew it was going to be working with projections.
“signed up for it because it had a free trial..”
So, I found SurvivalWare on the internet and signed up for it because it had a free trial. It had high recommendations. Seemed to be a tool that would work for what I wanted it to do and I—so I signed up for the free trial and began to use it.
By the time my 30 days were up, I realized that it was something that was absolutely imperative for me to have to do this work and it worked really well.
“And If I had had to do that with the spreadsheet, I would have been crazy. It would have been absolutely insane.”
To take it from the raw data, from the company and put it into their spreadsheet would have been massive collating and sorting process because it had to be done 60 times. And while we were analyzing and trying to figure out how to put their projections into a future basis, there would be lots of changes that were happening during this analysis process. And If I had had to do that with the spreadsheet, I would have been crazy. It would have been absolutely insane.
The complete edited Transcript:
Interview with Terry Armstrong
January 12, 2010 – 9:30 pm ET
Ms. Kelly Luhring: Tell us about your company and your specific role in the company.
Ms. Terry Armstrong: I have to tell you a story of a company that I no longer am working with to connect it to SurvivalWare because about six or eight months ago, I stopped doing that work and I may go back to it, but right now the financial world has flipped a few things around, as you know, and what I was doing at that time is no longer available to me. So, I’ll tell you about that story because what I’m doing now doesn’t relate to SurvivalWare.
What I was doing was working with a company that linked up businesses who were interested in going public with hedge funds for finances. Okay? And what we did was we did due diligence work to assess companies’ operations and we did some past financial analysis and some projection analysis for the hedge funds to look at and determine whether this company was a viable operation for them to invest in.
Ms. Kelly Luhring: And so, how did you find out about SurvivalWare then?
Ms. Terry Armstrong: Well, when I was doing this work, I was having to take companies’ financial data and distill it into a specific format that the hedge funds wanted to see it in and it was a grueling process – changing significantly every time I had a new engagement. Also if the hedge fund decided to engage the company and move forward, there would be future analysis of, “this is how you said you were going to do and this is how you did.” I was engaging with a company that had 250 general ledger accounts that needed to be boiled down into 24 categories of income expense categories and consistently reporting how they did versus how they said they were going to do. So, I would be trying to take all of these account balances and push them into this 24 account format every time I was going to be reporting. And it was crazy to do that with a spreadsheet. It was just full of errors and I started searching on the internet for a tool that would allow me to do that and I knew it was going to be working with projections.
So, I found SurvivalWare on the internet and signed up for it because it had a free trial. It had high recommendations. Seemed to be a tool that would work for what I wanted it to do and I—so I signed up for the free trial and began to use it.
Ms. Kelly Luhring: Oh, great.
And after you began using it, then you decided to go from there and actually buy a package?
Ms. Terry Armstrong: Oh, definitely. By the time my 30 days were up, I realized that it was something that was absolutely imperative for me to have to do this work and it worked really well. I worked with Rusty who was giving me instruction and help all along the way because I was using it for a purpose that the software was probably not intended for. A major sorting tool is what I was using it for and to keep my sorting consistent throughout the periods. So, I might end up with five years worth of financial information from a company in each of the five years would need to be put in and report out in these specific 24 categories and present income statements and balance sheets in these specific categories each time. And that is what SurvivalWare did for me.
Ms. Kelly Luhring: Did these companies use a specific type of accounting software.
Ms. Terry Armstrong: Well, it varied.
Ms. Kelly Luhring: And so, how easy was it to learn how to use SurvivalWare?
Ms. Terry Armstrong: It was pretty easy. I did use Rusty a lot. He gave me a lot of pointers as to how to do it, but it functioned very well once I got the hang of it.
Ms. Kelly Luhring: And so, was it easy to load data from different accounting software and do projections?
Ms. Terry Armstrong: Well, the ease of loading from the accounting software depended on whether the client was able to get the accounting data into a spreadsheet format because I would either download a couple of times. It works pretty well with QuickBooks, but even QuickBooks downloaded into an Excel spreadsheet and then into SurvivalWare. So, that’s the way I always used it. I created a spreadsheet from the accounting system and then fed the spreadsheet into SurvivalWare. And I got to build my row maps and went from there.
Ms. Kelly Luhring: And before were you just relying on kind of Excel? What was your user experience with Excel and what are some of its limitations?
Ms. Terry Armstrong: Well, I’ve been using Excel since it was Lotus and there was some product even before that, so I have been using a spreadsheet a long time – 30 years, I guess. Mostly I’ve used Excel and I’m a pretty high level user of Excel. For the purpose that I was using it, it would have been a nightmare to try to do this with Excel. I could not have done it with Excel without a lot of errors, and inconsistencies. You know, to take 100 general ledger accounts and pull them into a 24 account level of structure consistently over years, past data and future data would have been an Excel nightmare.
Ms. Kelly Luhring: And so–?
Ms. Terry Armstrong: –And trying to figure out how to do it. I never did it with Excel. As soon as I saw the tasks and realized what was going to be necessary, I started looking for another tool because I wasn’t going to have that kind of patience. I knew it wasn’t an application for Excel, you know?
Ms. Kelly Luhring: And how was SurvivalWare able to do what Excel – what would have been a nightmare in Excel?
Ms. Terry Armstrong: Well, once you have the account number or account name and you link it in the row map to the final account name, all you have to do is just import it and it does all that sorting for you.
Ms. Kelly Luhring: And so, how often were you using SurvivalWare and how long did you use it for?
Ms. Terry Armstrong: I used it about a year. My work had distinct phases to it. I would spend time at the client’s site gathering a lot of information and preparing a narrative report and then I would move into the financial analysis phase. And when I moved into the financial analysis phase, I worked with SurvivalWare constantly for two or three weeks for that client. Once I got the financials in the format that I needed them in, then I would move into the next phase of the project which was to do some projections with regard to stock sales and purchases and then my intent was to use SurvivalWare again once the client company and the hedge fund linked up to assess their performance against their projected performance. But, I never got to that phase of it.
So, what I was doing during the year that I was working with SurvivalWare was intense working with SurvivalWare in that middle phase of the reporting work that I did for each client. So, I probably had about 15 clients that I went through that process for in a year.
Ms. Kelly Luhring: And what is it that you liked best about SurvivalWare?
Ms. Terry Armstrong: Well, I like its functionality. I liked the way it took data from many different types of sources and allowed me to pull it into one piece of software. I think it would have been outstanding and really valuable to compare your actual performance with the projected performance.
The part that I liked the best that I used was just being able to take a massive amount of data and consistently and predictably distill it into a comprehendible format of income statement and balance sheet to analyze that data.
Ms. Kelly Luhring: And what did you—you were pretty content in terms of the financial projections being on point and not full of errors?
Ms. Terry Armstrong: Yeah, I found it pretty easy to use and pretty flexible so that it could accommodate a lot of different scenarios.
Ms. Kelly Luhring: And what did you think about the graphics as well?
Ms. Terry Armstrong: I didn’t get into the graphics very much.
Ms. Kelly Luhring: So, was the data showing—just showing all of the past and then there’s perhaps financial information as well as the financial projections and they were satisfied with that format?
Ms. Terry Armstrong: Yes, they didn’t want to see anything graphical. They wanted to see the numbers in a specific format and that’s all we showed them in addition to narrative work that we did.
Ms. Kelly Luhring: And were they satisfied with the SurvivalWare projections?
Ms. Terry Armstrong: Actually, I would take the SurvivalWare data and put it back into a spreadsheet format because that is what they required. It would be month-by-month for five years. So, we’re talking about 60 columns of data had to be pushed through this sieve to get it from two or 300 general ledger accounts pulled down to 24 general ledger accounts that were reported in a financial statement format – sixty times for one client. So, I put it back into a spreadsheet format for them to look at because that’s what they wanted.
Ms. Kelly Luhring: Oh, okay.
Ms. Terry Armstrong: To take it from the raw data, from the company and put it into their spreadsheet would have been massive collating and sorting process because it had to be done 60 times. And while we were analyzing and trying to figure out how to put their projections into a future basis, there would be lots of changes that were happening during this analysis process. And If I had had to do that with the spreadsheet, I would have been crazy. It would have been absolutely insane.
And what SurvivalWare allowed me to do was to have a holding place where the links between the huge number of general ledger accounts that the company was using to collect their information. And the few number of general ledger accounts such as hedge fund wanted to see all this data and allowed me to keep those links straight month-by-month through a five month historical process—I mean a five year historical process and a five year projection period. So, it was a massive amount of data that was constantly being manipulated and reworked until it finally settled into the product that would be presented to the hedge fund in the form of a spreadsheet.
Ms. Kelly Luhring: And so, in your opinion, how much time do you think you saved using it?
Ms. Terry Armstrong: Oh, an immense amount of time. Hundreds of hours per client.
Ms. Kelly Luhring: And then, what types of businesses do you think would benefit from SurvivalWare?
Ms. Terry Armstrong: Well, I think the projection capability which I never really got into for myself, but I looked into because I had expected it to go in that direction. Any kind of business would benefit from that, particularly smaller businesses that don’t have any mechanism for doing that already. Ones who aren’t projecting their cash flow, who don’t know what’s going to happen to them with regard to cash flow over the next “x” months or years.
Ms. Kelly Luhring: And did you feel like, Terry, it was adequate customer support?
Ms. Terry Armstrong: Oh, outstanding. Outstanding customer support.
Ms. Kelly Luhring: And would you recommend it to a friend or a colleague?
Ms. Terry Armstrong: I definitely would.
Ms. Kelly Luhring: Well, do you have any maybe last minute questions or comments? Something that possibly you would have liked SurvivalWare to have done that it wasn’t able to?
Ms. Terry Armstrong: Well, the only other thing I would add is that I was able to get help any time, day or night, and it was invaluable. I got into this work not knowing how it was going to function and if I hadn’t had SurvivalWare, I would not have continued with it. I would have had to get out of it because I’m not interested in pushing numbers through spreadsheets like that. That would have been grunt work that would have been just driving me insane.
I really appreciated it and I thought Rusty was outstanding and he was always willing to help me figure out how to do things with the software that maybe somebody else hadn’t asked to do before and I really appreciated it. I thought it was an outstanding piece of software and the price was unbelievable. Definitely a very good value.
Transcription Services Provided By:
eTranscription Solutions, LLC
www.etranscriptionsolutions.org
(740) 385-5994
Filed under: Cash Flow Analysis and Projections, Financial Management Concepts, SurvivalWare Customer Stories, Uncategorized | Tagged: Excel, Lotus 123, Spreadsheet, Spreadsheet errors, too complex for spreadsheets | Leave a Comment »





