BASICS OF MS-EXCEL 12.1 INTRODUCTION MS-Excel 2000 is a Windows based application package. It is quite useful in entering‚ editing‚ analysis and storing of data. Arithmetic operations with numerical data such as addition‚ subtraction‚ multiplication and division can also be done with Excel. You can sort the numbers/characters according to some given criteria (like ascending‚ descending etc.)and solve simple financial‚ mathematical and statistical formulas. 12.2 OBJECTIVES After going through
Premium Spreadsheet Graphical user interface Microsoft
96 Balance Sheet 2004 2003 Edwards‚ Inc. has prepared the following comparative balance sheets Cash $198‚000 $102‚000 for 2003 and 2004: Receivables $106‚000 $78‚000 2004 2003 Inventory $100‚000 $120‚000 Prepaid expenses $12‚000 $18‚000 Cash $ 198‚000 $102‚000 Plant assets $840‚000 $700‚000 Receivables 106‚000 78‚000 Accumulated depreciation $(300‚000) $(250‚000) Inventory 100‚000 120‚000 Patent $102‚000 $116‚000 Prepaid expenses 12‚000 18‚000
Premium Generally Accepted Accounting Principles Balance sheet Revenue
additional funds is best described as: A) a publicity problem. B) an agency problem. C) an adverse selection problem. D) a moral hazard. Section: 1.2 Ownership Versus Control of Corporations 4) What is the role of an auditor in financial statement analysis? Section: 2.1 The Disclosure of Financial Information 5) An agency problem can be alleviated by: A) requiring all firms to be sole proprietorships. B) compensating managers in such a way that acting in the best interest of shareholders
Premium Time value of money Net present value Cash flow
CHAPTER 2 – Investing and Financing Decisions and the Balance Sheet I. THE OBJECTIVE OF FINANCIAL REPORTING‚ THE ELEMENTS OF THE BALANCE SHEET‚ AND THE RELATED KEY ACCOUNTING ASSUMPTIONS AND PRINCIPLES. A. Primary objective of financial reporting 1. To provide useful economic information about a business to help investors and creditors make good financial decisions. a. Decision makers are expected to have a reasonable understanding of accounting concepts and procedures
Premium Balance sheet Generally Accepted Accounting Principles
Common-size and trend analysis of the BS In our analysis of Swisscom’s Balance Sheet‚ we first decided to have a global view and then to go into details in order to conduct a good analysis. When we first look at the BS‚ we notice that the company is in a very positive situation from a financial viewpoint. Indeed‚ some of its assets increased between 2011 and 2013‚ while some of its liabilities decreased during this period. When we conduct this type of analysis‚ it is necessary to take into account
Premium Balance sheet Generally Accepted Accounting Principles Financial ratios
Continuing Cookie Chronicle 219 Dec. 1 5 8 9 15 16 19 23 23 23 28 Natalie hires an assistant at an hourly wage of $8 to help with cookie making and some administrative duties. Natalie teaches the class that was booked on November 25. The balance out- standing is received. Cookie Creations receives a check for the amount due from the neighborhood school for the class given on November 30. Cookie Creations receives $750 in advance from the local school board for five classes that the company
Premium Income statement Generally Accepted Accounting Principles Balance sheet
Liqi wang Accounting Income tax Both Amgen and Gilead are fully disclosed the income tax information according to GAAP requirements. Both companies recorded income tax in financial statement such as income statement and specified the detailed components of income taxes. Amgen recorded income tax based on pretax income‚ applicable tax rate and tax planning opportunities available in various jurisdictions. Gilead’s income provision was computed under liability method. Both
Premium Generally Accepted Accounting Principles Taxation Progressive tax
Surf Excel‚ launched in 1954‚ is one of the oldest detergent powders in India and Pakistan. Initially‚ the brand was positioned on the clean proposition of “washes whitest”. However‚ with the emergence of numerous local detergent manufacturers and the entry of other global brands‚ Surf Excel underwent various changes in its Brand Communication; from ’lalitaji’ to ’dhoondte reh jaaoge’ to ’jaise bhi daag ho‚ surf excel hai na’‚ and is today communicated on the platform of ’Dhaag achcha hai’. This
Premium Marketing Laundry detergent Supply and demand
Question 1 1. The following is Addison Corporation’s contribution format income statement for last month: Sales $1‚000‚000 Less: Variable Expenses $ 700‚000 Contribution Margin $ 300‚000 Less: Fixed Expenses $ 180‚000 Operating Income $ 120‚000 The company has no beginning or ending inventories. A total of 20‚000 units were produced and sold last month. What is the company’s margin of safety in dollars? $400 000 10
Premium Contribution margin Variable cost Operating leverage
Chapter Introduction to Microsoft Excel A spreadsheet is a computer program that turns the computer into a very powerful calculator. Headings and comments can be entered along with detailed formulas. The spreadsheet screen is divided into ROWS and COLUMNS; the intersection between a row and a column is termed a CELL. Usually only a small section of the overall spreadsheet is displayed on the screen. 1 The Microsoft Excel Screen 1 Load Microsoft Excel and you should receive the following
Premium Microsoft Spreadsheet Microsoft Excel