Anticipating the price of goods in “n” years

The time value of money formula is one of the financial foundation in personal finance. Approximate this by calculating the Future Value, FV using financial calculator or excel. 
Say, GSC  movie ticket at RM 10.00. Ignoring personal inflation rate, we take CPI increment of 3% per year, in 10 years.
In Excel, type “=fv(“, then you will key in “0.03” for “rate”, “10” for “nper” which mean n number of periods, “0” for “pmt” which stands for periodic payment, and “-10” for “[pv],  present value for which it must be negative.

You will get the answer RM 14.80. This is the expected movie ticket price in 2022 if inflation remains constant each year.

Leave a Reply

Your email address will not be published. Required fields are marked *