L
Lisa VH
I am working on a worksheet and I need any help I can get.
This is the information I have to create my spreadsheet
and I am lost. Please help in any way you can. Please
email me at (e-mail address removed) if possible.
Here goes:
For the next 15 years, I plan to make monthly payment
deposits to a long-term savings account at a bank for
college tuition. The account pays 5.25% annual interest,
compounded monthly. I need to create a worksheet that uses
a financial function to show the future value (FV) of my
investment and a formula to determine the percentage of
the college's tuition saved. This is the information I
have: Out of State Annual Tuition= $50,000; Rate(per month)
=5.25%/12; Nper(number of monthly payments) =15*12; Pmt
(payment per period)=$400; and percentage of Tuition Saved
= FV/Tuition for Four Years; College for 4 years is
$200,000. I also need to create a data table that shows
the future value and percentage of tuition saved for
monthly payments from $175 to $775, in $50 increments.
So, I know some of what I need to do but I don't know how
to get started. The Out of State Annual Tuition is
throwing me off and don't I need to figure out a formula
for the cost of the tuition in order to figure out the
other information? I'm so confused. I would greatly
appreciate any help even just a step to get me started.
Thanks much! Lisa
This is the information I have to create my spreadsheet
and I am lost. Please help in any way you can. Please
email me at (e-mail address removed) if possible.
Here goes:
For the next 15 years, I plan to make monthly payment
deposits to a long-term savings account at a bank for
college tuition. The account pays 5.25% annual interest,
compounded monthly. I need to create a worksheet that uses
a financial function to show the future value (FV) of my
investment and a formula to determine the percentage of
the college's tuition saved. This is the information I
have: Out of State Annual Tuition= $50,000; Rate(per month)
=5.25%/12; Nper(number of monthly payments) =15*12; Pmt
(payment per period)=$400; and percentage of Tuition Saved
= FV/Tuition for Four Years; College for 4 years is
$200,000. I also need to create a data table that shows
the future value and percentage of tuition saved for
monthly payments from $175 to $775, in $50 increments.
So, I know some of what I need to do but I don't know how
to get started. The Out of State Annual Tuition is
throwing me off and don't I need to figure out a formula
for the cost of the tuition in order to figure out the
other information? I'm so confused. I would greatly
appreciate any help even just a step to get me started.
Thanks much! Lisa