In Progress

ROI caluclation - Pro Forma - for Medical factoring - simple spreadsheet - 2 days max

This an interesting project. We provide all data.

You will provide a financial proforma and an ROI/IRR on investment prediction for these type of receivables.

See all the data inside the Zip Files.

We will give you assumptions and based on that you need to provide spreadsheet and financial proforma on IRR/ROI

for investing in these type of receivables.

Assumptions:

1. We only refer to medical factoring where medical providers bill the medical insurance carriers

for medial claims and get paid in no more than 120 days. ideally we like to factor receivables in the 30 - 60 days range.

2. Factor rates are the interest % the investor make on the money advanced and collected. usually it is charged weekly. see sample Term sheet

or monthly. typically if a claim gets paid over 30 days the interest will accrue/compounded

We want to keep it simple

Typical factor rates are:

REST IN ZIP FILE ATTACHED

It does not need to be fancy..just clean and detailed and show ROI/IRR caluclation and we want to show our investors

if they put lets say 0.5% per month in capital or 1% month in capital

and X Millions per month as we grow..what will be Net Profits from this factoring

Show all that and what we ask in the specs for project

Has to be in Excel SpreadSheet/s and even if you have a word doc or some diagram( option only) will be extra cool.

remember we give you sample data

and provider does not provide finanicals..we give you collection and aging report and based on that you build rev potential..based on cost of money and profit variable parameters ..it is very easy !

Any questions let us know.

WE NEED IT IN 48 HOURS from bid acceptance

if you cant DO NOT BID!

$150 Budget -/+

Thanks

Skills: Data Entry, Data Processing, Excel, Finance, Statistics

See more: multifamily pro forma spreadsheet, retail real estate pro forma, free real estate pro forma, return on investment template, roi report template, simple roi template, return on investment worksheet, how to calculate roi for a project, roi chart excel templates, formula to calculate return on investment, how to calculate monthly return on investment, development pro forma real estate, real estate development pro forma spreadsheet, pro forma modeling excel, real estate pro forma sample, real estate pro forma example, excel real estate pro forma, free real estate investment pro forma excel pdf, excel pro forma real estate, accounting excel formulas pro forma

About the Employer:
( 370 reviews ) Las Vegas, United States

Project ID: #15529605

Awarded to:

daniyal3214

I am a professional Financial Analyst and excel expert with years of experience in preparing similar financial models and financial analysis using advance level tools of Excel. Relevant Skills and Experience I will More

$50 USD in 1 day
(107 Reviews)
6.0

11 freelancers are bidding on average $128 for this job

usmanhassan123

MPhil in STATISTICS

$77 USD in 1 day
(48 Reviews)
5.8
$155 USD in 3 days
(38 Reviews)
5.5
imran2093

Hello Sir/Madam, I am able to do this project. I have a similar experience. I will give you exact accurate work within [login to view URL] I can help your other stuff. Thank you for your time Relevant Skills and Experience Data More

$35 USD in 3 days
(8 Reviews)
3.1
Sohaibkhann99

I will provide accurate data entry and work for your project for one week. Please, contact me before ordering this gig, so that I know exactly how to help you and contribute to your project. If you need a data ent More

$152 USD in 3 days
(1 Review)
1.4
$155 USD in 3 days
(0 Reviews)
0.0
mrkongkan

Hello, I have seen your job details and I want to do your job. I am able to meet all of your demands. Please give me a chance to do your job. Thank you. Regards, Mrikongkan Relevant Skills and Experience I have a lot More

$150 USD in 2 days
(0 Reviews)
0.0
Shohanurzaman

Hi, When I learned of your need for a Data Entry Clerk, I hastened to submit the enclosed resume. As a dedicated professional with solid experience in accurate and timely data entry. Relevant Skills and Experience Wit More

$133 USD in 1 day
(0 Reviews)
0.0
robbinrush852

Hello sir, I am a professional data entry operator.I am doing full time data entry work in other [login to view URL] i am new in this market.I have many of experiences in data entry and data collect. Relevant Skills and E More

$155 USD in 3 days
(0 Reviews)
0.0
nhernandez2017

I look forward to working on this project. I have an MBA and have worked multiple years in Mergers and Acquisitions. Thanks for providing the background info and assumptions Habilidades y experiencia relevante I have More

$211 USD in 2 days
(0 Reviews)
0.0
FredyCastellanos

A proposal has not yet been provided

$138 USD in 2 days
(0 Reviews)
0.0