Save this Search
     

All JobsVBAFinance & Management

 (31 results)  
Sort by:
  • Posted Date
Fixed Price: $65 or less   |  Posted: Nov 20, 2015  |  Closed  |   2 Proposals
A bidding scenario will be given and must be solved doing monte carlo simulation through Crystalball program. If you are not an expert at excel do not apply. This is a simple task answering just four questions. Need it within 24hrs.
Category: Investment Analysis       

****
 [?]
Sign in to view client's details.
| Client
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Nov 02, 2015  |  Closed  |   18 Proposals
I am looking for an individual with very strong experience in using VBA for financial projects in general and assessment of structured cash flows in particular. I have the model and Excel based prototype. I need thorough Q/A & Q/C on the macro and potentially making modifications and fixing a number of issues. The job is listed as hourly, but we can discuss fixed fee as well after you review the model. This is not the job for someone just learning VBA or finance: please don't apply unless you have a strong relevant experience. Thank you, M
Category: Investment Analysis       
Skills: VBA, Financial modeling, Excel VBA       

f****kin
 [?]
Sign in to view client's details.
| f****kin
|    United States
Fixed Price: Less than $500   |  Posted: Nov 01, 2015  |  Closed  |   10 Proposals
the back comission is calculated on the net return at the moment but i need this exel sheet to be modified in a way so the backcomission is calculated on total return. the netwinnings are (return - stake) and the total is (stake + winning) so the backcomission must be calculated in the total on the new exel sheet.
Category: Tax Services       
Skills: Business Planning, Business Mathematics       

o****lla
 [?]
Sign in to view client's details.
| o****lla *
|    Albania
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Oct 25, 2015  |  Closed  |   7 Proposals
Hello, I have a spreadsheet which I use to manually populate stocks and shares data from internet sites (see document here   [obscured]  /redir?resid=FFDA477FC63D6805!1220&authkey=!AP6Ehd1SYZtz1_U&ithint=folder%2cxlsx): uk.finance.yahoo.com finance.yahoo.com google.com/finance morningstar.co.uk (subscription service, I can supply logon credentials) msn.com This is very time consuming, but with the use of Excel web queries and\or VBA this could be made much quicker. However this is beyond my skills, hence posting this project. The spreadsheet is used to examine financial data on UK companies. The overall goal of this project is to develop a spreadsheet which will identify company stocks that should be considered for investing. I am not working for a company, this is a personal project to help me manage my personal pension investments. The output should be compatible with Excel 2016. The websites provided are the ones I use, however I do not mind which websites ...
Category: Investment Analysis       
Skills: Microsoft Excel, VBA, Stock Market       

l****win
 [?]
Sign in to view client's details.
| l****win
|    United Kingdom
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Oct 23, 2015  |  Closed  |   10 Proposals
We need someone to help improve our clients workbooks: Qualified individual needs to be able to do the following: -Create 30/60/90 variance in Cashflow report -Write VBA code to automatically fill in employee name (would like a code where once you start typing in a few letters it suggests a name), ID, practice group -Have 2 workbooks talk to each other and data is automatically uploaded between the 2 -Create a baseline worksheet that automatically saves itself off -Write code that allows the user to lock in the data for previous months but modify it for upcoming months -Verify earned revenue formula is working -Be able to organize and make worksheets run more efficiently -Create code that allows the worksheets to be saved off at the end of every year -Other Excel based issues that arise
Category: Financial Reporting       

T****ach
 [?]
Sign in to view client's details.
| T****ach
|    United States
Fixed Price: About $20   |  Posted: Oct 17, 2015  |  Closed  |   9 Proposals
Hi, I would like to create new workbook files from each row in an excel file. If the workbook exists, then to add the row to the file. Here is more information- I have a pretty basic Excel macro request. I am attaching a file called FinanceTotalsAllStores. This is a file generated every day in the same format. If you could open that file, you can follow the steps that I need performed. Basically every line in column A which is NOT bolded is a different store. The date on the top is the date of the report. I need a macro which will add data from that day to individual workbook file (store file) for each store. In each store file, I want it to copy the date to column A and then the data from that day. Keep it in date order. If data exists for that date, show a popup showing that data exists and do nothing.
Category: Accounting       
Skills: Microsoft Excel, Excel VBA       

p****mit
 [?]
Sign in to view client's details.
| p****mit
|    United States
Fixed Price: Not Sure   |  Posted: Oct 15, 2015  |  Closed  |   7 Proposals
I need to find Excel experts who are also good at using Google sheets. People who have experience do cross-tabulation, statistical analysis, and creating dashboards are preferred. Must have experience working alone and with a team. When applying please tell me which times of the day you are typically free (please convert your time to PST).
Category: Other - Finance & Mgmt       

u****013
 [?]
Sign in to view client's details.
| u****013
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Sep 27, 2015  |  Closed  |   3 Proposals
Hello, I would like some help making a workbook template few macros. The basic idea would be to import a couple of financial .csv reports, and do some basic formatting, formulas and analysis.
Category: Financial Reporting       

