1. 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...
  2. M

    VBA: User selects cells and with macro applies compound interest

    Hello VBA users way better than me, I have a workbook with multiple tabs and several lines of budget numbers on each tab. Each tab is a different project and no two tabs are the same. Project budgets are arranged by task and Fiscal Year. My goal is to enable the end user of this code to...
  3. C

    Compounding Commission Schedule

    Hi All, I'm very new to this forum so please forgive me. I'm trying to create a compounding commission schedule that is as follows: 10% of the amount from $0 - $50,000 with a minimum of $1,000 5% of the amount from $50,001 – $100,000 3% of the amount from $100,001 - $250,000 2% of the...
  4. W

    Compound interest with variable interest rates and monthly additional payments

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

    Interest Calculation

    I am trying to develop a spreadsheet that will enable me to calculate the exact amount of accrued interest (compounded annually based on actual investment date). Typically I would just use a FV formula, but that only works if there is an investment made DAY 1 and no subsequent transactions...
  6. G

    Compounding Forecast Equation

    First, THANK YOU for the help. I need it. hopefully this will be simple for someone else. Here's the basic issue: i'm creating a revenue forecast for my internet company. one of the determinant variables is "daily active users" or DAU. new dau are added every month. some percentage of them stay...

Some videos you may like

This Week's Hot Topics