Project #7036 - Principles Of Finance

Week 1 Project: Due Sunday 6/2 before midnight (11:55pm PST)

You are tasked with creating an excel spreadsheet that will act as a "shell" for financial statements (Income Statement, Balance Sheet, Statement of Cash Flows). You will use Apple's financial statements from Yahoo! Finance for this project. Keep in mind that you will this shell for other companies, in the future, by simply substituting in new numbers. This financial model should calculate all totals and subtotals and information used in more than spot should be linked to the original source.

 

Familiarize yourself with Yahoo! Finance (http://finance.yahoo.com/) and Excel.

  1. Enter the following symbol for Apple into the Get Quotes field and click Get Quotes: AAPL
  2. Locate the Financials section of the left-hand tool bar.
  3. Open up the Income Statement.
  4. Create the Income Statement in sheet 1 of an Excel document.
  5. Open up the Balance Sheet.
  6. Create the Balance Sheet in sheet 2 of the Excel document.
  7. Open up the Statement of Cash Flows.
  8. Create the Statement of Cash Flows in sheet 3 of the Excel document.
  9. Use the tips, tricks, and techniques learned to create a professional spreadsheet from Chapters 24-29. (Principles Of Finance With Microsoft Excell, Excel Simon Benninga)
  10. Make sure you calculate ALL totals and link all appropriate cells.
  11. Take the time to understand the relationship of each item to the financial statement.
  12. Include all 3 years.
  13. Make sure you format all numbers (Accounting, no $-sign, no decimal places) and dates.
  14. Title your file: "Your Name" Project 1

Subject Business
Due By (Pacific Time) 06/02/2013 10:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy