Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use excel , need help with functions and setting up cash flows in Excel because I am only used to using a financial calculator,

image text in transcribedPlease use excel, need help with functions and setting up cash flows in Excel because I am only used to using a financial calculator, thanks!

A mutual fund has been advertising that, had you deposited $250 per month in the fund for the last 10 years, you would now have accumulated $85,000. Assuming that these deposits were made at the beginning of each month for a period of 120 months, calculate the effective annual return fund investors got. 12. Hint: Set up the following spreadsheet and then use Goal Seek. 1 Monthly payment 2 Number of months 250 120 4 Effective monthly return? 5 Accumulation

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Engineers Cost Handbook Tools For Managing Project Costs

Authors: Richard E. Westney

1st Edition

0824797965, 978-0824797966

More Books

Students also viewed these Finance questions

Question

Explain the various methods of job evaluation

Answered: 1 week ago

Question

Differentiate Personnel Management and Human Resource Management

Answered: 1 week ago

Question

Describe the functions of Human resource management

Answered: 1 week ago

Question

4. Devise an interview strategy from the interviewers point of view

Answered: 1 week ago