Answered step by step
Verified Expert Solution
Question
1 Approved Answer
create a financial projection with the data financial projection for duration of 6 months 9.0 Financial Projection Our starting capital for COOK is RM16,000, which
create a financial projection
with the data
financial projection for duration of 6 months
9.0 Financial Projection Our starting capital for COOK is RM16,000, which will be used to pay for the startup expenses. Specifically, will be contributing RM6,400, while vill be contributing RM3.200 each. Our estimated expenses at startup consists of website development which amounts approximately RM6,000. We will be also purchasing 2 freezers which have the volume of 200L and 700L respectively. Furthermore, a payment processor will be set up. The chosen online payment gateway is iPay88, which has a one-time registration and annual fee of approximately RM1,000 in total. Lastly, we will also allocate around RM5,035 for other miscellaneous expenses such as furniture, operating license fee, office equipment and etcetera. Table 1 below shows a breakdown of our expenses at startup. Estimated expenses at startup (on Jan 2021): Table 1: Estimated expenses at startup of COOK Feb 1,600 Unit sales/month (1) Product revenue Service revenue (2) Gross profit Jan 1,000 5,000 2,333 7,333 8,000 3,733 11,733 Mar 1,750 8,750 4,083 12,833 Apr 1,900 9,500 4,433 13,933 May 2,100 10,500 4,900 15,400 Jun 2,250 11,250 5,250 16,500 Employee payroll Marketing expenses Rental Utilities Others (Maintainance, allowance, etc) Starting expenses Total expenses (2,400) (400) (2,000) (600) (500) (16,000) (21,900) (2,400) (600) (2,000) (620) (800) (2,400) (400) (2,000) (630) (500) (2,400) (200) (2,000) (640) (500) (2,400) (200) (2,000) (650) (500) (2,400) (200) (2,000) (660) (500) (6,420) (5,930) (5,740) (5,750) (5,760) Net profit (14,567) 5,313 6,903 8,193 9,650 10,740 5,843 15,493 26,233 Profit projection (14,567) (9,253) (2,350) [1] average revenue for each product is RMS [2] service revenue = (unit sales per month/ 3) x RM7 average delivery charge Key Resources - - - - maltose - candy mold - cold kitchen - freezer - ice box - fruits - chiller - wrapping paper - kitchen utensils and equipment I - - Cost Structure - - production cost - marketing cost - distribution cost employee payment - partnership fee - raw materials cost 9.0 Financial Projection Our starting capital for COOK is RM16,000, which will be used to pay for the startup expenses. Specifically, will be contributing RM6,400, while vill be contributing RM3.200 each. Our estimated expenses at startup consists of website development which amounts approximately RM6,000. We will be also purchasing 2 freezers which have the volume of 200L and 700L respectively. Furthermore, a payment processor will be set up. The chosen online payment gateway is iPay88, which has a one-time registration and annual fee of approximately RM1,000 in total. Lastly, we will also allocate around RM5,035 for other miscellaneous expenses such as furniture, operating license fee, office equipment and etcetera. Table 1 below shows a breakdown of our expenses at startup. Estimated expenses at startup (on Jan 2021): Table 1: Estimated expenses at startup of COOK Feb 1,600 Unit sales/month (1) Product revenue Service revenue (2) Gross profit Jan 1,000 5,000 2,333 7,333 8,000 3,733 11,733 Mar 1,750 8,750 4,083 12,833 Apr 1,900 9,500 4,433 13,933 May 2,100 10,500 4,900 15,400 Jun 2,250 11,250 5,250 16,500 Employee payroll Marketing expenses Rental Utilities Others (Maintainance, allowance, etc) Starting expenses Total expenses (2,400) (400) (2,000) (600) (500) (16,000) (21,900) (2,400) (600) (2,000) (620) (800) (2,400) (400) (2,000) (630) (500) (2,400) (200) (2,000) (640) (500) (2,400) (200) (2,000) (650) (500) (2,400) (200) (2,000) (660) (500) (6,420) (5,930) (5,740) (5,750) (5,760) Net profit (14,567) 5,313 6,903 8,193 9,650 10,740 5,843 15,493 26,233 Profit projection (14,567) (9,253) (2,350) [1] average revenue for each product is RMS [2] service revenue = (unit sales per month/ 3) x RM7 average delivery charge Key Resources - - - - maltose - candy mold - cold kitchen - freezer - ice box - fruits - chiller - wrapping paper - kitchen utensils and equipment I - - Cost Structure - - production cost - marketing cost - distribution cost employee payment - partnership fee - raw materials cost Step 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