Business Start Up Project

Business Type	Lemonade Stand
Location	Mall
Business Opening Date	April 1st
Hours of Operation	10am – 9pm Monday through Saturday, 12pm – 6pm on Sundays. Closed on Thanksgiving, Christmas, and New Year’s Day.
Weekly Mall Traffic	100,00 patrons, including children
Market Analysis	Stand location can sell 15 -25 cups of lemonade per hour, initially you estimate your stand can sell 20 cups per hour. Each cup holds 12 fluid ounces and will be filled with 10 ounces of lemonade
Accepted Form of Payment	ALL SALES WILL BE CASH
Monthly Rent	$4500 plus 3.5% of total sales Rent includes all utilities (water, gas, electric), garbage collection, custodial services, mall security, and liability insurance. Rental agreement is month-to-month, must be personally guaranteed. One-month deposit of $4,500 is required
Material Purchases	All material purchases will be paid for in cash; no trade credit will be used. Current cost of lemons is $0.28 per lemon. A cup of lemonade requires three lemons. Maximum lemon storage is one week, refrigerated. The sugar cost is $0.19 per pound for 50 pounds. One cup requires one tablespoon of sugar or 5 grams of sugar per cup. One-pound equals 454 grams. Cups with lids cost $0.10 each for a quantity of 1000 cups. Straws cost $0.01 each for a quantity of 5000 straws. Napkins cost $0.003 each for a quantity of 10,000 napkins. It is anticipated that each customer will utilize at least two napkins. Bottled water is $1.00 per gallon delivered on site to the lemonade stand. Water must be purchased in a minimum of 50-gallon increments.
Employees	2 attendants at the stand from 9:30 am – 10:30 pm Monday through Saturday. 1 additional attendant after 3 pm 3 attendants on Sundays from 11:30 am – 7:30 pm One of the attendants will be a supervisor, a supervisor must be present at all hours. (you may elect to be the supervisor on site at all hours or part of the hours, you may also elect to have a family member or partner be the supervisor). As the owner, you would like to take a salary of $80,000 per year (including benefits)
Hourly Rate (attendants)	minimum wage in Ohio ($8.70 per hour) plus 30% for benefits (note: you will need to calculate the hourly wage rate as a single amount: minimum wage plus benefits costs)
Hourly Rate (supervisor)	$21.00 per hour (this already includes benefits). The supervisor’s salary is for an employee other than yourself.
Capital Equipment Cost	Setting up the stand is $250,000 which includes all equipment, counters, signage, refrigerators, ice-machine, and cash register. This equipment can be purchased with $50,000 cash and a bank loan for the remainder. You will need to determine the bank loan terms for the remainder amount- the annual interest and monthly payments for 5 years. You are to assume that the monthly loan payment will be $XXXX amount, broken down as $X interest each month and $X on the loan principal balance. The equipment is to be depreciated on a straight-line basis (no salvage value) over the 7 years of its estimated life. Note: “free” loans – where you do not have to make payments for X-years on the loan are not to be used.

1. Starting (opening) Balance Sheet (time zero)
   1. Create a Balance Sheet showing starting Assets, Liabilities, and Shareholder's Equity. The assets will include cash, equipment, inventory, etc. The long-term liabilities will include the bank loan.
   2. The shareholder's equity will include starting capital which must be sufficient to purchase starting inventory, pay employees and rent for the first 2 months, pay the $4500 rental deposit, pay $50,000 for the equipment, and make payments on the equipment loan for the first year.
   3. The equity is your cash investment in the business and may come from your personal savings, personal investments, from your family and friends, a second mortgage on your home, or your kids' piggy banks. It may also partially come from a partner or partners. The cash investment will be shown as Shareholder's Equity on the Balance Sheet. Some of this cash will be spent on equipment ($50,000), starting inventory, rent deposit ($4500), et The remainder will appear as cash on hand on the Balance Sheet to help cover the monthly expenses going forward.
2. Projected Income Statement for First Month and End of Year 1
   1. Based on your sales estimates, calculate the cost of operating the business for the first month and then for the first 12 months of operation including materials costs, labor, accessories (straws and napkins), rent payments, interest payments, and depreciation. Note: Estimated sales are cyclical. For example, you will need to estimate a higher sales volume (greater than 20 cups per hour) during the summer season, etc. You must provide your monthly sales estimates.
   2. You will need to calculate the direct materials costs to make one cup of lemonade. Make sure to include the costs for the cup, lid, straw, and napkins.
   3. Based on the above calculated cost and the initial sales estimates, establish a projected selling price per cup with a minimum 20% profit.
   4. Prepare a Projected Income Statement for the first month of operations. Then, prepare a Pro Forma Income Statement as of the close of year 1.
3. Cash Flow Analysis
   1. Calculate cash flows at start-up and then for each month. Cash flow is the most important financial data in a business, especially a start-up. Business happiness is positive cash flow.
4. Projected Balance Sheet for First Month of Operations and End of Year 1
   1. Calculate a projected Balance Sheet at the close of month 1 using the starting Balance Sheet, the Projected Income Statement data, and the Cash Flow Analysis. Then prepare a projected Balance Sheet as of the close of year 1.

Answer rating: 100% (QA)

Question Prepare a Projected Balance sheet A projected balance sheet is also referred to as a pro forma balance sheet It shows the estimation of the total assets and total liabilities of any business ... View the full answer