Find Jobs
Hire Freelancers

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

$250-750 USD

Completato
Pubblicato quasi 6 anni fa

$250-750 USD

Pagato al completamento
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 +/-
Rif. progetto: 17021832

Info sul progetto

25 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
HI there, I can help. Thanks, RRC
$350 USD in 15 giorni
4,8 (71 valutazioni)
6,4
6,4
25 freelancers are bidding on average $402 USD for this job
Avatar dell'utente
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 giorni
4,9 (274 valutazioni)
7,1
7,1
Avatar dell'utente
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 portfolio. With over 10 years of cross-functional experience, and helping clients world wide with diversify team, I provide genuine and innovative solutions as per your circumstances and requirements. I am MBA-Finance, M.A-Economics, and Qualified Chartered Accountant. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Rakesh
$555 USD in 10 giorni
4,9 (73 valutazioni)
6,4
6,4
Avatar dell'utente
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 in 1 giorno
4,8 (45 valutazioni)
6,0
6,0
Avatar dell'utente
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 past similar projects, I want to exceed your expectation by completing a part of your job as a FREE sample before you award the project. If you are satisfied with the result, you can go ahead and award the project. Please let my reviews do the talking. Do you want me to start working on the sample right away?
$350 USD in 1 giorno
4,6 (32 valutazioni)
5,4
5,4
Avatar dell'utente
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 for references about quality of my work and my previous experience. It would be great to have chat with you for discuss details.
$355 USD in 10 giorni
4,4 (10 valutazioni)
5,1
5,1
Avatar dell'utente
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 know basic VBA coding. I've read through the project and it seems simple enough. Feel free to check out the financial model I built that's in my portfolio for an M&A transaction. I think I would be the ideal candidate for this project. I guarantee you will be satisfied with my work. Best, Cameron
$350 USD in 2 giorni
5,0 (4 valutazioni)
3,7
3,7
Avatar dell'utente
SFG is a financial market specialist we would easely complete your Excel calculation tasks. Best Regards
$333 USD in 10 giorni
5,0 (3 valutazioni)
2,9
2,9
Avatar dell'utente
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 resp as a Corporate Finance Manager. During this experience, I was responsible for Mergers & Acquisitions, Strategic Financial Decisions, I built financial budgets- P&L, balance Sheets and Cash Flow, forecasts, valuation, business cases, NPV/IRR and cost models, supply chain and working capital optimization levels etc. Besides, I have done many business plans & financial models with companies in different industries such as fintech/IT, food and beverage, consumer electronics etc., of which I am working with 2 to set-up their financial processes. I have helped a few of the start-ups raise Seed and Series A funding of approx. $5m. During these assignments, I wrote traditional b-plans, Pitch-decks, BMCs and also constructed financial forecasts, budgets, pro-forma Income Statement, Balance Sheet and Cash Flow, valuation metrics etc. Additionally, I have worked with investment banks as an external consultant and have done a total deal size of approx. $50 mn. Very recently, I just concluded the forecast, valuation, merger deal finalization for two companies in Music Industry (Deal Size: $9m) and A deal in F&B ($8 mn). I am currently working with an online platform start-up that I valued at $24 mn for a potential $5 mn deal. Thanks Mayank Talwar, CFA
$388 USD in 5 giorni
5,0 (2 valutazioni)
2,8
2,8
Avatar dell'utente
hi i am expert in excel and have financial background please consider
$250 USD in 1 giorno
5,0 (2 valutazioni)
1,9
1,9
Avatar dell'utente
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 giorni
5,0 (3 valutazioni)
1,8
1,8
Avatar dell'utente
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 giorni
5,0 (1 valutazione)
0,3
0,3
Avatar dell'utente
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 candidate for this position.
$322 USD in 5 giorni
5,0 (1 valutazione)
0,5
0,5
Avatar dell'utente
I have a degree in Business Economics, from which I learned intermediate skills at finance to calculate ROI, IRR and Accounting 101. When I finished the program, I was hired by Deloitte as a Transfer Pricing Consultant, where I acquired accounting and advanced finance knowledge. This background makes me a good fit for the job proposal.
$250 USD in 10 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Respected Sir/Madam I would like to undertake this assignment as I feel I am the right person for this job; I have plenty of experience regarding Financial Analysis and Excel Modeling which means that I will be able to do the job efficiently and also in timely fashion. I have also looked into the attached files and the things that need to be included in the model. It will take me approximately 5 days to complete the project after examining each and every entry made in the file. Be assured that everything will done according to your satisfaction! Furthermore if you want to know how I will go forward with the project, please feel free to ask me! Looking forward to hearing from you Regards Hamza Shah
$333 USD in 5 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$555 USD in 10 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
We are a professional CPA and accounting services provider Over 10 years of experience Located in LA
$333 USD in 7 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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/Capital Budgeting techniques. I can complete your assignment according to your satisfaction within given time. Please feel free to contact me with confidence.
$333 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I am a advocate practicing in tax matters .like Gst, Income tax. i have sufficient experience for handle work load .
$355 USD in 10 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
Westlake Village, United States
4,9
347
Metodo di pagamento verificato
Membro dal mar 3, 2010

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.