In Progress

Excel Expert Required

Excel Spreadsheet required to check the viability of candidates for home loans (mortgages)

The model must be dynamic, colourful and be able to provide a weekly budgetary brake down for year 1 and monthly breakdown for subsequent years.

The model must be encoded in the Euro Currency.

It must be full interchangeable and have the ability to handle 5 variable and 5 fixed loans for periods of 25,30,35 year depending on the option select . Ie.. Check the affordability if a person requests a mortage of 400,000 euro over a 35 year loan taking mortgage providers A policy which for example might be 4% APR per annum. On the main overview page it should allow users to easily switch between the variable and fixed loan options.

It must also have the ability for candidates the enter the outgoings such as transport costs, food, utilities, holidays, clothes , Socialising etc. The model should also have the option to increase these prices over the subsequent years by inflation. The model should allow users to change this figure easily. Ie.. Assumption Inflation rate will be an average of 3.5% over 35 year period etc..

This must also be the same for the wages section where users can impute there projected earnings per year for a 5 year period and then have the model increase their earnings for subsequent years by inflation etc...

The model should allow users to be able to change their tax rate easily. Ie.. tax will be 20% of the first 25000 euro of salary and 35% thereafter. However this should be adaptable so users can change the percentage and bands themselves accordingly.

The overview pages should then bring all of the information together in an easily readable format and show what the net income of the candidate will be per week, their projected mortgage outgoings and their income deductions such as utilities etc..

Skills: Data Entry, Data Processing, Project Management, Script Install, System Admin

See more: salary information, net salary, format prices, excel model expert, excel 16, adaptable, 25000 euro tax amount, excel expert salary, rate change, n excel, fixed prices, mortgages, model clothes, increase income, home loan, format excel, fixed income, expert excel, excel model, encoded, change currency, spreadsheet holidays, currency rate, excel mortgage, excel breakdown spreadsheet

About the Employer:
( 0 reviews ) Surrey, Ireland

Project ID: #193349

7 freelancers are bidding on average $81 for this job

deCODEtech

Hi, We can create the excel sheet before choosing your bid .If you give me details today, on monday it will be prepared as we're having two holidays here. Waiting for your positive response. Rakesh Kumar deCODE T More

$90 USD in 2 days
(1 Review)
3.4
ecorporate

I have handled over 16 related projects on excel.I can do this for you.

$90 USD in 5 days
(1 Review)
1.8
etindore

I can prepare this on 3 days. Thx

$85 USD in 3 days
(1 Review)
1.0
arnoldtanubrata

As part of my long term goals and values, I am focusing on a career that incorporates both my education and professional experience. I am eager to learn more and apply about the position of THE POSITION ADVERTISED an More

$100 USD in 2 days
(0 Reviews)
0.0
bizlight

Just provide me all the details and you have it by 3 days.

$80 USD in 3 days
(0 Reviews)
0.0
sbinfo

Hi Check pm for detail

$50 USD in 2 days
(0 Reviews)
0.0
Hemsundar

Hello sir this is vasu. I have solid expireance with excel. I can write formulas also. i am waiting for project. warm regards Vasu.T

$70 USD in 10 days
(0 Reviews)
0.0