financial

Hi Everyone, English is not my first language so this might not be explained as good as it could be. But well, I'm making a monthly financial report where I have to make a graph with the trend of the realized sales and the budget. Thing is the realized sales data changes depending on which...

I am trying to model a future share price, based on: - Dividend per year - yearly volatility (standard deviation) - price -exercise price -risk free rate -Time period I currently have the following equation to predict the daily movement of the share: =J8*(1+NORMINV(RAND(),0,$J$10)) Where J8...

I have two tables, one has the [Sales data] (Customer and Sales Dollars), the other table has [Order Details] (Product line and SKU). Both are related with a 1:1 key. I want a pivot report to show Customer (from sales) in the column, SKU (from orders) in the next column, and Product line...

Hello everybody. For a particular loan, having disbursement date, interest rate, disbursement fee, maturity.... how in excel to calculate the yield on this loan, in ONE formula? I have tried "yield" formula, however - it is for securities, bonds... not for loans granted. IRR will not work for...

All, I need some help creating a dynamic formula that calculates a percentage based on when a benefit is supposed to begin. For example, let's say we receive the following data about an "Awesome Benefit" that we will start realizing in Q3 2015. 100% will be realized by end of 2017. <tbody>...

Have a monthly model and want to be able to flex the year ends between Dec, March and June from a switch. What's the easiest way to do this, use flags?

I am trying to distribute an amount in some months based on a StartDate and EndDate. I guess I've found a method to do it manually, but I want to do it all in automatically in VBA only based on the three 'variables'. I've tried to parse what I've done down below. I hope it's understandable. I...

Anyone have suggestions on which formulas to use / how to do a presentation of a Statement of Changes in Equity on Microsoft Excel?

Just a quick one. Does anyone know about Vumero or have any more info other than what is on their site? How it works or when it's launching? Cheers Yogi

Dear All, I have historical prices of a FTSE 100 index. There are two columns, Times and Price. The time is uneven and is in seconds For instance: Time Price 2011-04-01T07:12:35.412Z 5949.6 2011-04-01T07:12:35.412Z 5949.4 2011-04-01T07:12:35.412Z 5949.4...

Hi, I have a spreadsheet with a set of dates and rent charged on certain dates. Rent changes on certain dates, I would like to automate the spreadsheet so I do not have to manually go in and spread out the rent based on the dates. Essentially this is a rent schedule and I want the total rent...

Hi everyone, <o:p></o:p> I really need your help. For 1 month now I’m trying to make financial countdown timer – but no luck. <o:p></o:p> What I managed to do is how much money I have now and my (expenses) average money spent; - per day - per month, and - per year <o:p></o:p> <o:p></o:p> And...

I have seen too many projections done this way for there not to be a good way of calculating this. It is driving me crazy trying to figure it out. I have a spreadsheet that is for financial projections for a start-up. It uses months # 1 to 48 instead of real dates and is laid out horizontally...

I have very limitted use of Excel, but need to create a workbook that tracks $ due to our company based on visits completed. For example, pt # 1 comes in for Visit 1 ($2300.00), Visit 2 ($1600.00), and Visit 3 ($1000.00). On Sheet 1 I want to track the Visits by placing an X in the box meaning...

My client owes the bank 5988.77. Over 12 months at 23% using =pmt this is 563.36 per month. I need a formula or a method to calculate how many months will be required if the client can only pay say 70.32 per month. Neither Tools / Goal seek nor Tables seem to work for me. Any ideas would be...