| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||
2 | Process details for Hypha Worker Co-operative Prop #839 | Quarterly Financial Report | ||||||||||||||
3 | ||||||||||||||||
4 | Reported by the Hub team of Hypha Worker Co-operative Inc. to the Cosmos Hub DAO | |||||||||||||||
5 | ||||||||||||||||
6 | Available fee cap for 2024 | Exchange rates for period ending June 30 2024 | ||||||||||||||
7 | Denomination | Annual | Quarterly | Monthly | 1 ATOM = | $6.65 | USD | CoinGecko | ||||||||
8 | USD | $1,200,000 | $300,000 | $100,000 | 1 USDC = | $1.00 | USD | |||||||||
9 | USDC | 840000 | 210000 | 70000 | 1 USD = | $1.37 | CAD | |||||||||
10 | ATOM | 38019 | 9505 | 3168 | USD to CAD exchange rate from Bank of Canada | |||||||||||
11 | ||||||||||||||||
12 | Hypha wallets | Q2 burn rate report | ||||||||||||||
13 | Budget wallet (vesting): | cosmos13gatuxfqxn7m3vtlydkyznfs9k8xv8283la5a5 | Role | Apr | May | Jun | Q2 average | |||||||||
14 | Available fee cap wallet: | cosmos1ax7krw2ymq8upaxwce7df3xpalpp0jddm29fws | Program lead FTE | 1.00 | 1.00 | 1.00 | 1.00 | |||||||||
15 | Payroll wallet: | cosmos1d4t7vv9500sma5sea7668pea93dyke8kpvdhyw | Senior eng FTE | 0.90 | 0.90 | 0.60 | 0.80 | |||||||||
16 | Bonus wallet (vesting): | cosmos1s39x73k7l0s88jkm399nkdk693ljmkjd2x83es | Dev ops eng FTE | 0.60 | 0.60 | 0.60 | 0.60 | |||||||||
17 | Intermediate eng FTE | 0.80 | 0.80 | 0.80 | 0.80 | |||||||||||
18 | 325k USD is a single FTE billable rate for the year. | Technical advisor FTE | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||||
19 | At $1.2M, that means Hypha’s fee cap allows us to have a maximum of 3.7 FTE. | Total FTE | 3.30 | 3.30 | 3.00 | 3.20 | ||||||||||
20 | FTE assumes that the person works 2080 hours per year, or 520 hours per quarter. | Percentage of fee cap used | 89.19% | 89.19% | 81.08% | 86.49% | ||||||||||
21 | USDC earned | 62432.43 | 62432.43 | 56756.76 | 181,621.62 | |||||||||||
22 | Percentage of fee cap used = total FTE / max FTE | ATOM earned | 2825.75 | 2825.75 | 2568.86 | 8,220.36 | ||||||||||
23 | USDC earned = percentage of fee cap used * USDC fee cap | |||||||||||||||
24 | ATOM earned = percentage of fee cap used * ATOM fee cap | |||||||||||||||
25 | Cash Flow Management Report | |||||||||||||||
26 | Period: April to June 2024 | |||||||||||||||
27 | ||||||||||||||||
28 | ATOM | USDC | Total in USD | Total in CAD | ||||||||||||
29 | Hub-disbursed funds | |||||||||||||||
30 | Budget Wallet Opening Balance | 28,417.86 | 627,845.35 | $ 816,851.02 | $ 1,117,751.71 | |||||||||||
31 | Bonus Wallet Opening Balance | 21,000.00 | 0.00 | $ 139,650.00 | $ 191,092.41 | |||||||||||
32 | Total Hub-disbursed funds | 49,417.86 | 627,845.35 | $ 956,501.02 | $ 1,308,844.12 | |||||||||||
33 | ||||||||||||||||
34 | Transfers b/w Budget & AFC Wallet | |||||||||||||||
35 | April Released Amounts | 3,017.03 | 66,658.66 | $ 86,724.77 | $ 118,671.28 | |||||||||||
36 | May Released Amounts | 4,681.60 | 103,435.86 | $ 134,572.92 | $ 184,145.10 | |||||||||||
37 | June Released Amounts | 1,872.64 | 41,374.34 | $ 53,829.16 | $ 73,658.03 | |||||||||||
38 | $ - | $ - | ||||||||||||||
39 | Total of Released Vested Amounts | 9,571.27 | 211,468.86 | $ 275,126.86 | $ 376,474.42 | |||||||||||
40 | ||||||||||||||||
41 | List of all Outflow from AFC Wallet | |||||||||||||||
42 | 1) Invoiced by Hypha | |||||||||||||||
43 | April Invoice | 2,825.75 | 62,432.43 | $ 81,226.34 | $ 111,147.41 | |||||||||||
44 | May Invoice | 2,825.75 | 62,432.43 | $ 81,226.34 | $ 111,147.41 | |||||||||||
45 | June Invoice | 2,568.86 | 56,756.76 | $ 73,842.13 | $ 101,043.10 | |||||||||||
46 | $ - | $ - | ||||||||||||||
47 | 2) Returned to community | 1,350.91 | 29,847.24 | $ 38,832.05 | $ 53,136.48 | |||||||||||
48 | Total Outflows from AFC Wallet | 9,571.27 | 211,468.86 | $ 275,126.86 | $ 376,474.42 | |||||||||||
49 | ||||||||||||||||
50 | AFC Wallet Closing Balance | 0.00 | 0.00 | $ - | $ - | |||||||||||
51 | Budget Wallet Closing Balance | 18,846.59 | 416,376.50 | $ 541,724.17 | $ 741,277.30 | |||||||||||
52 | Bonus Wallet Closing Balance | 21,000.00 | 0.00 | $ 139,650.00 | $ 191,092.41 | |||||||||||
53 | Total Closing Balance | 39,846.59 | 416,376.50 | $ 681,374.17 | $ 932,369.70 | |||||||||||
54 | ||||||||||||||||
55 | ||||||||||||||||