You work as an analyst in the investment bank. Your manager asks you to calculate debt that the company will require to finance its PPE expansion. Before you can do that you need to calculate the CAPEX required to support the Sales growth.	2017	2018	2019
Sales	11 025,0	12 985,0	16 047,5
Property Plant and Equipment	4500,0	5300,0	6550,0
Accumulated depreciation	(1350,0)	(2120,0)	(3602,5)
Net PPE	3150,0	3180,0	2947,5
You met with your senior manager and these are the remarks made by her:
1) Every forth year the Company has to doubles its regular CAPEX compared to regular trend due to technological changes. In 2020 this is exactly what management is planning to do.
2) Management predicts Sales to be 18000 in 2020 and then Sales will be increasing at the same growth rate as in 2020/2019 for the next three years
3) The company wants to raise debt equal to 50% of CAPEX in 2020 and 40% CAPEX in 2021 and 2022. Provide the debt amount requred by the company in the next three years.
4) All increases in gross PPE are due to CAPEX. There is direct connection between the Sales and Capex, so we are safe to use last two year average ratio to predict CAPEX. Deprecaition relationship will be as in 2018 -2019. All increased in Accumulated Depreciation are due to Depreciation expense
Use what you learned in the course to provide solution for the above assignment. You MUST create a table exactly as in your model.
Provide short NOTES or COMMENTS where you need to make assumptions