massively undervalued, page-75

Couldn't help myself and bashed this together. Happy to have this shredded to pieces for any errors I may have made. Also happy to make it your own, improve it and reshare it.
https://www.dropbox.com/s/nmim6ktqisbr9m3/PLS valuatn.xlsx?dl=0

	Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8
0	PLS Valuation Sheet
1		2mta name plate	2mta name plate	2mta name plate	5mta name plate	2mta name plate	5mta name plate	8mta name plate
2	Scenario	conservative?	pessimistic?	not crazy?	conservative?	pessimistic?	not crazy?	not crazy?
3	Plant processing capacity t/yr	2,000,000	2,000,000	2,000,000	5,000,000	5,000,000	5,000,000	8,000,000
4	Spodumene recovery %	17.5%	15.0%	17.0%	15.0%	12.0%	16.0%	16.0%
5	Spodumene recovery t/yr	350,000	300,000	340,000	750,000	600,000	800,000	1,280,000
6	Spod processing cost US$/t	$220	$250	$220	$250	$300	$250	$250
7	Ore sell price US$/t	$800	$700	$950	$950	$800	$1,000	$1,000
8	Tantalum & other credits US$/t	$20	$10	$50	$20	$10	$50	$50
9	Margin US$/t	$600	$460	$780	$720	$510	$800	$800
10	Forex USD->AUD	$0.78	$0.70	$0.78	$0.78	$0.70	$0.78	$0.78
11	Assumed % of nameplate proc cap.	80%	60%	90%	80%	60%	80%	80%
12	EBITA A$/yr	$215,385,000	$118,286,000	$306,000,000	$553,846,000	$262,286,000	$656,410,000	$1,050,256,000
13	Valuation xEBIT	6	10	12	7	10	8	7
14	Capital invested/debt	$250,000,000	$350,000,000	$250,000,000	$350,000,000	$450,000,000	$350,000,000	$350,000,000
15	Company value	$1,042,300,000	$832,900,000	$3,422,000,000	$3,526,900,000	$2,172,900,000	$4,901,300,000	$7,001,800,000
16	Shares issued	1,556,000,000	1,556,000,000	1,556,000,000	1,556,000,000	1,556,000,000	1,556,000,000	1,556,000,000
17	Price per share	$0.65	$0.55	$2.20	$2.25	$1.40	$3.15	$4.50