26 July 2011

Anticipating the price of goods in "n" years


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.

No comments:

Post a Comment

Web Analytics