Financial Analysis Work using STATA -- 2

Hi 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 FINAL I NEED BY 27 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 [login to view URL] 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 yet...so 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??