• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Stephen L. Nelson

Author. Accountant. Aspiring Apiarist.

  • Articles
  • e-Books
    • Maximizing Section 199A Deduction
    • Setting a a Reasonable S Corporation Salary
    • Small Business Tax Deduction Secrets
    • Real Estate Tax Loopholes & Secrets
    • DIY LLC Formation and Incorporation Kits
    • Sample LLC Operating Agreements
    • Sample Corporation By-Laws
  • Contact

Using Excel

Customizing the Business Planning Starter Workbook

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

You can use the business planning starter workbook for many business projections. However, you might want to change the starter workbook so that it more closely matches your requirements. For example, you can add text that describes the business and the forecasting horizon. You can increase or … [Read more...] about Customizing the Business Planning Starter Workbook

Filed Under: Business Planning, Using Excel Tagged With: business planning

Understanding the Business Planning Starter Workbook’s Calculations

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

The business planning starter workbook has seven parts: the inputs forecast, Balance Sheet, Common Size Balance Sheet, Income Statement, Common Size Income Statement, Cash Flow Statement, and Financial Ratios Table. I want to briefly describe the calculations that occur within each of these parts in … [Read more...] about Understanding the Business Planning Starter Workbook’s Calculations

Filed Under: Business Planning, Using Excel Tagged With: business planning

Using the Business Planning Starter Workbook

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

You can use the business planning starter workbook, shown in Figures 10-1 through 10-5, to construct pro forma financial statements that let you forecast profits and losses, financial condition, and cash flows for a business or organization. To use the workbook, you develop and then enter … [Read more...] about Using the Business Planning Starter Workbook

Filed Under: Business Planning, Using Excel Tagged With: business planning

Working with the Financial Analysis Tools in Excel’s Small Business Financial Manager

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

The Small Business Financial Manager provides you with four Financial Analysis Tools: Business Comparison Reports, Buy vs. Lease Analysis, a Create Projection Wizard, and What-If Analysis. You can move backward and forward within a Financial Manager Tool wizard’s dia- log boxes by clicking the … [Read more...] about Working with the Financial Analysis Tools in Excel’s Small Business Financial Manager

Filed Under: Finance, Using Excel Tagged With: small business financial manager

Working with the Report Wizard in Excel’s Small Business Financial Manager

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

After you’ve imported your accounting data, you use the Report Wizard to produce a fi- nancial report based on the imported accounting data. Reviewing the Report Wizard Reports The Report Wizard produces reports that fall into one of seven categories: balance sheets, cash flow statements, change … [Read more...] about Working with the Report Wizard in Excel’s Small Business Financial Manager

Filed Under: Finance, Using Excel Tagged With: small business financial manager

Importing Financial Data Into Excel’s Small Business Financial Manager

May 18, 2015 By Stephen L. Nelson Leave a Comment

Cover to MBA's Guide to Microsoft Excel

Before you can begin using the Small Business Financial Manager, you import the financial data stored in your accounting system and store it in a database. You may also need to reorganize the data slightly once it’s in this database. And, of course, as your accounting records change, you’ll want to … [Read more...] about Importing Financial Data Into Excel’s Small Business Financial Manager

Filed Under: Using Excel Tagged With: small business financial manager

  • « Go to Previous Page
  • Go to page 1
  • Interim pages omitted …
  • Go to page 3
  • Go to page 4
  • Go to page 5
  • Go to page 6
  • Go to page 7
  • Interim pages omitted …
  • Go to page 10
  • Go to Next Page »

Primary Sidebar

Article Categories

  • Accounting
  • Business Planning
  • Finance
  • Real Estate
  • Statistics
  • Taxes
  • Using Excel

Copyright © 2025 Stephen L. Nelson, Inc. · Contact · Steve’s Bio · Publications · Glossary