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



Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 10% with the coupon code: best10