finance

' Spot = Spot Price of the underlying ' K = Strike Price ' T = Option Maturity in Years ' rf = Interest Rate in decimal (i.e, for 5%, use 0.05) ' vol = Yearly volatility of the underlying in decimal ' n = Number of time steps ' OpType = 'C' for Call and 'P' for Put ' ExType = 'A' for...

I am trying to create a formula that will populate 2024 values and show a smooth trend that ends up with the 2024 average being 3% higher than the 2023 average. When I average all of the months for 2024, it needs to come out to $71.71.The 3% assumption would be an input cell. Is there a way to...

I work in Finance and have a QoL-issue with excelling daily. I use INDIRECT and SUMIFS constantly when comparing figures. Oftentimes it's about comparing latest estimates with previous forecasts or budgets in an earlier instances of the same file (although with a different name)...

BCDEFGHIJKLMNOPQR2TRACKING SHEET3# of Trades3Winners3.00004Batting Avg100.00%Losers0.00005Sharpe Ratio#DIV/0!Breakeven0.00006Avg ROI84.95%Avg Risk1.17077Commission#REF!Avg Winner45.41338Overall P/L$136.24Avg Loser#DIV/0!910DateSymbolPositionSharesFillExitExit HalfExit QtrEntryStopRisk...

Hi there. I have a sheet with ~5k rows of customer data for a SW company (see sample below). I want to break it down so that I can analyze things like recurring v. non-recurring revenue, total subscription revenue by product type by customer... Does anyone have any thoughts on how to do this...

Hello, I was given the following financial task in excel. To be honest i tried to solve it, but i would appreciate some help from your side in order to be sure. I would veryt gratefull if you can help me. 1. Please add a column in "Sales analysis" in order to calculate the gross profit of each...

So I have a table that has the following Phase Code Description Cost Preliminary Phase A1 Liaison $ 3,000.00 A2 Project Meeting $ 2,000.00 B1 Financial Modelling $ 1,000.00 C1 Project Management $ 1,000.00 Main Phase A1 Liaison $ 5,000.00 A2 Project...

Hi Everyone, I am seriously considering spending a lot of time building a data model in order to benefit from Power Pivot and DAX. I work as a finance business partner and my role is to analyse data (monthly most of the time) through multiple scenarios (P&L by country, by account, by project...

PROJECT: CONTRACTION OF A LOAN REPAYMENT SCHEDULE FOR A HOUSE MORTGAGE The mortgage, of UGX 1,400,000,000, has a term of 40 years. For the first 2 years, no repayments are made, although interest still accrues on the loan. Interest-only repayments are due from this point until the end of the...

THANK YOU SO MUCH FOR ANY TIME AND EFFORT IN HELPING ME SAVE MANY MAN HOURS AT WORK!!!! I just need to take a large data set from the first format below to the second. The changes include: 1. New column 2. Each row from the original data set that begins with cell A containing "RE: $...

Hi everyone, how are you? Could I ask you to help me please? I need to calculate automatically 2 things (in the tab "Cost details"): 1/ The P&L impact (taking into account several variables - from cell L13 to cell S13) 2/ the Cash position (cashout) based on payment terms, total cost expense...

Hi everyone, how are you? Could I ask you to help me please? I need to calculate automatically 2 things (in the tab "Cost details"): 1/ The P&L impact (taking into account several variables - from cell L13 to cell S13 2/ the Cash position (cashout) based on payment terms, total cost expense...

Hi! I'm trying to create a FIFO (First in, First Out) Revolving Line of Credit Tracker in Excel. We buy "short-term" notes (aka, lines of credit) and pay back P&I throughout the month which gets applied to the oldest note first. The rates for each note fluctuates with WSPRIME. I've attached a...

I have dynamic low of day (LOD) stock prices in column A and last stock prices (LSP) in column B. The data is pulled from an external web service and never hard coded. I need to create 11 additional columns of data based on these two values: Column C would display the times the LSP fell below...

I need a formula which allows the 'Money Leftover' cell K7 to always equal 500. I've probably worded the above really vaguely, however I'll add an image to try and get explain myself. What I need: As I start to add in values under columns C-I, the values in K will either go up or down...

. I have the following data from the S&P 500 index ranging from 1990-present. I need to do the following; identify all periods of market downturns and market upturns market upturn is defined as a period during which there is no downside move in the index greater than 20% and a downturn is...

Hello All, If somebody help with my my question I will be very thankful. Thank you very much in advance. My question is that when I use XNPV function in payment schedule as attached which I know only the monthly irregular payments and I want to discount all the payments to 1 January with taking...

Hello all, *Second time posting as the last thread did not display correctly* This may be a long shot but I am throwing this out there to see if anyone can help. I would like to recreate a form of a three-structure in Excel. Below is an sample set of folder structure data. Commercial...

Hello All - When I copy a Balance Sheet from a website the negative figures map over like this "(100,000" as the other parenthesis pastes to the next cell. I then have my own formatted Balance Sheet elsewhere on the worksheet and am able to use Index(Match) to pull over the initial figures I...

Hi, each month I run a report and complete multiple Vlookups against last months report through VBA. The reports are called the same thing, example - April folder - Finance extract, May folder - Finance extract. In order for my macros to work, I have to each month rename the previous month...