# interest

1. ### Calculate interest rate

\$1,000 grows to \$1,000,000 in 200 periods at what interest rate? thanks :confused:
2. ### How to calculate compound interest?

hello first post here i want to learn to calculate compound interest using excel how do i do that? let say i have 1000\$ and it gets 10% raised every week how do i calculate the total growth in 1 year?
3. ### Loan Repayment Formula with Interest Capitalization and Monthly Payment

Hi All, I have a loan repayment schedule as below where interest accrued on loan principal is capitalized on quarterly basis (blue marked dates) and payment is made monthly. Here green cells are variable, meaning user should be able to define loan disbursement date (here, 7 OCT 2019), first...
4. ### Copy Range D6:P6 in every 2 minutes And PASTE Values to Down Cells Continuesly in every 2 minutes

Dear Sir, Iam a small NSE Option Trader. For Open Interest Tracker, i have designed a excell sheet Name OI Tracker. In this sheet i get the updated Open Interest Values From D6:P6 (These Values get updated when the Open Interest data Updates in www.nse.com. So i need to get it copied the below...
5. ### HELP: Excel Formula using date as basis for interest

Hello, newbie here. can someone please help on how to work on the formula using dates (year... if possible movable dates) as basis for computing the interest. i made a formula and i cant seem find anyway to have the year be moving, depending on the present year, or if possible to include the...
6. ### Weighted Average Loan Payment Formula

Hi everyone, I'm attempting to create a formula that calculates a "paid-to date" for a loan that has multiple principal balances. I want to be able to plug in a payment amount and have a formula in the Interest Paid-to column determine the paid-to date by applying the payment to the loan with...
7. ### VBA IRR on Amortization Tabl

I'm looking for a way to use VBA to calculate the IRR of the cashflows of an amortization table without actually needing an amortization table in my workbook, but rather just the loan attributes. I currently use the following function to calculate the cumulative interest paid given the...
8. ### Withdrawing balances from accounts

Hi, Below are two banks, Bank A and Bank B where i am intending to withdraw based on the annual increase in withdrawal of 3% starting at age 70. Everthing works ok for me and and I provided the formula below that i am working on. However, I could not get the formula out for withdrawal. Given...
9. ### Loan repayment calculation

Hi I want to take out a loan for 25,000,000 at 7% annual fixed interest rate and make month end monthly repayments. I want to take out the loan immediately "month 0" but not start paying it back until month 7... because I won't have any income for 6 months. I must pay the whole lot back by...
10. ### Match & Countifs (probably ..)

I've been struggling with a formulae (having tried various connotations of COUNTIFS) to first: - count the number of matches per item (an item can occur multiple times in the Master list) on an extensive list but that is further restricted to only those whose characteristic of interest has to...
11. ### Compounding Interest

Hi there, I can see myself spending (more) hours on this so before I do, I thought I'd check if there's any clever cookies who know how to do this. I would like to calculate the compounding interest on a Overdrawn Loan account. I would like the interest incurred to be shown quarterly. In...
12. ### reverse engineer interest rate

hi all. i'm trying to work a reverse calculation on a finance repayment calculator. i have have the standard amortisation calcs.. \$20k amount 84 months 10% interest \$332 repayments per month Total interest component of \$7890 If i bump the repayments up to \$375 per month, it lowers the loan...
13. ### Dashboard Using Dates, Date Ranges and an Aging Matrix

I need some help. I have a spreadsheet that has two sides. A shortages side and a Surplus side. The numbers on the two sides two will always remain seperate Basically a Debits and Credits Accounting type setup. Each side of the spreadsheet is an every growing and shrinking with the number...
14. ### If value in report combobox A, B or C, then another combo box d or e.

Good day all, I have a simple issue that I am struggling to resolve. In an access report I have a combobox (Called "InterestCode") that looks up a value from a query and outputs that value. There are a number of options , eg. M1, M2, M3, P1, P2 etc. Depending on this value, I would like...
15. ### Xcel newb needing help calculating simple interest on a judgment

I have used court calculators in the past to calculate the amount of interest (simple) owed, to-date, on a judgment but have been tasked with something I am unaware how to solve. My best best was to figure out an Xcel formula in hopes of simplifying my life. Judgment was awarded on December...
16. ### Payment plan, with 2 accounts, paid in order

Hello! I am having a hard time doing this in excel, and variations of it::confused: how can i calculate the monthly price i need to pay to pay down 2 accounts 2 0 where the 1st account is worth 2000 and has 0 percent interest and the 2nd account is work 10,000 and has 5 percent compounting...
17. ### Time Value of Money

Hi, I need help on calculation FV. I need to know the FV of a \$1M investment that pays out 5% interest on a monthly basis. PV \$1m Number of years 5 Interest Rate 5% Payment \$ this is where i don't know what to fill out FV ? Thanks
18. ### Copy a Cell Value to Another Cell in the same Table

Hi I have a table with 12 columns which is used for tracking Receipts and Payment for Individual CLient. (I have a sample file. But this forum doesnt seem to allow me to attache it to the post) I am trying to create a automated consolidated snapshot as of current date i.e. Total Principal...
19. ### Compound and simple interest VBA?

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...
20. ### Adjust Calculation based on 2x conditions in multiple cells?

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

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