+ Reply to Thread
Results 1 to 2 of 2

Excel model - Financial Analysis

Hybrid View

  1. #1
    Registered User
    Join Date
    04-20-2022
    Location
    Hamburg, Germany
    MS-Off Ver
    2016
    Posts
    2

    Excel model - Financial Analysis

    Dear All,

    I would like to kindly ask for your assistance on a bottleneck that i am facing the last couple of weeks in excel and can't solve myself. I have attached a simplified version of my model just for illustration purposes in order to make it easier for someone that could assist me. So basically, as shown on the tab "Financial1" of the excel file my current model refers to company financials that have a financial year starting from January & ending on December. Filling my full model based on that is pretty straightforward and easy. However, certain companies on my portfolio do not have a financial year of January to December but March to December or October to September. Can someone help me build inside my already existing formulas another formula that takes that into account and depending on each case adjusts the dates shown to e.g., March to December or October to September?

    Many thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,704

    Re: Excel model - Financial Analysis

    If you are using SUMIFS

    =SUMIFS(Financials1!$F8:$CK8,Financials1!$F$&:$CK$7,">=" & Year_Start,Financials1!$F$&:$CK$7,"<=" & EOMONTH(Year_End))

    otr

    =SUMIFS(Financials1!$F8:$CK8,Financials1!$F$&:$CK$7,">=" & Year_Start,Financials1!$F$&:$CK$7,"<=" & Year_End)

    where Year-Start / Year_End are Financial year start/end dates

    You could replace G7 formula with

    =EOMONTH(F$7,0)+1

    copy across
    Last edited by JohnTopley; 04-22-2022 at 04:54 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro for data tables in financial model slowing down excel
    By berlin_21 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-04-2021, 03:38 AM
  2. Replies: 1
    Last Post: 02-10-2021, 08:22 PM
  3. Financial analysis using excel
    By John Oloo in forum Hello..Introduce yourself
    Replies: 4
    Last Post: 01-14-2021, 10:21 AM
  4. Financial Analysis and Excel
    By ExcelAteMyHomework in forum Excel General
    Replies: 2
    Last Post: 09-06-2011, 02:19 PM
  5. Excel question for financial model
    By kidflip in forum Excel General
    Replies: 2
    Last Post: 03-16-2011, 03:13 AM
  6. financial model
    By cassandra23 in forum Excel General
    Replies: 4
    Last Post: 12-24-2008, 12:20 AM
  7. financial model
    By sid_2007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2007, 08:32 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1