Read EFWManual.indd text version

ELECTRONIC FINANCIAL WORKSHEETS

THE PLANNING SHOP'S

INSTRUCTOR'S MANUAL

The Electronic FInancial Worksheets, v. 2

The Planning Shop, 2004 companion software to The Successful Business Plan: Secrets & Strategies by Rhonda Abrams The Planning Shop, 2003

The Electronic Financial Worksheets were developed as a companion software product to The Successful Business Plan. We have taken all of the financial worksheets form the text-and then some!--and set them into a Microsoft Excel spreadsheets. Tedious formatting and time-consuming calculations have been done already, so your students can focus their time and energy on research to support their business idea and financial plan. The Electronic Financial Worksheets run on any PC using Windows 98 or later and Microsoft Excel 97 or later. Most students, business majors and non-business majors alike, have used Excel once or twice--and that's all takes to successfully use The Electronic Financial Worksheets!

The Successful Business Plan is the best-selling business plan book on the market.

Currently in its 4th edition, it's been adopted at over 200 colleges, universities, and business schools across the country and world-wide. The book is based on the author's exhaustive, meticulous research and professional experiences with hundreds of companies and funding organizations. With dozens of worksheets, The Successful Business Plan takes students step-by-step through every critical section of a successful business plan.

The Successful Business Plan addresses all aspects of developing a successful business

plan--including the ethical aspects. In fact, it was the first business plan book to include a section on social responsibility. Your students are tomorrow's business owners, and now is the time to reinforce their sense of ethical behavior and social responsibility. The Planning Shop is dedicated to providing your students with the best Entrepreneurship textbooks around. We're equally as dedicated to providing you with outstanding teaching tools and support. In order to achieve this goal, we've developed this Instructor's Manual. Some of its features include: · · · · · Sample Syllabus Chapter Outline List of Included Worksheets & Charts List of Frequently Asked Questions Dedicated Support Contact Information

For your convenience, this manual is available on our website as well: http://www.PlanningShop.com/instructors/manuals/EFW

ENT 312: The Successful Business Plan

Planning Shop University, Fall 2005 Text: The Successful Business Plan: Secrets & Strategies by Rhonda Abams, The Planning Shop, 2003 ISBN 0-9669635-6-3 Required Software: The Electronic FInancial Worksheets, v. 2 The Planning Shop, 2004

Prof. Jane Smith [email protected] 650-289-9120 Office Hours: MWF 3:30-5:30 and by appointment

Welcome to ENT 312: The Successful Business Plan! In this course, you will:

· become familiar with the components of a business plan · working in teams, develop a business plan for a new business · learn how to present your business plan to potential funders/investors

Using the Abrams text, you will learn about the various components of a business plan, from the Executive Summary to Strategic Positioning to the Technology Plan to Social Responsibility. Extra attention will be paid to the Financials, including income statements, balance sheets, cash flow statements, sales projections, etc. You will find all of the financial spreadsheets in The Electronic Financial Worksheets version 2. You can download this program form The Planning Shop's website, www.PlanningShop.com/worksheets. The worksheets are an Excel-based spreadsheet program, suitable for printing, and are compatible with your PC running Windows 98 or later and Microsoft Excel 97 or later. Enter the code SMIFAL in your online shopping coart to receive an additional 5% off of the price of the worksheets. (Please remember that software piracy is stealing, and it is illegal. Show The Planning Shop the same respect you hope that your customers will show you, and don't pirate the worksheets.) You will develop your business plans in small groups, following the steps presented in the Abrams text. A sample plan is included in the text for your reference, and we will be exploring each section in class as well. Your team with present its business plan to a panel of potential funders, made up of venture capitalists, angel investors, and bank lenders. Course Goals:

· prepare a concise and effective written business plan and present it orally to a panel of

potential funders

· include support in the form of: evidence of customer acceptance, appreciation of

funders' needs, evidence of focus, and proprietary position

· display an understanding of the different components of the business plan in relation to

each other and the business as a whole within the context of the industry

· prepare an executive summary · prepare a company description · prepare a marketing/sales plan

· prepare an operations plan · prepare complete financial projections · prepare a social responsibility plan · prepare an exit plan

Be sure to utilize the research resources available to you at the school library. Many feebased business databases are available there for free--check with the research librarian. The publisher of your textbook, The Planning Shop, also publishes books to help you with business research, how to present your plan, and other such books that you may find useful. Check their website at www.PlanningShop.com. Course Schedule: Week Date 1 2 3 4 5 6 7 8 9 10 9/28 10/5 10/12 10/19 10/26 11/1 11/8 11/15 11/29 12/5 Topic Business Plan overview; formation of teams; preliminary project discussions Executive Summary Marketing/Sales Plan Marketing/Sales Plan, cont. Operations Plan; Technology Plan Social Responsibility Plan; Exit Plan Financials Financials, cont. Putting the Plan to work; Prepare for presentations Presentation of plans Read Chapters/Work on Corresponding Worksheets 1, 2, 3 4 5, 6, 7 8, 9, 10 11, 12, 13 14, 15 16 16, 17 18, 19, 20

