Debugging a pro-forma Excel worksheet - non-macro, only functions

[login to view URL]

Please find attached worksheet. I am looking for an accountant type who understands spreadsheets very well. You will find attached a very robust spreadsheet that has some circular reference issues when we change some variables. There is no VBA to worry about, only spreadsheet design and functions.

The design of this spreadsheet is as follows:

1. We have 10 building projects of 30 units each which we are building one right after another. The buildings are exact replicas of each other so their costs will be the same. The building costs are found on tab RR ConceptBud.

2. The Dashboard tab controls most of the variables (Spreadsheet 3). This spreadsheet is saved in 3 views and it is easier to work on each section through their views. My immediate problem is when I change the Start month from previous project, I get a circular reference problem. Cells C6 to C15 are the months when the next project starts relative to the previous project. The circular references come from me modifying all the Equity Partner Cashflows on each project (for example line 1121 for project 1 - see second spreadsheet).

3. What this spreadsheet is trying to do is look at sources of funds from 4 sources, 1. Outside investor investment, 2. Bank Loan, 3. LLC Equity (our money), and 4. Sales. You will see these sources in the revenue portion. Outside investor funds are used first, then loan, then our money, and sales comes in independent of those three sources. The spreadsheet is divided into two major sections of data, one is the Project cash flows (spreadsheet 1) and the second is the outside investor waterfall (spreadsheet 2). The model makes heavy use of the Switch command (for instance line 9 on the project cash flow - spreadsheet 1) so we can change the months which we do the project controlled from the dashboard.

4. I need someone to grow with me in this project to help modify and maintain the spreadsheet as we go through our project. This project will get off on the right foot with me explaining the project and the spreadsheet in detail in a chat.

5. Look forward to a long relationship with the right person.

Taidot: Excel, kirjanpito, Sijoitusanalyysi, Rahoitus

Näytä lisää: real estate pro forma excel, excel pro forma worksheet real estate, accounting excel formulas pro forma, free real estate investment pro forma excel pdf, pro forma modeling excel, real estate development pro forma excel, pro forma excel, pro forma excel worksheets, print worksheet using macro excel, sample real estate development investment excel pro forma, free real estate pro forma excel, excel monthly pro forma financial statements, pro forma financial statements excel, prepare pro forma balance sheet excel, excel pro forma income statement, property pro forma excel

Tietoa työnantajasta:
( 85 arvostelua ) southlake, United States

Projektin tunnus: #21435291

34 freelanceria on tarjonnut keskimäärin 128$ tähän työhön


Dear Employer, I will do any Excel based job of yours. It can be functions, Dashboards, Graphs, Pivots, Slicers, VBA etc. Please message me, I would love to collaborate for a long term relationship. I am an expert w Lisää

$150 USD 7 päivässä
(178 arvostelua)

Hello, I’m an Excel expert and I would like to help you with your worksheet. Please check my profile and contact me to discuss further details. Regards.

$150 USD 3 päivässä
(312 arvostelua)

I possess exceptional data science and statistical analysis experience. I use Excel, STATA, R-Programming and SPSS software’s in qualitative and quantitative research and report writing. I hold MBA (Strategic Managemen Lisää

$200 USD 3 päivässä
(248 arvostelua)

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Lisää

$200 USD 7 päivässä
(227 arvostelua)

Greetings from Easton PA, USA.. {smile} Quite a few external workbook references. Will likely recommend you employ a single MsAccess database (DB) to consolidate as an Excel/DB setup has huge reporting benefits. Highl Lisää

$200 USD 7 päivässä
(30 arvostelua)

I am an experienced chartered accountant with advance level expertise in Ms Excel. Therefore, I can aptly undertake your task. I went through your Excel file, and I assure you that I can undertake this work and complet Lisää

$30 USD 2 päivässä
(87 arvostelua)

Hi, I am interested in working on the task. I have more than 5 years of experience working with excel, excel macros, Data analysis, report generation and creating dashboards. Looking forward to discuss further. Best R Lisää

$150 USD 7 päivässä
(40 arvostelua)

Hi, I have understand the project requirement & interested to modify or update excel template for this project. Please send a message so we can discuss more & start the project. Thanks.

$40 USD 1 päivässä
(24 arvostelua)

Hi. I can write projects in long term for you. Great app writer for your projects. I have writen scraping, excel, googlesheet, csv, database app, macro, vba for many years. I am ready to write your project. Thank you f Lisää

$80 USD 3 päivässä
(12 arvostelua)

Hi. I am an accounting professional with high proficiency in Excel and other Microsoft office programs. I ensure efficiency in carrying out my tasks. It would be a big privilege to be part of this project. I hope you w Lisää

$150 USD 7 päivässä
(5 arvostelua)

I can do the job! Nothing to difficult, but will require some time analyzing all the sheets. If necessary, we can communicate via voice call (I speak english with an almost native accent because I was raised in USA, Lisää

$100 USD 5 päivässä
(13 arvostelua)

$ 30 Only ------ In just 12 Hours ------- BBA, MBA in accounting------ Excel Data Entry, VBA Macro and Formula Generation Expert ------ 100% satisfaction first, then payment.

$30 USD 1 päivässä
(26 arvostelua)

Hi there, I am an accountant from South Africa and I have extensive Excel and MSOffice experience. I specialise in excel report design, but can do most tasks needed in excel. I have a solid understanding of accounting Lisää

$200 USD 4 päivässä
(5 arvostelua)

Hello there, I am excel expert. I am good at Excel formula, VBA, Macro. If you want to done your task perfectly and accurately then please contact me. Hope to hear from you. Thanks.

$30 USD 1 päivässä
(11 arvostelua)

Dear Sir, I trust you are well, I am a chartered accountant and an expert in Excel. I can support you to get this job done. I am waiting for your hearing. Many thanks, Kajee

$200 USD 7 päivässä
(5 arvostelua)

Dear I read your description and I have found that your job very interesting And it would be easy to be done at a short time you can see my work in the profile --------------------------------------------------- Lisää

$140 USD 2 päivässä
(2 arvostelua)

Hello, I am a CPA CMA and I have extensive knowledge with MS Excel. I have reviewed your spreadsheet and I can help you with the issues you are having. I can complete this work with 100% accuracy and very high qualit Lisää

$140 USD 7 päivässä
(1 arvostelu)

I am an accountant with many years of experience in various accounting activities I graduated in 2005 Also a programmer specializing in accounting and administrative programs I have a great experience in Excel and Lisää

$30 USD 15 päivässä
(1 arvostelu)

Hello, I'm an experienced Excel user, and have been working with smart tools and analysis for already 10 years. This experience includes KPI's consolidation, big databases management, budget planning, advanced formula Lisää

$30 USD 3 päivässä
(1 arvostelu)

i can fix bugs and i am expert in that. plz text me.....................................................

$166 USD 1 päivässä
(1 arvostelu)