Excel - Profit and Loss combining multiple investments

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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.

Excel

Project ID: #16826173

About the project

34 proposals Remote project Active 5 years ago

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
(25 Reviews)
4.9

34 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
(277 Reviews)
7.6
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
(273 Reviews)
7.2
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
(87 Reviews)
6.8
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
(206 Reviews)
6.8
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
(26 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.3
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
(37 Reviews)
5.0
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
(31 Reviews)
5.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
(13 Reviews)
4.8
ScareCrow01

I can help. Thank You

£111 GBP in 3 days
(19 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
(14 Reviews)
3.6
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
(6 Reviews)
3.9
varshil8060

Hi, I have 6+ years of experience in IT industry and can help you create the EXCEL file you are looking for. I can help you create the Profit & Loss statement to account the details as on the start date the investme More

£111 GBP in 3 days
(0 Reviews)
0.0
salionduka

Hi there. I am new here, but I am very good at excel. I have automated many tables related to sales, target achievement etc., with many variables affecting the result (very long formulas). Relevant Skills and Experien More

£133 GBP in 2 days
(0 Reviews)
0.0
NehadSalem

with my long experience in Excel and MIS and financial Data , and being new to this web site, i will make sure to deliver that project successfully

£166 GBP in 3 days
(0 Reviews)
0.0
SofiaSE

Hi! As you can see on my profile, I have worked as an assistant to high level managers at a large financial institution. In that role, I often have put together spreadsheets similar to the one you describe. I am More

£90 GBP in 2 days
(0 Reviews)
0.0
arbers227

This year I've studied excel at school and got a 100/100 average (meaning I got perfect scores in every exam and quiz)

£111 GBP in 3 days
(0 Reviews)
0.0
Naru4215

A proposal has not yet been provided

£111 GBP in 3 days
(0 Reviews)
0.0