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

Evner: Regnskab, Forretnings Analyse, Excel, Finans, Finansanalytiker

Se mere: 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 Asp.net 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

Om arbejdsgiveren:
( 347 bedømmelser ) Westlake Village, United States

Projekt ID: #17021832

Tildelt til:


HI there, I can help. Thanks, RRC

$350 USD in 15 dage
(71 bedømmelser)

25 freelancere byder i gennemsnit $402 på dette job


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 in 5 dage
(274 bedømmelser)

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 Flere

$350 USD in 10 dage
(227 bedømmelser)

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 Flere

$555 USD in 10 dage
(73 bedømmelser)

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 på 1 dag
(45 bedømmelser)

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 Flere

$350 USD på 1 dag
(32 bedømmelser)

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 Flere

$355 USD in 10 dage
(10 bedømmelser)

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 Flere

$350 USD in 2 dage
(4 bedømmelser)

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

$333 USD in 10 dage
(3 bedømmelser)

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 Flere

$388 USD in 5 dage
(2 bedømmelser)
$555 USD in 10 dage
(3 bedømmelser)

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 in 10 dage
(3 bedømmelser)

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

$250 USD på 1 dag
(2 bedømmelser)

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 in 5 dage
(1 bedømmelse)

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 Flere

$322 USD in 5 dage
(1 bedømmelse)
$555 USD in 10 dage
(0 bedømmelser)

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

$500 USD in 10 dage
(0 bedømmelser)

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

$355 USD in 10 dage
(0 bedømmelser)

A proposal has not yet been provided

$555 USD in 10 dage
(0 bedømmelser)

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

$333 USD in 2 dage
(0 bedømmelser)
$555 USD in 10 dage
(0 bedømmelser)