Last week, I conducted a webinar on Time Value of Money (TVM). I demonstrated five TVM formulas to do analysis and make better financial decisions.
After the webinar, Ian, my partner, asked if the TVM formula could calculate his annual returns from an investment of a dividend stock. I was given the following details:
Investment Price = S$ 1.037 (after brokerage fees)
Year 1 Dividends = 7.504 cents
Year 2 Dividends = 7.759 cents
Year 3 Dividends = 8.076 cents
Year 4 Dividends = 8.192 cents
Year 5 Dividends = 8.560 cents
Market Price (4 December 2021) = S$ 1.87
We need an advanced TVM formula to calculate Ian’s returns.
Hence, in the next live webinar, I’ll share how to calculate IRR and XIRR and use them to make wiser financial decisions.
Apart from Ian’s investment, we’ll explore:
- How to use IRR to assess returns of a savings plan (with irregular premium and cash payout)?
- How to use XIRR to assess stocks, unit trust, properties?
- How to analyse the following situation where I put up the problem as homework for all attendees:
Question: Which way do you want to get paid?
A. $10,000 now
B. $10,100 next month
C. $12,000 one year later
D. $14,000 two years later
E. $5000 now, $7000 one year later
ATTENTION: The content you are currently able to view is limited because you are not logged in to our website.
We apologize for the inconvenience, but without a logged-in Premium Webinar Membership, access to our full webinar recordings, video content, and exclusive downloads is restricted. If you find our content valuable and want to dive deeper, we invite you to check out our paid membership options call Premium Webinar Membership.
However, we’re delighted to inform you that attending our live webinars remains free of charge! Trust us, it’s a game-changer for anyone serious about financial growth. To stay in the loop about our future webinars, we announce new topics every week. Make sure to follow us on Email, Telegram, and Facebook so you never miss out on our latest webinar invitations and announcements.
If you are a paid member, please login below:
4 replies to "Time Value of Money (Part 2) – Advanced Level of Financial Literacy"
Hi,
I am a new member. If the dividend I received is free stocks, not cash, how to calculate my CAGR?
If it is free stock, that means the money is still in the account. Therefore, technically no cash flow in or out.
So can just ignore it because there is no transaction in your calculation.
Then the value will be reflected at the “market value” you use in your entire Cash Flow schedule (the final line)
Hi,
As I’m working on Personal Finance Workbook regarding to this topic, i am stuck at exercise question as below:-
Your insurance agent proposed an education savings plan for your newborn baby. You will need to pay a fixed premium of RM3000 a year for 15 years. At the end of the term, you will receive an estimated maturity benefit ranging from RM55,000 to RM80,000. Calculate the possible range of CAGR using a Google Spreadsheet.
PV = 0
NPER = 15
PMT = 3,000
FV = 80,000
CAGR = NA
My understanding is that the PMT and NPER are regular, shall i not use the formula of finding out RATE? If yes, I could not generate the rate in XCEL after keying in the PV/FV/PMT/NPER. Can i be enlightened on where am i getting wrong at?
Thanks, appreciate it.
You entered PMT = 3000
if it is positive, it means you are receiving money. But actually, is should be negative because you are paying the premium. Money is going out from your pocket.
Change the PMT to -3000 (negative), and you will be able to find out the RATE.