Fin 382 final financial analysis project

Fin 382 Final Financial Analysis Project

Project on Well Fargo
and Bank of America

Course Project
Horizontal Analysis –

I. Choice of
Companies and an Overview of Their Operations and Industry – Briefly outline
what each company does and its industry.

II. Discussion of
Current Issues Impacting Financial Statements – Include any relevant current
event information, news that has affected financial statements, or world events
that could impact the businesses. Research will have to be done on this. Some
good sources of information include the most recent annual reports for each
company (these can be found online for all publicly-traded companies; utilize
the most current year-end annual reports available), Yahoo! Finance, the MSN
Money website (this will provide current information on your company and some
ratio information), and various business magazines. You can find the websites
suggested under the Webliography tab in the course.

III. Relevant
Ratios and Discussion – List what ratios you think are relevant to your
companies and industry. Go to the Excel spreadsheet in Doc Sharing, review the
ratios listed under the ratio tab, and pick what you think may be relevant. In
one to two paragraphs, briefly discuss ten ratios you think may be important,
and include ratios from the different categories. The ratios will be
automatically calculated on the spreadsheet (please see section IV regarding
this). (10 points)

IV. Excel
Spreadsheet FinSAS.xls – Manually input the financial data for your company
under the input tab on the spreadsheet. You should insert numbers highlighted
only in blue. These numbers should be found in the company’s most recent
year-end annual reports (utilize the most year-end numbers; the spreadsheet has
it starting at 2008, but change the year to 2012 and go five years historically
from there to 2008), which can be obtained online under your company choice.
Complete a separate spreadsheet for each company. Write that you completed the
input for the spreadsheet for both companies and that the spreadsheet works. To
check this, once you input the data in the input tab only, check the other tabs
(ratio, vertical analysis) to ensure that you see the automated calculations.
(20 points)

V. Bibliography


Written content and explanations can be completed in a
separate (Word) document.

Course Project
Vertical Analysis –

I. Identification
of Significant Asset Items, Liability Items, and Comments on Revenue and
Profitability – List specific issues that you think affect these items. For
example, economic factors, new product launches, and recent news developments
can affect the items. Information can be obtained from annual report write-ups,
financial notes, and the Internet. Briefly comment on how they affect financial
numbers such as sales, profitability, costs, revenue, and so forth.

II. Relevant
Ratios and Discussion of Your Findings of Vertical Analysis – Discuss briefly
your vertical analysis findings, which are calculated automatically on the
spreadsheet under the vertical analysis tab. Then, identify any key ratios that
you think impact vertical analysis.

III. Excel
Spreadsheet FinSAS.xlsx, Calculations of Vertical Ratio Analysis – This is a
separate tab under the project spreadsheet and will calculate automatically,
based on what you inserted in the input tab during Week 2. Ensure that it has
calculated, and provide a brief analysis of your findings. The spreadsheet does
not need to be submitted this week; just state that the spreadsheet is
calculating correctly for each company.

Course Project Final
Ratio Analysis –

I. Explaining
Business Objectives and the Effect of the Objectives on the Ratios – Briefly
highlight if the ratios meet the criteria of the business objectives. These
objectives can be found in the annual reports under CEO comments and business

II. Identification
of the Three Most Important Ratios for Your Companies and Support – Include why
you think these ratios are the most important; what do they indicate about the
financial health of each company? All ratios should be automatically calculated
based on your input sheet from Week 2.


III. Computation
of Relevant Ratios and Comparison to Industry Data – Verify that all ratios
have been automatically calculated on the spreadsheet. On a separate document,
list the ratios in comparison to the industry. Industry ratios can be found on
various financial websites. The list should be in a table format, showing
Company A, Company B, and then the industry ratio.

a. Bibliography

 b. Other back
material, as needed: detailed tables, extended quotations from which shorter
quotes are taken, and so forth.

Final Report

Written content and explanations can be completed in a
separate (Word) document.

General Expectations for your Final Course Project
Submission –

 A Word document, as
well as the Excel document for each company, must be submitted. Also, submit a
spreadsheet for each company completed.

 You should also be
sure that you answered the following: “Which company has better financial
ratios and why? What do the ratios indicate? Compare the financial ratios for
the latest year to the industryaverages.
Is each company above or below the industry averages? Compare for each
ratio.” All this information should come from your previous weeks’
submissions. A suggestion is to include a section in the paper that responds to
each of these questions stated. A paper clearly outlined with separate sections
generally reads easier.

Citation Help 

Don’t forget to cite your sources properly, both
parenthetically and in your bibliography or works cited. If you need assistance
with proper citation, the following website may be beneficial:

Be certain to Use the APA Style



Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Assignment Help has assembled a team of highly skilled writers with diverse experience in the online writing circles. Our aim is to become a one stop shop for all your Academic/ online writing. Check out below our amazing service!


Essay Writing Services

At Assignment Help, we prioritize on all aspects that creates a good grade such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines. The principal purpose of essay writing is to present the author's evaluation concerning a singular subject about which they have made. Since Professionalism is the mother of every success, try our team of experienced writers in helping you complete your essays and other assignments.


Admission Papers

You have been trying to join that prestigious institution you long yearned for, but the hurdle of an admission essay has become a stumbling block. We have your back, with our proven team that has gained invaluable experience over time, your chance of joining that institution is now! Just let us work on that essay.How do you write an admission essay? How do you begin the essay? For answers, try Quality Custom Writers Now!


Editing and Proofreading

Regardless of whether you're pleased with your composing abilities, it's never an impractical notion to have a second eye go through your work. The best editing services leaves no mistake untouched. We recognize the stuff needed to polish up a writing; as a component of our editing and proofreading, we'll change and refine your write up to guarantee it's amazing, and blunder free. Our group of expert editors will examine your work, giving an impeccable touch of English while ensuring your punctuation and sentence structures are top-notch.


Technical papers

We pride ourselves in having a team of clinical writers. The stringent and rigorous vetting process ensures that only the best persons for job. We hire qualified PhD and MA writers only. We equally offer our team of writers bonuses and incentives to motivate their working spirit in terms of delivering original, unique, and informative content. They are our resources drawn from diverse fields. Therefore your technical paper is in the right hands. Every paper is assessed and only the writers with the technical know-how in that field get to work on it.


College Essay Writing

If all along you have been looking for a trustworthy college essay service provider that provides superb academic papers at reasonable prices, then be glad that you search has ended with us. We are your best choice! Get high-quality college essay writing from our magnificent team of knowledgeable and dedicated writers right now!


Quality Assignment/Homework Help

We give the students premium quality assignments, without alarming them with plagiarism and referencing issues. We ensure that the assignments stick to the rules given by the tutors. We are specific about the deadlines you give us. We assure you that you will get your papers well in advance, knowing that you will review and return it if there are any changes, which should be incorporated.