Question: Show how u solve using excel rate function The final tally is in: This years operating costs were down $100,000, a decrease directly attributable to

Show how u solve using excel rate function
The final tally is in: This years operating costs were down $100,000, a decrease directly attributable to the $520,000 investment in the automated materials handling system put in place at the beginning of the year.
a. If this level of annual savings continues for five more years, resulting in six total years of annual savings, what compounded annual rate of return will that represent?
b. If these annual savings continue for nine more years, for a total of 15 years of annual savings, what compounded annual rate of return will that represent?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!