financial calculations

Hi Everyone, I am having real problems calculating values based on certain drop down selections I make. For example, for my business I am trying to calculate the spend per year by selecting a drop down and choosing the year I want to be calculated. I already have the spend data for all the...

Hi all, I have a column of daily dates & in the next column I have the corresponding values (daily stock returns) for those dates. For the EOM dates, the return is for the whole month, not just the day like the daiy returns are. I would like to find the 1 year return, which means I need to...

Suppose I take out a $100,000 loan with (say) 6% interest rate, but do not pay the fully amortized payment each month. After (say) 10 payments, I want to know the remaining loan balance. How do I do this? Thanks, Bill

Hello, We have created a free-to-use, open-source, financial model. In the current model, we have fully-functioning VBA macros which can 1) sculpt debt by cutting and pasting the calculated values until the difference between the calculated and pasted value equals zero, and 2) maximizes the...

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

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

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

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

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

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

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