The tag has no wiki summary.

learn more… | top users | synonyms

-1
votes
0answers
56 views

Need help with excel formula for health insurance policy

Before I even begin, I apologize for asking this question. It is HW and I should be doing this by myself, but I am just at a loss of what to add and what to subtract to end up at a end cost to a ...
0
votes
0answers
41 views

Sensitivity Table for IRR Using Purchase Price & Total Synergies

For my DCF I have a line for Synergies to be entered for each of four years How can I create a sensitivity table in Excel for IRR taking into variations in purchase price (enterprise value) and total ...
6
votes
4answers
431 views

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 ...
2
votes
1answer
174 views

Calculating total number of monthly payments in Excel using NPER and PMT?

How to calculate the total number of monthly payments given the amount of loan ($275,000), the annual interest rate (4.35%) and the number of years (30)? I'm confused because I'm trying to use the ...
0
votes
2answers
73 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
71 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
932 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
243 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 ...
1
vote
0answers
327 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
221 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
15k 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
290 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
446 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
15k 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 ...