Upgrade Preforma - Excel SpereadSheet - IRR and ROI
$30-250 USD
Pago na entrega
Tasks:
Expand on current proforma and create a full Proforma wth IRR, ROI Based on investment
"IRR - I just calculate IRR based on the cash flows. you are correct, to compute the real IRR we need in include the capital/investment. I think we can do that part in the next phase of the project."
1. Look at what we have so far as a basis to continue this project
2. We want to expand on the last version and put financials projections and ROI and IRR if we get an investment of 100MM in our assumption...How much we can bring return on 100MM investment ...also I like you to build it on cost of capital of only 5% per year ( Put param borrowed money rate ) and that can be changed to 4% per year and 3% is default per year ..and the rate which we will charge client will be 1.25 per month or 16% per year ...to the client...so there is like 13%-14% profit per year we can generate per client...But I want you to put default 5% borrowed money rate year, and 1.25 per month or 16% per year for the client..
3. please take 100MM into investment into company for :
Clients Funding 60%
Marketing 10%
Underwriting Costs, Employees/Salaries, Account Management,Payroll Tax 15%,
Software Dev/BC: 5%
Legal, Accounting : 5%
Office Lease, Equipment, Misc 5%
4. 60% of 100MM will go to deploying the capital into new accounts...giving the physicians the money ...80% upfront....assuming 120 days or be safe 5 months or 150 days account is fully paying off...remember we sign client for at least 1 year ...So in theory in 150 days we should be paying off the first month of billing where we advance 80% of client funding need...So like 5 months to be safe delay till an account if fully paid off from insurance companies close to 95%-100 % of billed amount ...(when we underwrite an account we assume we collect close to 100% of what billed)
#4 is very important and you to include into the proforma since that help to calculate the delay in profits and payback from each account we fund(80% upfront)
You have to include tha in your performs upgrade including
All costs and use the Budget deployed and calculate IRR and ROI of the 100M investment( add to assumptions)
and if we change investment amount - will affect the IRR and ROI and profits
Calculate break even point, IRR, ROI after we introduced investment into spreadsheet
** Let us know if you have any questions !
Thanks
Please include in preforma also what we attached here
More detail and info we need to take into account
See all additions
Budget $300 +/-
ID do Projeto: #17003571
Sobre o projeto
16 freelancers estão ofertando em média $153 nesse trabalho
Hi there..... Warm Greetings We came along with your request for Upgrade Preforma - Excel SpereadSheet - IRR and ROI and we reviewed your project description. We'd like to help you with confidence and satisfying Mais
I have gone through your project details. I'm confident to assist you with my experience in similar projects. If you award this project, I'll do my maximum to complete this work accurately / timely.
Hello. I have all skills one needs to complete your task. Nevertheless I fell that you have to provide me some additional information about your project in order to understand your demands and how my experience could Mais
I am the most skilled person in financial analysis and strategy. Will need from your description and information available in excel and what is the results you want: eg. Marginal contribution, etc Relevant Skills an Mais
Hello, I am Khanh, an associate auditor at EY Vietnam, one of the four biggest auditing companies in the world. My experience revolves around book-keepings, entries journalize at a lower level; and making financial Mais
Hi I am a certified charted accountant. I thoroughly reviewed and understood what you are looking for here. I have performed this task before In my professional career. I can share previous work sample if you want to h Mais
Hello Sir, I am a semi-qualified Chartered Accountant with 3 years work experience in Excel spreadsheet.I work on almost all functions of Excel pivot table to VLOOKUP.I will work for company and individual with on-tim Mais
Hello there, Based on your assumptions and details provided, I can build an interactive forecast model. However, I would need some more details about the industry. I can provide you examples of performa and forecasts Mais
I am an accountant at PwC (one of the big four accounting firms) and calculating measures such as IRR is within my day to day job. I believe my experience in excel will help me complete the task! Relevant Skills and E Mais
I m postgraduate, in CA final persuing CS also, I will ensure quality work from my side.