Excel Specialist

Search more jobs

The work required: Automate and simplify an in-house built Excel Real Estate Financial Viability Appraisal.

Remove old codes and coding to prevent errors from happening within the tool, requires working in the developer function in Excel.
Automate cash flows based on inputting number of months for the real estate development stages (pre-planning, planning, void and construction) with the option to select functions as linear, s-curve or manual payments, each stage should have a start and end date and its own cashflow.
Automate professional fee cash flow based on the programme; see point 2.
Automate finance structure and interest fees, including payment schedule and sales strategy
Incorporate IF functions to reduce the time it takes to fill out the appraisal.
Use class: residential, industrial, office, retail, leisure etc.
Sqm and sqft to be shown separately or together
Automate the land value tab to include developers’ profit and STAMP Duty calculation based on an actual formula. The Deal structure should also be incorporated whether it is a JV, unconditional purchase, subject to planning, airspace lease or DM proposal.
Revenue and finance fees are to be added to workings and include an option for golden brick.
Revenue inflow to be automated based on the sale’s start and end of the rental occupation start and end.
Create a sensitivity table that can change between Revenue and Cost based on market fluctuation and sqft/sqm adjustments.
  • More than 30 hrs/week
  • 6+ months
  • Expert
    Experience Level
  • Remote Job
  • Ongoing project
    Project Type

Skills and Expertise

Microsoft Excel Data Analysis

Activity on this job

  • 10 to 15
    10 to 15
  • 5 days ago
    Last viewed by client
    5 days ago
  • 0
  • 0
    Invites sent
  • 0
    Unanswered invites

About the client

Member since Oct 6, 2022
  • Netherlands
    4:43 pm
  • 5 jobs posted
    0% hire rate, 5 open jobs
  • Member since Oct 6, 2022

Explore similar jobs on Upwork

Senior Data Analyst
Fixed-price ‐ Posted 7 minutes ago
Data Analysis SQL Python Power Query
Data analysis
Hourly ‐ Posted 15 minutes ago
Microsoft Excel Data Analysis Data Visualization

How it works

Post a job icon
Create your free profile

Highlight your skills and experience, show your portfolio, and set your ideal pay rate.

Talent comes to you icon
Work the way you want

Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.

Payment simplified icon
Get paid securely

From contract to payment, we help you work safely and get paid securely.

Want to get started?

About Upwork

Stars rating
(Average rating of clients by professionals)
G2 2021
#1 freelance platform
Signed contract every week
Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by
Microsoft Logo Airbnb Logo Bissell Logo GoDaddy Logo