Financial model

WorldwidePaperCompany.xlsx

Sheet1

		FUTURE VALUES
Year							Values $Million
2017	capital invested						16
2018	capital invested						2
	Operating Savings						2
	Working Capital(10%of annual ravevenue- $4million)						0.4
2019	Working Capital(10% of Incremental sales-$10million)						1
	operating Savings						3.5
2020	Working Capital(10% of Incremental sales-$10million)						1
	Operating Savings						3.5
2021	Working Capital(10% of Incremental sales-$10million)						1
	Operating Savings						3.5
2022	Working Capital (10% of incremental sales-$10million)						1
	Operating Savings						3.5
		INTEREST RATES
YEAR							Values in $million
2017		cost of goods -75% of ravenues-$16million					12
		SG&A- 5% of ravenue-$16million					0.8
2018		cost of goods-75% of $4.4million					3.3
		SG&A- 5% of ravenue-$4.4million					0.22
2019		cost of goods-75% of $4.5million					3.375
		SG&A-5% of $4.5million					0.225
2020		cost of goods- 75% of $4.5million					3.375
		SG&A- 5% of $4.5million					0.225
2021		cost of goods-75% of $4.5million					3.375
		SG&A-5% of $4.5million					0.225
2022		cost of goods- 75% of $4.5million					3.375
		SG&A- 5% of $4.5million					0.225
YEAR	2017	2018	2019	2020	2021	2022
FUTURE VALUE	16	4.4	4.5	4.5	4.5	4.5
INTEREST RATE	12.8	3.52	3.6	3.6	3.6	3.6