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