Find Jobs
Hire Freelancers

Excel Spreadsheet formula help

$30-250 USD

Closed
Posted over 4 years ago

$30-250 USD

Paid on delivery
As an investor I lend money to builders. If a builder is building a home, I release funds to them 2x per month per home to cover invoices. the Builder pays me back once the home has sold. I charge an origination fee on the total funds and then an interest rate on the funds actually deployed until the loan is paid back. I need to I have a spreadsheet that dynamically fills Loan funds deployed, interest Accrued, Payback upon sales, Total Capital deployed with IRR and Total interest earned on each home and the entire portfolio. What I have done so far has taxed my excel skills. my vlookup function is not grabbing the right variables (I'm pulling my hair out with this). Here are the variables that I am working with: 1. # of Projects to start -How often to start them 2. Start Date of each project 3. Duration of each project [login to view URL] % charged [login to view URL] Rate [login to view URL] Sales date with variable control to model what it looks like depending on how fast it sells. I have created a skeleton. i need to get the rest of it built as quickly as possible. I believe that hte formula's are intermediate formulas that are just outside of my patience. Please read my comments in the cells
Project ID: 20245608

About the project

56 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
56 freelancers are bidding on average $111 USD for this job
User Avatar
Dear Employer, I fully understand your job and will do a perfect job for you. Please message me and let me work on your job. I am an excel expert and have created hundreds of such models before as well. Do please check my previous reviews once!! Thanks and Regards, Ash
$250 USD in 7 days
5.0 (237 reviews)
8.0
8.0
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$250 USD in 6 days
4.9 (438 reviews)
8.3
8.3
User Avatar
I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You can check my profile feedback section and you will know what my client asking for my work. I am Alison certified for Microsoft Office and Microsoft Excel. So, you can Trust me for a Best output with complete satisfaction. Your work will be delivered well in advance with seamless communication & timely response until project is completed. As well as for any alternation and query we are available 24 x7. Looking forward for great business deal. "
$55 USD in 1 day
4.9 (468 reviews)
7.9
7.9
User Avatar
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks .
$155 USD in 3 days
4.8 (91 reviews)
7.6
7.6
User Avatar
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
$100 USD in 2 days
5.0 (437 reviews)
7.6
7.6
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$100 USD in 1 day
4.9 (463 reviews)
7.8
7.8
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do anything make formula or script in excel :) please ping me now and im able to help you to build your formula for your excel THank you Galih
$50 USD in 2 days
4.9 (420 reviews)
7.4
7.4
User Avatar
Hi there, As an Excel expert i can create thst formula for you. Please feel free to contact me to discuss further details. Best regards Miljan
$183 USD in 2 days
4.9 (172 reviews)
7.7
7.7
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. It is a complex project that requires time and dedication. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$100 USD in 1 day
4.9 (302 reviews)
7.3
7.3
User Avatar
Greetings! I am a specialist in excel and can help you here. Look forward to hear from you. Thanks, RRC
$200 USD in 3 days
4.9 (77 reviews)
7.1
7.1
User Avatar
Hello there, I am an Excel expert and I worked in finance too. I can support you to create the formulas. I see you did few in tab test formula's. Please contact me and we can finish all thing today. Thank you.
$60 USD in 1 day
5.0 (221 reviews)
6.5
6.5
User Avatar
Hi, Please take a look at my reviews/portfolio for Excel projects here: https://www.freelancer.com/u/best4best I am ready to create an easy-to-use template for your requirement. Regards Mamta
$140 USD in 3 days
5.0 (214 reviews)
6.7
6.7
User Avatar
Hey there ! I would love to help you out with this project. I am a good Virtual Assistant,Data Researcher,Data Entry Operator,Data Scraper,Great with Excel and Word and a Detail Oriented person, whom delivers given project on deadlines. I read through the entire project and understood it. I am able to provide my work and show that i am capable of handling your projects. This is an Ideal Project for my Capabilities. Check my reviews to an idea about my work. Hope to hear from you. Thanks :)
$111 USD in 2 days
5.0 (65 reviews)
6.4
6.4
User Avatar
$ 30 ONLY !!!!! [BBA, MBA in AIS, & EXCEL FORMULA EXPERT] Sir, I have seen your attachment and I understand your requirements clearly. I can send you DRAFT project file to ensure my expertise. If you are 100% satisfied first, then award me the project. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Graph etc. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar
$30 USD in 1 day
5.0 (226 reviews)
6.2
6.2
User Avatar
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully and saw attached file. I think you should use VBA programming because VLookup has limited capabilities. VBA is powerful and flexible. I have done mostly Excel VBA Programming jobs. So, I can do this job nicely. Ready to start, please message me to discuss your project in more details. Thanks, Virendra
$250 USD in 7 days
4.8 (114 reviews)
5.9
5.9
User Avatar
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
$50 USD in 2 days
4.9 (83 reviews)
5.7
5.7
User Avatar
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entry, excel
$98 USD in 3 days
4.6 (104 reviews)
6.2
6.2
User Avatar
Dear Client, I am Expert in Excel Formula's. I have 5+ Years of Experience in Data Entry, Web Scrapping, Web Research and MS Office. I will be there during your working hours to provide support whenever you need. Let’s have a quick chat to discuss this project. Looking forward to hear from you soon. Thanks & Regards, Ritika Keshri
$30 USD in 1 day
5.0 (81 reviews)
5.4
5.4
User Avatar
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks .
$155 USD in 3 days
5.0 (11 reviews)
5.2
5.2
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/whitehorsetechn?w=f I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Ramesh
$120 USD in 3 days
4.8 (14 reviews)
5.3
5.3

About the client

Flag of UNITED STATES
Farmington, United States
4.8
4
Payment method verified
Member since Dec 24, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.