Create a budget/statement of cash flows in Excel. Use the format as laid out in the book in Chapter 6. The excel file should have four tabs, in this order: Income Statement (p 97), Balance Sheet (p 103), Cash to be Paid Out (p 87), and Sources of Cash (p 89). Use the dollar amounts from the examples in the book. Use formulas when appropriate. You will create your own Cash to be paid out, and Sources of Cash as described in the text. Then the Pro Forma Cash Flow Statement for Year 1 of operations is shown in the text. Do not include tax considerations at this time.

Pinson, L. (2013). Anatomy of a business plan: The step-by-step guide to building your business and securing your company's future.