Question: Use the excel handout to develop financials for final project 1. Start with a monthly budget. Figure how many items you might sell. To make

Use the excel handout to develop financials for final project 1. Start with a monthly budget. Figure how many items you might sell. To make it realistic do not make all months the exact same. please help me complete this, it is about a financial plan of an imaginary restaurant, just need to fill it randomly with no prior statement, choose any numbers you wishUse the excel handout to develop financials for final project 1. Start

with a monthly budget. Figure how many items you might sell. To

12-Month Income Statement (Profit & Loss Statement) Enter your Company Name here Insert Year: September November October December April YEARLY Revenue (Sales) Category 1 Category 2 Total Revenue (Sales) 0 01 01 0 01 0 0 Cost of Goods Sold Category 1 Category 2 Total Cost of Goods Sold 0 Gross Profit 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 0 0 0 0 0 0 0 0 Net Profit ol ol 0 ol ol 0 0 Balance Sheet Current Assets Cash in Bank Cash Value of Inventory Prepaid Expenses (insurance) Total Current Assets $0 Fixed Assets Machinery & Equipment Furniture & Fixtures Real Estate / Buildings Total Fixed Assets SO Total Assets $0 Liabilities & Net Worth Current Liabilities Accounts Payable Taxes Payable Notes Payable (due within 12 months) Total Current Liabilities $0 Long-Term Liabilities Bank Loans Payable (greater than 12 months) Less: Short-Term Portion Total Long-Term Liabilities $0 Total Liabilities SO Owners' Equity (Net Worth) SO Total Liabilities & Net Worth $0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

\f