Suljettu

Upgrade Preforma - Excel SpereadSheet - IRR and ROI

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 +/-

Taidot: kirjanpito, Liiketoiminta-analyysi, Excel, Rahoitus, Sijoitusanalyysi

Näytä lisää: irr calculator, roi analysis spreadsheet, roi excel, roi calculator excel template, convert irr to roi, roi template for it projects, how to calculate portfolio return in excel, project roi calculator excel, excel partition irr, excel unleveraged irr, excel levered irr, medical equipment data excel, irr excel function, implement excel irr function, project roi excel template, outsourcing roi calculator excel, failed irr calc excel, excel spereadsheet templates questionaire, irr function excel increase iterations, excel roi script

Tietoa työnantajasta:
( 352 arvostelua ) Westlake Village, United States

Projektin tunnus: #17003571

16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

schoudhary1553

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 Lisää

$250 USD 3 päivässä
(224 arvostelua)
7.4
$250 USD 12 päivässä
(69 arvostelua)
6.4
prakash1317

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.

$50 USD 2 päivässä
(24 arvostelua)
4.3
vkoliennikov

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 Lisää

$30 USD 3 päivässä
(1 arvostelu)
1.9
parameswar1015

A proposal has not yet been provided

$155 USD 3 päivässä
(0 arvostelua)
0.0
raghavajay3

A proposal has not yet been provided

$83 USD 3 päivässä
(0 arvostelua)
0.0
alejandracabo1

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 Lisää

$155 USD 1 päivässä
(0 arvostelua)
0.0
shabananjum

A proposal has not yet been provided

$166 USD 3 päivässä
(0 arvostelua)
0.0
ajahjoll

I have been working as a business advisor for a German bank for more than 6 months. My daily operations involve analyzing the business model of our clients and providing credit limits to clients that have potential in Lisää

$122 USD 2 päivässä
(0 arvostelua)
0.0
ngockhanh5110

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 Lisää

$222 USD 1 päivässä
(0 arvostelua)
0.0
SobiaJamshed

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 Lisää

$250 USD 5 päivässä
(0 arvostelua)
0.0
Rishabhwadhwa04U

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 Lisää

$30 USD 3 päivässä
(0 arvostelua)
0.0
Luminari27

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 Lisää

$222 USD 3 päivässä
(0 arvostelua)
0.0
dorisyeung

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 Lisää

$155 USD 3 päivässä
(0 arvostelua)
0.0
suahmed01

Dear Sir/Madam, I have about 24 years experience in bookkeeping and accounting works. I have also experienced in tax matter. I have completed my Chartered Accountancy articleship from KPMG Rahman Rahman Huq, Charter Lisää

$155 USD 3 päivässä
(0 arvostelua)
0.0
parminder1994

I m postgraduate, in CA final persuing CS also, I will ensure quality work from my side.

$155 USD 3 päivässä
(0 arvostelua)
0.0