FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help finding the formula for interest rate. simple formula and excel please. WN ona Assume the total cost of a college education will

I need help finding the formula for interest rate. simple formula and excel please.
image text in transcribed
WN ona Assume the total cost of a college education will be $325,000 when your child enters college in 18 years. You presently have $85,000 to invest. What annual rate of interest must you earn on your investment to cover 2 the cost of your child's college education? 3 4 Input area: 5 Future value $325,000 Years 18 8 Present value $85,000 9 10 (Use cells A6 to B8 from the given information to complete this question.) 11 12 Output area: 13 14 Interest rate 15 16

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_2

Step: 3

blur-text-image_3

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

A Smart Kids Guide To Personal Finance How To Earn Money

A Smart Kids Guide To Personal Finance How To Earn Money

Authors: Ryan Randolph

1st Edition

1477708235, 9781477708231

More Books

Students also viewed these Finance questions

Question

★★★★★
If 3 of the 1000 test subjects are randomly selected, find the probability that they all had correct test results (either true positive or true negative). Is such an event unlikely? a. Assume that...

Answered: 1 week ago

Question

★★★★★
\f\f\f\f\f

Answered: 1 week ago

Question

★★★★★
=+ Are butter and margarine substitutes or complements for this manufacturer?

Answered: 1 week ago

Question

★★★★★
Discuss the meaning and problems associated with using the end-state view criteria of merit, achievement, effort, and contribution.

Answered: 1 week ago

Question

★★★★★
I need help finding the formula for interest rate. simple formula and excel please. WN ona Assume the total cost of a college education will be $325,000 when your child enters college in 18 years....

Answered: 1 week ago

Question

★★★★★
please help with the problems below. please use excel and show all calculations. thank you! 8. Suppose you have $50,000 in your retirement fund and you'll be saving $15,000 per year at the end of the...

Answered: 1 week ago

Question

★★★★★
Virtual Coach is an on - line personal training service that allows athletes to upload their training data ( heart - rate, watts, perceived exertion, speed, etc. ) and then provides personalized...

Answered: 1 week ago

Question

★★★★★
Parent Co. owns 75% of Sub Co. and uses the cost method to account for its investment. The following are summarized income statements for the year ended December 31, Year 7. Income Statements For...

Answered: 1 week ago

Question

★★★★★
You are hired as a production manager within a small manufacturing firm that produces wood furniture for homes. You ask the company owner who is the CEO what the environmental management plan is. He...

Answered: 1 week ago

Question

★★★★★
According to a poll, 705 out of 1084 randomly selected adults living in a certain country felt the laws covering the sale of firearms should be more strict. a. What is the value of p, the sample...

Answered: 1 week ago

Question

★★★★★
The data from car crash tests for four different vehicle size categories (Small, Midsize, Large, and SUV) with measured amounts of left leg femur force (kN) results in the following Minitab display....

Answered: 1 week ago

Previous Question Next Question