interest

  1. M

    Power Query reporting non-existent errors?

    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...
  2. B

    Loan repayment calculator

    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...
  3. A

    reverse compound interest

    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...
  4. P

    Formula to work out what the APR is from a monthly interest rate

    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...
  5. 6

    calculate monthly interest given annual interest

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

    Help with a very complicated formula

    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)...
  7. R

    Formula FV and Date if not working

    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...
  8. A

    Calculating Compounding Interest Expense by Month

    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...
  9. G

    CAGR with increasing capital

    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...
  10. S

    Stumps

    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...
  11. E

    Accumulated compound interest rates factor calculation

    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...
  12. N

    Calculating Interest Rate and Expense Calculation: Amortization Schedule

    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...
  13. F

    Interest rate calculation

    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
  14. A

    Combine multiple cells into single expression - common issue?

    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...
  15. T

    Compound interest since specific date

    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...
  16. O

    Formula Override

    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...
  17. O

    If Statements with multiple criteria options

    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...
  18. A

    Interest on Term Deposits as on today

    <!--[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...
  19. B

    Compound interest, varying per annum

    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...
  20. J

    Amortisation Schedule

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top