Build an overlay matrix for each investor with a summary page - excel - COVID 19

$10-30 USD

In Progress

Posted

about 4 years ago

$10-30 USD

Paid on delivery

I need completed by 4/12/2020 - In an excel format that is attached, break down each investor on separate tabs, then put on the first tab a colored summary based on loan programs. Excel format already done, just need to copy paste and fill in blanks Loan programs: Conventional - FNMA Fannie Mae or FHLMC Freddie Mac FHA VA Break Down needed: Minimum Credit Score's allowed Max DTI or debt to income ratios allowed Income guidelines Rental income guidelines vs Agency Self employed income overlays vs Agency Verification of Employment criteria. Forbearance information- Age of documentation ( ie. 30, 45, 60 days I will attach most of them from the individual investors information and I would like it transferred into an excel worksheet for easy readability. ***First start off with agency - Fannie and Freddie - they are the Agency ones and they are the foundation to the rest. Amerihome Caliber First Guarantee(FGMC) Flagstar Freedom Homepoint Mr. Cooper New Rez Planet Home Plaza PRMG The Money Source Towne ( nothing needed on this one ) = they follow Agency Guidelines. USBANK Excel sheet attached.

Project ID: 24854807

About the project

15 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Adarsh225

Hello, This is Adarsh. I hope you've gone through my profile. After reading your job description, I consider myself that I am eligible for this work because I have experience in the field of Data Entry, Excel, Data Processing, Word. I assure that my work will be accurate and efficient. I can work 35-40Hrs per week. I hope you will contact me soon. Thank you, Adarsh.

$20 USD in 7 days

0.0

(0 reviews)

0.0

15 freelancers are bidding on average $60 USD for this job

@editchamp

Hey, I can completed by 4/12/2020 - In an excel format that is attached, each investor on separate tabs.I will Excel format already done, just need to copy paste and fill in blanks. Waiting for your reply Thanks

$20 USD in 7 days

5.0

(158 reviews)

7.1

@rinabuoy13

Hello, I am an independent, experienced excel / vba expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$30 USD in 1 day

5.0

(105 reviews)

6.3

@daniyal3214

I can perfectly help you with that. I am a professional Data Analyst, Data Scientist and Data Visualization expert holding years of experience. in Excel, VBA, SQL, Power BI, Tableau and various other tools to perform automation and develop dynamic and automated tools. I will be happy to discuss in detail how I am highly suitable for this project.

$30 USD in 1 day

4.6

(172 reviews)

6.4

@maulikaparikh

Hello, I am Maulika from India having a superior experience in data entry. PDF Conversion & All type of Excel work as well as paper document to digital entry. Working for a Canadian Transportation company like the same you require. Looking forward to work with you.

$10 USD in 1 day

5.0

(8 reviews)

5.7

@satishtl

Hi, - Each investor could be arranged in separte tabs with the breakdowns as needed. provided the datapoint for the breakdowns are provided. - Summary on the first tab according to the various loan programs. - Have good expertise in Excel automation and help on reporting from these data points and consolidation. - Have given approximate bid, based on full details will arrive at the final one. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl

$30 USD in 4 days

4.7

(49 reviews)

6.0

@azharqazi786

I am expert in ms office all softwares Relevant Skills and Experience MS office 2016

$78 USD in 1 day

0.0

(0 reviews)

0.0

@DrilonSh

Hello, My bank career has also given me experience in MS Office, i can successfully help you in realizing this project and others in future, i now this field and can use my skills to successfully finish this job. Do you need the spreadsheet to be protected? Is it better if we highlight or use special font in lets say titles or any of contents? Also for more details i suggest to chat. Thank you for having in consideration my proposal. Kind regards, Drilon

$450 USD in 5 days

0.0

(0 reviews)

0.0

@anandkakarla78

A strong Analytical team with good working skills on excel, Visual Basic and more to make this project a success. Look forward Relevant Skills and Experience Excel, Visual Basic

$25 USD in 3 days

0.0

(0 reviews)

0.0

@FionaZ77

I am skilled in EXCEL. I studied in Mathematical Finance and I quite familiar with business analysis. Due to the COVID-19, I have plenty of time staying at home. Thus, I can work efficiently and effecitvely.

$30 USD in 7 days

0.0

(0 reviews)

0.0

@daya78477

Hi, I live in the US. I can help you. I am ready to get started ASAP. Please let me know if you’re interested. Thank you

$89 USD in 2 days

0.0

(0 reviews)

0.0

@jazvilloga

i can finish this task fast and accurate and also on time

$25 USD in 1 day

0.0

(0 reviews)

0.0

@simurad977

I have also experienced Relevant Skills and Experience Give me

$15 USD in 1 day

0.0

(0 reviews)

0.0

@DHEYA060

i will do your job .. i have good Experience in excel and type of this projects ... i will do it as you want and as you need and i will edite any things you want ...

$20 USD in 7 days