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

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
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
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education