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