Answered step by step
Verified Expert Solution
Link Copied!

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 wishimage text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions