Upgrade to 11.0

Standard

£34.99

Upgrade Now

Premier

£39.99

Upgrade Now

* Upgrade price depends on your current version

Customizing Tables - Advanced Programming
Customizing Tables - Advanced Programming

Question:
How can I go beyond simply entering my data and really program the financial tables in your software?


Answer:
The software includes a complete chapter on advanced programming in the manual, which is not only a physical book but also the same book digitized within the software.

The program is built around a very powerful financial forecasting tool, a set of linked financial tables. All you do is type your assumptions in the green cells, avoid the black cells, and you don't have to program anything. Sales, personnel, income, cash, balance, ratios, and a couple other tables are linked together already, so a change in one flows logically to all the others. This financial tool has been developed over more than 18 years now, has been used with hundreds of thousands of successful business plans, and it works. It is financially and mathematically correct.

However, like all business models, any projection of the future, it is at best a very good educated guess. It depends on assumptions. It is a general tool that can be applied to millions of specific cases. It can always be improved, tailored, and customised. The objective of the manual chapter is to take that basic model and make it better, so it works exactly as you'd like, for your business.

These financial tables, in fact give you extensive spreadsheet-like programmability for your financial tables. Your financials, although they don't need to be programmed, are built into a very powerful spreadsheet tool that includes a complete Microsoft-Excel©-compatible spreadsheet. It supports financial functions that can calculate your loan payments, depreciation, and investment analysis. All of this power is available even within the financial analysis.

The Advanced Tables chapter in the manual is about the spreadsheets in the program. This chapter will explain how the formulas work, and why; it will also cover how you might change them, when you ought to, and what you might change them to. It's also about spreadsheet formulas you can use, and how to use them. It covers many common formulas people use to calculate cost of sales, for example, or sales commissions, or loan repayments. It shows you how to add common formulas and how to create your own. It's about how to use built-in functions to supercharge your analysis.

The best way to learn this is by doing it. Therefore, the manual chapter takes you through a series of examples. It starts with simple examples that offer practical tips. It also includes details of more complex formulas, and practical explanations of formulas you might want to add or change.