Kapalı

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.

Beceriler: Excel, Muhasebe, Mali Analiz, Finans

Daha fazlasını gör: 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

İşveren Hakkında:
( 85 değerlendirme ) southlake, United States

Proje NO: #21435291

Bu iş için 34 freelancer ortalamada $128 teklif veriyor

asin1987

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 Daha Fazla

$150 USD in 7 gün içinde
(178 Değerlendirme)
7.6
P0L

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 in 3 gün içinde
(312 Değerlendirme)
7.3
charleslimnet

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 Daha Fazla

$200 USD in 3 gün içinde
(248 Değerlendirme)
7.1
elqueabandona

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 Daha Fazla

$200 USD in 7 gün içinde
(227 Değerlendirme)
6.9
wsh2

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 Daha Fazla

$200 USD in 7 gün içinde
(30 Değerlendirme)
6.0
Baderah

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 Daha Fazla

$30 USD in 2 gün içinde
(87 Değerlendirme)
5.1
AkilaArun

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 Daha Fazla

$150 USD in 7 gün içinde
(40 Değerlendirme)
5.0
rashedkhanrubel

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(24 Değerlendirme)
4.2
writingapp

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 Daha Fazla

$80 USD in 3 gün içinde
(12 Değerlendirme)
4.2
Sen139

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 Daha Fazla

$150 USD in 7 gün içinde
(5 Değerlendirme)
3.7
ielucerotrad1

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, Daha Fazla

$100 USD in 5 gün içinde
(13 Değerlendirme)
3.9
AnowarRatul

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(26 Değerlendirme)
3.8
Aragornsan

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 Daha Fazla

$200 USD in 4 gün içinde
(5 Değerlendirme)
2.9
Rasel2543

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)
3.2
smartbookaccount

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 in 7 gün içinde
(5 Değerlendirme)
2.4
AhmedRagab321

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 --------------------------------------------------- Daha Fazla

$140 USD in 2 gün içinde
(2 Değerlendirme)
2.0
rogerreid

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 Daha Fazla

$140 USD in 7 gün içinde
(1 Yorum)
0.8
moh2020

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 Daha Fazla

$30 USD in 15 gün içinde
(1 Yorum)
1.0
brunovilela4219

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 Daha Fazla

$30 USD in 3 gün içinde
(1 Yorum)
0.5
Mad8Work

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.3