ABCDEFGHIJKLMNOPQSTUVWXYZ
1
2
Introduction & Configuration
V11.4
3
4
Support0. General Configuration
5
Start by entering the general information of the report, product, and other key variables
6
Language / idioma / langueEnglish
7
8
Organization:Café para todos
9
Country:Perú
10
Responsible PartyHubert Peri
11
MenuReport Cut-off Date26-Mar-25
12
13
➡ Home1. Products
14
15
➡ PurchasesMain ProductCoffee
16
Primary SpeciesArabica
17
➡ SalesSecondary SpeciesNone
18
Sales Unit of MeasureQQ
19
➡ FinancingEstimated sales volume (domestic and export) 400,000
20
Purchases Unit of MeasureQQ 45.36 KG equivalent?
21
➡ Commercial Analysis
22
Maximum Exposure Limit (Short)10%
23
➡ Position AnalysisMaximum Exposure Limit (Long)10%
24
Do you use Financial Hedging?Yes
25
➡ Financial Analysis
26
2. Date Configuration
27
28
Starting Harvest Calendar Year2024
29
30
First Month of ContractingAugust-24
31
First Month of Coffee CollectionOctober-24
32
First Month of ShippingNovember-24
33
34
3. Projections
35
36
MonthCollection (%)Collection QQSales (%)Sales QQ
37
October-240% -
38
November-244% 16,000
39
December-2443% 172,000 0% -
40
January-2537% 148,000 24% 96,000
41
February-2515% 60,000 23% 92,000
42
March-251% 4,000 23% 92,000
43
April-25 15% 60,000
44
May-25 6% 24,000
45
June-25 4% 16,000
46
July-25 2% 8,000
47
August-25 2% 8,000
48
September-25 1% 4,000
49
Total100%100%
50
51
52
4. Market Data
53
54
Arabica
55
Daily Purchase Price (USD/QQ): $ 185.12
56
NY Coffee Exchange Price (USD/LB): $ 3.50
57
Today’s Date28-Oct-25
58
59
5. Conversions
⚠ This section does not need to be filled out.
60
61
Equivalence: 1 QQ to KG46
62
Equivalence: 1 QQ to LB100
63
Equivalence: 1 KG to LB2.20462
64
Equivalence: 1 KG to MT1000
65
66
NYC Contract Size (QQ)375
67
NYC Contract Size (KG) 17,000
68
NYC Contract Size (LB) 37,500
69
70
6. Financial Expense Projection
📊 Enter the harvest expense projection to estimate the income statement.
71
72
Monthly Fixed Costs (USD): $ 92,520
73
Variable Costs(USD/QQ): $ 59.00
74
Annual Financial Costs (USD): $ 1,921,424
75
76
Starting Cash Balance (USD): $ 2,000,000
77
Opening Equity at the Beginning of the Period
 $ 200,000
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100