Video for Entrepreneurs – Personal Financial Statement

A regional microlender named Accion Texas helps entrepreneurs get started on the process of builing small businesses.

In this video I walk you through the process of collecting your personal financial data all in one place, using an Accion template available on their website.

The personal financial statement would be used to talk to any bank or lender about getting a loan. Even prior to that, it could be used by you to determine whether your startup idea makes financial sense at this time.

See related post Accion Texas video on using a startup capital template

personal_financial_statement

Post read (2120) times.

Video For Entrepreneurs: Tracking Startup Capital in a Spreadsheet

Startup-resources-videoI periodically produce instructional videos for a local micro lender named Accion Texas. They support and lend to young and startup companies that might otherwise get overlooked by the traditional banking industry. In fact one of the key conditions of being an Accion Texas customer is a prior rejection for a bank loan application.

The point of this video I made is to introduce Accion’s customers and potential customers to the value of tracking your startup costs in a spreadsheet. Since I am a huge proponent of entrepreneurship for building wealth, and since many entrepreneurs are not necessarily spreadsheet whizzes, I figured this may have appeal beyond just Accion Texas customers. I hope it will be useful to you.

 

Please see related posts:

Entrepreneurship I – Salary vs Ownership

Entrepreneurship II – Ownership vs. Working for Others

Entrepreneurship III – The Air, The Taxes, and Retirement

Excel Video Training – The Autofill Function

 

 

Post read (4638) times.

Excel Basics Introduction Video #6 – Autofill Function

This video, #6 in the series aimed at introducing Excel for small business, shows the autofill function, an extremely useful tool in Excel.  Small business owners may find autofill saves a ton of time when tracking costs and revenues, making future business plans, and preparing for a loan.

 

Excel Basics Video #1 – Introduction to Excel for Small Business

Excel Basics Video #2 – Opening up a Workbook

Excel Basics Video #3 – Arithmetic & Formatting

Excel Basics Video #4 – Sums and Averages

Excel Basics Video #5 – Formatting Cells

Excel_small_business_autofill

Post read (2814) times.

Excel Basics Video #1: Introduction for Small Business Owners

Lately I’ve been working with Accion Texas, a regional micro lender organization, to produce educational videos for entrepreneurs.  Below is an introduction to the first series of six videos, which covers the first steps in using Excel, such as how to open up a workbook, how to begin to format a worksheet, and how to program simple math in your spreadsheet.

The next series of videos – still to be produced – will be on how a small business owner can use Excel to tracks costs and revenues, and how to model future growth.

I’ll be posting the basic introductory series of six videos here in the next few days and weeks.

Eventually I hope to work my way up to showing how Excel helps us calculate key personal finance topics, such as modeling a home loan or car loan, calculating compound interest, and discounted cash flows.

One of the advantages of this very basic series is that – for anyone who has never used Excel but wants to learn those advanced skills – here’s a way to jump on the surfboard while the waves still move very slowly.

Please see related Posts:

Excel Basics Video #1 – Introduction to Excel for Small Business

Excel Basics Video #2 – Opening up a Workbook

Excel Basics Video #3 – Arithmetic & Formatting

Excel Basics Video #4 – Sums and Averages

Excel Basics Video #5 – Formatting Cells

Excel Basics Video #6 – Autofill

 

 

Excel_Icon

Post read (5960) times.