Out-of-state tuition
You know you want your child to be able to go to any school they are interested in, even if it is out-of-state. Estimate the amount you will need to pay each year to save $25,000 for four years of college ($100,000 total) for the average out-of-state tuition cost.
この演習はコースの一部です
Google Sheetsで学ぶファイナンシャル・モデリング
演習の手順
- Use the
pmt()function with the arguments of rate, number of years, present value, and future value to estimate yearly payments in cellB7.
