Save this Search
     

All JobsVBAFinance & Management

 (291 results)  
Sort by:
  • Posted Date
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  |  Ends: 7d, 6h  |   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       

t****shi
 [?]
Sign in to view client's details.
| t****shi
|    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       

t****shi
 [?]
Sign in to view client's details.
| t****shi
|    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       

t****shi
 [?]
Sign in to view client's details.
| t****shi
|    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       

t****shi
 [?]
Sign in to view client's details.
| t****shi
|    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
Fixed Price: Less than $500   |  Posted: Jul 25, 2015  |  Closed  |   14 Proposals
Hi So we are launching a new network marketing company with a pretty much forced matrix whereby there's only 5 tiers down. (depth fixed at 5 tiers) and width is pretty much unlimited (meaning you can always add new people under you). We will be using an affiliate marketing software to track commission generated and whose under you. The product itself is $400. You are buying the first $400 to join as a distributor. Assuming you are generating 2 downlines, you pretty much break even at first tier... 1st tier sales - 50% commissions x 2 downlines 2nd tier - 5% x 4 3rd tier - 5% x 8 4th tier - 5% x 16 5th tier - 5% x 32 The above is only for the first sale from your downlines. For subsequent sales through your downlines, it's all at 5% commission. We do want to take into account what we can earn in subsequent sale too. We want an excel...
Category: Financial Planning       

u****ize
 [?]
Sign in to view client's details.
| u****ize
|    Singapore
Fixed Price: Less than $500   |  Posted: Jul 14, 2015  |  Closed  |   7 Proposals
We need an Excel macro and designed excel report that will take the data in the QuickBooks Enterprise and QuickBooks that will create a daily dashboard . The dashboard will be used each month and capture all data for the month. We will then save this dashboard in our files and start a new one the next month. The dashboard will need to calculate the following: ? Total sales from previous day ? Total AR ? AR Collected from the previous day ? % of AR collected from previous day ? Cash on hand ? Inventory 1 Account ? Inventory 2 Account ? Gross Margin % I would also like to have the customized report compare the previous day's data with the prior day's results and the prior months. On a separate excel tab, we need graphs that will update each day, so that on the first of the month there is only one day's of activity, but by the end of the month, the graph will show the entire month's activity day-to day. I will need the following graphs: ? graph of the sales activity ? Grap...
Category: Financial Reporting       

s****e00
 [?]
Sign in to view client's details.
| s****e00
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 13, 2015  |  Closed  |   4 Proposals
Hi, I need a forex algorithm in Excel VBA to automate trades based on decisions that will be made purely by price movements and tick data. Broker to be used would be IG and linked with their API to fully automate the trading process. There are a multiple levels to the trading logic, but need to know if someone is able to do this prior to discussing details openly.
Category: Investment Analysis       
Skills: Excel VBA, forex       

o****s88
 [?]
Sign in to view client's details.
| o****s88
Fixed Price: Less than $500   |  Posted: Jul 07, 2015  |  Closed  |   7 Proposals
Please help me create the following rules for the attached work bookwork. 1. On the LLC, Sales, Dev, GC, SI, A, A01 and FM tabs create the following conditional formats 1.a. If any number both positive and/or negative is entered into Current Adjustment (Column G), turn the corresponding Note cell in Column P light green. See LLC tab for hard coded example. 1.b. If Cost to Date (Column M) exceed Total Committed Cost Column K, turn the corresponding Cost to Date cell Red 1.c. If Total Committed Cost (Column K) exceeds Current Budget After Adjustment (Column J), turn the total Committed Cost Orange. 1.d. In the Cash Flow tab, please setup a conditional format to change the cells a color that fall between the Start Date and Fish Date Range 2. On the Allocation Tab please create a multiple array function or some other type of formula that will pull the cells that have "Current Adjustments" on the Allocation Summary tab in order by tab. See hard coded example in the Allo...
Category: Other - Finance & Mgmt       

m****b21
 [?]
Sign in to view client's details.
| m****b21
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Jul 06, 2015  |  Closed  |   21 Proposals
Looking for someone to build, design and send 5 Area Managers weekly reports on their individual Sales representative's Commission Balances on a weekly basis. Details of the assignment: Initally: 1. Design data format to be able to present "Copy of Commission Statement" attachment in pivot table format based. The data will be a combination of the data sources I send to you: Data sources: 1. Zoho CRM report for sales (Students) that have passed confirmation date (Census date) - please see Zoho Report Example 2. Excel Workbook of how weekly pay has been calculated each week, includes the database of the students that were paid against. Please see "Commission Data 07-07-15" attachment as an example. - Best to work off of this and build your data format to spit out the report For the calculations: Each student is $450 confirmed at Census Date for an EA (Sales Representative Each student is $75 confirmed at Census date for a Team Leader including their own sales. Ongo...
Category: Financial Reporting       

****
 [?]
Sign in to view client's details.
| Client
|    Australia
Hourly Rate: $20 - $30 / hr   |  Duration: 1-3 months  |  Posted: Jun 26, 2015  |  Closed  |   7 Proposals
I am very interested in learning the basics of financial modelling, in particular projecting the three statements, linking them, calculating IRR etc... As of now I have a sound working understanding of a number of concepts in both accounting and finance, having completed the CFA Level I exam and having recently sat the 2015 CFA Level II exam. I am also open to any suggestions that you may have, i.e. directing my learning toward what you feel is most important to know around analyst/starting level in IBD or Sales & Trading at an investment bank. I look forward to hearing from you. SP
Category: Investment Analysis       
Skills: VBA, Accounting, BASIC       

S****993
 [?]
Sign in to view client's details.
| S****993
|    United Kingdom
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 22, 2015  |  Closed  |   11 Proposals
please see attached PDF. It is not necessary for the programmer to understand anything about finance. just Excel programming. The description PDF should be clear enough.
Category: Investment Analysis       
Skills: Microsoft Excel, Excel VBA       

k****d01
 [?]
Sign in to view client's details.
| k****d01
|    United States
Fixed Price: Less than $500   |  Posted: Jun 18, 2015  |  Closed  |   3 Proposals
attached is the file with the explanation inside. its simple to understand - i have not found a quick solution while googling it - so if you take a look and know the solution please bid. if not - don't waste my time, if i had 3 days to research myself i would do it myself. thx
Category: Financial Reporting       

g****ova
 [?]
Sign in to view client's details.
| g****ova
|    Israel
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 14, 2015  |  Closed  |   19 Proposals
Looking for some quick Excel guidance with likely more work to follow. Specifically, seeking assistance creating a nested ISERROR AND OR statement for an average function. I want to exclude '0' values. Please reach out if you're interested in the job and think that you can provide assistance. Additionally, please let me know your rate. Thanks.
Category: Financial Reporting       
Skills: Microsoft Excel, Excel VBA       

****
 [?]
Sign in to view client's details.
| Client
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Jun 10, 2015  |  Closed  |   28 Proposals
Excel Expert needed for consulting, estimating, and problem solving several questions. Example would be parsing out data from single cell into multiple (using formulas), creating chart to better visualize data, etc. Only need a few hours of your time. Please respond ASAP.
Category: Other - Finance & Mgmt       
Skills: Microsoft Excel, Excel VBA       

j****cld
 [?]
Sign in to view client's details.
| j****cld
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: Not Sure  |  Posted: Jun 07, 2015  |  Closed  |   6 Proposals
guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded guru neeeded
Category: Financial Reporting       
Skills: Excel VBA       

D****sen
 [?]
Sign in to view client's details.
| D****sen
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