Your grandparents have been left a substantial amount of money and want to...

Your grandparents have been left a substantial amount of money and want to...

Author: Jean Brunner

Your grandparents have been left a substantial amount of money and want to invest in a company.


Your grandparents have been left a substantial amount of money and want to invest in a company. Your grandfather trusts you to make a recommendation, but he also wants to see the reasoning behind your choice.
You have an idea of which company to choose, and you decide to prepare 3 sets of documents for your grandparents to consider: business analysis, combined income and cash flow statement, and trend analysis.
Business Analysis
Select a public company that trades on either the NYSE or the NASDAQ. Perform a business analysis (both external and internal) for your company using the most recent information from various sources. Possible sources include the following:
Annual report or form 10-K
Magazine or newspaper articles
Company Web sites
Government information
Industry information
Rating agencies
Analyst reports
Internet articles
Your analysis should be approximately 5 pages long. Be sure to cite your sources using APA guidelines.
Combined Income and Cash Flow Statement
Download the company's most recent annual report from its Web site or the company's form 10-K from the U.S. Securities and Exchange Commission (SEC) Web site (www.sec.gov).
Confirm that the firm's income, dividends, and other capital transactions explain the change in equity for the most recent year. (You may need to consult the statement of shareholders' equity.)
Confirm that the firm's cash flow statement begins with the same net income amounts found in the income statement.
Confirm that the firm's cash flow statement shows a change in cash that is equal to the difference between cash shown on the balance sheet at the beginning and end of the year. In Excel, construct a combined income statement and cash flow statement.
Write 1–2 paragraphs that answer the following:What would you do if you found there was a huge difference in the net income amounts and the reported cash flow amounts?
How could technology limit the likelihood of this happening again?

Trend Analysis
Finally, prepare a trend analysis of operating ratios for at least 3 years' worth of financial data. Prepare the analysis in Excel. You may wish to create a common-sized income statement first, but it isn't required.
If you adjusted for any nonrecurring items in step 1, explain the adjustments in a separate Word document. Use any other information in your company's annual report to explain the change in revenues, gross margin percentage, and operating margin percentage. Add this information to the Word document.

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.