Need to prepare estimated financial records of a Restaurant business.

Students will build on the Idea they submitted on the Market Analysis Assignment assignment. Using the business idea approved by the professor in the Business Plan Mentorship \#1 meeting, and using the feedback given; students will provide a spreadsheet with several worksheets to demonstrate what the financials might look like for their company in the first year. Group Information Students should work in the same groups as used on the Market Analysis Assignment assignment. Assignment Requirements Students will submit an excel spreadsheet with several worksheets. One worksheet should contain a balance sheet, another an income statement and a third should include a breakeven analysis. (Including charts demonstrating their breakeven point). On the same sheet as the balance sheet students should calculate several applicable financial ratios (leverage, liquidity, etc). Likewise on the income statement worksheet students should also provide some applicable ratios financial ratios (profitability, efficiency). Students should consider carefully which types of accounts (and their approximate size). Service business vs retail vs manufacturer will have drastically different sized accounts based on the kind of business they do. Some level of research about the industry your company is in is expected. Be sure to reference applicable sources that are used to come up with your estimates. Assignment Evaluation Students will be graded firstly on completeness. Students who do not complete the minimum requirements should not expect a passing grade. Students who complete the minimum requirements listed above adequately should expect up to 75% on the assignment. Student who submit work that demonstrates their understanding of both the format (balance sheet, income statement and breakeven) how their business ideas accounts might be able to achieve greater then 75%. Note: Plagiarism or Academic Misconduct on one part of the assignment will be result in a zero on the entire assignment (and the usual academic penalties). All students who contribute to an assignment may be held responsible for Academic Misconduct contained within the assignment. Students will build on the Idea they submitted on the Market Analysis Assignment assignment. Using the business idea approved by the professor in the Business Plan Mentorship \#1 meeting, and using the feedback given; students will provide a spreadsheet with several worksheets to demonstrate what the financials might look like for their company in the first year. Group Information Students should work in the same groups as used on the Market Analysis Assignment assignment. Assignment Requirements Students will submit an excel spreadsheet with several worksheets. One worksheet should contain a balance sheet, another an income statement and a third should include a breakeven analysis. (Including charts demonstrating their breakeven point). On the same sheet as the balance sheet students should calculate several applicable financial ratios (leverage, liquidity, etc). Likewise on the income statement worksheet students should also provide some applicable ratios financial ratios (profitability, efficiency). Students should consider carefully which types of accounts (and their approximate size). Service business vs retail vs manufacturer will have drastically different sized accounts based on the kind of business they do. Some level of research about the industry your company is in is expected. Be sure to reference applicable sources that are used to come up with your estimates. Assignment Evaluation Students will be graded firstly on completeness. Students who do not complete the minimum requirements should not expect a passing grade. Students who complete the minimum requirements listed above adequately should expect up to 75% on the assignment. Student who submit work that demonstrates their understanding of both the format (balance sheet, income statement and breakeven) how their business ideas accounts might be able to achieve greater then 75%. Note: Plagiarism or Academic Misconduct on one part of the assignment will be result in a zero on the entire assignment (and the usual academic penalties). All students who contribute to an assignment may be held responsible for Academic Misconduct contained within the assignment