Hi Sir,

Please help to prepare financial statements for 5 years for hypothetical case

HYPOTHETICAL - CASE - MEAL BOX - STARTUP - RAW MATERIAL DELIVER TO CUSTOMER

BUDGET - TENTATIVE

PLEASE PREPARE:

• 5 YEARS - PROFIT AND LOSS - Pls specify all the details in Excel for understanding.
• 5 YEAR - CASH FLOW- - Pls specify all the details in Excel for understanding.
• 5 - BALANCE SHEET - - Pls specify all the details in Excel for understanding.
• Also please comment on the main ratios

CAPITAL - USD - 20000 BY 5 PARTNERS = USD 100,000.00

Expenses:

Shop - rent: USD 30,000.00 (Annual)

Electricity: USD 500.00 PER MONTH

Startup- ELECTRIC transport - USD 8,000.00 (SECOND HAND)- ASSET

Refrigerator - USD 5000.00 (SECOND HAND)-ASSET

INSURANCE - 1000.00 USD YEARLY , Fire content - USD 1500.00 YEARLY

Prep counters and cutting boards - USD 300.00 ONE TIME

Safety tools (first aid, fire prevention) - USD 200.00 ONE TIME

Storage space, shelving, and containers - USD 500.00 ONE TIME

Sinks/washing equipment - USD 500.00 ONE TIME

Cooking equipment (pots, pans, utensils, bowls, towels - USD 500.00 ONE TIME

Ingredients or material - Cost: USD 3,000.00 MONTHLY

Packaging cost - USD 1.50 PER BOX

Website development and maintenance, online ordering platform - USD 3000.00 ANNUAL

Software cost - USD 100.00 YEARLY

Marketing and advertising cost for targeting market - USD 2000.00 ANNUAL

Legal fees for business registration, permits, and license - USD 700.00 ONE TIME

National food level 2 permit - USD 300.00 2 ANNUALS

Provision of Facilities and Services

For air conditioning in your business space - USD 1000.00 ONE TIME

Employee - salary: USD 0.00 (for first 6 months)

Employee - salary: USD 22.80 hrs for 5 hrs for 7 days (after first 6 months)

Telephone cost + Internet cost - USD 300.00

Sale - TARGET TO Sale BY WEBSITE - 10 boxes per day (except SUNDAY) and each box cost USD 12.00 (Including 15% GST) FOR FIRST 6 MONTH AND THEN 12 Boxes per day (except Sunday) and each box cost USD 12.00 (Including 15% GST)

Sale - TARGET for a subscription - 5 boxes per day (except SUNDAY) and each box costs USD 10.00 each day for a monthly subscription- It will continue throughout the business.

TARGET - 2^ND YEAR ONWARD 20% of Sales will be increased for website sales and 20% of sales will be increased for subscription sales.

Assumption -

• No delivery cost as it will be done by partners.
• Pricing includes GST.
• NO FUEL COST FOR AN ELECTRIC VEHICLE
• INITIAL 6 MONTHS - NO SALARY - AS PARTNER WILL DO DELIVERY AND AFTER 6 MONTHS 5 PARTNERS WILL TAKE A SALARY OF USD 22.80 PER HRS FOR 5 HRS FOR 7 DAYS.
• TAX - AS PER USA TAX LAW