Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
The Excel ACCRINT function returns the accrued interest for a security that pays interest periodically. The Syntax is: ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method]) The arguments can be explained as: issue - the issue date of the security. first_interest - the first date interest will be paid. settlement - the settlement date of …
I received an email from Stacey a few weeks ago asking: “Which formula would I use to find the initial investment amount required to have $15,000 at the end of 5 years, if my bank pays 4.75% interest, compounded monthly?” The answer is the PV Function. =PV(4.75%/12,60,0,-15000,0) =$11,834.50 Excel’s PV Function PV Function Syntax =PV(rate,nper,pmt,[fv],[type]) …
James wrote to me and asked: if he buys shares worth $2000 and gets 4% return, how many times does he need to reinvest all of his capital before he makes $1m. Of course James was quick to point out that this scenario doesn’t take into account loosing on any of his trades. Reasonable I …
Ever had a spare $10,000 to put in a term deposit? If you did you might wonder what it would be worth at the end of 2 years at an interest rate of 6% compounded monthly. It’s not as simple as =$10,000 x (1+.06 x 2)…although this will get you close. But if you’re a …
