[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.
34 freelanceria on tarjonnut keskimäärin 128$ tähän työhön
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.
$ 30 Only ------ In just 12 Hours ------- BBA, MBA in accounting------ Excel Data Entry, VBA Macro and Formula Generation Expert ------ 100% satisfaction first, then payment.
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.
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