finance

So I have a list of colums like so: C1 C2 C3 X A D Y B E Z C F And I have a combo box made from form controls that has C1, C2, C3 etc. What I'm trying to make work is to select C2 for example and have the results spit out like this: Category1...

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...