Investment financial sustainability and maximum cash exposure calculator
Edit the blue fields: every amount is recalculated instantly. All values in euro.
Total investment
—
Public grant
—
Private share
—
Cash exposure A+B+C
—
Share of investment
—
Investment breakdown
Item
VAT rate
Net amount
Building works
%
€
Orchard / tree planting
%
€
Machinery and equipment
%
€
General expenses
%
€
Total investment (net of VAT)
Investment including VAT
Grant and premiums
Grant rate
%
Public grant
Private share of investment
Bank Sustainability Statement / Loan Resolution
%
Additional premiums, if anye.g. Young Farmers package and/or innovative start-ups
€
Payment claims you intend to submit
Invoiced volume for 1st interim claimmin · max of the investment
%
Invoiced volume for 2nd interim claimmax of the investment
%
Average VAT rate on interim claims
%
Bank guarantee cost (estimate)annual rate × duration
%years
Cash flow
A
Advance and first private contributionup to the 1st interim claim
Advance secured by bank guarantee
Premium advance, if any (50%)
Bank guarantee cost (estimate)
Invoicing required for 1st interim claimVAT included
First private contribution1st claim invoicing − advance
A · Exposure up to the 1st interim claim
Grant payable at 1st interim claimnet of VAT
B
Second private contributionup to the 2nd interim claim
Invoicing required for 2nd interim claimVAT included
B · Second private contribution2nd claim invoicing − grant from 1st claim
Grant payable at 2nd interim claimnet of VAT
C
Final private contributioncompletion of works and final claim
Total expenditure before the final claim
C · Remaining expenditure before the final claiminvestment incl. VAT − interim-claim expenditure
Grant payable at final claim
Premium payable at final claim
Totals
Overall cash exposure (A + B + C)
Share of investment
Total gross cash outflows"TOTALS" cell of the original spreadsheet
ABC
Green figures are public disbursements; red figures are cash outflows borne by the company. Indicative estimates: advance, interim and final claim rules follow the relevant call for applications.
Request the calculation as a PDF (A4)
The PDF carries the Studio's letterhead and the full calculation with the values currently entered. To download or receive it, fill in your name and email and give your consent.
Requests received (Studio only)
For each request you can regenerate the PDF with the requester's data, email them and mark it as sent.
No requests.
Studio S.T. Morelli s.r.l.s. · C.so Umberto I, 58 · 72017 Ostuni (BR) · Tel. +39 0831303039