# interest calculation

1. ### Calculate interest on loan given at various date with moving libor rate

Hi All Looking forward for your advice and help in calculating interest on loan given at various date. Details as below a) I have below data as loan disbursement date during the period <tbody> Party Date of Loan Loan Amount A 3-Jan-2016 \$ 1,500.00 B 3-Jan-2016 \$ 200.00 C...
2. ### Day Count Convention

Trying to compare cumulative interest paid on a loan using different day count convention - I've used CUMIPMT but not sure what the defaut day count convention it uses or if I can change it. Any suggestions?
3. ### Interest on increasing capital amount, not compounded

I am hoping someone can help. I have spent all afternoon trying to figure this one out, to no avail. Basically, I have a principal amount which stays the same and recurrs daily, say £10 (see table below). I want to add interest on that at 8% simple annual interest from the date it is incurred...
4. ### Calculating Interest with Various Rates and Time Periods

Hi all, I'm trying to automate interest calculation given the total charge amount, due date, and interest rates for each period. The following table is the interest rates table for account code and time period: Acc Code BEG END Low Rate% High Rate% 13 0001-01-01...
5. ### Excel Formula, Payment calculation

Hello, I need to calculate a commission based on following rates for different bank. Rates are as follows: Please help me calculate the commission based on below conditions: Conditions: Wells Fargo: 70% of total reserve below (column F) Ally Bank : 75% of total reserve below (column F)...
6. ### Reserve Formula

Hello Guys, I work for a auto dealership and my boss asked me to calculate a reserve on finance deals. I have total 5 finance deals and total amount of financed is: \$169,819. My spread is always 2% ( buy rate-sell rate) The reserve is the difference between buy rate and sell rate. How do I...
7. ### Amortisation Calculator

Hi Guys, I am looking to do a presentation where I present the costs differences between 2 home loans. 1. Example one is a loan at 5% pa 2. Example two is a loan at 4% pa There are two graphs that i am trying to build. 1. the cost savings between example 2 and 1 over a 30 year period...
8. ### Interest Earning of Fixed Deposit

Hi Everyone i need a formula to calculate Accumulated Interest earned and Maturity vale of an Investment made for a certain period. <tbody> A1 B1 C1 D1 E1 F1 G1 Principal Amount Interest Rate Start Date Maturity Date Period (days) <tbody> Maturity Amount </tbody> <tbody> Total...
9. ### Loan/Lease Interest Calculator Problem

Hi there, I've been searching google high and low for a spreadsheet that can help me with an analysis I'm trying to run. I manage a golf course and every few years, I have to turnover our power cart fleet. It's always a question of how many carts we can afford based on our budget. So I was...
10. ### Formula for interest payable

Hi There Can anyone give me a formula for calculating the interest payable on a loan, based on: Amount of loan; Interest rate; Repayment amount; Repayment frequency. e.g £3000 loan at 12% paid at £120/month. I can get it right one payment at a time, but would like a single formula to do the...
11. ### Excel Idiot needing help with interest formula

I appreciate any help in advanced. I have promised my boss a Excel Spreadsheet calculating accrued interest to date on judgments we were awarded by first thing in the morning. Now at 3:00am I am ready to give up! Here are the columns for my spreadsheet related to my question for with an...

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...