ur five-year old daughter has just announced that she would like to attend college. Your best guess is that it will cost approximately $25,000 per year for four years in tuition, books, rent, etc. for her to attend State College 12 years from now (first payment beginning on year 13). You believe that you can earn a rate of 9% on investment to meet this goal. a. If you were to invest a lump sum today in hopes of covering your daughter’s college costs, how much would you have to invest? b. If you now decided to invest annually instead, how much would you have to invest every year? (investment every year, years 1-12) c. You just learned of a $10,000 inheritance and plan to invest it in your daughter’s college fund (inheritance is available today at time 0). Given this new source of funds how much do you have to invest every year? d. Create a combo box that will switch provide the user with 5 different inheritance amounts ($8,000, $9,000, $10,000, $11,000 and $12,000)

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter5: The Time Value Of Money
Section: Chapter Questions
Problem 38P
icon
Related questions
Question

Your five-year old daughter has just announced that she would like to attend college. Your best

guess is that it will cost approximately $25,000 per year for four years in tuition, books, rent,

etc. for her to attend State College 12 years from now (first payment beginning on year 13). You

believe that you can earn a rate of 9% on investment to meet this goal.

 

a. If you were to invest a lump sum today in hopes of covering your daughter’s college

costs, how much would you have to invest?

b. If you now decided to invest annually instead, how much would you have to invest every

year? (investment every year, years 1-12)

c. You just learned of a $10,000 inheritance and plan to invest it in your daughter’s college

fund (inheritance is available today at time 0). Given this new source of funds how much

do you have to invest every year?

d. Create a combo box that will switch provide the user with 5 different inheritance

amounts ($8,000, $9,000, $10,000, $11,000 and $12,000)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 8 images

Blurred answer
Knowledge Booster
Checking Accounts
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.
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
SWFT Comprehensive Vol 2020
SWFT Comprehensive Vol 2020
Accounting
ISBN:
9780357391723
Author:
Maloney
Publisher:
Cengage
SWFT Individual Income Taxes
SWFT Individual Income Taxes
Accounting
ISBN:
9780357391365
Author:
YOUNG
Publisher:
Cengage
SWFT Comprehensive Volume 2019
SWFT Comprehensive Volume 2019
Accounting
ISBN:
9780357233306
Author:
Maloney
Publisher:
Cengage