How to solve this using excel
Favorites|Homepage
Subscriptions | sitemap
HOME > Mathematics > How to solve this using excel

How to solve this using excel

[From: ] [author: ] [Date: 11-08-25] [Hit: ]
I tried so many times but I cant solve this using goal seek.=11327.Enter the above as one continuous string.Put 1 in the cell D1.1.2.......
11327.5*(1+r)^16+
11327.5*(1+r)^15+
11327.5*(1+r)^14+
11327.5*(1+r)^13+
11327.5*(1+r)^12=63163
Solve for r.

I tried so many times but I can't solve this using goal seek.
Thanks in advance

-
My Excel sheet worked as follows:

Put the following formula in a cell (I used A8):

=11327.5*((1+D1)^16+
(1+D1)^15+
(1+D1)^14+
(1+D1)^13+
(1+D1)^12)

Enter the above as one continuous string.

Put 1 in the cell D1.

Run goal seek by doing the following:

1. Data Tab
2. What If Analysis
3. Goal Seek
4. "Set Cell" to A8
5. "To Value" 63163
6. "By Changing Cell" D1.

Answer should appear in Cell D1 as 0.00781514973346338
1
keywords: solve,excel,to,How,using,this,How to solve this using excel
New
Hot
© 2008-2010 http://www.science-mathematics.com . Program by zplan cms. Theme by wukong .