Save this Search
     

All JobsVBAFinance & Management

 (252 results)  
Sort by:
  • Posted Date
Fixed Price: Less than $500   |  Posted: 6h, 55m ago  |  Ends: 14d, 17h  |   4 Proposals
I would like a monthly and YTD management dashboard report based on various financial statements below. The report should include critical operational and financial data and kpis. Monthly data is actual and plan and will be uploaded every month. - Balance sheet - PL account - Cash flow - Cost analysis Please feel free to provide with samples with your proposal. Model should be excel base and no programming. Attach is just an example of how it could look like.
Category: Financial Reporting       

R****r80
 [?]
Sign in to view client's details.
| R****r80 *
|    Norway
Fixed Price: Not Sure   |  Posted: 23h, 59m ago  |  Ends: 14d, 0h  |   15 Proposals
Looking to have a finance/excel ace build out of workbook financial model for our IPO clients. Workbook would consist of a detailed discounted future cash flow model with variable inputs; risk free rates, tax rates, beta, cost of equity, terminal growth rate compared against various initial public offering scenarios - number of shares offered, price per share, total dollar amount of offering. We want this to be a tool that we can use to both propose pre-ipo valutions and price (we are a law firm) and dilution to the original shareholders, as well as having the ability to utilize tthe workbook to run various scenarios. I myself have extensive excel knowledge and financial knowledge, but lack the time to devote myself to this project.
Category: Investment Analysis       

a****esq
 [?]
Sign in to view client's details.
| a****esq
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 21, 2015  |  Ends: 10d, 19h  |   11 Proposals
I would like to setup a macro to track our budget and compare it to actuals. I would be interested in importing the actuals from an excel spreadsheet generated from Quickbooks and importing it into an excel sheet with the macros. Thanks, Mike
Category: Financial Planning       
Skills: Excel VBA       

m****eze
 [?]
Sign in to view client's details.
| m****eze
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 21, 2015  |  Closed  |   8 Proposals
I would like to setup a macro to track our budget and compare it to actuals. I would be interested in importing the actuals from an excel spreadsheet generated from Quickbooks and importing it into an excel sheet with the macros. Thanks, Mike
Category: Financial Planning       
Skills: Excel VBA       

m****eze
 [?]
Sign in to view client's details.
| m****eze
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 17, 2015  |  Ends: 6d, 4h  |   7 Proposals
Hi, We are trying to create a portfolio management reporting template in PowerPoint. The idea is to create a template, possibly using VBA as well, to create PowerPoint slides from different tabs from Excel. Description: - Various tabs in Excel and then generate into PowerPoint slides. - Ideal scene is to generate each tab in Excel into a slide in PowerPoint (open to discussion for other options) - involves lots of numbers and graphs in the Excel - formulas or VBA to calculate periodic returns from a range of monthly data (for example of 1 month, 3m, 6m.... 24months returns) Requirement: - Advanced skills and experience in Excel and PowerPoint - Advanced skills in Excel VBA - Have done previous jobs similar to the one now. - Good Elance ratings. Thank you very much. Will So
Category: Financial Reporting       
Skills: Financial Reporting       

l****123
 [?]
Sign in to view client's details.
| l****123
Fixed Price: Less than $500   |  Posted: Apr 10, 2015  |  Closed  |   9 Proposals
Pretty straight forward. I need a command button created Place button in cell F38 of tab "Calculate Your ROI". Name button "Apply" Action should be If value in D38 = 'Yes', then hide rows 61 to 68 If value in D38 = 'No', then hide rows 40 to 60
Category: Financial Reporting       
Skills: Microsoft Excel, VBA       

L****a26
 [?]
Sign in to view client's details.
| L****a26
|    United States
Hourly Rate: More than $50 / hr   |  Duration: Not Sure  |  Posted: Apr 08, 2015  |  Closed  |   43 Proposals
Hello, My team is looking for someone with strong Excel skills who is familiar with formulas such as VLOOKUP, AVERAGE and data manipulation. It is also desirable for your to have VBA knowledge and some experience within finance (although not necessary). This project is well paid and can start immediately after an initial conversation. Best, Andrew
Category: Other - Finance & Mgmt       

A****wTh
 [?]
Sign in to view client's details.
| A****wTh
|    United Kingdom
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 07, 2015  |  Closed  |   19 Proposals
i have two excel sheets , one is daily prices for currencies . and the other is for the same currencies but it show them each tab for a single currency . i want No. 1 to read from No.2 . Both attached here .
Category: Financial Reporting       
Skills: Microsoft Excel       

t****idi
 [?]
Sign in to view client's details.
| t****idi
|    Jordan
Hourly Rate: $15 - $20 / hr   |  Duration: Not Sure  |  Posted: Apr 03, 2015  |  Closed  |   5 Proposals
Strong technical background with a degree of MIS. Proficient in programming language. ex Java, SQL and C#. I am interested in Finance and have many relevant experiences about it.
Category: Investment Analysis       
Skills: Java, VBA, SAS, 3D Printing, Microsoft SQL CE       

