[https://docs.google.com/spreadsheets/d/1\_9J1v-7NRuYSMMuVXEyB8R7zTJCoJK4J/edit?usp=sharing&ouid=114907155294514129066&rtpof=true&sd=true](https://docs.google.com/spreadsheets/d/1_9J1v-7NRuYSMMuVXEyB8R7zTJCoJK4J/edit?usp=sharing&ouid=114907155294514129066&rtpof=true&sd=true)
The tool is extremely simple, you input: Total shares, cash and equivalents, gross debt. Then the production forecast, price of gold, their average AISC and current multiple (Adjust the currency conversion if needed).
The sheet then builds a few cascade tables based of those numbers and haircut derivatives, and the projections those scenarios create.
Then at the bottom you get a "summary" displaying average and median for the total, 50% and 25% (top and bottom) similar to this but color coded and better formated:
|**Scenario**|**EBITDA NET CapEx CAD**|**8**|**8.5**|**9**|**9.5**|**10**|**10.5**|**11**|**11.5**|**12**|
|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|:-|
|**Lower 25 % Average**|**$1,281.00**|**$26.08**|**$27.61**|**$29.13**|**$30.66**|**$32.19**|**$33.72**|**$35.25**|**$36.78**|**$38.31**|
|**Lower 25 % Median**|**$1,328.00**|**$26.96**|**$28.54**|**$30.13**|**$31.71**|**$33.30**|**$34.88**|**$36.46**|**$38.05**|**$39.63**|
|**Lower 50 % Average**|**$1,497.00**|**$30.20**|**$31.99**|**$33.77**|**$35.56**|**$37.35**|**$39.13**|**$40.92**|**$42.71**|**$44.49**|
|**Lower 50 % Median**|**$1,531.00**|**$30.84**|**$32.67**|**$34.50**|**$36.33**|**$38.15**|**$39.98**|**$41.81**|**$43.63**|**$45.46**|
|**Total Average**|**$1,965**|**$39.14**|**$41.48**|**$43.83**|**$46.17**|**$48.52**|**$50.86**|**$53.21**|**$55.55**|**$57.90**|
|**Total Median**|**$1,893.00**|**$37.75**|**$40.01**|**$42.26**|**$44.52**|**$46.78**|**$49.04**|**$51.30**|**$53.56**|**$55.81**|
|**Upper 25 % Average**|**$2,437.00**|**$48.14**|**$51.05**|**$53.96**|**$56.87**|**$59.77**|**$62.68**|**$65.59**|**$68.50**|**$71.41**|
|**Upper 25 % Median**|**$2,395.00**|**$47.34**|**$50.20**|**$53.06**|**$55.92**|**$58.77**|**$61.63**|**$64.49**|**$67.35**|**$70.21**|
|**Upper 50 % Average**|**$2,749.00**|**$54.10**|**$57.38**|**$60.66**|**$63.94**|**$67.22**|**$70.50**|**$73.78**|**$77.06**|**$80.34**|
|**Upper 50 % Median**|**$2,678.00**|**$52.74**|**$55.93**|**$59.13**|**$62.32**|**$65.52**|**$68.71**|**$71.91**|**$75.10**|**$78.30**|
