AGBU 292: Agribusiness Final Year Project - Financial Plan Exercise Instructions: Consider the following hypothetical situation. Read the information provided below on the company Take-Home Pizza, Inc. Based on this information, prepare the projected financial statements in accordance with general accounting principles. The projected financial statements should be submitted in a single Excel file, per student. Students should complete the exercise and all the questions individually. Company and Products: Take-Home Pizza, Inc. is a new pizza take-out and delivery service started in the suburbs of Beirut. Take-Home Pizza, Inc. will be a privately held corporation owned in majority by Ben and his partner, Alex. Take-Home Pizza, Inc. will offer a wide variety of pizza, as well as sauces, sodas, fruit juices, and desserts. A new investor will be invited to participate in the company's capital, which will be $101,500. After spending several months searching for a convenient location, they have decided to open their business in the suburbs of Beirut by leasing a commercial space in the area. Business Model: Take-Home Pizza, Inc. is a typical take-home restaurant where customers order food and drinks at the counter, as opposed to sit-down restaurants that provide table service. Wait-staff is therefore not included in the work team. Orders are taken online, by phone, or at the company's location. To prepare pizza, they will use high-quality ingredients and traditional recipes. State-of-the-art, energy-efficient food preparation equipment, and technology will be available to their kitchen staff, as they plan to invest their capital invaluable long-term assets. Personnel Plan: Personnel will include one manager, one cook, one kitchen staff member, and two servers. As their restaurant will be open Monday through Saturday, the team of five can operate effectively only by using alternative work schedules that take into account the busiest periods of the day, the time needed to prepare the food before opening, and a forty hours week. In addition to salaries, important bonuses and incentives are included in the personnel table that will be used to reward employee performance, on a pay-for-performance basis. (Note: No-adjustment is required for inflation during the first year of operation.) Personnel Plan Year 1 (Sep 19-Aug 20) Manager $22,800 $20,400 Kitchen Staff Member $19,200 Servers (2) $38.400 Bonuses and Incentives $7,800 Other SO Total People 5 Total Payroll $108,600 Cook Start-Up Funding Take-Home Pizza, Inc. needs start-up capital that will be used for legal expenses, kitchen inventory and equipment, packing and other materials, rent, promotion, business sign, and inventory on hand at start- up, as detailed below. Co-owners Ben and Alex have estimated total start-up costs of $131,500 Co-owners Ben and Alex have agreed to provide start-up financing in the amount of $72,000 ($36,000 each and a combined share of 70.94% ownership). Approximately $59.500 in additional funding is needed An investor and co-owner is welcome to participate in the company's capital for the amount of $29,500, and could be offered a portion of 29.06% ownership of the $101,500 company capital. The cumulative dividends that would be paid to the new investor, based on 29.06% ownership, over the next five years, would be $187,618 o Year 1 $17,892 o Year 2 $27,091 o Year 3 $37,213 o Year 4 $48,613 o Year 5 $56,809 Co-owners Ben and Alex will not take dividends over the first five years. The reasons for this decision are: a) they will receive employment compensation and benefits, and b) the undistributed dividends will increase the amount of retained earnings, as a strategy to strengthen the company's financial position for sustainable future growth, to increase the company's net worth, and subsequently the market value when it goes public For the remaining $30,000 additional financing needed to cover the start-up costs, the company plans to receive a five-year term commercial loan facility, which will meet the cash flow requirements. The borrowed funds will be used exclusively to buy equipment, based on the list that will be made available to the lending institution. The loan could be repaid in equal monthly installments over a 5-year period. Start-Up Expenses . Rent: A commercial property will be leased in August 2020 for a minimum of five years, with the option to extend the lease for another five years after that. The co-owners have an estimated $2,000 monthly rent expense ($17.22 per square meter per month). Kitchen Inventory: Food preparation (aprons, blender, gloves, storage containers, trays, work tables, mixers, condiment bottles, cleaning supplies and equipment, tableware, pots and pans, glassware, paper, pizza pans, etc.), pizza tools (parchment paper, oven brush, bobble popper, pizza tray rack, pizza separator, and other specific items); and utensils (cooking utensils, wheel cutters, cutting guide, rocker knives, etc.) Kitchen Equipment: Pizza ovens, pizza dough equipment (digital scale, mixer, dough docker, automatic dough press, pizza sheeter, manual pizza press), pizza display merchandiser, refrigerated preparation tables, freezers, cooler package, and holding table with infrared warmers. Other expensed equipment: Neon pizza signs, tables, and chairs, coffee makers, coffee filters, tea dispensers, juice dispensers, cleaning equipment, dish machines, etc. Promotion expenses at start-up are initially estimated at $3,300 and will be used for various marketing information materials and advertisements. Legal expenses include business formation, advice and assistance, basic contract reviews, and general business advice Office supplies include desks, files, tape, record books, forms, etc. Permit expenses are the additional costs incurred to operate legally in the suburbs of Beirut Start-Up Assets Long-term assets: $50,000 worth of equipment (long-term assets) will be expensed over the next five years, using the straight-line depreciation method. The company policy is to purchase only new, state-of-the-art, energy-efficient equipment from reliable suppliers in the food industry. Inventory on hand at start-up includes specific ingredients for pizza preparation (flour, spices and pizza condiments), sauces, juices and other soft drinks, coffee, tea, toppings, parmesan cheese, cookie dough, breadsticks and different dessert items that can be ordered together with the main menu item. It also includes supplies that are used during the packing, sale, and delivery process, and miscellaneous supplies. The cash requirement at start-up is estimated to be $14,000. Summary: Start-Up Expenses and Start-Up Assets Start-up Expenses Legal $2,200 Kitchen Inventory (Supplies) $6,000 Packing Materials $2,500 Kitchen Equipment $20,000 Rent $2,000 Promotion $3,300 Other Expensed Equipment $5,000 Business Sign $3,000 Permits $2,500 Office Supplies $2,000 Other (miscellaneous) $4,000 Total Start-up Expenses $52,500 Start-up Assets Cash Required $14,000 Start-up Inventory $15,000 Long-term Assets $50,000 Total Assets $79,000 d 1.pdf 4 / 6 / 66% + Total Funding Requirements Start-Up Expenses to Fund $52,500 Start-Up Assets to Fund $79,000 Total Funding Required $131,500 Estimation of Target Market Share The population in suburbs of Beirut exceeds one million, which means that, theoretically, the maximum number of pizzas (1/2 pie portions) ordered per month at different restaurants in the area (total market) would be 100,000 pies (1 million residents / 5 residents / 2 half pies). This number needs to add the orders that will be made by many businesses, let's assume five hundred businesses, in the area which is estimated at 5% of the retail market (5,000 pies (100,000 ples x .05)). Thus, the estimated total market in suburbs of Beirut area is 105,000 pies per month. Take-Home Pizza, Inc. estimates a target market share of 4,224 ples or 4% (4,224 ples / 105,000 pies -,04) per month, and believes this target market share to be reasonable and achievable. Assuming 24 business days per month, the company estimates to attract and maintain at least the minimum number of customers required to order 176 ples per day (4,224 ples/24 days). If each customer would order one pie it would mean a total of 4,224 customers per month. This figure is disputable because the companies typically order a large number of pizza, and the individuals usually buy by slices, or order full ples for home delivery. However, it is a good starting point for analysis. The company's market survey shows that one in five persons interviewed order pizza at least once a month. Sales Forecast Projected sales are actually net sales, which consist of the gross proceeds from sales of merchandise (te, gross sales -- less returns and allowances). Considering an average price of $17 per pie, Take-Home Pizza, Inc. would need to sell on average 176 pies each day ($72,000 average monthly sales / $17 per pie 124 business days per month). Two weeks are reserved each year for paid vacation, when the restaurant will be closed, but important maintenance works are scheduled for the equipment and facilities during this break period. This is the reason why the sales in August are projected at 50% of normal sales. Using the equipment and technology the company will be able to produce maximum 400 ples per day (theoretical operating capacity). However the normal operating capacity, which takes into account the usual breaks and the idie periods, is only 300 ples per day, or 75 percent (usually 10 working hours per day). That means that the average projected 176 pies per day would be reached at only 58 percent of normal operating capacity (176 ples / 300 pies - 58), which is a reasonable target. In periods of peak sales, the normal operating capacity could be extended by working more than 10 hours per day Therefore from the operating point of view, the sales forecast is feasible. This is a hypothetical example and does not reflect the actual population number in the suburbs of Beirut 11.pdf 5 / 6 66% + [ @ Based on the above scenarios, the sales forecast and price per pie of the first 12 months for the business year 2019) are provided for you. 0 20 Nov 20 Dec 20 Feb-21 Mar 21 Apr-21 May 21 21 MA21 13150 560 410 216 140 20 30 180 130 19 1 500 1.300 356 2 160 20 2194 1.540 700 360 200 1,670 710 375 220 Sales Forest Pin for NI Pius Healthy She marian Pizza Special Other Total Un Poes for All a Haley Style Piena prian Man Special Other 1.720 730 375 250 120 1,195 1.800 150 40 130 2.150 1.090 555 USO 10 410 330 150 1610 2010 1060 435 350 100 4015 2.100 1.100 570 420 TO 350 300 210 30 3.100 170 4,345 2.000 3.105 BO 4520 15 26 16 16 18 19 21 25 16 18 19 21 25 16 18 19 21 16 18 19 21 25 16 18 19 21 16 10 19 21 16 18 19 20 25 16 18 19 21 19 21 16 18 19 23 21 20 * Important Assumptions Due to current economic uncertainties, the company's assumptions are conservative. In judging and estimating, the co-owners have chosen the alternatives that are least likely to overstate assets and income. General Assumptions FY2020 FY2021 FY2022 FY2023 FY2024 Estimated sales growth 10% 10% 5% % Cost of goods sold % of sales) 52% 52% 52% 52% 52% Inventory (of sales) 39% 39% 39% 39% 39% Other Operating Expenses '% Sales) 0.5% 0.5% 0.5% 0.5% 0.5% Payroll Taxes and Benefits 29% 29% 29% 29% 29% Long-term Interest Rate 12% 12% 12% 12% 12% Corporate Tax Rate 30% 30% 30% 30% 30N Payment Delays 30 30 30 30 30 Sales on Credit 15% 15% 15% 15% 15% Sales Tax, VAT 10% 10% 10% 10% 10% Inflation Rate 5X 5% 5% 5X 5% Collection Period Next month following sales Target Inventory 39% of current sales Accounts Payable (Cost of goods sold + Targeted Inventory (Ending) - Targeted Inventory (Beginning Payroll $ 108 600 per year Sales and Marketing and Other Expenses $8,000 per year Office Supplies $1,200 per year Utilities $6,600 per year Insurance $9,000 per year Depreciation A strait line method. no salvare value at the end of its useful life '5 years) Note: Costs/expenses following year I should be adjusted for inflation (which is hypothesized to be 5%). Questions Questions Prepare the projected financial statements for Take-Home Pizza, Ine for the period FY2020-F2024, in accordance with the general accounting principles. Link the sales projections, cost of sales, expenses, and projected financial statements on Excel Sheet 1. Prepare opening Balance Sheet of Take Home Pizza, Inc 2. Prepare Monthly Sales Forecast and Pro Forma statements (Profit and Loss, Cash Flow and Balance Sheet) for the first year 3. Prepare Yearly Sales Forecast and Proforma itatements (Profit and Loss, Cash Flow and Balance Sheet) for the next five years. 4. Prepare the ratio analysis that clearly shows Take-Home Pizza, Inc.'s financial position. s. When will the company start to break even? 6. Calculate the Monthly (Yearly Units Break even and Monthly (Yearl Revenue break-even. Hint: Compute Average Per Unit Revenue Average PerUnit Variable Cout, and Estimated Monthly Fixed Cost. 7. When is the payback period for the new investor? 2. Prepare the following ratios for the period FY2020-P82024 Current . Quick Total Debit to Total Assets . Net Profit Margin Return on Equity Assets to Sales . Current Debt/Total Assets Dette Equity ched 1.pdf Based on the above scenarios, the sales forecast and price per pie of the first 12 months (or the business year 2019) are provided for you. Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 2,010 1,060 780 340 180 120 80 1,500 435 Sales Forecast (Units) Pizza for All Pizza Healthy Style Pizza Vegetarian Pizza Special Other Total Unit Sales Unit Prices Pizza for All Pizza Healthy Style Pizza Vegetarian Pizza Special Other 960 410 216 140 90 1,816 1,300 556 288 160 90 2394 1,540 700 360 200 100 12.900 1,670 730 375 220 110 3,105 1,720 730 375 250 120 3,195 1,800 850 430 330 150 3560 1,850 850 430 330 150 3,610 2,150 1,090 555 380 170 4,345 2,300 1 100 570 420 350 160 4,015 1,150 550 300 210 90 2,300 180 4570 16 16 18 19 21 25 16 18 19 21 25 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 Important Assumptions Due to current economic uncertainties, the company's assumptions are conservative. In judging and estimating, the co-owners have chosen the alternatives that are least likely to overstate assets and income. General Assumptions FY2020 FY2023 5% Estimated sales growth Cost of goods sold (% of sales) FY2021 10% 52% 39% FY2022 10% 52% 39% FY2024 % 52% 39% 52% 39% 52% 39% AGBU 292: Agribusiness Final Year Project - Financial Plan Exercise Instructions: Consider the following hypothetical situation. Read the information provided below on the company Take-Home Pizza, Inc. Based on this information, prepare the projected financial statements in accordance with general accounting principles. The projected financial statements should be submitted in a single Excel file, per student. Students should complete the exercise and all the questions individually. Company and Products: Take-Home Pizza, Inc. is a new pizza take-out and delivery service started in the suburbs of Beirut. Take-Home Pizza, Inc. will be a privately held corporation owned in majority by Ben and his partner, Alex. Take-Home Pizza, Inc. will offer a wide variety of pizza, as well as sauces, sodas, fruit juices, and desserts. A new investor will be invited to participate in the company's capital, which will be $101,500. After spending several months searching for a convenient location, they have decided to open their business in the suburbs of Beirut by leasing a commercial space in the area. Business Model: Take-Home Pizza, Inc. is a typical take-home restaurant where customers order food and drinks at the counter, as opposed to sit-down restaurants that provide table service. Wait-staff is therefore not included in the work team. Orders are taken online, by phone, or at the company's location. To prepare pizza, they will use high-quality ingredients and traditional recipes. State-of-the-art, energy-efficient food preparation equipment, and technology will be available to their kitchen staff, as they plan to invest their capital invaluable long-term assets. Personnel Plan: Personnel will include one manager, one cook, one kitchen staff member, and two servers. As their restaurant will be open Monday through Saturday, the team of five can operate effectively only by using alternative work schedules that take into account the busiest periods of the day, the time needed to prepare the food before opening, and a forty hours week. In addition to salaries, important bonuses and incentives are included in the personnel table that will be used to reward employee performance, on a pay-for-performance basis. (Note: No-adjustment is required for inflation during the first year of operation.) Personnel Plan Year 1 (Sep 19-Aug 20) Manager $22,800 $20,400 Kitchen Staff Member $19,200 Servers (2) $38.400 Bonuses and Incentives $7,800 Other SO Total People 5 Total Payroll $108,600 Cook Start-Up Funding Take-Home Pizza, Inc. needs start-up capital that will be used for legal expenses, kitchen inventory and equipment, packing and other materials, rent, promotion, business sign, and inventory on hand at start- up, as detailed below. Co-owners Ben and Alex have estimated total start-up costs of $131,500 Co-owners Ben and Alex have agreed to provide start-up financing in the amount of $72,000 ($36,000 each and a combined share of 70.94% ownership). Approximately $59.500 in additional funding is needed An investor and co-owner is welcome to participate in the company's capital for the amount of $29,500, and could be offered a portion of 29.06% ownership of the $101,500 company capital. The cumulative dividends that would be paid to the new investor, based on 29.06% ownership, over the next five years, would be $187,618 o Year 1 $17,892 o Year 2 $27,091 o Year 3 $37,213 o Year 4 $48,613 o Year 5 $56,809 Co-owners Ben and Alex will not take dividends over the first five years. The reasons for this decision are: a) they will receive employment compensation and benefits, and b) the undistributed dividends will increase the amount of retained earnings, as a strategy to strengthen the company's financial position for sustainable future growth, to increase the company's net worth, and subsequently the market value when it goes public For the remaining $30,000 additional financing needed to cover the start-up costs, the company plans to receive a five-year term commercial loan facility, which will meet the cash flow requirements. The borrowed funds will be used exclusively to buy equipment, based on the list that will be made available to the lending institution. The loan could be repaid in equal monthly installments over a 5-year period. Start-Up Expenses . Rent: A commercial property will be leased in August 2020 for a minimum of five years, with the option to extend the lease for another five years after that. The co-owners have an estimated $2,000 monthly rent expense ($17.22 per square meter per month). Kitchen Inventory: Food preparation (aprons, blender, gloves, storage containers, trays, work tables, mixers, condiment bottles, cleaning supplies and equipment, tableware, pots and pans, glassware, paper, pizza pans, etc.), pizza tools (parchment paper, oven brush, bobble popper, pizza tray rack, pizza separator, and other specific items); and utensils (cooking utensils, wheel cutters, cutting guide, rocker knives, etc.) Kitchen Equipment: Pizza ovens, pizza dough equipment (digital scale, mixer, dough docker, automatic dough press, pizza sheeter, manual pizza press), pizza display merchandiser, refrigerated preparation tables, freezers, cooler package, and holding table with infrared warmers. Other expensed equipment: Neon pizza signs, tables, and chairs, coffee makers, coffee filters, tea dispensers, juice dispensers, cleaning equipment, dish machines, etc. Promotion expenses at start-up are initially estimated at $3,300 and will be used for various marketing information materials and advertisements. Legal expenses include business formation, advice and assistance, basic contract reviews, and general business advice Office supplies include desks, files, tape, record books, forms, etc. Permit expenses are the additional costs incurred to operate legally in the suburbs of Beirut Start-Up Assets Long-term assets: $50,000 worth of equipment (long-term assets) will be expensed over the next five years, using the straight-line depreciation method. The company policy is to purchase only new, state-of-the-art, energy-efficient equipment from reliable suppliers in the food industry. Inventory on hand at start-up includes specific ingredients for pizza preparation (flour, spices and pizza condiments), sauces, juices and other soft drinks, coffee, tea, toppings, parmesan cheese, cookie dough, breadsticks and different dessert items that can be ordered together with the main menu item. It also includes supplies that are used during the packing, sale, and delivery process, and miscellaneous supplies. The cash requirement at start-up is estimated to be $14,000. Summary: Start-Up Expenses and Start-Up Assets Start-up Expenses Legal $2,200 Kitchen Inventory (Supplies) $6,000 Packing Materials $2,500 Kitchen Equipment $20,000 Rent $2,000 Promotion $3,300 Other Expensed Equipment $5,000 Business Sign $3,000 Permits $2,500 Office Supplies $2,000 Other (miscellaneous) $4,000 Total Start-up Expenses $52,500 Start-up Assets Cash Required $14,000 Start-up Inventory $15,000 Long-term Assets $50,000 Total Assets $79,000 d 1.pdf 4 / 6 / 66% + Total Funding Requirements Start-Up Expenses to Fund $52,500 Start-Up Assets to Fund $79,000 Total Funding Required $131,500 Estimation of Target Market Share The population in suburbs of Beirut exceeds one million, which means that, theoretically, the maximum number of pizzas (1/2 pie portions) ordered per month at different restaurants in the area (total market) would be 100,000 pies (1 million residents / 5 residents / 2 half pies). This number needs to add the orders that will be made by many businesses, let's assume five hundred businesses, in the area which is estimated at 5% of the retail market (5,000 pies (100,000 ples x .05)). Thus, the estimated total market in suburbs of Beirut area is 105,000 pies per month. Take-Home Pizza, Inc. estimates a target market share of 4,224 ples or 4% (4,224 ples / 105,000 pies -,04) per month, and believes this target market share to be reasonable and achievable. Assuming 24 business days per month, the company estimates to attract and maintain at least the minimum number of customers required to order 176 ples per day (4,224 ples/24 days). If each customer would order one pie it would mean a total of 4,224 customers per month. This figure is disputable because the companies typically order a large number of pizza, and the individuals usually buy by slices, or order full ples for home delivery. However, it is a good starting point for analysis. The company's market survey shows that one in five persons interviewed order pizza at least once a month. Sales Forecast Projected sales are actually net sales, which consist of the gross proceeds from sales of merchandise (te, gross sales -- less returns and allowances). Considering an average price of $17 per pie, Take-Home Pizza, Inc. would need to sell on average 176 pies each day ($72,000 average monthly sales / $17 per pie 124 business days per month). Two weeks are reserved each year for paid vacation, when the restaurant will be closed, but important maintenance works are scheduled for the equipment and facilities during this break period. This is the reason why the sales in August are projected at 50% of normal sales. Using the equipment and technology the company will be able to produce maximum 400 ples per day (theoretical operating capacity). However the normal operating capacity, which takes into account the usual breaks and the idie periods, is only 300 ples per day, or 75 percent (usually 10 working hours per day). That means that the average projected 176 pies per day would be reached at only 58 percent of normal operating capacity (176 ples / 300 pies - 58), which is a reasonable target. In periods of peak sales, the normal operating capacity could be extended by working more than 10 hours per day Therefore from the operating point of view, the sales forecast is feasible. This is a hypothetical example and does not reflect the actual population number in the suburbs of Beirut 11.pdf 5 / 6 66% + [ @ Based on the above scenarios, the sales forecast and price per pie of the first 12 months for the business year 2019) are provided for you. 0 20 Nov 20 Dec 20 Feb-21 Mar 21 Apr-21 May 21 21 MA21 13150 560 410 216 140 20 30 180 130 19 1 500 1.300 356 2 160 20 2194 1.540 700 360 200 1,670 710 375 220 Sales Forest Pin for NI Pius Healthy She marian Pizza Special Other Total Un Poes for All a Haley Style Piena prian Man Special Other 1.720 730 375 250 120 1,195 1.800 150 40 130 2.150 1.090 555 USO 10 410 330 150 1610 2010 1060 435 350 100 4015 2.100 1.100 570 420 TO 350 300 210 30 3.100 170 4,345 2.000 3.105 BO 4520 15 26 16 16 18 19 21 25 16 18 19 21 25 16 18 19 21 16 18 19 21 25 16 18 19 21 16 10 19 21 16 18 19 20 25 16 18 19 21 19 21 16 18 19 23 21 20 * Important Assumptions Due to current economic uncertainties, the company's assumptions are conservative. In judging and estimating, the co-owners have chosen the alternatives that are least likely to overstate assets and income. General Assumptions FY2020 FY2021 FY2022 FY2023 FY2024 Estimated sales growth 10% 10% 5% % Cost of goods sold % of sales) 52% 52% 52% 52% 52% Inventory (of sales) 39% 39% 39% 39% 39% Other Operating Expenses '% Sales) 0.5% 0.5% 0.5% 0.5% 0.5% Payroll Taxes and Benefits 29% 29% 29% 29% 29% Long-term Interest Rate 12% 12% 12% 12% 12% Corporate Tax Rate 30% 30% 30% 30% 30N Payment Delays 30 30 30 30 30 Sales on Credit 15% 15% 15% 15% 15% Sales Tax, VAT 10% 10% 10% 10% 10% Inflation Rate 5X 5% 5% 5X 5% Collection Period Next month following sales Target Inventory 39% of current sales Accounts Payable (Cost of goods sold + Targeted Inventory (Ending) - Targeted Inventory (Beginning Payroll $ 108 600 per year Sales and Marketing and Other Expenses $8,000 per year Office Supplies $1,200 per year Utilities $6,600 per year Insurance $9,000 per year Depreciation A strait line method. no salvare value at the end of its useful life '5 years) Note: Costs/expenses following year I should be adjusted for inflation (which is hypothesized to be 5%). Questions Questions Prepare the projected financial statements for Take-Home Pizza, Ine for the period FY2020-F2024, in accordance with the general accounting principles. Link the sales projections, cost of sales, expenses, and projected financial statements on Excel Sheet 1. Prepare opening Balance Sheet of Take Home Pizza, Inc 2. Prepare Monthly Sales Forecast and Pro Forma statements (Profit and Loss, Cash Flow and Balance Sheet) for the first year 3. Prepare Yearly Sales Forecast and Proforma itatements (Profit and Loss, Cash Flow and Balance Sheet) for the next five years. 4. Prepare the ratio analysis that clearly shows Take-Home Pizza, Inc.'s financial position. s. When will the company start to break even? 6. Calculate the Monthly (Yearly Units Break even and Monthly (Yearl Revenue break-even. Hint: Compute Average Per Unit Revenue Average PerUnit Variable Cout, and Estimated Monthly Fixed Cost. 7. When is the payback period for the new investor? 2. Prepare the following ratios for the period FY2020-P82024 Current . Quick Total Debit to Total Assets . Net Profit Margin Return on Equity Assets to Sales . Current Debt/Total Assets Dette Equity ched 1.pdf Based on the above scenarios, the sales forecast and price per pie of the first 12 months (or the business year 2019) are provided for you. Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 2,010 1,060 780 340 180 120 80 1,500 435 Sales Forecast (Units) Pizza for All Pizza Healthy Style Pizza Vegetarian Pizza Special Other Total Unit Sales Unit Prices Pizza for All Pizza Healthy Style Pizza Vegetarian Pizza Special Other 960 410 216 140 90 1,816 1,300 556 288 160 90 2394 1,540 700 360 200 100 12.900 1,670 730 375 220 110 3,105 1,720 730 375 250 120 3,195 1,800 850 430 330 150 3560 1,850 850 430 330 150 3,610 2,150 1,090 555 380 170 4,345 2,300 1 100 570 420 350 160 4,015 1,150 550 300 210 90 2,300 180 4570 16 16 18 19 21 25 16 18 19 21 25 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 Important Assumptions Due to current economic uncertainties, the company's assumptions are conservative. In judging and estimating, the co-owners have chosen the alternatives that are least likely to overstate assets and income. General Assumptions FY2020 FY2023 5% Estimated sales growth Cost of goods sold (% of sales) FY2021 10% 52% 39% FY2022 10% 52% 39% FY2024 % 52% 39% 52% 39% 52% 39%
