My major work to Conduct quantitative analysis of financial data to forecast revenue, identify future trends and identify risk associated wi x th capital expenditure, acquisitions, and joint-venture projects. 
For this purpose i worked with R and tableauu. ia slo dod ad hoc anlysis and reporting,i did it preferably on tableau beacuse

A few possibilities things you should be familiar with:
understand what is a chart of accounts is, how costs are allocated at a high level and how costs roll up and down
be able to create or recreate a basic financial reporting dashboard in excel
be comfortable with excel functions, especially formulas, named ranges, conditional formatting, pivot tables and Vlookups / Hlookups
be proficient with discounted cash flows and PV calculations
be able to articulate your assumptions, and do some sensitivity analysis around how much your results will vary if your assumptions are inappropriate



financila panning and anlysis

1.assess finacial position- past performance, future possibilties of growth
financial ratio-capital structure ratio,profitabilty,productivity,liquidity,market value
2.financail raio nalysis-dupont analysis it is a long term analysis- disinteggraeteand lea
leverage ratio=assets/equity-cpaital structure ratio,inverse of equity financong ratio(percent of assets finanaced by equity), efr abd dfr are im[prtant to firms access ti debt,
asset turnover= sales/asset, productivit ratio, productivity of assets in generating revenue,
profit margin=ebit-taxes/sales
debt burden
ebit-taxes-interset/ebit-taxes
multiplying all 4 gives us return on equity



Tanya

11, September 2015


What experience do you have in Finance/Accounting field? 
What made you choose to apply for this Finance job?
What are your top 3 skills that you feel you can bring and help you in this Finance/Accounting job? 
Can you describe a recent situation in which you accomplished an important objective in a brief period of time? 
Do you prefer team work or individual work? 
What process/method do you use to ensure accuracy?
How do you manage online finance operations and describe a method you used to prepare a report? 
When working on a particular project, describe a time when you provided strategic analysis to drive improved decision making. What was the situation? How did you come up with your resolutions?
What is the current tax rate in the country you currently live in?
What financial experience do you have to date? 
What have you done to improve your Finance knowledge in the last year? 
What have you learned from your mistakes in your last Finance job? 
What is working capital? 
What are deferred taxes? 
Explain what is meant by private equity. Which method do you use to calculate company assets invested in external projects? 
In which conditions would a company prefer a debt over equity finance? 
Explain macroeconomics/capital markets/investment theory? 
Where do you think interest rates will be 1 year from now? 
What do you think about the economy and interest rates? 
Which financial reporting software/method did or have you used in the past?
Which departments might you have worked with in the collection of any financial data?
Do you have any specific accounting/finance qualifications?
Did you ever have to present financial reports to management?
What have you learned from your mistakes in your last Finance job? 
How many transactions where you expected to process on a daily, weekly and monthly basis? Did you reach those targets?
What kind of targets did you have to deal with in your last Accounting job?
What previous experience do you have in arranging payment agreements?
On average what was the volume (number) of invoices you had to collect and/or pay?
What would you do if a client could not pay their financial bill?
How do you/would you prioritise payments?
Do you have any experience in setting credit limits? Talk to me about it?
Did you ever stop/cancel orders of non-paying clients? Tell me about it? (NOTE: this is a great opportunity to show off your skills)
Do you have any experience in Fraud investigation? Tell me about it?
When working on a project, tell me about a time when you provided strategic analysis to drive improved decision making. What was the situation? How did you come up with your resolutions?
What is the current tax rate in the country you currently live in?
What have you done to improve your Finance knowledge in the last year? 
What have you learned from your mistakes in your last Finance job? 
Where do you think interest rates will be 1 year from now? 
What do you think about the