Every month Sam Tabor is assigned a different job at Russo & Daughters Financial Consulting. Sam enjoys the task variety and
1 answer:
You might be interested in
Answer:
Expected withdrawal is $45,000 for 30 years = total of $1,350,000
You will be required to invest in $25.063 every year.
Explanation:
By applying the goal seek formula in excel to determine the annual invested fund, based on a compounded interest rate of 6% over a duration of up to a maximum of 25 years from Year 0, we can clearly see that Savings ought to be $25,063 for every year.
The future Value of each saved fund is derived and added to future value of each years subsequent saved fund to arrive at a total expectation of $1,350,000 expected value after 25 years (i.e. $45,000 annual withdrawal x 30 years of withdrawal)
This brings total savings to $626,572 for the entire 25 years
Kindly refer to the attachment for breakdown of workings.
The average change in the tuition in the school is $1748.30 per year
<h3>How to find the average rate of change</h3>The formula would be
y2 -y1 / x2 - x1
The value for y1 = 19890
y2 = 30380
x2 = 2011
x1 = 2005
We would have to put these values in the formula that we have above such that we would be having:
30380 - 19890 / 2011 - 2005
10490 / 6
= $1748.30
Hence we would say that the average rate of change is $1748.30 per year.
Read more on the average rate of change here
#SPJ1
