interest

Hello there. I was wondering what formula to use to calculate compound interest where the interest rate is not fixed each year e.g. investment of £400k interest rate months 1-12 @ 3% interest rate month 13-24 @ 3.5% interest rate month 25-100 @ 3% etc Hope that makes sense. I am using...

I am currently building an amortisation schedule for a property mortgage and am having difficulty filling the time series according to the length of year (Number of Payments). Any help would be greatly appreciated. I would like the period to update automatically based on a monthly payment...

Hello I have a mortgage comparison spreadsheet which, once the information has been input, compares the total amount payable over the initial fixed rate e.g. two years. Book1BC6Option One7Loan Amount (inc any fees added to loan)8Other Fees (not added to loan)9Term of Mortgage (in...

Hello all. I've been wrestling with this spreadsheet for a while now. I am trying to take a series of interest payments and loan receipts/repayments on varying dates and a rate based on Libor and calculate the XIRR. The loan is received net of financing fees. I need to amortise the net loan at...

Hi all, I'm trying to build a table to calculate compounding of interest however the input amount is something I need to edit and the interest changes at different levels. I tried stacking multiple IF statements so =IF(A1<=300,0.01,IF(A1>300 OR <1000... my formula breaks. I don't know how to...

Hi, I'm working on a project for my accounting class. Basically, I'm calculating total delinquent interest for several loans in default. The template looks like this:

Hi all, I have been trying to generate interest calculation automatically for my business. For example if we take one client at a time my business norms is if the balance is unpaid for 10 days then interest is applicable from the date of purchase. II have entered the formula for this and it is...

Hi, First time poster. I'm trying to back into the principal amount of a self amortizing loan with varying interest and cash flow. The interest rate will be 5% for the first year and 2% for years 2 - 6. There is no payment in year 1 and let's use $100 for payments in years 2 - 6. Any...

Long story short, I am trying to back into an amortization table using the following variables: Original Loan Amount = $575,000 Loan Start Date = 10/24/2011 Payment Date = The 24th day of each month (first payment 11/24/2011) Interest Type = 365/360 Interest Rate (before adjusting because of...

I have a cash-flow which I need to calculate how much interest is paid each month to the day. The interest is built up over the first 6 month then the total accumulated is paid on the 7th Month then the interest is paid on a monthly basis thereafter. I am currently doing this by using an IF...

Hi there, I am looking for a formula to help speed up a process. I have a spreadsheet which details invoice values and I need add 2% interest on for each 30 days that the invoice is overdue. I have columns titled; invoice number, invoice date, invoice due date (30 days from date), invoice...

Hi, The issue I'm facing is quite complicated to explain so please bear with me. Hopefully the example at the end will help. For accounting purposes I need have a few financial instruments (which you can think of simply as loans with an interest amount paid either annually or quarterly or...

Hi all, first post here though I've read thousands. I want to know what formula to use to calculate interest due on a loan on any particular date, where the rate is quoted as an AER (or Effective rate) and the interest is calculated (and compounded) daily (assuming no repayments made for this...

I am trying to create a spread sheet that will calculate the balance of a loan that does not require a minimum payment or even a payment for any certain amount of time, but will still add interest to the loan on a monthly bases. So to put it simple I have loaned someone $2843.87 they have no...

I have 5 years of data by month. I'm trying to calculate the total amount due each month, assuming the bill was never paid, to find out how much is owed. For example: Date: Amount: 12/1/2006 $21.10 11/1/2006 $21.10 10/1/2006 $21.10 etc... A 10%...

Hi all, This is my first post... I have a problem for which I need help. I have a bunch of different different payments for 500 people. They all end their payments in a different period, e.g. period 14 or 50, and I have a total of 360 periods. Besides this each period has a different interest...

I am trying to determine the amount of finance charges due based on 18% APR when I have the payment terms in one column (ie Net 15), the invoice date in one column (ie 1/15/12), the balance due in a column (ie $790.00), and the statement date in a column (ie 5/18/12). Suggestions? Also, to add...

Hi, We use =PMT() to find out the value of EMI for given principal, period and rate of Interest. Principal Months Interest EMI 100000 246 11% 1,025.30 (Formula used for EMI =PMT(C2/12,B2,-A2)) What formula can we use to find out Principal if period, rate of Interest and EMI is...

Hi everyone! I am calculating simple interest payments for a particular month. I have the outstanding principal and the rates can change within a month. So far, I have used the formula below: =IF(E8="-",I8*(M8-1)/365*P8%,I8*(DAY(E8)-1)/365*D8%+I8*(M8-DAY(E8)+1)/365*P8%) E column stores the...

Hello and first thank you for reading I have a formula =StartingBalance * (1 + Rate)^NumberOfDays this is to create a daily compounded interested rate now if this formula is correct (that is what I am checking) Principal = 400 interest rate = 3% number of days = 1 year then =400*(1+.03)^365...