$ 0 $ 1,700 $(2,035) $(1,945) Beginning Cash Cash In: Sales Cash $4,000 $4,800 Collections from Accounts Receivable Loan $ 8,000 Equity $ 8,000 $0 $4,000 $4,800 Total Cash In $ 8,000 $ 1,700 $1,965 $2,855 Total Cash Available Cash Out $1,500 $1,800 $2,250 Inventory Expenses Operating Expenses $50 Licenses $125 Insurance $1,000 $100 $100 $200 Marketing $75 $75 $75 Miscellaneous $100 Office Supplies $400 $400 $400 Payroll $50 $50 $50 Payroll Taxes $150 $125 $125 $125 Telephone $350 $350 $350 Vehicle $1,000 $10 $10 $10 Other: Web Page Capital Purchases $4,000 Vehicle $1,000 $1,000 $1,000 Owner’s Draw $6,300 $3,735 $3,910 $4,460 Total Cash Out Ending Cash $ 1,700 $(2,035) $(1,945) $(1,605) My Plan Assignment 12a: Financial Template— Operating Expenses worksheet Reassure students that while the Financial Plan is typically one of the most challenging to complete, the process has been broken down
Beginning Cash $ 0 $ 1,700 $(2,035) $(1,945) Cash In: Sales Cash Collections from Accounts Receivable $4,000 $4,800 Loan Equity $ 8,000 Total Cash In $ 8,000 $0 $4,000 $4,800 Total Cash Available $ 8,000 $ 1,700 $1,965 $2,855 Cash Out Inventory Expenses $1,500 $1,800 $2,250 Operating Expenses Licenses $50 Insurance $125 Marketing $1,000 $100 $100 $200 Miscellaneous $75 $75 $75 Office Supplies $100 Payroll $400 $400 $400 Payroll Taxes $50 $50 $50 Telephone $150 $125 $125 $125 Vehicle $350 $350 $350 Other: Web Page $1,000 $10 $10 $10 Capital Purchases Vehicle $4,000 Owner’s Draw $1,000 $1,000 $1,000 Total Cash Out $6,300 $3,735 $3,910 $4,460 Ending Cash $ 1,700 $(2,035) $(1,945) $(1,605) My Plan Assignment 12a: Financial Template— Operating Expenses worksheet Reassure students that while the Financial Plan is typically one of the most challenging to complete, the process has been broken down