FV function problem

A

Apocafist

New Member
Joined
Dec 1, 2012
Messages
1
Hello everyone,
I need help with an FV function on an excel worksheet. It has me really confused because I dont know where the values go or which ones to put into the function..but anyhow here is the question.

Assuming that the term begins on August 15 each year, calculate the future value of the amount of money that the couple will withdraw in each of the four years to pay for Tyler's education. Place the estimates into cells G28, G30, G32, and G34 as negative cash flows. (use the FV function along with the current cost of education and the estimated inflation rate to determine the future annual cost of education for the couple.)

THANKS ALOT FOR THE HELP!!:)



A
B
C
D
E
F
G
Savings Account
College Projections
Conclusion

<tbody>
[TD="align: center"]1
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]Projected Payments
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]3
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FDE9D9, align: center"]Year
[/TD]
[TD="bgcolor: #FDE9D9, align: center"]Status
[/TD]
[TD="bgcolor: #FDE9D9, align: center"]Date
[/TD]
[TD="bgcolor: #FDE9D9, align: center"]Deposits and Withdrawals
[/TD]

[TD="align: center"]4
[/TD]
[TD="bgcolor: #FDE9D9"]Annual Interest Rate
[/TD]
[TD="align: right"]6.0%
[/TD]
[TD="align: right"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]Age 11
[/TD]
[TD="align: right"]1/10/2013
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]5
[/TD]
[TD="bgcolor: #FDE9D9"]Annual Deposit
[/TD]
[TD="align: right"] $ 6,500.00
[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]3/15/2013
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]6
[/TD]
[TD="bgcolor: #FDE9D9"]Birthday and Holiday Gifts
[/TD]
[TD="align: right"] $ 200.00
[/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"]12/25/2013
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]7
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #F2F2F2, align: center"]2
[/TD]
[TD="bgcolor: #F2F2F2, align: center"]Age 12
[/TD]
[TD="align: right"]1/10/2014
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]8
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #F2F2F2, align: center"][/TD]
[TD="bgcolor: #F2F2F2, align: center"][/TD]
[TD="align: right"]3/15/2014
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]9
[/TD]
[TD="bgcolor: #FDE9D9"]Years Until College
[/TD]
[TD="align: right"]8
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #F2F2F2, align: center"][/TD]
[TD="bgcolor: #F2F2F2, align: center"][/TD]
[TD="align: right"]12/25/2014
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]10
[/TD]
[TD="bgcolor: #FDE9D9"]Current Cost of College
[/TD]
[TD="align: right"] $ 15,000.00
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #E6E6E6, align: center"]3
[/TD]
[TD="bgcolor: #E6E6E6, align: center"]Age 13
[/TD]
[TD="align: right"]1/10/2015
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]11
[/TD]
[TD="bgcolor: #FDE9D9"]College Cost Inflation
[/TD]
[TD="align: right"]4.0%
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #E6E6E6, align: center"][/TD]
[TD="bgcolor: #E6E6E6, align: center"][/TD]
[TD="align: right"]3/15/2015
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]12
[/TD]
[TD="bgcolor: #FDE9D9"]Projected Cost of Four Years of College
[/TD]
[TD="bgcolor: #EEECE1, align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #E6E6E6, align: center"][/TD]
[TD="bgcolor: #E6E6E6, align: center"][/TD]
[TD="align: right"]12/25/2015
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]13
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DADADA, align: center"]4
[/TD]
[TD="bgcolor: #DADADA, align: center"]Age 14
[/TD]
[TD="align: right"]1/10/2016
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]14
[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DADADA, align: center"][/TD]
[TD="bgcolor: #DADADA, align: center"][/TD]
[TD="align: right"]3/15/2016
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]15
[/TD]
[TD="bgcolor: #FDE9D9"]Net Present Value of College Plan
[/TD]
[TD="bgcolor: #EEECE1, align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #DADADA, align: center"][/TD]
[TD="bgcolor: #DADADA, align: center"][/TD]
[TD="align: right"]12/25/2016
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]16
[/TD]
[TD="bgcolor: #FDE9D9"]Plan Will Cover Cost of College
[/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #CECECE, align: center"]5
[/TD]
[TD="bgcolor: #CECECE, align: center"]Age 15
[/TD]
[TD="align: right"]1/10/2017
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #CECECE, align: center"][/TD]
[TD="bgcolor: #CECECE, align: center"][/TD]
[TD="align: right"]3/15/2017
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]18
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #CECECE, align: center"][/TD]
[TD="bgcolor: #CECECE, align: center"][/TD]
[TD="align: right"]12/25/2017
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]19
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #C2C2C2, align: center"]6
[/TD]
[TD="bgcolor: #C2C2C2, align: center"]Age 16
[/TD]
[TD="align: right"]1/10/2018
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]20
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #C2C2C2, align: center"][/TD]
[TD="bgcolor: #C2C2C2, align: center"][/TD]
[TD="align: right"]3/15/2018
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]21
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #C2C2C2, align: center"][/TD]
[TD="bgcolor: #C2C2C2, align: center"][/TD]
[TD="align: right"]12/25/2018
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]22
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BABABA, align: center"]7
[/TD]
[TD="bgcolor: #BABABA, align: center"]Age 17
[/TD]
[TD="align: right"]1/10/2019
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]23
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BABABA, align: center"][/TD]
[TD="bgcolor: #BABABA, align: center"][/TD]
[TD="align: right"]3/15/2019
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]24
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BABABA, align: center"][/TD]
[TD="bgcolor: #BABABA, align: center"][/TD]
[TD="align: right"]12/25/2019
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]25
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #AEAEAE, align: center"]8
[/TD]
[TD="bgcolor: #AEAEAE, align: center"]Age 18
[/TD]
[TD="align: right"]1/10/2020
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]26
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #AEAEAE, align: center"][/TD]
[TD="bgcolor: #AEAEAE, align: center"][/TD]
[TD="align: right"]3/15/2020
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]27
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #AEAEAE, align: center"][/TD]
[TD="bgcolor: #AEAEAE, align: center"][/TD]
[TD="align: right"]6/15/2020
[/TD]
[TD="align: right"]100.00
[/TD]

