We are looking for someone to develop an excel worksheet to help us with the following:
-Asset Summary Report including valuation metrics
-Historical & Pro Forma Operating Results with performance metrics with up to 10 year pro forma with vlookup capability
-Valuation Analysis including subject property and sales comparable metrics
-Valuation Analysis including income approach
-Cash flow investment analysis with PV, NPV, IRR calculations including data table sensitivity analysis
-Rollup cash flow reporting including portfolio PV, NPV, IRR calculations
We are fine with you using an existing template and model that already has these functions and then customizing it to our needs. If you don't know what we are talking about, please don't apply We need someone who is knowledgable.
We already have other worksheets and are obviously very familiar with this as an analysis tool, we simply want to have our own custom created version.
When applying please...
-Give us references and examples of your work.
-Rererence your relevant experience and domain area expertise.
-Estimate the number of hours it will take you to complete the project (we understand that there may be additional tweaks we would request and that would cost more.)
We are open to doing this on an hourly basis or on a project basis with the right person. If we can find the right person to work with, we will likely have many other projects and opportunities in the future.