Solved

compound interest over 8 months in excel

Posted on 2013-06-18
7
275 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delete texts with font color 16 30
ADD New Entries 7 16
Update As Well As Add 6 37
How do i remove text in between commas in Excel? 14 0
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

912 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

22 Experts available now in Live!

Get 1:1 Help Now