interest

Hi all, hoping someone can help me solve a complex query I have. I have a large spreadsheet which has unique reference numbers in col A and month-year (ie oct-06) across row 1 (from oct-06 to mar-18). The fiscal year for the spreadsheet is from 1-April to 31-March which is causing me problems...

Hello! This pertains to a model I am using to calculate interest rates for mortgages. Rates can be floating or fixed and the interest rate calculation method can either be Actual/360 or 30/360. There are 2x cells with dropdown choice similar to the below. (E3 & E4) which have values, and...

Dear all, Is there a way to: Calculate Cumulative interest paid at Month # 15 ("n") for Mortgage amortized for 25 years using ONE line. I want a single formula whereby I can just change "n" and it gives me the cumulative interest up to that point. All other mortgage elements (interest rate...

How would one go about designing an excel sheet that calculates interest like a bank's savings account, meaning balances that change from day to day and interest rates that change during the year? Preferably, the interest rates would come from a table.

I am trying to discount cumulative interest over a period of time. Say I have an original mortgage for $100,000 and a term of 60 months, then the borrower prepays on month 1 for $50,000. I want to know what the cumulative interest lost over that period is at a discounted rate of 15%. I want...

Dear Sirs Good afternoon , i m working on term loan sheet with moratorium period only the interest will be paid first and after couple of months will start paying Principal and Interest Kindly advise how can i use the excel to prepare a formula for that . Thanks & Regards Najib ABboud

Hello First post I know how to calculate the overall daily interest rate on a loan but what i would like to do if possible is to split this out into financial years So for example if a loan was taken out on 1 November 2018 and matured on 31 October 2021 (three years) I can calculate the...

I am trying to calculate interest due on a Per-Diem basis when the interest rate changed during a given time period. For example, our institution sends out $100M on 05/20/2018 and charges an interest rate of WSJ Prime (adjusting daily) on a Per-Diem Basis. We receive a payoff request for 6/30/18...

I am hoping to find a template to help calculate an amount due for interest. It is for a large amount of principal over a number of years. The amount is subject to interest compounded daily. There is no installment payment agreement in place. Over the years, several large payments have taken...

Hi Guys, I've had a few work sheets that calculate interest and time on regular payments but what I am looking for is something a bit more complex and I can't seem to work it out. I feel like I'm missing something really simple that I should know. <tbody> A B C D E 1 Principle $...

I need to create a loan amortization schedule using Access. My challenge comes as we are using compound interest and I need to determine the monthly payments. I am able to get the total to be repaid using the formula: =[LoanAmount]*((1+[InterestRate]/[CompoundType)^([LoanTerm]*CompoundType))...

Good day Like to split interest amount(236 692,92) between two entities as follows : Days Amount % Calculation 272 8 464 147,66 84,67% 200 602,49 113 1 532 635,76 15,33% 15 090,43 9 996 783,42...

Hi there, I am wondering if someone can help me figure out how to format this formula. Let's say I open up a CD for 5 years (60 months). If I keep the money in there for at least 4 months without breaking it I will get a $1000 bonus and the APY is 3%. How do I calculate the effective annual...

Hello, A spreadsheet I recently inherited has hard coded numbers, I was hoping someone could help me with the formulas to recompute a couple columns (PV Cash & Interest Exp) that I can't seem to re-create. Discount rate is 10%, term is 1/1/2020 - 12/31/2020, it's on a 13 period fiscal year...

I am trying to work out the interest rate of the below given cash flows. I have a principal balance of 1000 and I am paying interest quarterly, at the dates where the 1 is denoted. The interest amount is the sum of the previous quarters cash flows. So for example in the 30/09/2018 date, I will...

An organization has provided a loan to an staff. She pays her loan in installments whose principle amount is constant and the interest changes. What is the formula to calculate present value of future inflows if the interest at which the organization is providing the loan and discount factor is...

Hi All, I have had a look at a number of forums to try and find the answer to my question, but I will need this to be simplified. Suppose I started paying £20 every month into an investment portfolio for the next 40 years, with a fixed interest rate of 2.5%. However, every year I increase my...

I have various items in stock and was to calculate the interest for 30.42 days Where the item has been in stock for less than 30.42 days then the interest must be calculated by taking the value of the item in Col R x int rate in Col AF/365 x No. of days in Stock in Col X, otherwise the 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...