compounding

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

Watch MrExcel Video

This Week's Hot Topics

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
Top