daily interest of gic

[jeff2813]

Hi there, i have a $5000 GIC that has an interest rate of 2%, compounding once annually, for a 2 year term. I also have a spreadsheet that tracks my portfolio and would like to add the GIC. I've noticed that morningstar doesn't included the GIC in their totals whereas RBC Direct does. This reflects in a major difference in total return. Just wondering if i can incorporate the GIC into the portfolio based on what the GIC would be valued at Daily. As an example the GIC has a value of $5000 today but tomorrow it may have a value of $5000.05 or something like that. I hope this make sense. Thanks.

 

[Dave Patton]

T202006a.xlsm
	C	D	E	F	G
2	GIC	Rate	Purchased	Maturity	Accrued
3	$5,000.00	2.00%	08-Jun-20	$5,100.00	$5,000.27
5b

Cell Formulas
Range	Formula
F3	F3	=C3*(1+D3)
G3	G3	=(TODAY()-E3)*D3/365*C3+C3

or

T202006a.xlsm
	C	D	E	F	G	H
2	GIC	Rate	Purchased	Calculation	Maturity	Accrued
3	$5,000.00	2.00%	08-Jun-20		$5,100.00	$5,000.55
4	$10,000.00	2.00%	08-Jun-20	07-Jun-21	$10,200.00	$10,200.00
5b

Cell Formulas
Range	Formula
G3:G4	G3	=C3*(1+D3)
H3	H3	=((TODAY()-E3)+1)*D3/365*C3+C3
H4	H4	=(F4-E4+1)*D4/365*C4+C4

 

[jeff2813]

Thank you. Works great.

 

[Dave Patton]

Thanks for the feedback.