interest

I have Cost centers in column G and interest in column Y, Cost centers are repeated and so interest rates accordingly, only one interest rate should be for one cost center, so if there are more than one rates there is an error, so for example <tbody> 411044924 5.280613 411044924 5.280613...

Hi, i am new and i need help about compound interest based on 365 days excel I'm creating a file to monitor my bank investment. Here is the link https://docs.google.com/spreadsheets/d/1u8mqweR4PU0n9itwlN945a79R0ueMpRPc1SL2PGadsU/edit This year, my goverment change the way to calculate interest...

My employer recently upgraded to Office 2016. I'm getting an odd result in PowerQuery. When I update a particular query from a macro file using ActiveWorkbook.Connections("Query - Financing").Refresh The connection window tells me that every row - 190 - has errors. But when I click on...

hope someone can help, trying to work out how much I would need to pay each month for a loan/mortgage loan value 32,5000,000 interest rate 3% term 15 years I'm trying to work out what the formula would be to work out how much interest payments only would be each month also would the formula...

Hi, I need a formula to calculate a daily compound interest rate where I know the initial value and the present value. For example, if in a week an investment increased by 30% (let's say $100 becomes $130), how would I display the daily compound interest, ie by what percent did it increase each...

I need help on what formula I can use to work out an APR for a loan where the pay back is loan plus full interest divided by equal number of payments over the period. So, If a loan is £1,000 say at a simple monthly interest rate of 3% over 12 months, the payments are £113.33 each month to cover...

Given an annual interest of 10%, how do you calculate the equivalent monthly interest?

I have issues with this formula that is very hard to write. The formula is: If G111 is YES and F21= normal loan use one formula otherwise 0. If G111 is YES and F21= interest only loan use another formula otherwise 0. That is my formula like now. (my excel is in Italian)...

Hi, I figured I would make a new thread since I wrote too much confusing stuff in the other one, so hopefully this explain it better. I want to have a formula that will automatically yield an adjusted balance on the same day each month. Here is what I tried: =D6 - FV(D4/12, DATEDIF(D3...

I need to calculate monthly interest expense that is compounding. This shows the format that I am needing. So what is the interest expense for Jan, Feb, Mar, etc. <tbody> Amount 33600 Period (Years) 1 Interest Rate .0903 Compounding Periods (Monthly) 12 Month Interest Expense...

Hi Everyone! Recently I received some very great assistance in realizing I was trying to calculate the compounded annual growth rate (CAGR) of two values. What I'd appreciate help with now is...how do you calculate CAGR without counting deposits? This is what I mean: Month #1 : starting bal...

Hi everyone, is it possible to get a formula to work out the following : The data which I capture is the date in column A and amount in column B, I then manually work out the days and interest amount, am not always sure that my calculations are correct : Is there a formula that can work out...

Is there a formula to calculate a accumulated compound interest rates factor from/till any given month/year? For example, I have a table with month interest rates: A B 1 Oct/2017 1% 2 Nov/2017 3% 3 Dec/2017 4% 4 Jan/2018 2% 5 Feb/2018 5% 6 Mar/2018 2% So If I wan't to get the accumulated...

My company has a loan taken out on 8/25/17 for $122,100.00 with a purchase amount of $170,940 (this is the total payment amount). The payments of $1,187.09 start on 8/28/17 and are Monday through Friday, except for holidays. The number of payments is 144 (with the last payment being $1,186.13. I...

What is the formula to calculate the annual interest rate from the following : Start date – 1 Jan 2018 Start value - $100,000 End date – 31 Dec 2028 End value - $160,000 Interest – compounded monthly

The FVSCHEDULE formula requires a single range of cells with the series of interest rates. However, I need to build this series of interest rates through a dynamic formula. Therefore I need a way to combine "[Formula 1]+[Formula 2]+[Formula 3]..." into a single range, or an expression that...

I would like to figure out the total payout figure for a loan. I have the initial amount in column b Date of loan in column c Interest rate in column d I need the total amount of the loan today with compounding interest without having made any payments. For instance: $10k loan from 6th July...

I've built a pretty extensive loan pricing model for my boss. Basically you put in some parameters and it does quite a few lookups to determine an interest rate we will charge. Long story short I worked for hours on the formula to get it just right. Now I want to add in functionality to where...

Good morning all, I'm trying to build a lending price model for my boss. Basically one that can determine the interest rate based on some inputs. Here are the criteria - 1. Credit score - which I have defined as 720+, 719-690, etc 2. The year the vehicle was made - 2015-2017, 2012-2014...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I need to calculate the interest paid out as on today for a large number of Lump sum Term Deposits. Interests on the deposits are paid every calendar quarter...