Excel help to create IRR and MOIC results within an existing cashflow
- or -
Post a project like this$
- Posted:
- Proposals: 14
- Remote
- #1407700
- Expired
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
PowerPoint Template design | Brand Identity | Logo Design | UX design | Print design | Website design
Houston
Big 4 Experience | Business Services | Consulting | Financial/Valuation Models | Research | Bookkeeping | Taxes
Ahmedabad
Consultant- Market research, Data analysis, Social media, Primary and Secondary research
Chennai
1429861140641644372013718271415095980049148038314558801228050137642413913201480900
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