finance

  1. H

    Avoiding INDIRECT when referencing and comparing ranges in different workbooks

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

    Finance P/L and Day P/L Formula

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

    Software Biz Analysis for Investing: How to break down customer data based on multiple criteria and show on new tabs

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

    Excel finance task

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

    Looking for a Formula / VBA that adds and transposes project cost and phase items

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

    Create Data Model for a finance position

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

    LOAN SCHEDULE 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...
  8. T

    Need short Macro for formatting task

    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: $...
  9. A

    Payment terms (formula) for P&L impact and Cash flow - HELP

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

    P&L impact and Cash flow impact (for expenses) - with payment terms

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

    FIFO Revolving Line of Credit Tracker with Interest

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

    Enter Timestamp for each time cell value changes

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

    How do I make one cell always equal to a specific number while still taking into account of other cells.

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

    Formula to identify changes of less than 20% and more than 20% over time?

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

    XNPV function

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

    Create a tree structure in Excel - Possible VBA input

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

    Search a Function for X if found do Y

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

    Vlookup from last months report for this months report

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

    Count needed based on date

    Hi team, like below format, i do have lot number of records. I want formula to calculate unique count, on every date from which department.. can anyone suggest on this.. ---- User count
  20. D

    VBA for Finance structure to Database structure (Copy & Paste)

    Hi everybody, I use this forum as much as I can to look for better ways to use Excel, but I'mn ot that good with VBA and I need ome help for restructuring some finance data into a Database tab. I have 4 tabs, identical formatting except the amounts per Month are different. The 4 tabs represent...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top