Financial Analysis Work using STATA -- 2


I need help in one of my works which supposed to be done using STATA, I only need help in DATA ANALYSIS PART.

Data I will provide to you.

I need all results file.

I need work update by 26 JUNE 2014


Open attached files to see details.

My Budget is about 30 USD


The macroeconomic data would be taken from the world bank database à World Development Indicators


we have to take the first differences of the variables because it is panel model

And it would be better if we make first differences in percentage ( ROE T – ROE T-1 )/ 100) %


The title is "US COMMERCIAL BANKS CAPITAL RATIO AND HOW IT AFFECTS LENDING " .A dissertation about the capital adequacy of banks (Basel I, II, etc.) and how it affects the loans that they retain in their portfolios. In particular we need to create a model using data from the FDIC [url removed, login to view] do a statistical analysis of the model and make inferences about the Capital ratio and loans of these banks. I attach a representative Article for the topic . The software may be stata .

Do not forget the regulations( Basle Rules) .We have to make a short reference because The capital ratio is connected with the bank regulations

We do not want to research the monetary policy of the banks and their loan rates,although is it good to make some reference to this field ,but our research is to compare the capital ratio with the Loans as balance sheet elements. To make it clear if one year a bank has a low capital ratio how this affected its loans in the B/S ??? IT had large deposits so they continue to give loans?? they issued bonds ?? or something like that.... We research the balance sheets of the commercial banks in US to make conclusions about their liquidity and risk exposure...

We have to make a model that is not tested a simple way to create a model is to see which variables appear mostly through the literature and insert them to our model! The model must include Capital ratio ,Loans ,micro and macro variables ,and some other variables referring to liquidity ,profitability ,and risk exposure.

So i attached you a draft of the model... Be careful we want the changes of the factors (Δ%) ,the Growth!!!

No rates and monetary policy ,no demand nor Supply of Loans because we dont know where the y take these numbers!!

We have 3 factors , the autoregressive factor the bank factor and the macroeconomical factor in our model!! We run three regressions our Y variable with each one factor and then all the combinations so as to finally come to the model with 3 factors... We have to comment all these scenarios!!! This the most important part of our dissertation!!!!!

Then we have to create a table to check the sign directions of our factors according to our hypothesis, for example we will find a minus sign for Net charge offs , is that right?? how is it explained??

Skills: Accounting, Finance, Financial Markets, Mathematics, Statistics

See more: using stata financial research, financial research using stata, work reference, the world bank, supply and demand data, ratio in accounting, i want to know accounting, i need help with my dissertation, how work it, how to do simple accounting, how to create accounting, help financial, good article conclusions, first financial bank, first commercial bank, financial accounting part 2, financial accounting part 1, financial accounting for banks, field in accounting, demand and supply data

About the Employer:
( 75 reviews ) Bangalore, India

Project ID: #6112503

Awarded to:


Hi I have MBA degree in Finance from prestigious IIM Kozhikode in India and I am also FRM certified. I understand financial terms and implications very clearly. I happen to have excellent skills in python, but I hav More

$25 USD in 3 days
(0 Reviews)

2 freelancers are bidding on average $28 for this job


A proposal has not yet been provided

$30 USD in 1 day
(0 Reviews)