e****ton
 [?]
Sign in to view client's details.
| e****ton
|    United States
Fixed Price: Not Sure   |  Posted: Sep 27, 2015  |  Closed  |   6 Proposals
I have a Excel macro that needs to be tweaked and dynamic range and logical formulas to be put in place so that the macro performs to its optimal potential. The candidate must be an expert in VBA and Needs to have a Skype and should be Willing to start immediately the assignment will not take more than a couple hours. More details provided to the right candidate. Candidate must know VBA very well.
Category: Accounting       
Skills: Bookkeeping, Accounting, Analytics       

R****_po
 [?]
Sign in to view client's details.
| R****_po *
|    India
Hourly Rate: $10 - $15 / hr   |  Duration: 1-2 weeks  |  Posted: Sep 26, 2015  |  Closed  |   4 Proposals
I have a Excel macro that needs to be tweaked and dynamic range and logical formulas to be put in place so that the macro performs to its optimal potential. The candidate must be an expert in VBA and Needs to have a Skype and should be Willing to start immediately the assignment will not take more than a couple hours. More details provided to the right candidate. Candidate must know VBA very well.
Category: Accounting       
Skills: Microsoft Excel, VBA       

a****ush
 [?]
Sign in to view client's details.
| a****ush
|    India
Fixed Price: Not Sure   |  Posted: Sep 13, 2015  |  Closed  |   21 Proposals
Seeking a strategic analyst to assist in developing financial models. Must have exceptional skills in Excel with VBA expertise (highly desired), CPA/CFO/Finance background. Role requires performing research on gaming and casino markets and developing or modifying (adding sheets, cells, VBA coding and reliable data) to excel spreadsheets for a publicly listed company. Subject to the quality of work produced, the role may lead to ongoing work in a variety of industries.
Category: Financial Planning       

R****ise
 [?]
Sign in to view client's details.
| R****ise
|    Australia
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Aug 22, 2015  |  Closed  |   3 Proposals
Design a product according to prediction of the market and a write up needs to be submitted. The write up needs to include: 1. Prediction and opinion on the market. 2. Explain the product's structure and profit. 3. Scenario analysis, including the worst case scenario. 4. Pricing demonstration, including all data, hypothesis explanation(if any) and risk index.
Category: Financial Planning       

j****omi
 [?]
Sign in to view client's details.
| j****omi
|    Singapore
Hourly Rate: $10 - $15 / hr   |  Duration: 1-2 weeks  |  Posted: Aug 20, 2015  |  Closed  |   3 Proposals
I have a Excel macro that needs to be tweaked and dynamic range and logical formulas to be put in place so that the macro performs to its optimal potential. The candidate must be an expert in VBA and Needs to have a Skype and should be Willing to start immediately the assignment will not take more than a couple hours. Please include your skype ID for Immediate start of the project. More details provided to the right candidate. Candidate must know VBA very well.
Category: Accounting       
Skills: Microsoft Excel, VBA       

a****ush
 [?]
Sign in to view client's details.
| a****ush
|    India
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 16, 2015  |  Closed  |   7 Proposals
We are looking to build a portfolio monitoring tool in Excel. We will complete the top level conceptual design it in house and give you detail of its core functionality. Beyond that, you will be responsible for the design and build of the tool. ] The tool will consist of 4 key elements: a reporting system for asset managers to provide information on a quarterly basis, a "one page" summary sheet for each asset that concisely displays all relevant information in a well designed format, an interactive dashboard that displays trends over time and that allows the asset manager to isolate different variables, assets, and time periods and, lastly, a portfolio overview that concisely captures relevant information, forecasts and history for distribution to investors. We are under time pressure and would like this completed in the next 3 weeks. Due to the time pressure we would like to see proposals as soon as possible. Review the attached scope and outline and get in contact with r...
Category: Investment Analysis       

****
 [?]
Sign in to view client's details.
| Client
|    United Arab Emirates
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 13, 2015  |  Closed  |   2 Proposals
We are looking to build a portfolio monitoring tool in Excel. We will complete the top level conceptual design it in house and give you detail of its core functionality. Beyond that, you will be responsible for the design and build of the tool. ] The tool will consist of 4 key elements: a reporting system for asset managers to provide information on a quarterly basis, a "one page" summary sheet for each asset that concisely displays all relevant information in a well designed format, an interactive dashboard that displays trends over time and that allows the asset manager to isolate different variables, assets, and time periods and, lastly, a portfolio overview that concisely captures relevant information, forecasts and history for distribution to investors. We are under time pressure and would like this completed in the next 3 weeks. Due to the time pressure we would like to see proposals as soon as possible. Review the attached scope and outline and get in contact with r...
Category: Investment Analysis       

****
 [?]
