RIV20 User Manual for RuralInvest
RIV20 User Manual for RuralInvest
©FAO/Fermin Dibarboure
2023
©FAO/Fermin Dibarboure
Table of content
1. Introduction 2
a. Useful links 3
b. Create an account 4
c. Home page 8
d. How to create a configuration 10
e. List 16
2. Create a new business concept 22
c. Overview 24
d. General information section 26
e. Justification & analysis 28
f. Personal notes 29
g. Entrepreneurs and beneficiaries 30
h. Qualitative assessment 31
i. Investment costs 32
j. General and fixed costs 36
k. Activity blocks 37
l. Summary and reports 46
Table of content
3. Convert a Business Concept into a Business Plan 49
m. New information required 51
n. General information 52
o. Entrepreneurs and beneficiaries 53
p. Investment costs 55
q. General and fixed costs 58
r. Activity blocks 63
s. Contributions 70
t. Summary and reports 79
4. Sensitivity analysis 86
5. Incremental analysis 89
6. Collaboration features 95
Useful links
RuralInvest website
[Link]/in-action/ruralinvest
An introduction to RuralInvest
[Link]/course/[Link]?id=754
4
Create an account
5
Create an account
Once you have installed the RuralInvest software, you must first create an account.
7
Create an account
Once you click the link to verify your account, you will be directed to the web app and see a confirmation
message. You can enter your credential and go back to the desktop app.
10
Configuration
Creating a configuration
The first thing you must do in order to create a new business concept/plan is to create a configuration.
1
Click on the configuration button and
click on ‘New’.
11
Configuration
Creating a configuration
The configuration allows you to have business concept/plans with the same parameters. This
”centralized” configuration ensures easier comparison between projects within a context: with the same
currency, the same exchange rate, the same qualitative sections, and especially the same discount rate.
12
Configuration
Discount rate
The discount rate refers to the interest rate used in discounted cash flow analysis to determine the
present value of future cash flows. The discount rate expresses the time value of money. It is the
interest rate used to determine the present worth of a future value by discounting.
To compare two business plans, it is important to use the same discount rate.
As guiding principle, discount rates should represent the opportunity cost of capital
for the agent (producer or government). For the producer, a realistic alternative is an
average of the passive deposit rate of local commercial financing agencies. The
government should instead consider the interest rate at which the country can borrow
capital from a relevant international capital market; alternatively, the return on long-
term public treasury bonds is also a suitable option.
The discount rate is the minimum rate of return to be made in order to make a profit,
this profit is the NPV.
13
Configuration
Customize the Qualitative Analysis
The qualitative information is a very important element of a business concept/plan. It allows the person
to analyse the business concept/plan and better understand the environment, the market opportunities,
the constraints, etc. Hence, you should give as much detail as possible about the project: the target
market for the products/services, the organisation of the business, the potential social and
environmental impacts and the risks.
You can customize the sub-steps and categories according to your needs and those of the institutions
who will receive the business plan.
14
Configuration
Customize Categories and Fields
You can also modify the Custom Categories and Fields. These categories appear in the first section of
the business plan/ business concept. This allows the plan to be classified according to these categories.
16
List
In the List, you can visualize all your projects, organizing them by folders.
17
List
List overview
Within the List section, you can create and import projects and visualize them as “personal projects” or
”collaboration projects” (see the section on “Collaboration” in page 95). Finally, you can also make a
backup saving your business plans all together.
Customize the
information you
want to see in the
columns of the list
You will of projects.
visualize your
projects here,
organized by
folders.
18
List
Manage your plans
You can download one project as well as move it between folders, delete it, duplicate it, download the
final report in excel or in PDF.
Select the
project.
19
List
Create new folder
You can create different folders to organize your projects.
20
List
Organize projects
To move a project between folders, select the project and the “edit buttons” will appear on the right.
1
Select the
project you 2
want to
move.
21
Create a new project
New busines concept
You can create a new business plan or business concept either from the List or from the ‘Home’ screen
by clicking ‘New’.
Choose if you want to create
a ‘Personal project’ (offline)
or a ‘Collaboration’ project
(in the cloud).
Choose the folder in which your
project will be saved within the
software. By default, your project
Precise here "Business is saved in the “Default folder”.
Concept" or "Business Plan”.
Select the configuration from your
list of configurations before you
Select whether you want to perform an can click the "Create" button.
incremental OR non-incremental
analysis -we will continue this guide
with the non-incremental analysis. You
will learn about the incremental analysis
further in the document-.
22
Create a new project
Business concept or business plan
Before making a detailed analysis of your project over several years (by selecting "Business Plan"),
RuralInvest recommends you make a simplified analysis on the cruising year (by selecting "Business
concept").
23
Business concept
Overview
In the ‘Overview’ you will see the different sections of a project. In the case of a Business Concept, you
have eight sections. You can navigate through the sections just by clicking on them.
24
Business concept
Overview
From the ‘Overview’ you can also convert your business concept into a business plan (see page 49) and
transform a personal project into a collaboration project to access to it online from any computer or to
collaborate with colleagues (see the section on “Collaboration” in page 95).
25
Business concept
General information section
In the general information section, you can change the name of the project if you want to and insert the
start-up month for the calendar, the environmental and the project category (that you previously
completed in the configuration) as well as additional information related to the location and status.
27
Business concept
Justification & Analysis
In every section of your project, you will have, at the right-side, access to the Justification & Analysis.
It is often the place where the technician or the reviewer can write an additional analysis or justify the
financing or the rejection of the project. When you print the report, you can choose whether to add this
section or not.
28
Business concept
Personal notes
In every section of your project, you will also have access to your personal notes. These notes may serve
as personal reminders or annotations for each section and will not be shared. Only you can see them.
29
Business concept
Entrepreneurs and beneficiaries
In this section you will enter all the information collected about the entrepreneurs and the beneficiaries.
30
Business concept
Qualitative assessment
The qualitative assessment is accompanied by subsections to better organize the information. As
mentioned previously, you can customize this section by adding/editing/deleting sub-steps and help
texts in the configuration (see page 14).
31
Business concept
Investment costs
The investment costs are divided in three categories: Goods, Labour and Professional Services
32
Business concept
Investment costs
When inserting ‘Goods’ you need to have the following information:
Remember to indicate whether
the good is new or not.
• Unit type, Quantity and Unit cost
• Amount covered by own resources
or external resources
• Economic life: how long the Good
is expected to last until it is
replaced
• Salvage: estimated price at which
the Good could be sold at the end of
its economic life
• Annual Maintenance: that will
appear in the General and fixed
costs
33
Business concept
Investment costs: adding an already existing good
If the Good that you are entering is an already existing good, you should be aware of the different fields
to complete.
34
Business concept
Investment costs: adding a labour cost
When adding a ‘Labour cost’ within the investment costs section, you can link it to a specific asset. This
means that when the asset will be replaced, the linked labour cost will automatically be considered.
35
Business concept
General and fixed costs
Follow a similar procedure with overhead and fixed costs: expenses of the business concept in a full
production year but which do not depend on the production volume of the enterprise.
36
Business concept
Activity blocks
To calculate all the costs that depend on the production and the revenues of the business, you will have
to create the necessary Activity Blocks.
37
Business concept
Activity blocks
Once you click to create a new block, you will have to enter the name, the chosen reference unit, the
number of reference units per cycle and then you will design the cycle in the calendar.
1
Choose the reference unit: the Like in the
best unit for calculating previous
production costs/revenues sections, you
during a cycle. can click here
to move within
2 the sections of
Choose the number of
reference unit per cycle: to a block. In the
reflect the whole activity, we second stage
can have a certain number of Here you can you will insert
reference units per cycle. add a revenues and
description of costs.
3 the block.
Fill in the corresponding boxes
to design your production
cycle.
38
Business concept
Activity blocks
By clicking on each ‘half-month’ of the calendar, the rectangles will become yellow. You will choose the
starting and ending month for the production i.e., months when the production costs will be applied.
Additionally, you will mark the months when transport costs will be applied for the sales (2nd row) as well
as the months when the payment is received (3rd row).
1 2
In the first row In the second
you establish row you will
the months select the
when the months when
production transport cost
costs will be will be applied
applied. for the sales.
3
In the third row you will
select the months when
the payment is received.
39
Business concept
Activity blocks
As a business concept is an annual analysis, if your cycle is longer than 12 months it cannot be created
and will have to be reduced to one year. When developing a detailed business plan, it will be possible to
have a longer cycle. However, if your cycle repeats itself within the year, you can easily duplicate it.
40
Business concept
Activity blocks
After designing the cycle, you will have to enter all the information related to ‘Revenues’, ’Input costs’ and
‘Labour costs’ always per reference unit per cycle.
41
Business concept
Activity blocks : Revenues
For the Revenues, the business can sell products or services. You must select a unit of sale for each
product according to the information provided by the entrepreneur and taking into account which
market prices are available.
2
Insert the quantity
produced of the
selected unit per 1
reference unit and Specify the ‘Sales
per cycle of unit’. This is the unit
production. in which a product or
service will be sold
3 (e.g.: kg, piece of
Insert the price for fruit, person-day of
the unit of sale work).
selected.
4
You can also insert
transport costs per unit of
sale associated to the
product/service to be sold. 42
Business concept
Activity blocks: Input costs
For the Input Costs, you must select the unit of measurement used to measure the asset. This may vary
according to the information available, but remember to insert the quantity of that unit per reference
unit and per cycle of production.
2
Insert the quantity
used of the selected 1
unit per reference Specify here the
unit and per cycle of ‘Unit Type’. The
production. unit of
measurement for
3 that cost.
Insert the cost
per unit.
4
You can also insert
transport costs per unit
type associated to the cost.
43
Business concept
Activity blocks : Labour costs
For the Labour Costs, you must also select the unit of measurement used to measure the asset.
However, in this case, the software will give you four options to choose from: person-day, person-week,
person-month, person-year.
2
Insert the quantity
used of the selected 1
unit per reference Click ‘Unit type’
unit and per cycle of to display the
production. drop down
menu and
choose your
preferred
option.
3
Insert the cost
per unit.
44
Business concept
Activity blocks
Finally, you will visualize the blocks in the block overview. Here you can see the months when an activity
takes place and the months when there is no production costs nor revenues. Also, you will see when you
have overlap of different productions.
Number of reference
units per cycle
45
Business concept
Summary and Reports
In the last section, you will first see a summary of the project with the main indicators of the business
concept.
46
Business concept
Summary and Reports
And then you will be able to generate a report in Excel and PDF formats.
47
Business concept
Summary and Reports: detailed and customized reports
48
Convert a Business Concept into a
Business Plan
49
Convert to Business Plan
Conversion allows to move from an “annual“ analysis to a “pluri-annual” analysis – without starting
from scratch.
50
Business Plan
New information required
Once you convert your business concept to business plan, you will see the sections you might need to
review highlighted with yellow and a whole new section, ‘Contributions’ in green. Within each section,
the new fields of information you might need to complete will also be highlighted.
51
Business Plan
General information
Firstly, in the ‘General information’ section you will find the possibility of choosing the duration of the
analysis for the business plan.
52
Business Plan
Entrepreneurs & Beneficiaries
In the ‘Entrepreneurs and Beneficiaries’ section you will have to provide further information about the
development partner (bringing the grant) and Indirect beneficiaries.
53
Business Plan
Entrepreneurs & Beneficiaries
When inserting a development partner you will see a drop down menu to choose the type of partner
54
Business Plan
Investment costs
Within the ‘Investment costs’ section, there are more funding sources for the investment: own
resources in kind, in cash, grant and loan.
55
Business Plan
Investment costs
When adding a new Investment Good, you can breakdown the total cost between (i) internal funding:
Own Resources in Kind or in Cash; or (ii) external funding: Grant Amount or Loan Amount.
57
Business Plan
General & Fixed Costs per year
Within the ‘General and Fixed Costs section’, you have 2 modes: (i) simplified: the general costs entered
will be applied for all the year of the analysis equally; and, (ii) per year: which gives the option to modify
the costs between the different years, for example, if the business expects to grow over the years and
therefore needs to recruit more employees.
58
Business Plan
General & Fixed Costs per year
When you create a new cost or open an already entered cost, you will be able to specify the quantity and
value per year.
1
Select the years you wish to apply
specific costs to. In this case, the ‘Unit
cost’ and the ‘Quantity per Year’
selected will be applied to the selected
year 1, 2 and 3 (in stripes).
2
Then, add the ‘Unit Cost’
and the ‘Quantity per year’
(for the selected years)
60
Business Plan
General & Fixed Costs simplified
If, on the other hand, the general and fixed costs remain the same for all the years of the analysis, then
you can remain in "Simplified" mode. Note that if you were in "Per Year" mode and you switch to
"Simplified" mode, by default the general and fixed costs of year 1 will be applied to all years.
61
Business Plan
Overview of the project
As you review each section, the yellow highlight will disappear so you will see only the unreviewed
sections.
62
Business Plan
Activity blocks
As a business plan is a multi-year analysis, you will now see that the blocks span several years. The
information filled in the cycle designer will allow the software to calculate a very precise monthly
operational cash flow.
63
Business Plan
Activity blocks
As a business plan is a multi-year analysis, you can also create cycles over several years and set the
interval between two cycles.
65
Business Plan
Activity blocks
By default, all revenues and costs will be equally distributed among the previously selected months in
the cycle. However, you can specify whether there are any specific revenues or costs that occur at any
specific time during the selected half months.
1
Deactivate the toggle
Once you select the
and the timeline will 2 specific month(s) you
be revealed. You will
will see them in solid.
see the steps of the
calendar painted with
stripes. This means
there are no steps
The same thing
selected. Click the
could be done for
steps in which this
the inputs and
specific revenue will
labour costs.
take place.
66
Business Plan
Activity blocks
The blocks you designed in the business concept were based on the year in full production. However,
after the conversion into a business plan, in a multi-year analysis your number of reference units per
cycle may not be the same from year to year.
67
Business Plan
Activity blocks
In the Production Pattern, you can modify the number of reference units per cycle for all production
cycles. This is particularly useful if production increases over the years until it reaches full capacity.
68
Business Plan
Activity blocks
You can model the growth of the activity by simply changing the number of reference unit per cycle.
69
Business Plan
Contributions: Long term loan
In Contributions, you will first see a summary of the investment costs: everything that is not covered by
own resources or grants will have to be covered by a long-term loan.
70
Business Plan
Contributions : Long term loan
You will also be able to insert the information of up to two long term loans.
71
Business Plan
Contributions: Primary loan
Check below how to model the primary loan to cover the investment costs.
73
Business Plan
Contributions
You can choose one of three options for the loan amortization. The Straight-Line and the Mortgage Style
Amortization, both explained below, and the Linear style which divides both interest and principal
equally between each payment period.
75
Business Plan
Contributions: Working capital
The ‘Amount financed’ is
The ‘Annual interest rate’ and the amount remaining
‘Method of amortization’ is that needs to be financed
information that will come by a credit
from the financial
institutions. The ‘Start month’ will be the first
negative month, in this case, the
second one. The loan duration is
It is not reasonable nor
calculated from the duration
recommended to start
between first and last negative
repaying the capital/interest
month. It is recommended
while the situation of the
though to add 2 months in case
business is still fragile. It is
something happens differently
advisable to leave enough
than expected.
grace period.
76
Business Plan
Contributions: Working capital
If the Cash Flow after the loan is still negative, the software will display an error message, you can not
continue.
77
Business Plan
Contributions: Credit line
The other possibility to finance the working capital requirement is through a Credit line, which represents
a credit of the exact amount needed for each negative month. You have to enter the ‘Credit Limit’ which
is the maximum outstanding amount that can occur in any month. This value is usually set by the financial
institution providing the credit line.
78
Business Plan
Summary and Reports
Normally, national financing agencies will be more interested in the cash flow meanwhile within the
development context it is useful to assess the financial profitability of a business, considering self-
consumption and own resources in kind.
79
Business Plan
Summary and Reports
The Yearly Cash Flow table, as its name indicates, gives an overview of all the inflows and outflows in
cash for all the years of the analysis: Investment outflows, Operation and Financial inflows and
Recurrent and Financial outflows.
81
Business Plan
Summary and Reports
The Financial Profitability table gives an overview of all the revenues and costs of the business
considering the self-consumption and own resources in kind.
82
Business Plan
Profitability indicators
Money loses its value over time. Therefore, with the Net Present Value, you can visualize the future cash
balance expressed in the monetary value of today. Meanwhile, the Internal Rate of Return is the annual
rate of growth an investment is expected to generate.
83
Business Plan
Summary and Reports
As it was the case with the business concept, when generating a report of a business plan, you can
generate a Basic Report, a Detailed Report and a Customized Report in both Excel and PDF formats.
As with the
business concept,
here you can
choose the type
of report between
basic, detailed or
In the business plan
customized.
report you can also add
the Income Statement
Here you Indicators for which you
choose between will be asked to
Excel and PDF. choose the Income Tax
Rate to apply.
84
Business Plan
Summary and Reports
With the Detailed Report you can print a complete report including all the possible fields and tables
whereas with the Customized Report you can select those sections you are interested in having within
the report.
85
Sensitivity analysis
86
Sensitivity Analysis
Business concept
In the sensitivity analysis of a business concept, you can see what would happen to the Net Annual
Income and the number of Years to Recover the Investment in the best and worst situations. As we are
working on a Business Concept, you will visualize the analysis for one year in full production.
1
You must select in the 2
You can modify the selected
table the variable(s) variables to visualize the different
you want to vary, situations: the best case (green) and
either in the revenue the worst case (orange).
(quantity produced,
price) or in the costs
(quantity purchased,
unit cost etc.). The
value entered in the
business plan/concept
will appear in grey as:
‘Base’.
3
At the right, you will see the impact of each
Visit the RuralInvest website variable in the financial indicators of the business
to see our animated tutorial plan for both situations. Below, you will see the
about the Sensitivity Analysis: impact of each variable combined in the financial
[Link]/in-action/ruralinvest indicators for each situation.
87
Sensitivity analysis
Business plan
Within a business plan, you will visualize the impact of the the best and worst case situations over the
years. This is also shown in a graph.
88
Activate the incremental analysis
89
Incremental analysis
With-project vs without project scenarios
RuralInvest is a tool to assess new investment and new activities within a business, therefore you can
distinguish between two different scenarios. The comparison will help to visualize the impact of the
investment/activities.
90
Incremental analysis
How to activate the incremental analysis
You can create the project with the incremental analysis since the beginning, but you can also activate it
within the ‘General information’ section, once you have already started to work on the business concept
or plan.
All the information you had inserted until the moment, will automatically be on the ‘With Project’ tab. You
will have to complete the without project tab to be able to compare both scenarios.
92
Incremental analysis
Copying cost from one scenario to the other
You can copy and paste information from one scenario to the other within all three quantitative
information sections. 2
Click the orange button that will
appear at the top right corner:
‘Copy to other scenario’.
1
Select the item
you want to
transfer to the Within the Activity Block
other scenario. section, you must click on
the three dots of the block.
3
Finally, it will
automatically appear
in the other scenario
93
Incremental analysis
Profitability indicators
With the incremental analysis activated and all the information completed, you will find in the ‘Summary
and Reports’ section the profitability indicators for each of the scenarios.
94
Collaboration in RIV20
95
Collaboration
It is now easy to collaborate and share business plans with colleagues with the collaboration features.
Instead of downloading a business plan and emailing it, which can cause different versions of the same
business plan; all you have to do is transfer it to Collaborative Projects and share it with collaborators in
order to work on the same business plan.
Business plan in
collaboration
96
Collaboration features
Business plan list
Within your List of projects, you can click the tabs to change between Personal projects and
Collaboration projects.
98
Collaboration features
Configuration
Click the Collaboration tab to see your collaborative configurations, you will be able to share these.
To share a
configuration, first
you must select it.
That will activate
the blue buttons
on the right.
You can send your configuration back to
‘Personal Configurations’. You can also
delete or duplicate a configuration. And you
can share via email or link.
99
Collaboration features
Configuration
Click the ’Share’ button and you can choose either to ’Invite via Email’ or to ‘Invite via URL’.
1
Type the email of your
colleague(s) and select the
privileges you want to assign
them: (i) Edit: all fields can be
modified; (ii) See/comment: 2
nothing can be changed, only The software will notify your
commented. colleague via email and will
automatically show the
configuration in their list of
configuration in
collaboration.
3
You will see the list of people to whom
you shared this file with. You will also see
if they already have an account or not. 100
Collaboration features
Configuration
Click the ’Share’ button and you can choose either to ’Invite via Email’ or to ‘Invite via URL’.
1
Select the privileges
you want to assign to
anyone who receives
the link.
2
The link will appear once you select the
privileges. Then just copy and share the
URL. Note that when using this option,
your colleague will have to access RIV20
via browser. Once clicked,, the
configuration will appear in the list of
configuration in collaboration.
101
Collaboration features
Access RIV20 via browser
If you need to access RIV20 and you don’t have your computer, you can do it via browser on the internet
(preferably Google Chrome). Go to [Link] and log in with your credentials. If you
go to your List, you will see those in collaboration and the ones shared with you.
3
When someone
shares a project with
you, you will receive
an email with a link to
4
As in the software, you will see
access the plan via
1 your collaboration projects
browser.
Log in with your credentials and those shared with you, as
in RIV20 website. well as the privileges you were
assigned.
2
You will see your profile
from the browser.
102
Collaboration features
Transfer to Collaboration project
From the ‘Overview’ click ‘Transfer to Collaboration project’ to transform a personal project into a
collaboration project to access to it online from any computer or to collaborate with colleagues.
103
Collaboration features
Transfer to Collaboration project
Once you transfer your project to Collaboration, you will still see it in both tabs: under the ‘Personal’ tab
in the List, and a copy will be created in the ‘Collaboration’ tab. In the collaborative project, you will see
new features, only available in this type of projects.
You can also transfer a Personal project to Collaboration Project directly via the list.
105
Collaboration features
Invite collaborator
To invite via Email, type the email address of the person you want to invite and select the privileges.
With ‘Edit’ privileges, the person invited can modify and work on the project, this means that if the
person makes changes, it will directly affect the project and you cannot go back. However, if you want
the person only to review and leave comments, you can choose ‘View / Comment’. This way, only you
can modify the project.
106
Collaboration features
Invite collaborator
To invite via URL, just select the privileges and click ‘Copy URL’, then share the link with your colleagues.
With ‘Edit’ privileges, the person invited can modify and work on the project, however, if you want the
person only to review and leave comments, you can choose ‘View / Comment’.
107
Collaboration features
Comments
Besides Justification & Analysis and personal Notes which are still available, you can leave comments in
each section for easier collaboration with your colleagues.
108
Collaboration features
Activity tracker
Be aware of the last changes made to each section.
©FAO/Paballo Thekiso
©FAO/Paballo Thekiso
SUPPORT
Please contact us if you need extra support: CFI-ruralinvest@[Link]
2023