Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    Excel help to create IRR and MOIC results within an existing cashflow

    - or -

    Post a project like this
    02/02/2017
    $
    • Posted: 6 years ago
    • Proposals: 14
    • Remote
    • #1407700
    • Expired
    Jonathan H.
    Jonathan H.
    FCCA, business planner, excel modelling expert
    Thailand Phuket
    IMnS Associates
    IMnS Associates
    Chartered Financial Modeler (CFM) & Valuation Practitioner (FMVA)
    Top Endorsed
    Pakistan Karachi
    Ritanshu S.
    Ritanshu S.
    Big 4 Experience | Business Services | Consulting | Financial/Valuation Models | Research | Bookkeeping | Taxes
    India Ahmedabad
    Alan T.
    Alan T.
    Senior Finance Professional, CGMA, ACMA
    United Kingdom Cambridge
    Mohammad Sadat Uddoula P.
    Mohammad Sadat Uddoula P.
    Expert in Excel, Google Speadsheet & VBA Macro
    Top Endorsed
    Bangladesh Dhaka
    Ash G.
    Ash G.
    VBA Programmer & Excel Expert w/ Data Analysis Skills. Experience with Power BI
    United Kingdom Telford
    Prateek G.
    Prateek G.
    Experienced Financial Modeler & Virtual CFO
    Turkey Demre
    Harsh S.
    Harsh S.
    Startup Expert - Financial Analyst
    India Bangalore
    Obaid U.
    Obaid U.
    Microsoft Certified Advance Excel Specialist¦Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦Excel related any Work¦Macros of Excel¦
    Top Endorsed
    Qatar Doha
    Aroog A.
    Aroog A.
    PowerPoint Template design | Brand Identity | Logo Design | UX design | Print design | Website design
    Top Endorsed
    Pakistan Gujranwala
    Thilani M.
    Thilani M.
    Chartered Accountant
    Sri Lanka Nugegoda
    Pugazhenthi E.
    Pugazhenthi E.
    Consultant- Market research, Data analysis, Social media, Primary and Secondary research
    India Chennai
    • 1
    • 2
    1429861443720980049113672712280501371827137642413913201406416141509514558801480383
    Jonathan H.
    IMnS AssociatesRitanshu S.Alan T.Mohammad Sadat Uddoula P. + 9 others have already sent a proposal.
    • 1
    • 1

    Description

    Experience Level: Entry
    Description of excel work: I have an existing excel file which provides a cashflow model for a real estate project involving land acquisition and subsequent land sales. I have 3 tasks I would like support on:

    1. Calculate the IRR of the cashflow - I can't get this working properly from the data and dates I have inputted;
    2. Calculate the MOIC - this is an important metric which I would like to display alongside the IRR;
    3. In one cell I have identified the peak cashflow, in the next cell I'd like some way of automatically presenting what date this peak cashflow event occurs.

    I would be grateful for someone who could support me quickly on these three tasks and provide a short explanation as to how they were addressed.

    I would prefer not to share the excel file until it I have appointed someone, but I will say that the spreadsheet is very simple with a relatively small amount of data.

    Thank you.
    Extra notes:
    Nick G.
    Nick G.
    100% (10)
    Projects Completed
    13
    Freelancers worked with
    12
    Projects awarded
    20%
    Last project
    21 Mar 2019
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

    • 03 Jan 2017Edima U.

      Hello, Could you provide a excel workbook with dummy data?

    277843
    02/02/2017
    $

    - or -

    Post a project like this
    Nick G.
    Nick G.
    100% (10)
    Projects Completed
    13
    Freelancers worked with
    12
    Projects awarded
    20%
    Last project
    21 Mar 2019
    United Kingdom

    Related project Searches


    real estate spreadsheets

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
    Cookie Settings
    Accept All Cookies