Sign in to view client's details.
| Client
|    United Arab Emirates
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 11, 2015  |  Closed  |   18 Proposals
We are looking to build a portfolio monitoring tool in Excel. We will complete the top level conceptual design it in house and give you detail of its core functionality. Beyond that, you will be responsible for the design and build of the tool. ] The tool will consist of 4 key elements: a reporting system for asset managers to provide information on a quarterly basis, a "one page" summary sheet for each asset that concisely displays all relevant information in a well designed format, an interactive dashboard that displays trends over time and that allows the asset manager to isolate different variables, assets, and time periods and, lastly, a portfolio overview that concisely captures relevant information, forecasts and history for distribution to investors. We are under time pressure and would like this completed in the next 3 weeks.
Category: Investment Analysis       

****
 [?]
Sign in to view client's details.
| Client
|    United Arab Emirates
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 10, 2015  |  Closed  |   17 Proposals
We are looking to build a portfolio monitoring tool in Excel. We will complete the top level conceptual design it in house and give you detail of its core functionality. Beyond that, you will be responsible for the design and build of the tool. ] The tool will consist of 4 key elements: a reporting system for asset managers to provide information on a quarterly basis, a "one page" summary sheet for each asset that concisely displays all relevant information in a well designed format, an interactive dashboard that displays trends over time and that allows the asset manager to isolate different variables, assets, and time periods and, lastly, a portfolio overview that concisely captures relevant information, forecasts and history for distribution to investors. We are under time pressure and would like this completed in the next 3 weeks.
Category: Investment Analysis       

****
 [?]
Sign in to view client's details.
| Client
|    United Arab Emirates
Fixed Price: Not Sure   |  Posted: Aug 08, 2015  |  Closed  |   7 Proposals
I need someone to make some excel charts a little more pretty. only contact me if you have experience doing this.
Category: Other - Finance & Mgmt       
Skills: Microsoft Excel, Statistics, Excel VBA       

u****013
 [?]
Sign in to view client's details.
| u****013
|    United States
Fixed Price: $75 or less   |  Posted: Aug 07, 2015  |  Closed  |   17 Proposals
I'm requesting a single excel document that can calculate the current mortgage balance. Preferably without VBA or if using VBA/macros must have extremely well documented code because I will need to convert it for the project I'm using it with. I'll need to be able to see the formulas so I can figure out how to integrate the functionality in a programing application. Take the following fixed information (first time use information) 1. Original Loan amount 2. Origination Date 3. First Payment due date 4. Minimum principle and interest payment amount (monthly) 5. Term (fixed only?10yr 15yr, 20yr or 30yr) And the following information that will change each time the sheet is used 6. Current Balance(from last statement) 7. Todays date (the payment applied date) 8. Payment amount (could be any positive number) And see what the updated balance is? EXAMPLE: Take the following fixed information (first time use information) 1. Original Loan amount: 184,095.00 2. Origination Date: 12/20/201...
Category: Accounting       

****
 [?]
Sign in to view client's details.
| Client
|    United States
Fixed Price: Not Sure   |  Posted: Aug 06, 2015  |  Closed  |   6 Proposals
I need a serious VBA guru to look at a file for me a remove the serial entry to unlock the sheet. Basically the sheet is uneditable and the guys that made it can't unlock it so I need it cracked. I think it could be my version of excel that is also causing problems. I can provide the real Serial number and the file to anyone with the skills. It's a little sensitive so I'd prefer not sharing it with the world. I'll submit it to anyone who can get it sorted. Please just submit your VBA skills and I'll engage anyone who looks like they have the skills. You can download a blank version of the sheet here to try it out.   [obscured]  /free-trial.html you can download it here. In detail: I've brought a financial model and it comes with a Serial Number entry from SpringExcel. I got a serial when I brought it and I've entered that serial and it won't unlock it. Then I contacted Jeff the owner of spring excel and he said he'can't understand why it's not unlocking and has as...
Category: Other - Finance & Mgmt       

e****nts
 [?]
Sign in to view client's details.
| e****nts
|    Australia
Fixed Price: About $20   |  Posted: Aug 01, 2015  |  Closed  |   22 Proposals
Quick Job I need a spread sheet created to track my business activities. It would be need to track my monthly activities and revenue on a daily basis, calculate the number daily, weekly and a total for the month. The heading i would require are Day/Month/Year 2015/2016 Staff Name Targets for the following (adjustable per week/month) & results tracked daily. 1. Leads 2. Conversations 3. appointments Booked 4. Appointments Confirmed 5. Sales Total 6. Cash Received 8. Profit Results (calculated per week/month - also shows a running total i.e.. if target was 200 calls and i made 95 it would show 105 to go) Feedback (area where i can leave feedback/coments) 9. Expenses 10. Profit Loss I would also like it to be bright and colourful!
Category: HR Policies & Plans       

d****324
 [?]
Sign in to view client's details.
| d****324
|    Australia
Fixed Price: Less than $500   |  Posted: Jul 28, 2015  |  Closed  |   21 Proposals
I have an XLS that helps me project costs and revenue of my AirBNB rental, but it's locked. I'd love for someone to recreate it cell by cell in an unprotected format. Attached. If it goes well, I may have another project to add in optimization features.
Category: Financial Planning       

j****222
 [?]
Sign in to view client's details.
| j****222
|    United States
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job