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
3
votes
2answers
887 views

How can I calculate (approximate) the future value of my investments? Is this formula appropriate?

I want to check to see if I'm meeting my investment goals, so I want to project forward my assets given a growth rate and a monthly deposit amount. What is the best formula to use for this? Is this ...
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....
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 ...

1
2