[TD="align: center"]28
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #F2DDDC, align: center"]9
[/TD]
[TD="bgcolor: #F2DDDC, align: center"]Freshman Year
[/TD]
[TD="bgcolor: #D8D8D8, align: right"]8/15/2020
[/TD]
[TD="bgcolor: #D8D8D8, align: right"][/TD]

[TD="align: center"]29
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #F2DDDC, align: center"][/TD]
[TD="bgcolor: #F2DDDC, align: center"][/TD]
[TD="align: right"]1/10/2021
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]30
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #E6B9B8, align: center"]10
[/TD]
[TD="bgcolor: #E6B9B8, align: center"]Sophmore Year
[/TD]
[TD="bgcolor: #D8D8D8, align: right"]8/15/2021
[/TD]
[TD="bgcolor: #D8D8D8, align: right"][/TD]

[TD="align: center"]31
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #E6B9B8, align: center"][/TD]
[TD="bgcolor: #E6B9B8, align: center"][/TD]
[TD="align: right"]1/10/2022
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]32
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #D99795, align: center"]11
[/TD]
[TD="bgcolor: #D99795, align: center"]Junion year
[/TD]
[TD="bgcolor: #D8D8D8, align: right"]8/15/2022
[/TD]
[TD="bgcolor: #D8D8D8, align: right"][/TD]

[TD="align: center"]33
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #D99795, align: center"][/TD]
[TD="bgcolor: #D99795, align: center"][/TD]
[TD="align: right"]1/10/2023
[/TD]
[TD="align: right"]6,500.00
[/TD]

[TD="align: center"]34
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #953735, align: center"]12
[/TD]
[TD="bgcolor: #953735, align: center"]Senior Year
[/TD]
[TD="bgcolor: #D8D8D8, align: right"]8/15/2023
[/TD]
[TD="bgcolor: #D8D8D8, align: right"][/TD]

</tbody>
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
Upvote 0
You must log in or register to reply here.

Similar threads

V
  • Solved
Insert Row
2
Replies
13
Views
190
RobP
R
JenniferMurphy
  • Question Question
Is this a good solution to Excel's table header weaknesses?
Replies
3
Views
301
zero269
Z
JenniferMurphy
  • Question Question
Are these retirement calculations correct?
Replies
6
Views
466
JenniferMurphy
JenniferMurphy
staticfluids
  • Question Question
Distribute Number into Several Part (Increment) Based on Other Data (Dynamic Array)
Replies
2
Views
386
staticfluids
staticfluids
D
  • Solved
Is there a quick way to create / fill this list
2 3
Replies
20
Views
380
Eric W
Eric W

Forum statistics

Threads
1,223,956
Messages
6,175,614
Members
452,661
Latest member
Nonhle

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top