l****008
 [?]
Sign in to view client's details.
| l****008
|    United States
Fixed Price: Less than $500   |  Posted: Mar 29, 2015  |  Closed  |   2 Proposals
I have say 40 sheets that have unique IDs (1,2,3,4,5) in column "A" but the IDs (of course) have a different starting row on each page, thankfully their order on each sheet is the same, so their offset to the IDs on the master sheet will be constant. I need code that when ran: 1) Takes the user's active cell on the single master sheet (only sheet the user views) and asks the # of rows they would like to insert. 2) Automatically inserts the same # of rows on sheets "Blue", "Dragon", "Apple", etc. (37 more) at the same appointed ID as ActiveCell or on the master sheet. 3) Autofills only new rows with formulae and conditional formatting from respective last old row above in each sheet, but does not copy down hardcoded data. I would like this done with offset as opposed to a lookup, the offset of each sheet may be the different or the same as other sheets relative to the Master sheet but it will be constant, set and forget.
Category: Other - Finance & Mgmt       
Skills: Microsoft Excel, VBA       

j****ane
 [?]
Sign in to view client's details.
| j****ane
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: 7-9 months  |  Posted: Mar 27, 2015  |  Closed  |   3 Proposals
I'm looking for someone who can improve my real estate model by making it more user friendly, while maintaining the integrity and complexity of the formulae.
Category: Other - Finance & Mgmt       

f****noz
 [?]
Sign in to view client's details.
| f****noz
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Mar 27, 2015  |  Closed  |   20 Proposals
I would like to be able to run a sensitivity analysis on IRR calculations with 3-4 variables changing, so to see the various results.
Category: Other - Finance & Mgmt       

M****el1
 [?]
Sign in to view client's details.
| M****el1
|    Hong Kong SAR, PRC
Fixed Price: Less than $500   |  Posted: Mar 23, 2015  |  Closed  |   9 Proposals
I need someone to build my model in excel/VBA - from bloomberg data. roughtly three simple models. Volatiltiy and Interest rate spread ratio - then ranking CDS - visualization Perhpas some options valuations and few other bits 150 fix
Category: Investment Analysis       

S****bFX
 [?]
Sign in to view client's details.
| S****bFX
|    Switzerland
Fixed Price: Not Sure   |  Posted: Mar 18, 2015  |  Closed  |   7 Proposals
New York Lotto   [obscured]  /wps/portal/Home/Lottery/Home/Jackpot+Games/LOTTO/Lotto+-+How+to+Play   [obscured]  /wps/portal/Home/Lottery/Home/Jackpot+Games/LOTTO/Lotto+-+Chances+of+Winning   [obscured]  /wps/portal/Home/Lottery/Home/Jackpot+Games/LOTTO/Lotto+-+Drawings+and+Prizes Please simulate the drawing of the New York Lotto game in Excel using controls, built in functions, macros, VBA scripts. [a] Please record the simulated winning numbers for 10 years (i.e. 1040 games). [b] Please plot a histogram to examine the likelihood of each number being drawn ============================================= Please find the attachments. Thanks
Category: Other - Finance & Mgmt       
Skills: Microsoft Excel, Statistics, VBA       

m****152
 [?]
Sign in to view client's details.
| m****152
|    Saudi Arabia
Fixed Price: Less than $500   |  Posted: Mar 18, 2015  |  Closed  |   6 Proposals
I have 40 sheets that have unique IDs (1,2,3,4,5) in column "A" but the IDs (of course) have a different starting row on each page, thankfully their order on each sheet is the same, so their offset to the IDs on the master sheet will be constant. I need code that when ran: 1) Takes the user's active cell (or asks for the column "A" ID to insert below) on the single master sheet (only sheet the user views) and asks the # of rows they would like to insert. 2) Automatically inserts the same # of rows on sheets "Blue", "Dragon", "Apple", etc. (37 more) at the same appointed ID as ActiveCell or user dictated ID as on the master sheet. 3) Autofills only new rows with formulae and conditional formatting from respective last old row above in each sheet, but does not copy down hardcoded data. $20USD
Category: Other - Finance & Mgmt       
Skills: Microsoft Excel, VBA       

j****ane
 [?]
