Questions tagged [spreadsheet]

For questions regarding the use of spreadsheet programs (such as MS Excel, Google Sheets, OpenOffice Calc, etc.) in personal finance, including questions about spreadsheet financial functions.

Filter by
Sorted by
Tagged with
27
votes
4answers
46k views

Daily interest calculation combined with monthly compounding: Why do banks do this, and how-to in Excel?

I often see banks advertise (for accounts with fixed yearly interest, let's say 1.5%) – "interested is calculated daily, and compounded monthly". I have 2 questions: Why are they calculating ...
19
votes
2answers
60k views

How do I calculate monthly compound interest in Google Sheets?

I have a financial spreadsheet with a column of all my deposits into my savings account. The leftmost column lists the dates of the deposits. Now, let's say my savings balance is $100.00 and my ...
7
votes
2answers
4k views

How can I calculate a “running” return using XIRR in a spreadsheet?

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. Here's a screenshot of a simplified spreadsheet in ...
2
votes
2answers
9k views

How to calculate the number of months until a loan is paid off (given principal, APR and payment amount)?

Does anyone know what formula they use for this When will you be debt-free? calculator? I want to put it in a Google Spreadsheet, but I can't find a payments-to-debt-free formula using my Google ...
4
votes
2answers
185 views

Daily Interest Monthly Compounding Multiyear

I downloaded the Excel spreadsheet mentioned in the accepted answer to this question: Daily interest calculation combined with monthly compounding: Why do banks do this, and how-to in Excel? It was ...
3
votes
1answer
225 views

How can I calculate the annualised growth rate for an irregular investment?

I have a portfolio, which I invest in monthly. Depending on my circumstances, the monthly amount changes from time to time (perhaps every two years or so). I want to calculate the annualised growth ...
1
vote
2answers
618 views

Why does =googlefinance() return a different open and close value on a non trading day

I'm using google finance in one of my sheets and it is returning slightly different values for open and close when stocks are not traded on that day. eg. sunday =INDEX(GoogleFinance("AMZN", "open", ...
1
vote
1answer
993 views

XIRR not working for this dataset. Any other method to calculate rate of return?

For this particular dataset xirr is not returning any reasonable value either in excel or google spreadsheet. What is the option to calculate the rate of return in cases like this?? Sl-no date ...