Record Details

Catalog Search

Search The Catalog


Back To Results
Showing Item 1 of 1

Business financial planning with Microsoft Excel

Powell, Gavin (author.).

Summary: "Business Finance Planning with Microsoft® Excel® shows how to visualise, 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, Finalising 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 customisable 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." -- Provided by publisher.

Record details

  • ISBN: 9781032008066
  • ISBN: 1032008067
  • Physical Description: print
    160 pages : illustrations (some color), tables, charts ; 24 cm
  • Publisher: Boca Raton : Chapman & Hall/CRC, 2023.

Content descriptions

Formatted Contents Note:
Chapter 1 In the Beginning -- 1.1 From Problem to Solution -- 1.2 Introducing the Case Study: BDaaSB -- 1.2.1 Where to Begin -- 1.2.2 Competitors -- 1.2.3 Loading and Analytics -- 1.2.4 Value in Presentation -- 1.2.5 Flexibility and Added-Value Spin-Offs -- 1.2.6 A Problem to Solve -- 1.2.7 Security -- 1.3 Tools, Processes, and Flow in This Book -- 1.4 Conclusion -- Chapter 2 Your Business Goals -- 2.1 Mission and Vision to Core Business Values -- 2.2 Core Business Values to SWOT Matrix -- 2.3 SWOT Matrix to SWOT Matrix Response -- 2.4 SWOT Matrix Response to Strategic Goals and SMART Objectives -- 2.4.1 Mapping Strategy over Time -- 2.4.2 SMART Objectives Is a Schedule of Events -- 2.4.3 Executing and Achieving SMART Objectives -- 2.5 Conclusion -- 2.6 The Spreadsheet So Far -- Chapter 3 Predicting Expenses with SMART Objectives -- 3.1 Revisiting SMART Objectives -- 3.2 Assessing Labor Costs -- 3.2.1 Business Cycle Timeline Structure -- 3.2.2 Specific Labor Requirements and Labor Costs -- 3.3 Equipment and Fixed-Asset Costs -- 3.3.1 Adding to Financial Statements -- 3.4 General Costs and Expenses -- 3.4.1 Legal Costs and Requirements -- 3.4.2 Other Expenses -- 3.4.3 Adding to Financial Statements -- 3.5 Conclusion -- 3.6 The Spreadsheet So Far -- Chapter 4 Predicting Sales Using Your Competitors -- 4.1 Generating Pricing Strategy with Marketing Analysis Tools -- 4.1.1 STEEP (Competitive Market Industry) Analysis -- 4.1.2 Porter's 5 Forces -- 4.2 Competitors -- Who and Why? -- 4.2.1 Competitors for the BDaaSB Case Study -- 4.3 Marketing Strategy and The 4 PS -- 4.3.1 Product, Price, and Sales Revenue Forecasting -- 4.3.2 Promotion, Place, and the Beginnings of Marketing Expenses -- 4.4 Conclusion -- 4.5 The Spreadsheet So Far -- Chapter 5 Predicting Marketing Costs -- 5.1 Market and Industry Segmentation -- 5.1.1 Market Segmentation -- 5.1.2 Industry Segmentation -- 5.2 Marketing Costing and Budgeting -- 5.2.1 Sales-Lead Generation Cost -- 5.2.2 Continuing Sales Forecasting from Chapter 4 -- 5.2.3 Marketing Costs Estimate -- 5.3 Conclusion -- 5.4 The Spreadsheet So Far -- Chapter 6 Formal Financial Planning and Budgeting -- 6.1 Startup Balance Sheet -- 6.2 Schedule of Startup Expenses -- 6.3 Proforma Income Statement -- 6.3.1 Quarterly One-Year Proforma Income Statement -- 6.3.2 Quarterly Two-Year Proforma Income Statement -- 6.3.3 Annualized Five-Year Proforma Income Statement -- 6.4 Proforma Balance Sheet -- 6.4.1 Adding to the Balance Sheet -- 6.5 Returning to the Income Statement -- 6.6 Proforma Cash-Flow Projection -- 6.6.1 What's in the Cash-Flow Projection? -- 6.6.2 Quarterly Two-Year Proforma Cash-Flow Projection -- 6.6.3 Annual Five-Year Proforma Cash-Flow Projection -- 6.7 Final BDaaSB Financial Statements -- 6.8 Final Financials for Your Business Idea -- 6.9 Conclusion -- 6.10 The Spreadsheet So Far.
Subject:
Microsoft Excel (Computer file) Microsoft Excel (Computer file)
Business enterprises Finance Data processing
Electronic spreadsheets Computer programs

Available copies

  • 1 of 1 copy available at NC Cardinal. (Show)
  • 1 of 1 copy available at Onslow County Public Library.

Holds

  • 0 current holds with 1 total copy.
Sort by distance from:
Show Only Available Copies
Location Call Number / Copy Notes Barcode Shelving Location Status Due Date
Jacksonville Main Library 658.15 POW (Text) 36015000489704 Adult Nonfiction Available -

Back To Results
Showing Item 1 of 1