Step 1 - Documentation and Planning Worksheets:

Documentation Worksheet

• Include your name, date, name of the business (The City Caf), and the purpose of the workbook.

Planning Worksheet

• Transfer the questions presented in the following steps and provide answers for each step.
• Identify which worksheet contains the information for each step.

Step 2 - Required Funds Worksheet:

1. Required Funds Worksheet
   • List all the expenses and prices from the business plan.
   • Include personalized cafe items and the costs associated with implementing them.
   • Account for any other necessary expenses to start the cafe.

Step 3 - Income and Expense Worksheets and Charts:

Income Worksheet

• Detail how you expect to earn money from the cafe's operations.
• Include income sources such as in-cafe orders, online orders, and call-in delivery orders.
• Use Excel predefined formulas to track expected incomes.

Expense Worksheet

• List the monthly expenses, including rent, advertisement, insurance, legal and accounting fees, repairs, supplies, utilities, internet, telephone, and staff salaries.
• Calculate income and expense balance.

Loan Feasibility Worksheet

• Include an expected income statement.
• Create charts to visualize income and expenses.
• Utilize conditional formatting to highlight key data points.

Investor Graphs Worksheet

• Include appropriate charts to visualize income and expenses. Ensure these charts are on the Investors worksheet.

Step 4 - Loan Amortization Schedule Worksheet:

1. Loan Amortization Worksheet
   • Create an amortization schedule based on the loan scenario provided.
   • Use financial functions to calculate interest and principal payments for each quarter.
   • Include this loan amortization schedule in the workbook.

Step 5 - Sales Report Worksheets:

Sales Summary Report Worksheet

• Create a summary worksheet to consolidate sales data from all locations.
• Include data from St. Louis, Chicago, and Memphis locations.

Individual Sales Records for St. Louis, MO Worksheet

• Populate this worksheet with sales data for The City Caf in St. Louis.
• Include monthly sales, cost of goods sold, payroll, and building costs.

Individual Sales Records for a Franchised Location Worksheet

• Populate this worksheet with sales data for one of the franchised locations.
• Include monthly sales, cost of goods sold, payroll, and building costs.

Individual Sales Records for a Franchised Location Worksheet

• Populate this worksheet with sales data for another franchised location, if applicable.
• Include monthly sales, cost of goods sold, payroll, and building costs.

Step 6 - Formatting:

• Apply a themed template or ensure that the workbook has a professional, visually appealing look.

Ensure that each worksheet is organized and well-labeled for easy reference. Verify that all calculations are accurate and that charts effectively communicate financial information. Once you've completed all these steps, you'll have a comprehensive Excel workbook for The City Caf's business plan.