• Medientyp: E-Artikel
  • Titel: Excel best practices
  • Beteiligte: Balik, Robert J.
  • Erschienen: Emerald, 2009
  • Erschienen in: Managerial Finance
  • Sprache: Englisch
  • DOI: 10.1108/03074350910949781
  • ISSN: 0307-4358
  • Schlagwörter: Business, Management and Accounting (miscellaneous) ; Finance
  • Entstehung:
  • Anmerkungen:
  • Beschreibung: <jats:sec><jats:title content-type="abstract-heading">Purpose</jats:title><jats:p>Currently many jobs for undergraduate finance majors require that the student demonstrate advanced Excel modeling skills. The purpose of this paper is to illustrate and explain the Excel Best Practices which should enhance their financial modeling efficiency.</jats:p></jats:sec><jats:sec><jats:title content-type="abstract-heading">Design/methodology/approach</jats:title><jats:p>The focus is a way to teach the Excel Best Practices when teaching financial modeling with Excel 2007. It uses a chronological modeling procedure that is consistent with current learning theory and the way students should use these Excel Best Practices. A capital budgeting replacement problem is used to illustrate many of the Excel Best Practices.</jats:p></jats:sec><jats:sec><jats:title content-type="abstract-heading">Findings</jats:title><jats:p>It was found that using a chronological modeling procedure is consistent with current learning theory.</jats:p></jats:sec><jats:sec><jats:title content-type="abstract-heading">Originality/value</jats:title><jats:p>Using the procedures mentioned in this paper should result in efficient financial modeling. Efficient models are created in less time, have fewer errors, if any, and are designed for ease of use.</jats:p></jats:sec>