View the step-by-step solution to:

Question

I've attached my PRO FORMA excel sheet with Income statement and Balance sheet. I don't know how to get the

percentage needed to complete the task"

"construct a pro forma income statement and balance sheet for the company using the percentage-of-sales method"


Select a publicly held company and access the company's Web page on the Internet to read its most recent annual report. The annual report is typically found in an "Investor Relations" or "Company Information" section within the company's Web site. You can use this website to look up any publicly traded company’s documents for additional consideration. Complete the following:

  • Using the company's financial statements, construct a pro forma income statement and balance sheet for the company using the percentage-of-sales method.
  • Be sure to include the original statements along with a defendable sales forecast. 
  • Upon completion of the financials, write a paper detailing the process and what you learned about the company as you work through this activity.


MICROSOFT INCOME STATEMENTS (In millions, except per share amounts)(Unaudited) Twelve Months Ended June 30, 2016 2015 2014 2016 2015 2014 Revenue Product Service and other 23,818 17,624 24,318 Total revenue 85,320 93,580 86,833 Cost of revenue Product 17,880 21,410 12,034 Service and other 14,900 11,628 14,900 Total cost of revenue 32,780 33,038 26,934 Gross margin 52,540 60,542 52,540 Research and development 11,988 12,046 11,988 Sales and marketing 14,697 15,713 14,697 General and administrative 4,563 4,611 4,563 1,110 10,011 1,110 Operating income (loss) 20,182 18,161 20,182 Other income (expense), net -431 346 -431 Income (loss) before income taxes 19,751 18,507 19,751 Provision for income taxes 2,953 6,314 2,953 Net income (loss) Earnings (loss) per share: Basic Diluted Weighted average shares outstanding: Basic 7,842 8,061 8,299 Diluted 7,929 8,061 8,399 $61,502 $75,956 $62,515 Impairment, integration, and restructuring $16,798 $12,193 $16,798 $0.40 $(0.40) $ 2.66 $0.39 $(0.40) $ 2.63 Cash dividends declared per common share $0.36 $0.31 $ 1.12
Background image of page 1
Year Average
Background image of page 2
Show entire document
Sign up to view the entire interaction

Top Answer

View the full answer
STATES SECURITIES.docx

Joined STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549
______________________________________________ Form 10-K
______________________________________________ (Stamp One) þ ANNUAL...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online