no reading due

Throughout the course, feel free to drop by my office during office hours, or to schedule an appointment. Refer to this syllabus and your text for useful and time-saving information. When all else fails, contact the textbook publisher's Academic Support person, Deborah Kaye: [email protected], phone: 650-289-9120 Monday through Friday, 9am - 5pm pacific time. Assignment Business Plan Presentation & Defense Peer Review Participation Points 600 200 100 100 Weighting 60% 20% 10% 10%

The Electronic FInancial Worksheets, v. 2

The Planning Shop, 2004 companion software to The Successful Business Plan: Secrets & Strategies by Rhonda Abrams The Planning Shop, 2003

List of Worksheets and Charts found in The Electronic Financial Worksheets v. 2

Worksheets

· Setup and Assumptions · Sales Projections · Inventory · Capital Purchases · Staffing Budget · Marketing Budget · Professional Services · Capital Investments and Loans · Income Statements · Cash Flow · Balance Sheet · Break Even Estimates · Key Ratios

Charts

· 1st-Year Financials At-A-Glance · Net Sales, Year 1 · 1st-Year cash Flow · 2nd-Year Cash Flow · 5-Year Financials At-A-Glance · Net Sales, 5-Years

The Electronic FInancial Worksheets, v. 2

The Planning Shop, 2004 companion software to The Successful Business Plan: Secrets & Strategies by Rhonda Abrams The Planning Shop, 2003

List of Frequently Asked Questions

COMPATIBILITY QUESTIONS Q: Will the Worksheets work on my Mac? A: Although we love Macs (a lot), this release of the Worksheets will not run on a Macintosh. The Worksheets contain custom programming that will work only on a PC running Windows 98 or later. If you try to run the Worksheets on a Mac, you'll receive an error message and the Worksheets will not open. One work-around is to use a "PC simulator" on your Mac, such as Virtual PC from Microsoft. Virtual PC will allow you to run a fully-functioning version of Windows (and most Windows software, including the Windows version of Excel) on your Macintosh. Q: Will the Worksheets work in any program other than Excel? A: No. Although there are other spreadsheet programs on the market that can read some Excel files, our Electronic Financial Worksheets contain custom programming that will not run correctly in other spreadsheet software. Please make sure you have Excel 97 or later running on Windows 98 or later. Q: When I opened the Worksheets, I received a cryptic error message--what the heck does it mean? A: This is typically due to one of two problems: You are not running the Worksheets on a "supported system configuration." In other words, you're not using a PC with Windows 98 or later and Microsoft Excel 97 or later, OR You do not have "Macros Enabled" in Excel. See the "Macros.txt" file that came with your Worksheets for more information.

The Electronic FInancial Worksheets, v. 2

The Planning Shop, 2004 companion software to The Successful Business Plan: Secrets & Strategies by Rhonda Abrams The Planning Shop, 2003

List of Frequently Asked Questions for The Electronic Financial Worksheets, v. 2

USAGE QUESTIONS Q. Some of the financial worksheets shown in the textbook are not included in the Electronic Financial Worksheets 2.0. Why not? A. In response to many users' feedback, we made some changes in version 2.0 of the Worksheets. We've added several new sheets which aren't included in the book, including a Capital Expenditures worksheet, an Inventory Worksheet, and a Capital Investment Worksheet. In doing so, we've taken the functionality that existed in the old Technology Budget and Startup Budget worksheets and have folded them into the new Capital Expenditures worksheet. With this change, you can now depreciate your technology and startup expenditures across your pro forma statements and the expenditures will be automatically reflected in your Cash Flow and Balance Sheets for you. We think you will find this a much simpler and more powerful method for reflecting your technology and startup expenditures. Q. I don't need all the rows that are available on some of the worksheets, and I'd like to delete them so my financials look nice when I print. How can I remove rows without compromising the calculations the program performs for me? A. Removing rows from any of the worksheets can, indeed, cause problems on other worksheets, because data is passed back and forth "behind the scenes." You never know if one of the rows you are deleting will affect data calculations elsewhere. However, one trick you can try is to "hide" rows that you don't need. Hidden rows are still available to the program, but are not visible to users or on printouts. Here's how to hide a row: Unprotect the worksheet on which the row you want to hide appears. Go to Excel's Tools menu, select the "protection" item, and select "Unprotect Sheet." Make sure that you have zeroed out any numbers that appear in the rows you are hiding--remember, the program will still draw on data in hidden rows. Select any cell in the row you want to hide. If you want to hide a stack of rows, draw your cursor down a column, selecting multiple rows. Go to Excel's "Format" menu, select "Row," then select "Hide." The rows will disappear.

The Electronic FInancial Worksheets, v. 2

The Planning Shop, 2004 companion software to The Successful Business Plan: Secrets & Strategies by Rhonda Abrams The Planning Shop, 2003

List of Frequently Asked Questions for The Electronic Financial Worksheets, v. 2 (cont.)

To unhide rows, do the following: On the worksheet where you want to unhide rows, use your mouse to select both the visible row above and the visible row below where the hidden rows live. Go to Excel's "Format" menu, select "Row," then select "Unhide." The rows will reappear. Q. There are "#####" showing up in some of my worksheet cells instead of numbers. What do I do? A. The "###" signs appear in a cell when the number that should be there is too long to fit within the cell. We have set the cells to comfortably hold seven digits (enough for most of our customers, but not so large that the worksheets won't print on standard size paper). If you have ambitious plans and require more digits, here's what to do: Unprotect the worksheet on which the "####" appears. Go to Excel's Tools menu, select the "protection" item, and select "Unprotect Sheet." Activate the column headers. Go to the Tools menu and select the "Options..." item. Click on the "View" tab. Put a check mark next to the "Row & column headers" item. Click "Okay." Now, to widen a column, place your mouse pointer at the top of the worksheets, within the column headers row (the row with the "A,""B,""C," etc.). Move your mouse between two columns, click and drag to the right. You'll increase the size of the column. Repeat this process for any other columns on the worksheet you wish to expand. Reprotect the worksheet using the "protection" item in the Tools menu. Do not enter a password. Q. There are "#NUM!" errors showing up in some of my worksheet cells instead of numbers. What do I do? A. This indicates that a calculation error is occurring somewhere in the worksheets. The most likely cause is that on the Capital Expenditures or Capital Investments worksheets you have entered a date that is prior to the start date of your company, as entered on the "Setup & Assumptions" worksheet. If you go back and change the date on either of these

The Electronic FInancial Worksheets, v. 2

The Planning Shop, 2004 companion software to The Successful Business Plan: Secrets & Strategies by Rhonda Abrams The Planning Shop, 2003

List of Frequently Asked Questions for The Electronic Financial Worksheets, v. 2 (cont.)

two worksheets to fall after your company's startup date, the #NUM! errors should disappear. In other cases, the error can occur if data of the wrong type has been entered into a cell. For instance, if you have entered alphabetic letters into a cell that is designed to accept only digits, a #NUM! error will occur in all the other cells that depend on that number for calculations. To fix this error, check your entries to make sure that you have entered valid data. Q. My Worksheets seem slow--every time I enter a number, it takes a moment for the program to respond. How can I make it go faster? A. The Worksheets are set up to "recalculate" after a change is made to any cell. This means that as soon as you make a change, all the other dependent numbers on that worksheet and all other worksheets are updated to reflect the change you just made. Because every number you enter will affect other numbers elsewhere in the program, this recalculation can take a moment or two, depending on your computer's processor speed. But there is a solution! You can turn off this "auto-recalculation" feature, and you'll find that entering data is nice and fast. The downside? All the other numbers in the program won't automatically update when you make a change--if you want to see how your changes have affected everything else, you'll need to tell Excel to recalculate by pressing the F9 button on your keyboard. Here's how to turn off auto-recalculation: Go to Excel's Tool menu and select "options." Click on the "Calculation" tab Select "manual" as the calculation option Click "Okay" to save your change Remember to press F9 on your keyboard to update your worksheets after you've entered your data.

The Electronic FInancial Worksheets, v. 2

The Planning Shop, 2004 companion software to The Successful Business Plan: Secrets & Strategies by Rhonda Abrams The Planning Shop, 2003

List of Frequently Asked Questions for The Electronic Financial Worksheets, v. 2 (cont.)

For more answers to frequently asked questions, check The Planning Shop's website: www.PlanningShop.com/worksheets If you need further assistance, feel free to contact The Planning Shop's customer support center via phone between the hours of 9 am and 5 pm Pacific Time, Monday through Friday at 650-289-9120. Email The Planning Shop 24 hours a day, 7 days a week at [email protected] The Planning Shop tries to answer every support email within 24 hours of receipt, during regular business hours. Your comments and suggestions are also welcomed by The Planning Shop! Send your thoughts, success stories, and ideas for future versions of The Electronic Financial Worksheets to [email protected], or mail them to:

Deborah Kaye Academic Director The Planning Shop 555 Bryant Street #180 Palo Alto, CA 94301

The Electronic FInancial Worksheets, v. 2

The Planning Shop, 2004 companion software to The Successful Business Plan: Secrets & Strategies by Rhonda Abrams The Planning Shop, 2003

More Books from The Planning Shop

Six-Week Start-Up: A step-by-step program for starting your business, making money, and achieving your goals!

by Rhonda Abrams, The Planning Shop, 2004 ISBN 0-9669635-9-8 paperback, 283 pg. list price: $19.95 Instructor's Manual, PowerPoint presentation available

What Business Should I Start? 7 steps to discovering the ideal business for you

by Rhonda Abrams, The Planning Shop, 2004 ISBN 0-9669635-8-X paperback, 384 pg. list price: $19.95

Successful Business Research: Straight to the Numbers You Need- -Fast!

by Rhonda Abrams, The Planning Shop, 2005 ISBN 0-9740801-3-6 paperback list price: $29.95

Information

EFWManual.indd

11 pages

Report File (DMCA)

Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

Report this file as copyright or inappropriate

649401