Update and add features for preforma - Excel - Need to know IRR - ROI - Finance Background

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 the 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 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 $350 +/-

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

Näytä lisää: part time finance jobs from home, accounting data entry work from home, online financial consulting jobs, freelance finance jobs in india, freelance finance jobs, part time jobs for finance professionals, freelance finance manager, online finance jobs in india, need to add features on existing website, need know singapore payroll software, add features website, add comma text excel, project add features software, list need know norwegian words, add comma data excel, avian add features, web designers need know flash, access visual basic search update add record, need know sales people, need know slogan

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

Projektin tunnus: #17021832

Myönnetty käyttäjälle:


HI there, I can help. Thanks, RRC

$350 USD 15 päivässä
(71 Arvostelua)

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


Hello, I’m an Excel expert and I would like to help you with your project. Please send me a message so that we can discuss more.

$350 USD 5 päivässä
(274 arvostelua)

Dear esteemed client, I possess exceptional finance modelling skills and experience. I have successfully completed over 2000 related projects and the responses are positively overwhelming as you can see from my review Lisää

$350 USD 10 päivässä
(227 arvostelua)

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Lisää

$555 USD 10 päivässä
(73 arvostelua)

Hello? how are you? As you can see my reviews, I have good skills in this fiedls. So I can help you if you want. I will never disappoint you.

$333 USD 1 päivässä
(45 arvostelua)

Hi, After reading your project description about updating and adding features to your Proforma, I feel like you have me in mind when creating the project. I have all it takes to deliver. Rather than just show you p Lisää

$350 USD 1 päivässä
(32 arvostelua)

Hi there, my name is Vasily, and it will be pleasure for me to help you with your financial task. Contribute all my efforts, experience and skills for deliver best results to you. You can have a look in my profile Lisää

$355 USD 10 päivässä
(10 arvostelua)

Hi, I graduated from Penn State's honors college with a degree in finance. I have worked in both asset management and investment banking. My Excel skills are extensive. I know how to use all functions and tools and Lisää

$350 USD 2 päivässä
(4 arvostelua)

SFG is a financial market specialist we would easely complete your Excel calculation tasks. Best Regards

$333 USD 10 päivässä
(3 arvostelua)

Hi! Your projects sounds very interesting to me since I am a CFA charter-holder and an MBA from SDA Bocconi school of management. I have a 6 years of Work experience with 2 Fortune 500 companies in India and Italy r Lisää

$388 USD 5 päivässä
(2 arvostelua)
$555 USD 10 päivässä
(3 arvostelua)

Hi. Am only bidding on this project after downloading the files attached. Am comfortable to deliver on this job. I can even start immediately

$444 USD 10 päivässä
(3 arvostelua)

hi i am expert in excel and have financial background please consider

$250 USD 1 päivässä
(2 arvostelua)

hello we are a team of chartered accountants can help you with your investment project. let's chat to discuss it further and get your job done at the earliest.

$444 USD 5 päivässä
(1 arvostelu)

My Previous job provided me with ideal experience for this position. For three year ,I developed many of the skills required for this job. In particular my Finance skill and accounting experience makes me an ideal can Lisää

$322 USD 5 päivässä
(1 arvostelu)
$555 USD 10 päivässä
(0 arvostelua)

Sir I am a semi qualified chartered accountant in India. I have excellent knowledge in Excel, accounting and finance related activities

$500 USD 10 päivässä
(0 arvostelua)

I am a advocate practicing in tax matters .like Gst, Income tax. i have sufficient experience for handle work load .

$355 USD 10 päivässä
(0 arvostelua)

A proposal has not yet been provided

$555 USD 10 päivässä
(0 arvostelua)

I am submitting this proposal for the subject project. I am qualified accountant having fifteen years experience in Accounting & Finance and expert user of MS Office. I have complete knowledge of Financial Management/ Lisää

$333 USD 2 päivässä
(0 arvostelua)
$555 USD 10 päivässä
(0 arvostelua)