Business Financial Planning with Microsoft Excel cover

160 pages · 2023

Catalog title1st Edition

Business Financial Planning with Microsoft Excel

By Gavin Powell

Published
June 9, 2023
Imprint
Chapman and Hall/CRC
Edition
1st Edition
ISBN
9781003175834

Overview

About this book

Business Finance Planning with Microsoft® Excel® shows how to visualize, plan, and put into motion an idea for creating a start-up company. Microsoft Excel is a tool that makes it easier to build a business financial planning process for a new business venture.

With an easy-to follow structure, the book flows as a six-step process:

Presenting a case study of a business start-up Creating goals and objectives Determining expenses from those goals and objectives, Estimating potential sales revenue based on what competitors charge their customers Predicting marketing costs Finalizing the financial analysis with a of financial statements.

Written around an IT startup case study, the book presents a host of Excel worksheets describing the case study along with accompanying blank forms. Readers can use these forms in their own businesses, so they can build parts of their own business plans as they go. This is intended to be a practical guide that teaches and demonstrates by example, in the end presenting a usable financial model to build and tweak a financial plan with a set of customizable Excel worksheets. The book uses practical techniques to help with the planning processing. These include applying a SWOT (strengths, weaknesses, opportunities, and threats) matrix to evaluate a business idea and SMART (Specific, Measurable, Achievable, Relevant, and Time-Bound) objectives to link together goals. As the book concludes, readers will be able to develop their own income statement, balance sheet, and the cash-flow statement for a full analysis of their new business ideas.

Worksheets are available to download from: https://github.com/gjtpowell/business_finance_planning

Subjects

Computer Science, Economics, Finance, Business & Industry

Inside the book

Table of contents

Select a chapter to read its abstract.

Chapter Chapter 1In the Beginning

Pages: 19

The act of beginning can sometimes be the biggest step to take, especially when the readers have no idea which piece comes first in a sequence of events. The case study will drive the entire process throughout the book and show how these planning tools led to the final decision not to pursue it. BDaaSB will create value for its customers by providing a BigData database storage service that in addition includes analytical processing, prediction and trending reporting, and visualization services, all for multiple small-sized business customers who can gain by access to BigData technology but cannot afford their own individual BigData installations. The size and scope of the opportunity will be localized at the beginning but will eventually have value for customers on a national and even an international scale. Services can be on demand or subscription based, where on-demand pricing charges as customer uses server resources, and subscription-based pricing charges a flat fee regardless of resource amounts used.

Chapter Chapter 2Your Business Goals

Pages: 23

A company mission is a goal for that organization as a whole, which defines the business of the organization and the reason for its existence. BDaaSB plans to reach profitability within three to five years. Services and initial customer base can be in place within one year, depending on the available team, as well as response from early adopters who will be given the product for free to begin with. The business philosophy will be for-profit, where later spin-offs can be both for-profit and not-for-profit (to generate goodwill), and potential spin-offs can be exploited after getting started as a BigData service for small companies. Organizations are lead from the top down, and the values of leaders will determine the culture of an entire organization, from which everything else follows. Sometimes the hardest step is the first one, and sometimes it is the simplest—but do not neglect easy steps at the beginning as they form the foundation of your business opportunity.

Chapter Chapter 3Predicting Expenses with SMART Objectives

Pages: 30

This chapter is the beginning of the journey where the readers start uncovering and detailing real financial numbers and comparing potential incomes or revenues with expenses—the part that really counts because in long term without finance and ability to acquire financial support of one form or another, and without a solidly detailed well-thought-out plan, they will have difficulty finding financial support to bring their business opportunity into existence. The BDaaSB case study business idea is an online cloud-based service that initially begins as a single founder-employee operation, which as it grows will morph into a business that does not require a large head-count labor force; however, most of labor is highly trained technically, and thus their cost for each individual is relatively high. For the BDaaSB case study, initially this business will be an in-the-basement, one-person prototyping operation that will build a framework for a service, find the best way to implement and provide that service while saving on costs.

Chapter Chapter 4Predicting Sales Using Your Competitors

Pages: 30

This chapter figures out how much revenue your new business idea can generate as a way to create a clear picture of how much your business is worth based on how much money you can bring into the company. This content is important because it allows you to present to investors, a bank, or other lenders just how much money your business can potentially make, which leads to your financial backers’ possibly making money. A STEEP analysis is a form of competitive market industry analysis where you do a simplistic but systematic analysis of where your business fits into an industry and with its competitors—whether known or unknown. BDaaSB competitors are in a new industry, so there may not be a lot of information. For other types of business there may be information online or at a library.

Chapter Chapter 5Predicting Marketing Costs

Pages: 27

This chapter digs into building a customer base with a marketing plan that helps one to figure out how much it will cost them to look for and acquire customers. Aligning business plan and marketing creates a brand, awareness, and partnerships—the objective is to acquire customers because without sales there is no business. Figuring out what the business market is and where it fits into a wider economic picture, such as its general industrial segment, can help to define how to market and thus attempt to predict and plan out the marketing costs. However, it is highly appropriate to perform an industry analysis in IT because as a service industry, any type of commercial computer science product or service can often be abstracted to numerous industries, where companies sell easily duplicated and perfected products over and again to many customers and many different industries, generating copious amounts of revenue.

Chapter Chapter 6Formal Financial Planning and Budgeting

Pages: 39

A startup balance sheet is where to expand on and provide more detail in financial statements on top of what has already been covered in income statements. A proforma financial statement is a type of statement that attempts to project ahead into the future, which for a new business seeking financial support and backing is exactly what is needed; you are making an educated and hopefully calculated guess at future income in order to show that you have a viable business idea. Cloud-based software services is an Information Technology service, and as a result it does not require a large capital investment—it’s a rental model. Accounts receivable is calculated as a percentage of the total sales revenue projection and is thus an estimation of how much revenue you expect to take in on credit. Accounts receivable is an asset because you expect to receive it and also a current asset because you expect to receive it in the short term.