2. Calculate the cost of Allison's education Sharon wants to create an education fund for Allison so she can go to 4 years of college at a private university. Tuition is $30,000 per year in today's dollars and is expected to increase at 6% per year until Allison begins her studies in 15 years. Step 1 - get PV of payments the interest rate per period total number of periods in investment payment made each period present value future value Step 2 - get PV of the tuition funds the interest rate per period total number of periods in investment payment made each period future value present value rate nper pmt present value payment made each period pv fv rate nper pmt fv pv Step 3 - amount she will need to deposit for 15 years the interest rate per period rate total number of periods in investment nper future value fv pv pmt 0.06 0 0.023585 $0.00 $277,800.00 $0 do formula here 8.5-6.0 2.358490566 use their $277,799 to make step 3 come out right) do formula here

Financial Accounting: The Impact on Decision Makers
10th Edition
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Gary A. Porter, Curtis L. Norton
Chapter9: Current Liabilities, Contingencies, And The Time Value Of Money
Section: Chapter Questions
Problem 9.18E
icon
Related questions
Question
Please make sure your answer is correct tutor. Out of my questions in Bartleby, 90% are wrong all the time. Please use clean format also. Thank you
2. Calculate the cost of Allison's education
Sharon wants to create an education fund for Allison so she can go to 4 years of college at a private university.
Tuition is $30,000 per year in today's dollars and is expected to increase at 6% per year until Allison
begins her studies in 15 years.
Step 1 - get PV of payments
the interest rate per period
total number of periods in investment
payment made each period
present value
future value
Step 2 - get PV of the tuition funds
the interest rate per period
total number of periods in investment
payment made each period
future value
present value
total number of periods in investment
future value
rate
nper
pmt
present value
payment made each period
pv
fv
rate
nper
pmt
fv
Step 3 - amount she will need to deposit for 15 years
the interest rate per period
rate
pv
nper
fv
pv
pmt
0.06
0
0.023585
$0.00
$277,800.00
$0
do formula here
8.5-6.0
2.358490566
use their $277,799 to make step 3 come out right)
do formula here
Transcribed Image Text:2. Calculate the cost of Allison's education Sharon wants to create an education fund for Allison so she can go to 4 years of college at a private university. Tuition is $30,000 per year in today's dollars and is expected to increase at 6% per year until Allison begins her studies in 15 years. Step 1 - get PV of payments the interest rate per period total number of periods in investment payment made each period present value future value Step 2 - get PV of the tuition funds the interest rate per period total number of periods in investment payment made each period future value present value total number of periods in investment future value rate nper pmt present value payment made each period pv fv rate nper pmt fv Step 3 - amount she will need to deposit for 15 years the interest rate per period rate pv nper fv pv pmt 0.06 0 0.023585 $0.00 $277,800.00 $0 do formula here 8.5-6.0 2.358490566 use their $277,799 to make step 3 come out right) do formula here
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Money Management and Achieving Financial Goals
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning