Lynda – Excel – Analyzing and Visualizing Cash Flows

Lynda – Excel – Analyzing and Visualizing Cash Flows
English | Size: 158.41 MB
Category: Tutorial

By learning how to evaluate and visualize cash flows for your business, you can make more informed decisions about prospects and projects. In this course, Curt Frye demonstrates effective ways of evaluating and visualizing cash flows using Microsoft Excel. He demonstrates how to calculate the effect of interest rates and inflation, calculate the present value of an investment, and determine how much interest you can save by paying extra principal each month. Plus, he explains how to calculate net present value and internal rate of return, and shows how to create a cash tracking worksheet, where you can keep a record of income, expenses, and your current cash balance. [Read more…]