Please see attached file for instructions

Accrued Interest = Principal Amount * (1 + Interest Rate / # Times Compounded) ^ (# Times Compounded * # of Years) ? Principle Amount.

No.	Principle amount	Interest rate	Start date	End date	# of Days	# times compounded	# of Years	Accrued interest
1	$2,253.40	0.1000%	07/01/2016	07/20/2016	19	Daily, 365	0.0520547945	$0.118
2	$2,253.40	0.1000%	07/20/2016	07/21/2016	1	Daily, 365	0.002739726	$0.002
Total					20	Daily, 365	0.0547945205	$0.12

Highlighted in yellow is the answer. I?m trying to understand the steps. If you could please do this in a spreadsheet showing the steps.

Accrued Interest = Principal Amount * (1 + Interest Rate / # Times Compounded) ^ (# Times Compounded * # of Years) - Principle Amount. No. Interest rate 0.1000% Start date End date 1 Principle amount $2,253.40 07/01/2016 2 $2,253.40 0.1000% 07/20/2016 Total 07/20/2016 # of Days 19 # times compounded Daily, 365 07/21/2016 1 20 # of Years 0.0520547945 Accrued interest $0.118 Daily, 365 0.002739726 $0.002 Daily, 365 0.0547945205 $0.12 Highlighted in yellow is the answer. I'm trying to understand the steps. If you could please do this in a spreadsheet showing the steps