시작하기무료로 시작하기

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로 하는 Financial Modeling

강의 보기

연습 안내

  • 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.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작