ABSTRACT

This text combines the teaching and explanation of spreadsheets with the essentials of finance and economics in a highly-visual, interactive and project-based approach. Students progressively build skills in Microsoft Excel, by proceeding through a variety of basic applications. Users of other spreadsheets will also benefit from the book. This innovative publication includes an accompanying disk that provides the spreadsheet files on which the text is based and the data for the exercises and assignments following each chapter.

part 1|54 pages

Spreadsheets and Budgets

chapter Chapter 1|11 pages

Spreadsheet Background and Basics

chapter Chapter 2|15 pages

Simple Budgets with Spreadsheets

chapter Chapter 3|12 pages

A Spreadsheet for a Project Budget

chapter Chapter 4|14 pages

Graphs and Charts

part 2|43 pages

Basic Concepts of Financial Economics

chapter Chapter 5|14 pages

Calculations with Interest Rates

chapter Chapter 6|14 pages

Mortgage Loans

chapter Chapter 7|14 pages

Present Values of Periodic Amounts

part 3|45 pages

Project Evaluation

chapter Chapter 8|11 pages

Basic Concepts of Project Evaluation

chapter Chapter 9|8 pages

Cash Flow Analysis

chapter Chapter 10|16 pages

Sensitivity Analysis and Data Tables

chapter Chapter 11|9 pages

Evaluation of Resource Extraction Projects

part 4|53 pages

Database Management Applications

chapter Chapter 12|10 pages

Basic Database Tools

chapter Chapter 13|8 pages

Looking up Data

chapter Chapter 14|12 pages

Frequencies and Quantiles

chapter Chapter 15|12 pages

Statistical Functions for Databases

chapter Chapter 16|10 pages

Investment Portfolio Evaluation