Sign in to view client's details.
| j****ane
|    United States
Hourly Rate: $12 - $20 / hr   |  Duration: 3-4 weeks  |  Posted: Mar 15, 2015  |  Closed  |   3 Proposals
Looking for an efficient Excel designer who has plenty of experience with advanced excel functions and tools. You can work with minimal direction and build reports with user friendliness and customer in mind. You should also be a confident English speaker as you will need to interact with our customers and represent our business. We are looking for someone who can work with our customers, understand their needs and build KPI reports. You will design excel reports based on our requirements in an efficiently, and user friendly design with nice clean KPI charts. Understanding of Zoho Reports and Zoho CRM also bonus (highlight this as well) You should be a customer oriented thinker and be able to quickly grasp ideas and turn them into powerful reports. Excel Experience and skills that are absolutely necessary are pivot tables, Vlookup, macros, VBA Here is an example video of how the excel report writer system works and how you may design and import a report   [obscured]  /watch...
Category: Accounting       
Preferred Location: North America, Western Europe, Eastern Europe

****
 [?]
Sign in to view client's details.
| Client
|    Canada
Hourly Rate: $5 - $12 / hr   |  Duration: 3-4 weeks  |  Posted: Mar 12, 2015  |  Closed  |   8 Proposals
Looking for an efficient Excel designer who has plenty of experience with advanced excel functions and tools. You can work with minimal direction and build reports with user friendliness and customer in mind. You should also be a confident English speaker as you will need to interact with our customers and represent our business. We are looking for someone who can work with our customers, understand their needs and build KPI reports. You will design excel reports based on our requirements in an efficiently, and user friendly design with nice clean KPI charts. Understanding of Zoho Reports and Zoho CRM also bonus (highlight this as well) You should be a customer oriented thinker and be able to quickly grasp ideas and turn them into powerful reports. Excel Experience and skills that are absolutely necessary are pivot tables, Vlookup, macros, VBA Here is an example video of how the excel report writer system works and how you may design and import a report   [obscured]  /watch...
Category: Accounting       
Preferred Location: North America, Western Europe, Eastern Europe

****
 [?]
Sign in to view client's details.
| Client
|    Canada
Fixed Price: Less than $500   |  Posted: Mar 05, 2015  |  Closed  |   1 Proposal
I have a list of 100,000 investments which I need some information on. This information is on morningstar.com. I need some code that will be able to search for the investment via Google. Select the Morningstar website. Then download the data from that page. Then organise the data into a standard table.
Category: Investment Analysis       
Skills: Python, VBA       

B****n11
 [?]
Sign in to view client's details.
| B****n11
|    United Kingdom
Fixed Price: Not Sure   |  Posted: Feb 28, 2015  |  Ends: 3d, 6h  |   11 Proposals
attached repo_test2 and basket2.xlsx is for this task. there are requirements for every term one contract has mentioned in repo.xlsx and ur task is to search all the contracts in repo.xlsx and find out those can satisfy the requirements in the basket. and produce a new excel to put those ones. i wil be looking fwd to your sample macro. second task is for those two doc - data for the trade balance and draw the flow chart. specific description is in the docx. basically i wanna draw a chart in excel exactly like the one in doc - kindly advise if this is possible and lets start from here. thanks!
Category: Other - Finance & Mgmt       
Skills: Microsoft Excel, VBA, Data Interpretation       

L****cks
 [?]
Sign in to view client's details.
| L****cks
|    Singapore
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 27, 2015  |  Closed  |   5 Proposals
I have an investment model that has several input cell ranges in different tabs. I want to compares changes from previous versions, note the impact to my return forecasts and comment on changes in a sheet.
Category: Investment Analysis       
Skills: VBA       

l****vo7
 [?]
Sign in to view client's details.
| l****vo7 *
|    United States
Fixed Price: $100 or less   |  Posted: Feb 24, 2015  |  Closed  |   3 Proposals
I expect following: - A detailed financial model on the company Esterline Corporation (NYSE:ESL) - 3-year historical with minimum 2 years including Qtrs - 4- year forecast including immediate current year and next year quarterly forecast - Proper revenue and cost drivers - Segments - DCF and Relative valuation - Proper cell comments for every assumptions - Sensitivity analysis tables - There should not be any formatting error - No circular reference, you can use circuit braker - You can use macro/vba in the model - A one page SWOT analysis on the company I need all this max within 2 weeks of job start.
Category: Investment Analysis       
Skills: Report Writing, Financial modeling       
Preferred Location: India/Southern Asia, Eastern Asia, Africa

a****avi
 [?]
Sign in to view client's details.
| a****avi
Fixed Price: Less than $500   |  Posted: Feb 24, 2015  |  Closed  |   4 Proposals
I need to implement the logic of the following paper either in excel or R, from where I can call a C++ program for executing the following logic. I am comfortable if you want to do it in some other language or any other efficient way of doing this. The inputs to run this program must be accessible from excel or a text file. I can share a brief overview similar to the logic mentioned above. I can share more details regarding the data file with serious freelancers who have considerable experience in such things and will not be trying to bid for such work for the first time.
Category: Investment Analysis       
Skills: VBA, C++, MATLAB, MetaTrader 4 (MT4)       

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