Solved

compound interest over 8 months in excel

Posted on 2013-06-18
7
270 Views
Last Modified: 2013-06-18
An insurance company has been debiting money since dec to jun 2013 without permission. I would like excel to add compound interest @ 8% added monthly from dec to june.

I cannot see how to do that.

spreadsheet attached

i am in latest excel version
eeexample.xlsx
0
Comment
Question by:PeterBaileyUk
  • 4
  • 3
7 Comments
 
LVL 6

Accepted Solution

by:
Michael earned 500 total points
ID: 39256517
in cell F12 type:
=E12*1,08^ROWS(E12:E$18)

then drag down to F18

the ROWS(E12:E$18) part results in 7 and decreases to 1 when dragging down
0
 

Author Comment

by:PeterBaileyUk
ID: 39256539
it didnt calculate all i see is the formula like it is a label
0
 
LVL 6

Expert Comment

by:Michael
ID: 39256552
see attached file for working formula
eeexample.xlsx
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:PeterBaileyUk
ID: 39256563
cannot see attachment
0
 
LVL 6

Expert Comment

by:Michael
ID: 39256574
Yes sorry
I edited the message, it's attached now
0
 

Author Comment

by:PeterBaileyUk
ID: 39256575
weird works in your ok thank you so i assume they owe me 234 odd
0
 

Author Closing Comment

by:PeterBaileyUk
ID: 39256582
thank you
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now