Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Would the number of periods here be 18 or 19 for the payment formula in excel? SUM =-PMT(D14,F30+|1,0,011) A AB D G PMT(rate, nper, pv,

image text in transcribed

Would the number of periods here be 18 or 19 for the payment formula in excel?

SUM =-PMT(D14,F30+|1,0,011) A AB D G PMT(rate, nper, pv, [fv], [type]) H Henry Spencer is interested in saving money to put his son, Shawn, through college. Shawn is turning 3 years old today, and Henry wants to be able to deposit an equal amount into a savings account each birthday until Shawn turns 21. He wants the deposits to be just large enough to pay for all 4 years of Shawn's education, and he plans to make the first deposit today. You can assume that tuition payments will be made on Shawn's 18th through 21st birthdays. You can also assume that the current cost of tuition is $42,000 a year, and that the cost will increase by 7% per year. If Henry is able to earn 11% a year in his account, how much should he deposit in the acount each year? 1 PV of Total Tuition $ 527,189.29 Annual Deposit Amount =-PMT(D14,F30+1, Shawn's Age 3 4 1 Rate of Return Tuition Cost This Year Tuition Inflation Rate 5 Year 0 1 2 3 4 5 11.0% 42,000.00 7.0% $ 6 7 8 $80,566.21 6 9 7 8 9 10 11 Tuition 42,000.00 $ 44,940.00 $ 48,085.80 $ 51,451.81 $ 55,053.43 $ 58,907.17 $ 63,030.67 $ 67,442.82 $ 72,163.82 $ 77,215.29 $ 82,620.36 $ 88,403.78 $ 94,592.05 $ 101,213.49 $ 108,298.43 $ 115,879.32 $ 123,990.88 $ 132,670.24 $ 141,957.16 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Deposit Account Balance 9,258.76 $ 9,258.76 9,258.76 $ 18,517.53 9,258.76 $ 27,776.29 9,258.76 $ 37,035.06 9,258.76 $ 46,293.82 9,258.76 $ 55,552.58 9,258.76 $ 64,811.35 9,258.76 $ 74,070.11 9,258.76 $ 83,328.88 9,258.76 $ 92,587.64 9,258.76 $ 101,846.40 9,258.76 $ 111,105.17 9,258.76 $ 120,363.93 9,258.76 $ 129,622.70 9,258.76 $ 138,881.46 9,258.76 $ 148,140.22 9,258.76 $ 157,398.99 9,258.76 $ 166,657.75 9,258.76 $ 175,916.52 12 10 11 13 14 12 13 15 16 14 15 16 17 18 19 17 20 18 21

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The FinTech Book The Financial Technology Handbook For Investors Entrepreneurs And Visionaries

Authors: Susanne Chishti, Janos Barberis

1st Edition

111921887X, 9781119218876

More Books

Students also viewed these Finance questions

Question

Discuss the importance of workforce planning.

Answered: 1 week ago

Question

Differentiate between a mission statement and a vision statement.

Answered: 1 week ago