Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 wish
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 $0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started