# financial formulas

1. ### Excel.. How to solve this ( Maths) in Excel ( FINANCIAL )

Hi Friends, I need your help. I am learning excel and i have a excel file with few instructions. Can any one able to solve this, & understand me - how we will solve it. it will be a great help. Please find the attached excel(Math-Finance file). I tried to solve but I am not sure ,what i did...
2. ### Sensitivity Analysis

Hey everyone, I have two difficulties to finalize my Sensitivity Analysis and hope that someone can help me out. This is my simplified basis table: <tbody> Income Statement Forecast NET SALES 4907,7 Number of Stores 368 Net Sales per Store 13,3 Cost...
3. ### Running totals based on single RTD cells updating.

Hi. Please forgive my inexperience - first post. Im using RTD to pull in financial data from a stock simulator. My objective is to calculate Volume Weighted Average Price (VWAP) on a continual basis every time a trade occurs. VWAP = (Cumulative(Last price * Last volume) / cumulative Volume)...
4. ### 2007 - Formula for Calculating Interest due on given date with principal & AER

Hi all, first post here though I've read thousands. I want to know what formula to use to calculate interest due on a loan on any particular date, where the rate is quoted as an AER (or Effective rate) and the interest is calculated (and compounded) daily (assuming no repayments made for this...
5. ### Formula with Multiple Variables - help please

Need help with a formula on excel that I can't seem to get. Basically I trying to create a formula where the monthly interest payment is automatically calculated based in what range the monthly billing falls into, as well as what type payment it is (E33). But I have several variables. Is this...
6. ### Financial formulas: Macro to calculate Williams %R

I am working on this project which needs to calculate Williams %R momentm indicator and then draw a bar chart for the result. I am just not able to get started. any help on this will be really appreciated.
7. ### Math behind FV formula

I often use the following formula to find outstanding balance on a loan: =FV ((i,periods,pmt,-pv). Does anyone know what the math is behind it? I know that the FV factor is ((1 + i/12)^periods) - 1......but I haven't been able to figure out how to use this to create a long hand formula. Also...

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...