开始使用免费开始使用

What's your nest egg?

To get started building a retirement model in real dollars, you can enter your expected return rate for retirement and the amount you want to withdraw each year. Let's estimate a bit more money to withdraw, to account for potential inflation.

With these values, you can then calculate just how much you need to have saved by the time you retire as the nest egg by using Annual Withdrawal divided by Interest Rate. Be to sure to maximize the columns to see the headers for the model.

本练习是课程的一部分

Google Sheets 金融建模

查看课程

练习说明

  • In B3, add 5% for the interest rate.
  • In B4, add $75,000.00 for the annual withdrawal.
  • In B5, calculate the nest egg you need for retirement by using withdrawal divided by interest rate.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习