The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
63 views

Find the compound return

If I have a specific amount of money. For example 1000€ at the beginning of the 2008 year. -65.55 2008 91.25 2009 17.74 2010 -42.87 2011 18.32 2012 -18.82 2013 56.57 2014 How much money ...
1
vote
0answers
44 views

Excel Canadian Mortgage Formula Help

I need to get the ending balance formula for a project in excel calculating mortgage payout. I am hoping to develop a formula instead of formulating an amortization table. I have used the following ...
3
votes
6answers
751 views

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 ...
3
votes
2answers
155 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 ...
0
votes
0answers
215 views

How to get most accurate stock data downloaded to excel

I've been downloading historical NASDAQ stock data from yahoo for about 2 years. Yesterday, 12/31/2013, it started to not download any historical data. But now I realize that yahoo's data probably ...
1
vote
1answer
158 views

How and Where can I easily pull data for the Dow 30?

Where/How can I pull the following data on the DJIA stocks into Excel from the Web that updates every time I hit refresh in Excel? The data: 1. Last 12 months of dividend payments 2. Prices 3. DJIA ...
3
votes
3answers
9k views

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 ...
1
vote
1answer
247 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
358 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 ...
12
votes
2answers
10k 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 ...