Excel help to create IRR and MOIC results within an existing cashflow
- or -
Post a project like this$
- Posted:
- Proposals: 14
- Remote
- #1407700
- Expired
Big 4 Experience | Business Services | Consulting | Financial/Valuation Models | Research | Bookkeeping | Taxes
Microsoft Certified Advance Excel Specialist¦Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦Excel related any Work¦Macros of Excel¦

PowerPoint Template design | Brand Identity | Logo Design | UX design | Print design | Website design

Consultant- Market research, Data analysis, Social media, Primary and Secondary research
1429861443720980049113672712280501371827137642413913201406416141509514558801480383





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:
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.
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 inClarification Board Ask a Question
-
Hello, Could you provide a excel workbook with dummy data?
277843
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