Sentences with phrase «deposit date column»

You just use the compound interest formula: Principle * (1 + Rate / Time) ^ Time For Cell C2 you want this formula: = B2 * -LRB--LRB-(1 + (D$ 1/360)-RRB- ^ (C$ 1 - $ A2)-RRB--1) Column A is deposit date Column B is deposit amount Cell C1 is today's date Cell D1 is the annual interest rate Most savings accounts that I know of compound interest daily and credit earned interest...

Not exact matches

Speake's other uses for VisiCalc range from balancing his personal checkbook register (he has created a tidy five - column grid, which indicates the date, check number, deposit and debit columns, and running totals) to reconciling an ailing company's account books with those of one of its suppliers.

I should say that I'm not married to XIRR, I just want to calculate the return on a running basis in a column next to dates, deposits and balances.

You would have 2 columns, one a list of dates (ie the dates of the deposits or dividends or whatever that you want to track, the last entry would be today's date and the value of the investment today.