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.
54
questions
1
vote
1answer
518 views
How can I make Excel handle fractions like Quickbooks?
When you have a fraction in Excel like 1.085 rounded to two decimals = 1.09.
In Excel if you add a series of these fractions with displayed two decimals of precision you are really adding 1.085 and ...
3
votes
3answers
761 views
Calculating Future and Present value into mortgage comparisons
I'm looking to buy a home in the next 3 or 4 months. The bank I'm working with has 10 different mortgage rates, currently ranging from 3.5% to 4.625%, with points respectively ranging from 2.875 to -1....
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 ...
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 ...
