Asha_Austin_financial_planning_worksheet.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEF
1
YEAR
Time Stamp
ItemAmountActuals
2
2014beginWorking Capital (Jan)72644
3
Disbursal - One Time0
4
Disbursal - Project Related0
5
Fundraising0
6
endEnd of Year Balance72644
7
2015beginGF split (Jan)30,769
8
LinkWorking Capital (Jan)103,413
9
LinkDisbursal - One Time28817
10
LinkDisbursal - Project Related27468
11
Fundraising14390
12
endEnd of Year Balance61,517
13
2016begin
WCR (Jan) - based on 2015 only
1.09
14
GF Split (Jan)39,215
15
Working Capital (Jan)100,732
16
Disbursal - One Time2692
17
Disbursal - Project Related36064
18
Fundraising3124
19
endEnd of Year Balance65,100
20
2017begin
WCR (Jan) - based on 2 yr avg
1.37
21
GF Split (Jan)15925
22
Working Capital (Jan)81,025
23
Disbursal - One Time4079
24
Disbursal - Project Related59225Mathru back to 12k budget, Mathru for WAH
25
Fundraising10000SoH 2017: 10k
26
endEnd of Year Balance27,722
27
2018begin
WCR (Jan) - based on 2 yr avg
0.54
28
GF Split (Jan)59565GF split will be top-off + Proportional split
29
Working Capital (Jan)87,287
30
Disbursal - One Time9546GSK shortfall: 8k; One-time Mathru at 1.8k
31
Disbursal - Project Related51356Includes WAH for Mathru: 2.5k60902
32
Fundraising41503Official from AWT
33
endEnd of Year Balance67,888
34
2019begin
WCR (Jan) - based on 2 yr avg
1.09WCR - 0.99 with 59k, 1.35 with 46k
35
GF Split (Jan)27956Official from AWT, Local FR for 2018 at 41k25267
36
Working Capital (Jan)95,844Operating budget at ~60k/ year93154
37
Operating Budget (2 year avg)62103
38
Disbursal - One Time5088Jan-Mar 2019 for Mathru, SAC for GSK/KWS
39
Disbursal - Project Related58851Need to disburse 60k
40
Fundraising35000SoH 2018: 10k, SoH 2019: 20k, SAC: 5k
41
endEnd of Year Balance66,904
42
2020begin
WCR (Jan) - based on 2 yr avg
1.07WCR at 1 is good for GF split
43
GF Split (Jan)26,727Local FR: 35k
44
Working Capital (Jan)93,631
45
Disbursal - One Time0
46
Disbursal - Project Related63572
47
Fundraising35000SAC: 5k, SoH 2019: 20k, SoH 2020: 10k
48
endEnd of Year Balance65,059
49
2021begin
WCR (Jan) - based on 2 yr avg
1.02
50
GF Split (Jan)30,575Local FR: 35k
51
Working Capital (Jan)95,634
52
Disbursal - One Time10000
53
Disbursal - Project Related58524
54
Fundraising35000SAC: 5k, SoH 2020: 20k, SoH 2021: 10k
55
endEnd of Year Balance62,110
56
2022begin
WCR (Jan) - based on 2 yr avg
0.94
57
GF Split (Jan)36,962Local FR: 30k
58
Working Capital (Jan)99,072
59
Disbursal - One Time40000
60
Disbursal - Project Related36691
61
Fundraising35000SAC: 5k, SoH 2021: 20k, SoH 2022: 10k
62
endEnd of Year Balance57,381
63
2023begin
WCR (Jan) - based on 2 yr avg
0.79
64
GF Split (Jan)51,530Local FR: 35k
65
Working Capital (Jan)108,911
66
Disbursal - One Time25000
67
Disbursal - Project Related9075
68
Fundraising35000SAC: 5k, SoH 2022: 20k, SoH 2023: 10k
69
endEnd of Year Balance109,836
70
71
72
73
74
Loading...