How to Prepare a Business Plan with Excel

33 Pages Posted: 15 Apr 2012 Last revised: 2 Jun 2019

See all articles by Roberto Moro Visconti

Roberto Moro Visconti

Università Cattolica del Sacro Cuore - Department of Business Administration

Date Written: june 1, 2019

Abstract

A business plan is a formal accounting statement which numerically describes a set of business goals, the reasons why they are believed attainable, and the strategic plan and managerial steps for reaching those goals. Hypotheses and visionary ideas of game changers have to be transformed into numbers and need to be backed by reasonable and verifiable assumptions about future events and milestones.

Microsoft Excel© stands out as the most popular spreadsheet software and for that reason the whole paper will move around Excel applications, even if other more sophisticated software programs may be conveniently used, considering also that data are typically importable from or exportable to Excel sources. Numbers are a mental discipline of ideas and Excel is the instrument to play with figures.

Even if this topic is not original or innovative, and has already been extensively investigated, as it appears from many sources, even freely available from the Web, it seems however potentially useful to go through it again, providing some further tips to both students and practitioners, especially to visionaries and challengers.

Note: A link to a free Excel file connects this explanatory PDF file to a more practical device. You-Tube tutorial videos accompany this paper and the Excel model. This Excel file derives from a joint work, coordinated by the author and anybody is welcome to freely copy/download/modify this open source file; the only condition kindly asked is to report any improvement, sending the amended file, together with a list of the modifications to roberto.morovisconti@morovisconti.it. Enjoy our creative intervention and contribute to upgrade the model, making it “viral” on the Web!

Keywords: learning platforms; Business Plan, economic forecasts; cash flow statement; Excel; interdisciplinary MBA topics; Big data; networks; SWOT; PEST; social media / YouTube

Suggested Citation

Moro Visconti, Roberto, How to Prepare a Business Plan with Excel (june 1, 2019). Available at SSRN: https://ssrn.com/abstract=2039748 or http://dx.doi.org/10.2139/ssrn.2039748

Roberto Moro Visconti (Contact Author)

Università Cattolica del Sacro Cuore - Department of Business Administration ( email )

Largo Agostino Gemelli 1
Milano, 20123
Italy

Register to save articles to
your library

Register

Paper statistics

Downloads
1,326
rank
13,771
Abstract Views
4,523
PlumX Metrics