blueSeed Plan is a productivity desk application developed to help users
building up a Business Plan, specifically, within the main areas of this
process, would assists the user in foreseeing budgets and projections to show
financial outcomes of an already ongoing project or one under discussion. An
essential tool for entrepreneurs or businessmen, taking their first steps in a
new undertaking or start-up, to evaluate its viability. It is very helpful when
carrying out financial, economic or costs analysis, above all in the case you
need to address potential investors interested in your project in funding
rounds, for example.
Taking into account common
data from the accounting records in the administration software or ledgers of
the company (sales, staff costs, inventory, financial expenses and revenues,
etc.), this app will lead you through the process of making up your own
financial forecasts in a very easy way. You will be able to produce some
projected statements as: Income Statements, Balance Sheets, Cash Flow
Statements, Break Even Analysis and Sources and Uses of Funds.
Besides the
accounting information, blueSeed Plan would ask you to introduce some global economic
variables such as CPI and Market Interest Rate. Depending on the exactitude of this
values and enterprise operational ones (you will find different sections, in
the user interface, where you will be asked to fill diverse kind of data a
company works with), you would have more accurate figures.
The reports issued by
this app would describe in numbers the outcome of your business strategies and
policies. They would help to provide an operating plan to assist you in running
the business and improve your probability of success.
The application is
divided in various sections:
The first time you
run the application or when you select to create a new document (or Project as it is called by the program),
you would be asked to introduce the Global Variables for the current document
which are: number and kind of periods, currency, CPI and Interest Rate of your
country or geographical area.
They will be used to
calculate price variation through the inflation rate, financial expenses and
revenues, and compound interest for all products in the company portfolio.
Hereunder, you can
see a screenshot of the first form and dialog boxes where you should insert the
figures:
You should introduce
data in the following fields:
Within this part you
should write the number of periods (years or months) your project will have, with
a maximum of 120. You should put an integer in the textbox without comas or any
other character.
This number would be
the time horizon you will set for all projections and must fit our and the
target audience expectations for this exercise.
As you can see in the
previous image there are three format options for each time unit (either year
or month) of the project:
·
Calendar year: periods of time
started in January and ended in December (natural year), you should put the
four digits of the initial year, for example:
“2016”, “1981”.
·
Year-on-year: this biannual format
can be used for not natural years, would be the case of fiscal or economic
years starting in a different month than January and not ending in December, the
way to write them is putting the four digits of the first year, hyphen followed
by the last two digits of the second year, for example: “2016-17”, “1981-82”.
·
Monthly: you can use this
format if you want to set a period of time lesser than a year, then select a
starting month and have in mind this time subdivision would be maintained
through all the time horizon. You should write the first three letters of the
starting month, then a hyphen followed by the last two digits of the initial
year, for example: “ene-16”, “jun-16”.
When you choose this
option, the application will automatically add a column with aggregated figures
in some of the reports produced, such as Income Statement, Balance Sheet, etc.
If you leave blank
this textbox the program will name “Period” to all time units and will number
them consecutively.
Although it has no
impact in any calculation made by the application, you can choose a name or a
symbol for the currency of the project, either one of which appear within the dropdown
box in the related subject or clicking “Other” in the same dropdown box and
writing the desired name in the appearing textbox.
The selection will
appear in all the reports produced.
You can also leave it
blank, in that case there will be no reference to any currency in the issued
reports.
CPI (or Consumer
Price Index) is a variable that would affect to several items in the project, such
as products sales prices, wages, purchasing and overheads, just like what
inflation reflects when price indexes increases.
For our project, it
can be a signed or unsigned integer or floating with two decimals at best.
Furthermore, this rate can be fixed for all the project, meaning that price
variation will be the same for all periods, or variable, you can put a
different rate for each period.
If you want a fixed
CPI you should put the desired estimated figure in the textbox labeled for that
purpose, on the other hand, if you want a variable rate the program gives you
four alternatives for its calculation:
1.
Manual
When you click on
this dropdown box item, a new form will appear with a blank table where you can
manually insert CPI figures for each period. They can be signed or unsigned
integers or floating numbers with decimals.
2.
Linear
Coefficient
When you choose this option, the form shows a textbox
where you can put the CPI rate for the first period (rate expressed in
percentage), and then the increase or decrease to apply in all other periods (in
this case this rate should be expressed in per-one, e.g. for a 10% rate change
you should write “0.01”).
The application will calculate future rates for each
period of time applying that linear coefficient each time over the previous.
3.
Data
Import
blueSeed Plan allows data import from an Excel file. So once you
have chosen that option in the dropdown box and an Excel file in the subsequent
window, you will see a similar form to the previous ones:
First of all, you should put the cells range containing
the data to import in the textbox labeled that way (data can only be numbers,
this option does not accept text), and it can have several rows and columns. If
the range has more than one row, the application takes values from left to
right and top to bottom.
Next step is to write the name of the Excel worksheet
in the next textbox under the previous one.
Then you click on “Import” and wait until the blank
table is filled with the numbers in the Excel file (this process could take
long if the selected range is too big).
If everything has worked out correctly and the figures
in the table are the ones you wanted, you can click on “OK”, otherwise you can
repeat the process checking the range and name of the Excel worksheet.
4.
Time
Series
Last item in
the dropdown box is “Time Series”. blueSeed Plan provides another
calculation method to estimate CPI rates in the Project. It do it according to historic
data trends, adding every new obtained value to the calculation of the next
period of time rate.
Once you have
the Excel file, where you keep the data series, selected (cells values can only be numbers, this
option do not accept text) you will see a similar form to the previous one. Here
you will first have to put the cells range in the upper textbox, it can have
several rows and columns, if it has more than one row, the application takes
values from left to right and top to bottom. Then you write the name of the
Excel sheet in the bottom textbox.
You click on “Import and calculate” and wait until the
blank table is filled with the numbers calculated by the application (this
process could take long if the selected range is too big).
If everything has worked out correctly and the figures
in the table seem to be right, you can click on “OK”, otherwise you can repeat
the process checking the range and name of the Excel worksheet.
Interest Rate is a
global variable (it would be the reference value for all the interest rates
needed in the project) and would affect to several items in the project, such
as leasing, renting, loans or credit lines. It can be a signed or unsigned
integer or floating with two decimals at best.
Besides, this rate
can be fixed for all the project, meaning that price variation will be the same
for all periods, or variable, you can put a different rate for each period.
If you want a fixed Interest
Rate you should put the desired estimated figure in the textbox labeled for
that purpose, on the other hand, if you want a variable rate the program gives
you four alternatives for its calculation:
1.
Manual
When you click on
this dropdown box item, a new form will appear with a blank table where you can
manually insert Interest Rate figures for each period. They can be signed or
unsigned integers or floating numbers with decimals.
2.
Linear
Coefficient
When you choose this option, the form shows a textbox
where you can put the Interest Rate for the first period (rate expressed in
percentage), and then the increase or decrease to apply in all other periods (in
this case this rate should be expressed in per-one, e.g. for a 10% rate change
you should write “0.01”).
The application will calculate future rates for each
period of time applying that linear coefficient each time over the previous.
3.
Data
Import
blueSeed Plan allows data import from an Excel file. So once you
have chosen that option in the dropdown box and an Excel file in the subsequent
window, you will see a similar form to the previous ones:
First of all, you should put the cells range
containing the data to import in the textbox labeled that way (data can only be
numbers, this option does not accept text), and it can have several rows and
columns. If the range has more than one row, the application takes values from
left to right and top to bottom.
Next step is to write the name of the Excel worksheet
in the next textbox under the previous one.
Then you click on “Import” and wait until the blank
table is filled with the numbers in the Excel file (this process could take
long if the selected range is too big).
If everything has worked out correctly and the figures
in the table are the ones you wanted, you can click on “OK”, otherwise you can
repeat the process checking the range and name of the Excel worksheet.
4.
Time
Series
Last item in
the dropdown box is “Time Series”. blueSeed Plan provides another
calculation method to estimate CPI rates in the Project. It do it according to
historic data trends, adding every new obtained value to the calculation of the
next period of time rate.
Once you have
the Excel file, where you keep the data series, selected (cells values can only be numbers, this
option do not accept text) you will see a similar form to the previous one.
Here you will first have to put the cells range in the upper textbox, it can
have several rows and columns, if it has more than one row, the application
takes values from left to right and top to bottom. Then you write the name of
the Excel sheet in the bottom textbox.
You click on “Import and calculate” and wait until the
blank table is filled with the numbers calculated by the application (this
process could take long if the selected range is too big).
If everything has worked out correctly and the figures
in the table seem to be right, you can click on “OK”, otherwise you can repeat
the process checking the range and name of the Excel worksheet.
Once you have all global variables well defined within
the first form, you should validate clicking on the corresponding button. If
there is no errors, “Accept” button is activated so it can be clicked to
continue with following stage in the process.
Now you have press the button, current window disappears
and the main window of the program is showed. Here you will introduce specific
data of the project.
You can see a detail of this form hereunder:
As you can realize this form has several tabs in it. The
one selected is the one is opened in first instance every time you start a new
project (“Start”).
First thing you can appreciate in the upper part is a
table with a summary with the numbers you have already introduced in the first
window. This table cannot be modified without going back to the first form, and
for that you would have to click on the “Global Variables” button below.
In the case you could not see all the columns or rows
of this table, you can click on it and move through the cells with the arrow
buttons in your keyboard.
If you are compelled to change any of those first
variables, you should bear in mind that depending on what changes are you going
to do, they may affect to the information you have already put in the main
window (in any of its tabs) and in some cases lose some part of it.
In the lower part of the tab you can see two captions:
Corporate Income Tax, which we explain in the next section, and Project Ratios where
you can find a list of several financial rates you can use for your analysis. This
ratios are refreshed every time we ask for a report in the application menu or
tool bar.
Corporate
Income Tax
In this block you can define sort of and rates for the
Corporate Income Tax. If it is a fixed rate type or it is a tax bracket one,
then select bracket ranges and income tax rate for each one.
For fixed rates, you just have to write the desired
figure in the textbox of the window that will appear when we get in “Fixed Rate”
box, then you click on “OK” and the number will be displayed in the textbox. It should be an unsigned integer or
floating with two decimals at best.
For tax bracket type, first step is to select the radio
button labeled as “In terms of Tax Base” and a dropdown box and two more
textboxes will be displayed. To define the tax bracket structure you may
proceed as follows:
-
The dropdown box lists two items: “To” and “Above”. Every time you want
to set a new bracket you have to select “To” except in the case of the last
bracket, where you have to clink on “Above”, thus adding last row of the table
and closing the bracket structure.
For instance, for a tax structure of three brackets: 0-100,000,
100,001-300.000 and 300,001- ∞, you would have to
put “To” in the first two segments, and “Above” in the last one.
-
In the textbox under the dropdown box, you have to write the figure corresponding
to the upper limit of the Tax Base (net income before taxes) Bracket, except for the last one where
you leave the previous number as the lower limit in a bracket that has no upper
end (or it has ∞).
Following prior example: 100,000 for the first one,
300,000 for the second one, and you will leave 300,000 for the last one.
-
Finally, you can insert tax rate
for every bracket in the second textbox, it should be an unsigned integer or
floating with two decimals at best.
For example, in a tax
structure which seeks to benefit low profits: 20% for the first bracket, 25%
for the second and 30% for the last one).
Once you have the values you require in the
corresponding boxes, you click on “Add to list” every time you want to
introduce a new bracket in the table. Any time you do it for the last segment
of that range (when you have “Above” selected in the dropdown box), you will
see this button and the one named “Delete row” will disable, as you have
already completed the tax income bracket structure.
To revert that situation you have to click on “Fixed
Rate” radio button and the table and boxes will disappear.
Before having introduced the last bracket in the table,
when it is not blocked and accepting more fields, you can delete rows of that
table by just selecting the one you want to delete and clicking on “Delete row”.
Now you have to
continue introducing data in the next tabs, so we will go over each one of the
in the following sections.
Sales tab shows the
following view:
First thing you see
is a blank table (with the exception of the headers on every column) where you
will see displayed every data you will be introducing afterwards: name of the
products (in the first column), sales amounts by period of time (next columns
with the periods names in the header), collection and excise tax pay terms by
period of time (which will be shown in the last two blue rows) and, finally, excise
tax rate by product (in the last column of the table, which cannot be viewed in
upper image).
In the case you could not see all the columns or rows
of this table, you can click on it and move through the cells with the arrow
buttons in your keydoard.
There are two ways to
insert data in the table: manually one by one or importing values from an Excel
worksheet.
In the first case you
should fill the different dialog boxes: product name, price (not excise tax
affected), excise tax rate and number of units sold. Then you should allocate a
period of time in the dropdown box just over the “Add to list” button.
If you want product price
to be affected by CPI (the value you have introduced in the first form), we
tick on the checkbox labeled “Apply inflation”. The way in which the program take
into account the inflation rate is to apply a coefficient to the price you have
written in corresponding textbox (which should be a reference from the previous
period to the first one in the project). That coefficient is the result of
multiply all the CPI rates (the ones shown in the table in the firs tab) from
the first period of time to the period you have currently selected.
Now that you have all
the data you want to introduce in the table and the period of time where you
want to do it, you can insert that values by clicking on “Add to list” button.
Average collection
and Excise Tax pay terms are added separately selecting one of the two options
in the “Terms” section, fixed for all the project, with means they would be the
same terms in all the periods of time, or you can select to put different terms
period by period (in this case you will see that the dropdown box used to
allocate periods is enabled).
To correct any of the
figures you have already introduced in the table, you count with two options: you
can delete a complete row (or product) just by selecting it and clicking on “Delete
row” button, or you can correct individual values cell by cell.
To change values in
only one cell you first have to select the radio button labeled as “Correct
cell”, then you have to select the cell by clicking on it and press “Correct”
button. A new window will appear where you have to introduce a new value, click
“OK” and the cell will show amended figure.
Import
As explained before, the application allows data
import from an Excel worksheet, as an alternative to inserting numbers one by
one as described in the manual method above.
To start this option you have to check “Import” box, write
excise tax rate if applicable within the textbox enabled, and then select one
of the two methods the dropdown box offers to the users:
1)
Data Import
First option is plain data import, once you have
chosen the Excel file where you have the information you want to import, in the
dialog window appearing after clicking on the corresponding dropdown box item,
you will see a similar form to the previous ones (CPI and Interest rate import
methods), and also process to follow is quite similar.
First of all, you should put the cells range
containing the data to import in the textbox labeled that way, but here there
is a difference this time in the way the values has to be positioned. They
should be organized in a similar way the application ask for values when using
the manual method, so there are two key factors to have in mind before organize
the information in the Excel worksheet:
I.
First column of the range should
contain the name of the products (with as many rows or fields as you need).
II.
After this first column, they
should follow pairs of columns for each same period of time (product price and
units sold, and should be as many pairs of columns as periods of time in the
project), with the same number of rows than the first one.
Next step is to write the name of the Excel worksheet
in the next textbox under the previous one.
Then you click on “Import” and wait until the blank table
is filled with the names and numbers in the Excel file (this process could take
long if the selected range is too big).
If everything has worked out correctly and the values
in the table are the ones you wanted, you can click on “OK”, otherwise you can
repeat the process checking the range and name of the Excel worksheet.
2) Time Series
The second item
listed in the “Insert data” dropdown box within import section is “Time
Series”. blueSeed Plan provides another
calculation method to estimate total sales figures for each period of time (for
only one field or product each time). It do it according to historic data
trends (data provided by the user), adding every new obtained value to the original
series and using increased set of values for the calculation of the next period
of time rate.
Once you have
the Excel file, where you keep the data series, selected (cells values can only be numbers, this
option do not accept text) you will see a similar form to the previous one.
Here you will first have to put the cells range in the upper textbox, it can
have several rows and columns, if it has more than one row, the application
takes values from left to right and top to bottom.
Then you write the name of the Excel sheet in the bottom
textbox.
It is important to note that, firstly, the program asks
only for historic sales figures (not prices at all, and not units numbers yet),
and no need neither to introduce names of the products in the first column as
before (application will assign a default name).
You click on “Import and calculate” and wait until the
blank table is filled with the numbers calculated by the application (this
process could take long if the selected range is too big).
When the program has finished calculation of the total
amount of sales for each period of time, it announce the user he could now
introduce total units sold in for each period, another table appears where we
can introduce, manually this time, the total quantity numbers for each period
(this table can be left totally blank as it has not impact in sales now that
the first table is completed).
If everything has worked out correctly and the figures
in both tables seem to be right, you can click on “OK”, otherwise you can
repeat the process checking the range and name of the Excel worksheet.
Stock and Purchasing tab has the following appearance:
Just like in the previous
tab, first thing you see is a blank table (with the exception of the headers on
every column and two first rows). Here you will see displayed every data you
will be introducing afterwards: end of period goods stock figures (in the first
row), name of the purchased products (in the first column under “Purchasing”
header), purchasing amounts by period of time (next columns with the periods
names in the header), average and excise tax pay terms by period of time (which
will be shown in the last two blue rows) and, finally, excise tax rate by
product (in the last column of the table, which cannot be viewed in upper image).
In the case you could not see all the columns or rows
of this table, you can click on it and move through the cells with the arrow
buttons in your keyboard.
To select the kind of
data you are working with, inventory or purchasing, you first have to click on
the consistent radio button, and follow as described in next paragraphs.
There are two ways to
insert data in the table: manually one by one or importing values from an Excel
worksheet.
In the first case you
should fill the different dialog boxes. When you are inserting inventory
figures you find a first textbox where you have to put opening balance in, beside
there is a dropdown box where you should specify during the period the goods
stock has increased or decreased, finally, in the textbox below you write the
amount of stock variation. Then you allocate the period of time to which the
data is related in the dropdown box just over the “Add to list” button.
Otherwise, if you are
introducing purchasing information, you first have to write the name of the
good in the upper textbox, then the purchased amount for that period, an excise
tax rate if applicable. Then again, you allocate the period of time to which
the data is related in the dropdown box just over the “Add to list” button.
If you want purchased
goods price to be affected by CPI (the value you have introduced in the first
form), we tick on the checkbox labeled “Apply inflation”. The way in which the
program take into account the inflation rate is to apply a coefficient to the purchased
total value you have written in corresponding textbox (which should be a
reference from the previous period to the first one in the project). That
coefficient is the result of multiply all the CPI rates (the ones shown in the
table in the firs tab) from the first period of time to the period you have
currently selected.
Now that you have all
the data you want to introduce in the table and the period of time where you
want to do it, you can insert that values by clicking on “Add to list” button.
Average and Excise Tax
pay terms are added separately selecting one of the two options in the “Terms”
section, fixed for all the project, with means they would be the same terms in
all the periods of time, or you can select to put different terms period by
period (in this case you will see that the dropdown box used to allocate
periods is enabled).
To correct any of the
figures you have already introduced in the table, you count with two options: you
can delete a complete row (or product) just by selecting it and clicking on “Delete
row” button, or you can correct individual values cell by cell.
To change values in
only one cell you first have to select the radio button labeled as “Correct
cell”, then you have to select the cell by clicking on it and press “Correct”
button. A new window will appear where you have to introduce a new value, click
“OK” and the cell will show amended figure.
Import
As explained before, the application allows data
import from an Excel worksheet, as an alternative to inserting numbers one by
one as described in the manual method above.
To start this option you have to check “Import” box,
write excise tax rate (just in the case you are working with in purchasing
choice) if applicable within the textbox enabled, and then select one of the two
methods the dropdown box offers to the users:
1)
Data Import
Subject to what kind of values you have chosen to
introduce, inventory or purchasing, the way the information has to be ordered
in the worksheet is going to vary, so we now are going to show you the two
different cases:
a)
Inventory
Once you have selected the Excel file in the window
appearing after clicking in the dropdown box item, you must follow next
instructions:
First of all, you should put the cells range
containing the data to import in the textbox labeled that way (data can only be
numbers, this option does not accept text), and it can have several rows and
columns. If the range has more than one row, the application takes values from
left to right and top to bottom.
Next step is to write the name of the Excel worksheet
in the next textbox under the previous one.
Then you click on “Import” and wait until the blank
table is filled with the numbers in the Excel file (this process could take
long if the selected range is too big).
If everything has worked out correctly and the figures
in the table are the ones you wanted, you can click on “OK”, otherwise you can
repeat the process checking the range and name of the Excel worksheet.
b)
Purchasing
Again, you have to choose the Excel file where you
have the information you want to import, in the dialog window appearing after
clicking on the corresponding dropdown box item, you will see then a similar
form to the previous ones (CPI and Interest rate, Sales import methods), and
also process to follow is quite similar.
First of all, you should put the cells range
containing the data to import in the textbox labeled that way, but here there
is a difference this time in the way the values has to be positioned. They
should be organized in a similar way the application ask for values when using
the manual method, so there are two key factors to have in mind before organize
the information in the Excel worksheet:
I. First column of the
range should contain the name of the purchased goods (with as many rows or
fields as you need).
II. After this first
column, they should follow columns with total amount purchased for each period
of time (not pairs of columns as in previous sections of the program), with the
same number of rows than the first one.
Next step is to write the name of the Excel worksheet
in the next textbox under the previous one.
Then you click on “Import” and wait until the blank table
is filled with the names and numbers in the Excel file (this process could take
long if the selected range is too big).
If everything has worked out correctly and the values
in the table are the ones you wanted, you can click on “OK”, otherwise you can
repeat the process checking the range and name of the Excel worksheet.
2) Time Series
This time, “Time
Series” option in this tab woks the same for inventory as for purchasing.
blueSeed Plan provides another
calculation method to estimate total figures for each period of time (for only
one field or product each time). It do it according to historic data trends
(data provided by the user), adding every new obtained value to the original
series and using increased set of values for the calculation of the next period
of time rate.
Once you have
the Excel file, where you keep the data series, selected (cells values can only be numbers, this
option do not accept text) you will see a similar form to the previous one.
Here you will first have to put the cells range in the upper textbox, it can
have several rows and columns, if it has more than one row, the application
takes values from left to right and top to bottom.
Then you write the name of the Excel sheet in the bottom
textbox.
It is important to note that, firstly, the program
asks only for historic figures (not prices and units numbers split, as in other
cases), and no need neither to introduce names of the products (in “Purchasing”
option) in the first column as before (application will assign a default name).
You click on “Import and calculate” and wait until the
blank table is filled with the numbers calculated by the application (this
process could take long if the selected range is too big).
If everything has worked out correctly and the figures
in the table seem to be right, you can click on “OK”, otherwise you can repeat
the process checking the range and name of the Excel worksheet.
In this section, application
shows following parts:
Just like in previous
tabs, first thing you see is a blank table (with the exception of the headers on
every column). Here you will see displayed every data you will be introducing afterwards.
In the case you could not see all the columns or rows
of this table, you can click on it and move through the cells with the arrow
buttons in your keyboard.
In fact there will be
two different tables, one for the data when you are working in “Positions and
Wages” option, and other for the information in “Social Expenses” one.
Anyway, the
information you will see in both tables will appear in following order: job
positions or social expenses denomination (in the first column), wage and
salaries total amounts for any job position or total amount for any expense by
period of time (next columns with the periods names in the header), finally, only
for “Positions and Wages” option, Personal Income Tax (PIT) rate, worker
Contribution (W) rate, company Contribution (C) rate, would be displayed for
every job position, if applicable, in the last three columns of related table,
which cannot be viewed in upper image.
To select the kind of
data you are working with, positions and wages or social expenses, you first
have to click on the consistent radio button, and follow as described in next
paragraphs.
There are two ways to
insert data in the tables: manually one by one or importing values from an
Excel worksheet.
In the first case you
should fill the different dialog boxes. When you are inserting positions and
wages figures you find a first textbox where you have to put the name of the
job positions in, beside there is another text box where you have to write the
number of positions for each job in the firm, and under you have another
textbox to introduce gross wage for that position. There are three more
textboxes where you can put in, whenever is necessary, Personal Income Tax
(PIT), worker Contribution (W), company Contribution (C) rates. Finally, you allocate
the period of time to which the data is related in the dropdown box just over
the “Add to list” button.
Otherwise, if you are
introducing social expenses information, you just have to write the name of the
expense in the first textbox and the expense total amount for that period in
the one below. Then again, you allocate the period of time to which the data is
related in the dropdown box just over the “Add to list” button.
If you want wages or
social expenses to be affected by CPI (the value you have introduced in the
first form), we tick on the checkbox labeled “Apply inflation”. The way in
which the program take into account the inflation rate is to apply a
coefficient to the gross wage you have written in corresponding textbox (which
should be a reference from the previous period to the first one in the project).
That coefficient is the result of multiply all the CPI rates (the ones shown in
the table in the firs tab) from the first period of time to the period you have
currently selected.
Now that you have all
the data you want to introduce in the table and the period of time where you
want to do it, you can insert that values by clicking on “Add to list” button.
To correct any of the
figures you have already introduced in the table, you count with two options: you
can delete a complete row (or product) just by selecting it and clicking on “Delete
row” button, or you can correct individual values cell by cell.
To change values in
only one cell you first have to select the radio button labeled as “Correct
cell”, then you have to select the cell by clicking on it and press “Correct”
button. A new window will appear where you have to introduce a new value, click
“OK” and the cell will show amended figure.
Import
You can only use this option when working in “Positions and Wages” selection.
As explained before, the application allows data import from an Excel worksheet,
as an alternative to inserting numbers one by one as described in the manual
method above.
To start this option you have to check “Import” box,
write Personal Income Tax (PIT),
worker Contribution (W), company Contribution (C) rates if applicable
within the textboxes enabled, and then select one of the two methods the
dropdown box offers to the users:
1)
Data Import
First option is plain data import, once you have
chosen the Excel file where you have the information you want to import, in the
dialog window appearing after clicking on the corresponding dropdown box item,
you will see a similar form to the previous ones (CPI and Interest rate, Sales
import methods), and also process to follow is quite similar.
First of all, you should put the cells range containing
the data to import in the textbox labeled that way, but here there is a
difference this time in the way the values has to be positioned. They should be
organized in a similar way the application ask for values when using the manual
method, so there are two key factors to have in mind before organize the
information in the Excel worksheet:
I. First column of the
range should contain the name of the job positions (with as many rows or fields
as you need).
II. After this first
column, they should follow pairs of columns for each same period of time (gross
wages and number of posts for each position, and should be as many pairs of
columns as periods of time in the project), with the same number of rows than
the first one.
Next step is to write the name of the Excel worksheet
in the next textbox under the previous one.
Then you click on “Import” and wait until the blank table
is filled with the names and numbers in the Excel file (this process could take
long if the selected range is too big).
If everything has worked out correctly and the values
in the table are the ones you wanted, you can click on “OK”, otherwise you can
repeat the process checking the range and name of the Excel worksheet.
2)
Time Series
The second item listed in the “Insert data” dropdown
box within import section is “Time Series”. blueSeed Plan provides another calculation method to
estimate total wages figures for each period of time (for only one field or job
position each time). It do it according to historic data trends (data provided
by the user), adding every new obtained value to the original series and using
increased set of values for the calculation of the next period of time rate.
Once you have the Excel file, where you keep the data
series, selected (cells values can only be numbers, this option do not accept
text) you will see a similar form to the previous one. Here you will first have
to put the cells range in the upper textbox, it can have several rows and columns,
if it has more than one row, the application takes values from left to right
and top to bottom.
Then you write the name of the Excel sheet in the
bottom textbox.
It is important to note that, firstly, the program
asks only for historic wages and salaries figures (not individual wage nor numbers
of position to make a multiplication), and there is no need neither to
introduce names of the posts in the first column as before (application will
assign a default name).
Next thing you click on “Import and calculate” and
wait until the blank table is filled with the numbers calculated by the
application (this process could take long if the selected range is too big).
When the program has finished calculation of the total
amount of payroll for each period of time, it announce the user he could now
introduce total number of job positions for each period, another table appears
where we can write, manually this time, the total quantity numbers for each
period (this table can be left totally blank as it has not impact in sales now
that the first table is completed).
If everything has worked out correctly and the figures
in both tables seem to be right, you can click on “OK”, otherwise you can
repeat the process checking the range and name of the Excel worksheet.
“Overheads” tab
displays as follows:
Like it happened in
previous sections, first thing you see is a blank table (with the exception of
the headers on every column) where you will see displayed every data you will
be introducing afterwards: name of the expenses (in the first column), expenses
amounts by period of time (next columns with the periods names in the header), average
and excise tax pay terms by period of time (which will be shown in the last two
blue rows) and, finally, excise tax rate by expense (in the last column of the
table, which cannot be viewed in upper image).
In the case you could not see all the columns or rows
of this table, you can click on it and move through the cells with the arrow
buttons in your keyboard.
There are two ways to
insert data in the table: manually one by one or importing values from an Excel
worksheet.
In the first case you
should fill the different dialog boxes: expense name in the first textbox, excise
tax rate and expenditure total amount in the second textbox. Then you should allocate
a period of time in the dropdown box just over the “Add to list” button.
If you want expenses to
be affected by CPI (the value you have introduced in the first form), we tick
on the checkbox labeled “Apply inflation”. The way in which the program take
into account the inflation rate is to apply a coefficient to the total amount
value you have written in corresponding textbox (which should be a reference
from the previous period to the first one in the project). That coefficient is
the result of multiply all the CPI rates (the ones shown in the table in the
firs tab) from the first period of time to the period you have currently
selected.
Now that you have all
the data you want to introduce in the table and the period of time where you
want to do it, you can insert that values by clicking on “Add to list” button.
Average and Excise Tax
pay terms are added separately selecting one of the two options in the “Terms”
section, fixed for all the project, with means they would be the same terms in
all the periods of time, or you can select to put different terms period by
period (in this case you will see that the dropdown box used to allocate
periods is enabled).
To correct any of the
figures you have already introduced in the table, you count with two options: you
can delete a complete row (or product) just by selecting it and clicking on “Delete
row” button, or you can correct individual values cell by cell.
To change values in
only one cell you first have to select the radio button labeled as “Correct
cell”, then you have to select the cell by clicking on it and press “Correct”
button. A new window will appear where you have to introduce a new value, click
“OK” and the cell will show amended figure.
Import
As explained before, the application allows data
import from an Excel worksheet, as an alternative to inserting numbers one by
one as described in the manual method above.
To start this option you have to check “Import” box,
write excise tax rate if applicable within the textbox enabled, and then select
one of the two methods the dropdown box offers to the users:
1)
Data Import
You have to choose the Excel file where you have the
information you want to import, in the dialog window appearing after clicking
on the corresponding dropdown box item, you will see then a similar form to the
previous ones (CPI and Interest rate, Sales, Purchasing import methods), and
also process to follow is quite similar.
First of all, you should put the cells range
containing the data to import in the textbox labeled that way, but here there
is a difference this time in the way the values has to be positioned. They
should be organized in a similar way the application ask for values when using
the manual method, so there are two key factors to have in mind before organize
the information in the Excel worksheet:
I. First column of the
range should contain the name of each expense (with as many rows or fields as
you need).
II. After this first
column, they should follow columns with total amount spent in that overhead for
each period of time (not pairs of columns as in other sections of the program),
with the same number of rows than the first one.
Next step is to write the name of the Excel worksheet
in the next textbox under the previous one.
Then you click on “Import” and wait until the blank table
is filled with the names and numbers in the Excel file (this process could take
long if the selected range is too big).
If everything has worked out correctly and the values
in the table are the ones you wanted, you can click on “OK”, otherwise you can
repeat the process checking the range and name of the Excel worksheet.
2) Time Series
The second item listed in the “Insert data” dropdown
box within import section is “Time Series”. blueSeed Plan provides another calculation method to
estimate total overheads for each period of time (for only one expense each
time). It do it according to historic data trends (data provided by the user),
adding every new obtained value to the original series and using increased set
of values for the calculation of the next period of time rate.
Once you have the Excel file, where you keep the data
series, selected (cells values can only be numbers, this option do not accept
text) you will see a similar form to other sections ones. Here you will first
have to put the cells range in the upper textbox, it can have several rows and
columns, if it has more than one row, the application takes values from left to
right and top to bottom.
Then you write the name of the Excel sheet in the
bottom textbox.
It is important to note that, firstly, the program
asks only for historic overheads figures (not costs and numbers of services to
make a multiplication), and there is no need neither to introduce names of the expenses
in the first column as before (application will assign a default name).
Next thing you click on “Import and calculate” and await
until the blank table is filled with the numbers calculated by the application
(this process could take long if the selected range is too big).
If everything has worked out correctly and the figures
in the table seem to be right, you can click on “OK”, otherwise you can repeat
the process checking the range and name of the Excel worksheet.
Below you can see a
screenshot of “Fixed Assets” tab when it is selected by user:
In this one, and some
of the following tabs, gathering information is a little bit different. Application
will not request for data in every period of time, it will just ask for opening
values or references and will automatically calculate the rest in each period, taking
into account all parameters introduced. Also, there is no possibility for data
import.
Again you have a
blank table (with the exception of the headers on every column) where you will
see displayed every data you will be introducing afterwards: name of assets (in
the first column), their end of period value (next columns with the periods
names in the header), average and excise tax pay terms by period of time (which
will be shown in the last two blue rows), excise tax rate by expense (in the
next-to-last column, not seen in the image above) and, finally, depreciation
rate (in the last column of the table, not seen in the image above).
In the case you could not see all the columns or rows
of this table, you can click on it and move through the cells with the arrow
buttons in your keyboard.
So, to load the
information in the table you first have to choose an asset in the list of the
dropdown box called “Asset Class”. Items in the list are: (first intangible
assets) I+D Expenses, Administrative License, Goodwill, ICT Apps; (then
property, plant and equipment) Buildings, Equipment, Furniture, Technical
Facilities, Vehicles and Land.
In the textbox below
you should write asset purchase price or market value (without excise tax). Then
you can write an excise tax rate in the textbox labeled accordingly, if that is
applicable, and finally put the consistent depreciation rate in the last textbox.
If you have used a
leasing contract to support the acquisition of any particular asset, so it is
linked to that financial debt, you should check on “Asset in leasing” box. It
is important you do it because, otherwise, program would already have a
financial debt (leasing) reflected in its reports, and would have another (fixed
asset supplier outstanding debt), at the end of period.
To set the date of
the asset acquisition you, as usual, have to select a period of time in the
dropdown box called “Period allocation” and click on “Add to list” button. After
that the program will calculate asset end of period value, deducting
accumulated depreciation.
Average and Excise Tax
pay terms are added separately selecting one of the two options in the “Terms”
section, fixed for all the project, with means they would be the same terms in
all the periods of time, or you can select to put different terms period by
period (in this case you will see that the dropdown box used to allocate
periods is enabled).
To correct any of the
figures you have already introduced in the table, you only count with one
option this time: you should delete a complete row (or asset) just by selecting
it and clicking on “Delete row” button.
Hereunder you can
find a screenshot of this tab:
Just as in the
previous tab, you have to provide the starting values and parameters of the
selected financial asset or liability, and the application calculates the
resulting data for the rest of the periods.
But first choice to
make is to select between financial expenses or revenues (each kind of data
will be recorded in a different table). For that, we check on the matching
radio button “Expenses” or “Revenues”.
In any choice you
have a blank table (with the exception of the headers on every column) where
you will see displayed every data you will be introducing afterwards: name of
assets or debts (in the first column) and accrued interest receivable or
payable by periods (next columns with the periods of time names in the header).
In the case you could not see all the columns or rows
of those tables, you can click on it and move through the cells with the arrow
buttons in your keyboard.
So to calculate and
display the figures in the tables, either you have selected expenses or
Revenues, you have to choose one item in the first dropdown box in the section.
For “Select financing” box the possibilities are: Leasing (post), Leasing
(pre), Renting, Loan and Credit Account; and for “Type of investment” one the
list is: Fixed term deposit and Loan.
In the textbox below
you can put the amount of the debt (or equipment cost or market value) or the credit.
Then you can set the length of the financial operation itself by write a number
in the “Term” labeled box.
In the cases of leasing
or renting debt operations, there are some other parameters you can make use
of: residual value, other expenses inherent to that operation (for renting), and
excise tax rate. As for Loans you can add a grace period.
But one of the most
important factor in every financial contract is interest. Here, the application
gives you two options:
We can select a fixed
interest for that particular operation, so you will have to pick that item in “Nominal
interest” dropdown box and write an interest rate in the textbox below.
On the other hand, if
you want a variable interest rate for every period, after picking that
selection in the dropdown box, you would have to put a rate differential (it
can be 0) that will sum up to the benchmark rate of our project (which is the
one introduced in the first form when opening a new project, and that is
displayed in “Start” tab).
Lastly, as usual, we
choose opening period for the contract, either debt or asset, and click on “Add
to list”. The program will calculate and display in the table the amount of interests
for that kind of operation in any period to the end of contract term (or project
life if this one is shorter).
To correct any of the
figures you have already introduced in the table, you only count with one
option this time: you should delete a complete row just by selecting it and
clicking on “Delete row” button.
Following tab is for
Non Operational expenses or revenues and it has this sight:
In this section you
have to introduce data period by period, in part is like first stages of the
application (but it cannot import values).
What you first see, other
than the usual blank table, is that there are two parts and only one is operational
at the same time, and by default is the first one (the one in the left) which
is enabled. To revert that situation you just have to click on “Add provisions”
box what will deactivate first group and activate “Provisions” one.
Left part of the
section “Non Operational Expenses and Income” is used basically for that, to introduce
non operational values in one of the tables (expenses or revenues), so first
choice to make is to select between them (each kind of data will be recorded in
a different table). For that, we check on the matching radio button “Expenses”
or “Revenues”. Then you have a textbox to write the name of the expense or
revenue and another one to put the amount for a given period of time in.
Finally you select the period in “Period allocation” dropdown box and click on
“Add to list”.
Tables are organized
as in previous tabs, in the first column the name of the expense or revenue
will be shown, and its amounts by period in the following columns. The last two
blue rows are reserved for provisions.
In the case you could not see all the columns or rows
of those tables, you can click on it and move through the cells with the arrow
buttons in your keyboard.
The group “Provisions”
in the right part allow you to manage short and long term provisions, and as
explained before, it has to be activated before start working with it.
After checking on
provisions box, first thing you note is that labels in radio buttons below change
for “Provisions of period” and “Provisions Surplus” accordingly. This make no
difference operationally (as they continue to distinguish between the same
tables you were using before), just announce what kind of provision movement you
are going to carry out, a period provision (equals an expense in income
statement) or a provision surplus (equals a revenue in income statement).
Hence, to copy the
values in the table you have to select one radio button and fill the textboxes
inside the group: figures for short term in the upper one and long term values
in the lower one.
Finally you follow as
usual, you should allocate a period of time in the dropdown box just over the
“Add to list” button and click on the later.
To correct any of the
figures you have already introduced in the table, you only count with one
option this time: you should delete a complete row just by selecting it and
clicking on “Delete row” button.
Last tab, to complete
the introduction of all information needed by the application, has this view:
As you can see in the
previous image, there are several groups where you must put the values you want
to record in the project.
In the first one
“Initial Net Equity”, you see different textboxes you can fill: Common Stock, Shareholders
Contribution Receivable, Additional Paid-In Capital, Previous Retained Earnings
and Recorded Losses.
In all five boxes you
should write opening values for each Net Equity field (those quantities should
be the same the ones you have in starting balance sheet of the new project).
Common Stock value is
a must you should fill, to have intelligible reports and to calculate some of
the financial ratios this program offers (as IRR). The applications offers the
opportunity to add capital increases after first period, as you will see later.
Rest of the textboxes
are optional to fill. Shareholders Contribution Receivable and Additional
Paid-In Capital values can be modified after having set opening values, as you
will see later. Movements in this variables would then affect to cash flow
report or to financial rates too.
Previous Retained
Earnings and Recorded Losses can be left blank, in the case your Project is related
to a new undertaking, or use the figure in balance sheet in the case of ongoing
companies.
Once you have written
all the initial values you want to record, just click on the upper “Add to list”
button to display them in the table. This action also enable the second group
of controls “Variation”, and disable the first one (there is an option to come
back to this group as you will see later).
In the case you could not see all the columns or rows
of this table, you can click on it and move through the cells with the arrow
buttons in your keyboard.
Now, in this group
you first can appreciate a dropdown box which has four options to choose:
Common Stock Increase, Additional Paid-In Capital, Shareholder Contribution Receivable
Deposit and Change Origin Values.
So, to make changes
in the displayed numbers, we have to select one of the first three items, last
one just disable this section and returns you to the first one. Then, write the
variation amount in the next textbox and, finally, allocate the period of time
when this adjustment would happen. Last of all you just have to click on “Add
to list” in this group, and the program will recalculate the balance of every
field on the table taking into account the new adjustments, and new values will
display in the table.
Last parts of the tab
are two sections where you can take decisions about tax credit and retained
earnings.
Within “Tax credit”
section, you have two options to choose: Offset or Not Offset negative tax
bases (coming from previous periods). If you choose to offset tax bases, any period
you have an income tax positive quota it will be diminish in the corresponding
amount. In the case you choose not to offset tax bases, any negative new tax
base will be added to Recorded Losses in balance sheet.
In conclusion, within
“Profit” section, you can choose destination of earnings surpluses in every
period of time, and you have two options: To Retained Earnings and To Dividends.
If you choose first choice, every net income would add to Retained Earnings in
the balance sheet (increasing net equity total amount). On the other hand, if
you decide to distribute dividends,
the program considers there is cash outflow (and there is no increasing in net
equity).
Most important
utility of blueSeed Plan is the production of several kind of reports, graphics
and financial ratios using all the information you have introduced in every
stage in the application.
Reports can be viewed
in the screen, for what you have to click on button in the toolstrip, or can be sent directly to printer just by
clicking on button
(there is the possibility to export to an
Excel file as you will see later).
After clicking on any
of the described buttons, a new dialog window will appear (as it is shown in
the following image), where you can select which reports, budgets, graphics you
want, and in which units they will be displayed.
Once we have chosen
the reports we want to see or print by checking on the matching box, you have
to click on one of the two buttons this window shows: view at the screen or print
it (depending on the choice you have done in
prior step), and export to Excel file
.
Usually, tables
displaying data in every tab of the main form are not big enough to see all their
rows or columns, therefore not having all information at only one view. To somewhat
sort this out, you can double-click on any table and it will be rendered in
full screen.
In some cases: Fixed
Assets, Financial and Stockholders’ Equity, you will see more information in this
mode than when not using full screen. This data, though used by the application
to make up the reports, is made not visible by the program to try to summarize the
most significant values in tab table smaller area.
For instance, if you
double-click in “Fixed Assets” tab table, you will see something like this
image hereunder:
And a clearer detail
of it would be:
Here you can see
that, below the row of every fixed asset, there is another with the related
accumulated depreciation.