In Progress

Excel - Profit and Loss combining multiple investments

I am looking to get a profit and loss spreadsheet for property investment.

I have started to buid one but have become stuck on certain aspects of it.

It needs to be able to combine multiple investments accross time periods. The issue arising is that the investment may not start at the same period and I would need the overview sheet to show this. For example Investment 1 Starts month -2 in January and Investment 2 starts month -2 in April. This posses an issue as I would like the Profit loss displayed yearly.

The profit loss account would need to incoporate this in such away that further investments can be added into it as time goes on.

Skills: Excel

See more: excel profit loss statement trial balance, excel profit loss stock, cash flow statement format excel profit loss, profit loss stock excel, stocks profit loss excel, stock profit loss calculator excel, sample profit loss statements excel worksheet, profit loss job excel, profit loss calculation excel format, excel stock profit loss calculator, calculate profit loss projects excel, excel stock profit loss sheet, template excel quartley profit loss statement, sample profit loss excel statement, excel accounting profit loss example

About the Employer:
( 0 reviews ) London, United Kingdom

Project ID: #16826173

Awarded to:

katiewells3

I am a business analyst with expert level Excel and a strong finance background and I would love to work with you on this project. I am extremely comfortable working with financial data (and concepts) and have built nu More

£150 GBP in 3 days
(24 Reviews)
4.9

36 freelancers are bidding on average £117 for this job

schoudhary1553

Greetings of the day! I am the best fit to your requested requirement. I can help you in Excel - Profit and Loss combining multiple investments. My Expertise & Experience: I am skilled in Excel. I would love More

£160 GBP in 3 days
(216 Reviews)
7.3
£100 GBP in 3 days
(301 Reviews)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

£150 GBP in 5 days
(180 Reviews)
6.7
P0L

Hello, I’m an Excel expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.

£120 GBP in 1 day
(245 Reviews)
7.0
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag More

£150 GBP in 3 days
(50 Reviews)
6.1
£150 GBP in 1 day
(32 Reviews)
5.5
£61 GBP in 3 days
(32 Reviews)
4.5
£50 GBP in 1 day
(22 Reviews)
4.7
vaidyag

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in I More

£50 GBP in 3 days
(9 Reviews)
4.3
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, More

£100 GBP in 1 day
(16 Reviews)
4.2
ScareCrow01

I can help. Thank You

£111 GBP in 3 days
(14 Reviews)
3.8
c4cuteconain

I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department currently serving as manager fiance and can complete your project as described

£100 GBP in 3 days
(24 Reviews)
4.2
swajantalukdar

Hello Will help you to create a sheet in such way that you can take any decision very easily. I mean the visualization of the data will be precise and clear. Regards Atiar T.

£100 GBP in 1 day
(9 Reviews)
3.8
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions and Macros using VB, the most important thing is t More

£100 GBP in 2 days
(7 Reviews)
3.0
£150 GBP in 3 days
(4 Reviews)
3.1
prakash1317

I have gone through your project in detail & I understood your requirements. I'm confident to assist you with my experience in similar projects. If you award this project to me, I'll do my maximum to complete the work More

£40 GBP in 2 days
(7 Reviews)
3.2
sanjibsahanew

Hi I would like to work for you. I will provide highly credible excel template as required by you paper with my senior level experience. You may validate my profile which is also certified as “Preferred Freelancer” More

£100 GBP in 5 days
(5 Reviews)
3.8
£55 GBP in 3 days
(5 Reviews)
2.9
£222 GBP in 10 days
(0 Reviews)
0.0
MTarr

We can index data to classify timelines for each investment and use separate tab to summarise annual p&l with Sumproduct or sumifs Relevant Skills and Experience I have over 20 years experience working with excel in a More

£200 GBP in 2 days
(0 Reviews)
0.0