Awarded

Management of Financial institution

You will be selecting the bank of your choice ( I chose Peoples Bank).

1. Access the financial actuals; that is, historical financial data for the past five years for the bank of your choice, as well as your bank’s competitor.

This may be taken from the commercial bank’s web site or from the SEC web site.

[url removed, login to view] a Microsoft Excel 2007 spreadsheet model using data given in the Statement of Financial Position. This should include:

the balance sheet

Income statement

5 -10 common and industry-specific financial ratios for both your selected commercial bank and its competitor.

[url removed, login to view] your Microsoft Excel spreadsheet and the information it yields, write a report which discusses your commercial bank’s strengths and weaknesses.

This report must be written using the Microsoft Word 2007.

[url removed, login to view] the prevailing rates set by the Federal Reserve Board.

Prepare a chart and analyze your selected commercial bank’s historical profitability over the past 5 years with the Federal Reserve interest rates over the past five years.

Discuss how these rates affected your bank’s profitability.

[url removed, login to view] the Annual Report of your selected commercial bank. Answer and discuss the following:

What is the announced mission and future direction as stated by the bank’s Chief Executive Officer?

Is your commercial bank in a good financial position to achieve those objectives?

[url removed, login to view] a forecast of your selected bank’s projected profitability (you forecast this!).

Assume that the Federal Reserve Board holds the interest rates “as is” or constant.

Discuss the impact this constant interest rate would have on three years of your bank’s profitability.

Skills: Business Analysis, Excel, Financial Markets, Financial Research

See more: management financial institution, institution financial management, access prevailing rates set federal reserve board, weaknesses and strengths, weaknesses, three weaknesses, strengths and weaknesses, microsoft excel management, good weaknesses to have, good weaknesses, good strengths and weaknesses, executive management, common weaknesses, commercial rate, answer financial, 3 weaknesses, 3 strengths and 3 weaknesses, 3 strengths 3 weaknesses, how to microsoft excel, research rates, prepare balance sheet, income statement, Financial report, financial Model, financial data research

About the Employer:
( 0 reviews ) hammond, United States

Project ID: #4180331

9 freelancers are bidding on average $116 for this job

javed1705

dear sir please check pm

$80 USD in 2 days
(106 Reviews)
6.3
xazoo

Consider it done, professionally. Thanks

$180 USD in 5 days
(58 Reviews)
6.1
satsin7

Hi I am a financial industry professional. More than 15 years experience. MBA(Finance) and MS(Accounts). I have understood the requirements and can deliver accordingly. Plese check my profile. 100% completion and sa More

$200 USD in 3 days
(32 Reviews)
5.1
gaudhampragadesh

Hi, I am interested. Regards, Gaudham. R

$70 USD in 3 days
(8 Reviews)
4.8
shahz87

Greetings, As a finance professional i would like to handle this [url removed, login to view] have a look to my PM.

$65 USD in 3 days
(10 Reviews)
3.7
mariyamkhawaja

Hi i am MBA Finance & in my last semester i made a report of Bank just like your requirements i do complete ratio analysis and all things you require and present a report on Muslim Commercial Bank So i can complete it More

$300 USD in 30 days
(0 Reviews)
0.0
borsis1

Hi I would be happy to do this research. I am a Business Analyst during the day and enjoy researching at night.

$165 USD in 4 days
(0 Reviews)
0.0
juthawatassoc

Hello sir, we have done many business analysis in our 25 year old carrier and would be glad to do it for you. Please have a look at your Pm. Thanks.

$50 USD in 5 days
(0 Reviews)
0.0
swetajain88

please consider. would like to serve you and assure complete satisfaction with the task.

$80 USD in 5 days
(0 Reviews)
0.0
amibrahim4477

Hello, I am interested to complete this job.

$65 USD in 3 days
(0 Reviews)
0.0
vyastik

Dear sir, I'm an experienced financial analyst and Excel / VBA developer and am eager to complete this job properly and in time.

$35 USD in 3 days
(0 Reviews)
0.0