As a part of our Canadian Business assignment, we are planning to open a restaurant in Canada and need the financial plan in the attached spreadsheet. The sheet should have a profit and loss statement and a balance sheet.
1st Part Balance Sheet 2nd Part 12-Month Income Statement (Profit & Loss Statement) Enter your Company Name here : Insert Year: March April May Decembe Septemb June October Novemb July YEARLY $O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Revenue (Sales) Category 1 Category 2 Total Revenue (Sales) Cost of Goods Sold Category 1 Category 2 Total Cost of Goods Sold $0 $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Assets Current Assets Cash in Bank Cash Value of Inventory Prepaid Expenses (insurance) Total Current Assets Fixed Assets Machinery & Equipment Furniture & Fixtures Real Estate / Buildings Total Fixed Assets Total Assets Liabilities & Net Worth Current Liabilities Accounts Payable Taxes Payable Notes Payable (due within 12 months) Total Current Liabilities Long-Term Liabilities Bank Loans Payable (greater than 12 months) Less: Short-Term Portion Total Long-Term Liabilities Total Liabilities Owners' Equity (Net Worth) Total Liabilities & Net Worth Gross Profit 0 0 0 0 0 0 0 0 0 0 0 0 0 $0 Operating Expenses Rent Expense Salary/Wage Expenses Supplies Expense Advertising Expense Utilities Expense Telephone/Internet Expense Insurance Expense Interest from Loans (if applicable) Other Expenses (specify) Total Expenses Net Profit $0 $0 $0 $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1st Part Balance Sheet 2nd Part 12-Month Income Statement (Profit & Loss Statement) Enter your Company Name here : Insert Year: March April May Decembe Septemb June October Novemb July YEARLY $O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Revenue (Sales) Category 1 Category 2 Total Revenue (Sales) Cost of Goods Sold Category 1 Category 2 Total Cost of Goods Sold $0 $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Assets Current Assets Cash in Bank Cash Value of Inventory Prepaid Expenses (insurance) Total Current Assets Fixed Assets Machinery & Equipment Furniture & Fixtures Real Estate / Buildings Total Fixed Assets Total Assets Liabilities & Net Worth Current Liabilities Accounts Payable Taxes Payable Notes Payable (due within 12 months) Total Current Liabilities Long-Term Liabilities Bank Loans Payable (greater than 12 months) Less: Short-Term Portion Total Long-Term Liabilities Total Liabilities Owners' Equity (Net Worth) Total Liabilities & Net Worth Gross Profit 0 0 0 0 0 0 0 0 0 0 0 0 0 $0 Operating Expenses Rent Expense Salary/Wage Expenses Supplies Expense Advertising Expense Utilities Expense Telephone/Internet Expense Insurance Expense Interest from Loans (if applicable) Other Expenses (specify) Total Expenses Net Profit $0 $0 $0 $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
