finance

Hi, I am using statistics to develop a finacial model on excel. I have created a table that lists returns of a security over a given period of time. I have used formulas to calculate the mean and standard dev of the returns. Right now, I am using the norm.inv function =norm.inv(.05...

I am making a net worth TEMPLATE page that has about 9 tables in it which are refered to as headers using the conditional formating that looks like this: "header" value % invest Ameritrade jpc 50 mo 50 Edward Jones mwa 50...

I know this isn't a new question. But I can't find the answer anywhere online. I have a spread sheet of 1500+ companies. (I can email you the .xls file if it would help.) I want to import specific information from Yahoo Finance, for example the first company on the list is AAIR, AAIR Key...

Hi Guys, I am dealing with a tremendous issue and I am walking with this idea for months and it is quite challenging also. Oke here is the deal, it is about Math and Finance. Suppose I have three Real Estates A,B and C. See inserted picture for the table: If I buy 1 Real Estate A I can...

Hi, I'm brand new to this forum and fairly new to excel. I'm building a property investment model and one stage of the model is a loan repayment calculator. I have built it and it runs perfectly. However, I want to add a feature that allows you to see how many days you could save from the total...

Revenues are received monthly and then distributed to Mark and Frank. At first, 75% of the revenues will go to Mark and 25% to Frank. This arrangement of 75/25 will be changed to 25% to the Mark and 75% to Frank once Mark’s $1000 investment is paid back. Once both parties have been compensated...

I have 5 years of data by month. I'm trying to calculate the total amount due each month, assuming the bill was never paid, to find out how much is owed. For example: Date: Amount: 12/1/2006 $21.10 11/1/2006 $21.10 10/1/2006 $21.10 etc... A 10%...

I am trying to determine the amount of finance charges due based on 18% APR when I have the payment terms in one column (ie Net 15), the invoice date in one column (ie 1/15/12), the balance due in a column (ie $790.00), and the statement date in a column (ie 5/18/12). Suggestions? Also, to add...

has anyone done any work on comparing the offerings of several vehicle novated lease providers?

My problem is pretty simple but the solution seems pretty complicated. I have a list of clients and I have data about each one (gender, age, location, profit margin, fin. ratios, industry, favorite color, etcc.. ) I work for a lending institution so I also know how late they were in making...

Is there a way to create some kind of output into multiple cells? For instance, I have a dollar amount that I want to increase by 5% each year but I don't know how many years yet. But based on user input (say 10yrs) 10 cells would be created, each 5% larger than the next?

I am interested to know whether there is a compound interest formula which takes inflation into account. I am familiar with the compound interest formula. The type of calculation I'm looking to do is Monthly investment of: $250 Annual interest rate: 4% Annual inflation rate: 3% Period of...

I recently downloaded a finance application for Excel. It is amazing... I did not know Excel could do some of these things... For instance, it has an unlock key window that pops up when you first open it. i could not find a way around this (I bought the key for only $1 from them, so no big...

Hi there, im trying to set up a spreadsheet that accesses a website like yahoo finance to retrieve data. I can get excel to pull data...DATA>IMPORT EXTERNAL DATA>NEW WEB QUERY...and then i choose the table i want imported. However, what I cant do is get another cell in the spreadsheet that i...

I've recorded a macro to download stock data from MSN and it works great. However, I want to be able to use the same macro to download data for other stocks based on data entered in a given cell in Excel. I would like to enter a stock symbol in cell B7 and have it download the same information...

Hi, I am curious to see a breakeven formula in excel to help me know how many shares of a stock I have to sell to cover the original cost and the taxes from the gain (taxes are 35%) My goal is to quickly see how many shares I can keep of a stock after I take out the original amount it took to...

Hi folks, I've got a slight problem with my Pivot tables in Excel 2007. I'd like to make an analysis about several Banks. When a bond gets issued, there are several banks organized as a consortium. I.e. I have Lead1, Lead2, and so on. If I put Lead1 in the pivot table as a column and the...

I have a list of products and their respective price (by month). In the worksheet I have the products in column A and then months across the top and their prices are the data points. I have already used an array function to count how many of the products fall within various price bands for...

Hello, I have a spreadsheet full of data that I download from a database and dump into Excel. (I also dump it into a financial software package to generate payments). The problem is that there isn't a good option in the financial software for creating a statement to send with the check. So...