始める無料で始める

Finish and visualize

You should finish your retirement model by copying the formula you just created to the rest of the table for retirement savings. By using the partial and complete absolute references in the previous exercise, you can simply copy and paste them into all the cells.

Last, visualize the difference more years of savings makes on the monthly payment by including a chart.

この演習はコースの一部です

Google Sheetsで学ぶファイナンシャル・モデリング

コースを見る

演習の手順

  • Copy the formula in B9 into the cells B9:G16 to complete the table.
  • Insert a line graph by clicking on cell A18, then highlighing A7:G16, clicking on insert, and then chart.
  • Be sure to change the chart to a line chart!

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する