financial calculations

  1. J

    Rolling return for 1Y/2Y/3Y/5

    I have a price point available with me from 1979 to 2018. I am looking to calculate the rolling return of this years for 1/2/3/5 Years period. Also, This returns I am looking in Percentage terms. Please advice right method
  2. I

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

    Financial Calculations

    Good evening, Does anyone know where I can find a nicely made spreadsheet that incorporates Time Value of Money calculations? Specifically one that calculates a future value given multiple "monthly" deposits? Thanks for your time! Have a Merry Christmas! Sincerely, Travis
  4. D

    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)...
  5. M

    Pivot Table with Multiple Currencies Summing to One Currency

    Hi all - I have an worksheet style database in Excel that contains information on several firms over several periods. Each measure is in the firm's native currency (USD, CAD) and I also have a column with the converted currency (CAD). In my Pivot Tables, I would like the ability to sum to one...
  6. B

    How to sum items in a column based on values in corresponding rows

    I have a purchasing spreadsheet I am working on that compares pricing for multiple items from different vendors. Column B has a the item purchase quantity, Column D has the item unit pricing from a specific vendor, and Column O determines the lowest price value from all the vendor columns and...
  7. S

    comparison of loans

    I would like to compare multiple loans with and without balloon payments. The common is loan amount $500,000. # compounding periods/yr, and balloon pmt option $100,000. EX: <table style="border-collapse: collapse; width: 764pt;" border="0" cellpadding="0" cellspacing="0" width="1014"><col...

Some videos you may like

This Week's Hot Topics