Calculate cash flow in Excel step-by-step, if you want to implement a reusable water system in the company in a dry cleaner to 10 years in the future.(I'll upvote if done in Excel, otherwise I won't)

* Interest rate: 4.2%

* Income sales and services: $ 1,392,462.00

Total income: $1,392,462.00

*Expenses Purchases: $ 276,000.00 General expenses: $ 742,800.00 Total expenses: $ 1,018,800.00

The system cost is given by this table:

Product	periodicity of change	Estimated consumption	Actual cost, national coin	Monthy cost products
Sand	Every 2 years		$500	$20.83
Activated charcoal	Every year		$2,000	$166.67
Diatomaceous earth	Weekly	A bag every six months	$500	$83.33
Bleach		A kg per week	$70	$280.00
accordion filter	Annually		$2000	$500.00
Electric energy		Variable	$500/month	$150.00
Salt	Monthly	A bag of 50 kg	$150	$166.67
			SUM	$1367.50

(*) Considering: cost of water $ 20.00 per cubic meter. With 25 days of activity per month in the washing workshop and with a daily consumption of 20,000 liters of water.

Note: Use the linear depreciation method