Personal Finance & Money Stack Exchange
Personal Finance & Money Stack Exchange

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.

69 questions
27
votes
4 answers

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 it daily?? If the compounding period is monthly, what is…
Saideira
  • 385
  • 1
  • 3
  • 6
19
votes
2 answers

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 monthly interest is 0.25% (1/4 of 1 percent). This…
grgoelyk
  • 301
  • 1
  • 2
  • 3
14
votes
6 answers

Why use accounting software like Quickbooks instead of Excel spreadsheets?

Some friends and I are starting a small landscaping cooperative, and are thinking about how we will manage accounting. Places we've worked in the past have used Excel spreadsheets to manage all of their finances. However, a lot of the stuff I've…
J. Taylor
  • 241
  • 1
  • 2
  • 6
9
votes
6 answers

Do bank use the same math formula to calculate the mortgage amortization table?

I've started making a spreadsheet to evaluate mortgages and how they would fit other financial plans. The most complicated part seems to be the mortgage calculation formula. That's the formula the banks use to create the mortgage amortization table…
TheMeaningfulEngineer
  • 249
  • 2
  • 7
8
votes
2 answers

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 LibreOffice Calc (f/k/a OpenOffice.org Calc; I…
bstpierre
  • 10,034
  • 4
  • 33
  • 65
6
votes
4 answers

What Excel function to use to calculate the return or interest rate on a savings account?

I'm getting confused by Excel's various different financial functions. Which one would I use to answer the following two questions and how? Suppose that on October 1st, 2012 I open a savings account and make a deposit of €10,000,000. The savings…
Rinzwind
  • 163
  • 1
  • 1
  • 4
5
votes
2 answers

Get Revenue Details in Google Sheets using Google Finance

Recently I learned about GoogleFinance and it's feature to use Google Sheets to provide you with all stock market data using a formulae for eg. =GOOGLEFINANCE("GOOG", "price", "1/1/2014", "12/31/2014", "DAILY") I read the doc that I found,…
Aklank Jain
  • 159
  • 1
  • 1
  • 2
4
votes
2 answers

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 helpful. However, I noticed that each month in the…
Lizzie
  • 41
  • 1
4
votes
1 answer

Am I calculating the future payment on my ARM correctly?

We currently have an ARM on our house, bought in April of 2020 with a starting rate of 1.99%. It is up for re-amortization in April 2025. Assuming that the rate adjust to the highest allowed in the contract (3%) our new interest rate will be 4.99%.…
Nosjack
  • 10,866
  • 1
  • 30
  • 58
3
votes
2 answers

Compare my variable portfolio performance with S&P 500?

The question may appear simple at first but I really cannot come up with a quick and easy way to compare my performance as a trader Vs S&P500. For the sake of simplicity, I am analyzing my portfolio value on a monthly statement basis instead of…
Cool_Coder
  • 141
  • 5
3
votes
1 answer

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 rate of my investment. At the moment I'm using…
Mark Barnes
  • 364
  • 1
  • 8
3
votes
2 answers

Compound daily interest with monthly deposits over x amount of years in excel

This is compound interest calculated daily and topped up with deposits every month e.g Begin with $100, earn 2% interest earned daily even on weekends, and then come month end invest another $100 on the compounded amount. Please assist in how I…
Traders Day
  • 31
  • 1
  • 2
3
votes
2 answers

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…
Bing
  • 133
  • 1
  • 1
  • 4
3
votes
6 answers

Shared groceries expenses between roommates to be divided as per specific consumption ratio and attendance

My apologies if this question is in the wrong section. Couple of my roommates & I (total 5 people) share the groceries expenses. We record the purchases in an Excel sheet, and also have the ratio of consumption of individual items specified for each…
Rohit Banerjee
  • 49
  • 5
3
votes
2 answers

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 good enough (assuming 5% growth): (Current Value +…
David Hayes
  • 537
  • 2
  • 8
1
2 3 4 5