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.

Topics include:
• Calculating the effect of interest rates and inflation
• Finding the arithmetic and geometric means of growth rates
• Calculating the future and present value of an investment
• Calculating loan payments for a fully amortized loan
• Calculating the effect of paying extra principal with each payment
• Finding the number of periods required to meet an investment goal
• Calculating net present value and internal rate of return
• Building a cash tracking worksheet
• Visualizing cash flows using a waterfall chart

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.