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

35 freelancers are bidding on average £116 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
(261 Reviews)
7.5
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
(272 Reviews)
7.2
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
(203 Reviews)
6.8
£100 GBP in 3 days
(306 Reviews)
6.9
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
(76 Reviews)
6.7
£150 GBP in 1 day
(51 Reviews)
6.1
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
(23 Reviews)
5.1
£61 GBP in 3 days
(67 Reviews)
5.3
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
(14 Reviews)
5.2
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
(32 Reviews)
4.8
£50 GBP in 1 day
(38 Reviews)
5.1
khurram1984

Hi. Your investment time period problem can be solved by making a sheet with proper formulas to reflect the proportionate income of its period, and then added to the total income.. You can share the sheet and I can wor More

£120 GBP in 2 days
(20 Reviews)
4.6
ScareCrow01

I can help. Thank You

£111 GBP in 3 days
(18 Reviews)
4.1
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
(14 Reviews)
3.6
£55 GBP in 3 days
(10 Reviews)
3.5
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
lightingdavid

Hello. I have read your project description carefully. I have rich experiences in EXCEL. I'm interested in your project and i can do it. Contact me please. Thanks.

£200 GBP in 3 days
(4 Reviews)
2.9
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
£222 GBP in 10 days
(0 Reviews)
0.0