Give out Google Sheet recipes, calculate millions in one second! 💸

Anyone who is DCA, a fund, or saving shares, have you ever wondered?..

"If I keep saving this, how much money will I have in 10 years?" 🤔

No need to press the calculator to get a headache. A found the "secret formula" in Google Sheet.

It's called the formula = FV, or the future value.

Just fill this recipe in. Sheet will tell us the future right away!

🔢 Time Machine Formula (Copy, go drop it):

= FV (Return per year / 12, Number of years * 12, -Savings per month)

📌 Example:

Suppose we save 2,000 baht per salary.

Expect an 8% annual return (invest in funds / shares).

Want to know how much money in 20 years?

Print it down as:

= FV (8% / 12, 20 * 12, -2000)

💥 Results: 1,178,040 baht!

(You see, the principal is only 4.8 lakh, and the breast is over a million baht because of the power of compound interest!)

⚠️ Remark (very important):

This formula only calculates the "money numbers" that will be received in the future. It has not eliminated "inflation" (that may reduce the value of money).

But, let's use it as a "starting goal" to rejoice and visualize the power of compound interest very well. ✅

Who has tried to calculate and caught a million at what age? Comment, tell me. 👇🤑

# techtuesday # productivity # Smart lazy # googlesheets # Investment finance