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.
Spreadsheets and budgets; spreadsheet background and basics; simple budgets with spreadsheets; a spreadsheet for a project budget; graphs and charts with Excel; basic concepts of financial economics; calculations with interest rates; mortgage loans; present values of periodic amounts; project evaluation; basic concepts of project evaluation; cash flow analysis; sensitivity analysis and data tables; database management applications; basic database tooks; looking up data; frequencies and quantiles of customer satisfaction; statistical functions; investment portfolio evaluation.