I need an excel template / book that can track a project and calculate investment returns (IRR) going in, and then follow up with an ACTUAL returns sheet after the fact. It will require the ability to calculate up to 120 months of returns, IRR, the ability to add in Capital Contributions, Loan Refinances, Capital disbursements, loan amortizations, capitalization inputs, Partnership splits, termination calculations, payoffs, amortization schedules, cash returns, growth rates, etc. etc. etc.
Hi Andrew,
My understanding is that you require an excel book (sheet/sheets) that will do the required calculations you have asked. I am assuming that you will provide all the formulae and the links between the inputs and the output. All that has to be done is design a layout which is user friendly and have the formulae built in.
I would love to assist you in this project.
Cheers
Vin
Please see PM for basic sample already created. I can complete the workbook within 3 business days for a total of $100 (unlimited revisions). Thank you for the opportunity.
Hi,
I am having 7+ years of experience in designing, developing and consulting desktop & web based applications using Microsoft Technologies. I have been using MS office 2003/2007 for almost 70% of my applications as I am working for an engineering company. I handle large & complex engineering datasheets in MS Excel or Access and then I need to convert them into SQL / Oracle / MySQL as per need by creating XML. Sometimes my client demands User interface so I create VB forms for user interaction with Excel ... and this is all in multi-user environment, sessions opened in multiple locations around the globe. The EPC's (engineering, procurement & commisioning) companies of Sabic group (Saudi Arabia) share these MS Access databases for setting up the plant. I have been actively doing all such activities.
I rate myself as 9/10 in VB 6.0
I am available in Yahoo messenger, MSN & Gtalk
Hoping to hear from you.
Regards
Annant S.
Dear Sir,
I have recently started bidding as a service provider. Consequently, I do not have any 3rd party references to verify my credibility.
I am willing to perform this job for whatever fee you deem reasonable. In the event you are not satisfied, I will forfeit any contracted payment amount and rework until you are satisfied.
I appreciate your time and consideration.
Client,
I will provide better service than other bidders because I created financial models like this while I was an analyst in a private equity group assigned to a $350 million commercial office property portfolio.
A model like this requires knowledge of real estate, promote structures, equity infusions, return calcs and dependencies.
I am proficient with ARGUS DCF.
I'd be pleased to help you with this project.
Scott
Work includes analyzing Excel file to gain complete understanding of the calculations and email exchange to more clearly define the final spreadsheet features. Spreadsheet will collect cash flows into monthly periods for internal rate of return analysis. Both "Baseline estimate" and "actuals w/ forecasted remaining cash flows" for comparison. Expanded features capital contribution, loan refinancing... Consider re-organizing annual operating data so you don't have 10 separate sheets - 1 for each year.
I am a MBA in Finance and have strong expertise in excel data modelling.I can take care of the requirements you mentioned and could provide you quality solutions.