Hello, please I really need help with this as it's a graded assignment. I would be so grateful.
a better picture of the sales forecast unit
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 attemative 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 (Sep19-Aug 20) Manager $22,800 Cook $20,400 Kitchen Staff Member $19,200 Servers (2) $38,400 $7,800 $0 Total People Total Payroll Bonuses and Incentives Other 5 $ 108,600 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: Year 1 $17,892 o Year 2 $27,091 0 Year 3 $37,213 Year 4 $48,613 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 earings, 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 Totol 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 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 ples (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 pies 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 pies or 4% (4,224 pies / 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 pies per day (4,224 pies/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 larger number of pizza, and the individuals usually buy by slices, or order full pies 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 fi.e. 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 /24 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 idle periods, is only 300 pies 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 ples - 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 Based on the above scenarios, the sales forecast and price per ple of the first 12 months (or the business year 2019) are provided for you. Sep-20 Oa 20 New Deco Ian 21 Feb-21 M21 Apr May 21 950 1.100 1.450 Plan for NI Para style 700 340 1,630 710 170 730 375 1.100 556 188 160 90 2010 1010 45 2.150 1.00 310 160 1.800 300 100 200 100 2000 2100 1,100 570 00 180 4570 550 300 210 120 Pura 220 10 3108 40 110 150 3510 30 150 25 120 3195 100 110 2300 To Sele Uw Perfor Pia Healthy Pimen Plus Soda 16 18 16 18 15 18 19 21 16 18 19 21 16 18 11 23 25 16 12 19 25 25 16 11 19 21 25 16 18 19 21 25 15 18 19 21 16 13 19 21 25 16 10 13 21 25 16 10 19 21 75 21 25 21 23 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 39% 29% 12% General Assumptions FY2020 FY2021 FY2022 FY2023 FY2024 Estimated sales growth 10% 10% 5% X Cost of goods sold % of sales) 52% 52% 52% 52% 52% Inventory (of sales) 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% Long-term Interest Rate 12% 12% 12% 12% Corporate Tax Rate 30% 30% 30% 30% 30% 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 5% 5% SN 5% 5% Collection Period Next month following sales Target Inventory 39% of current sales Accounts Payable Cost of goods sold + Targeted Inventory (Ending) 1-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 salvage 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 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. Sep 10 O-30 Nov 20 D20 in 31 feb-21 Mw-21 A21 May 21 in 21 IN Aug 1 1.100 OSWT 2010 960 410 210 1.6 730 2150 100 180 130 NO SE 280 160 1.540 700 360 300 100 3300 1.10 710 175 250 1:30 SER 100 850 10 330 150 1150 550 300 210 OE DEE ENT 555 ONE Seccanita) Pris for AI Plus Healthy Style Pirna Varian Pra Sed Othe Toto Uwa Unit Priors Piusa for NI Pista Healthy Style Para Vara Para Special 2.100 1100 570 420 10 20 2:20 110 J103 06 1220 TO 2015 2.300 16 18 16 IB 16 18 IN 16 10 19 21 16 18 19 16 16 10 19 19 21 21 2525 19 21 16 18 19 16 13 19 21 25 19 21 21 12 10 19 21 25 21 25 75 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 Prepare the projected financial statements for Take-Home Pizza, Inc. for the period FY2020-FY2024, 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 Pro Forma statements (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 5. When will the company start to break even? 6. Calculate the Monthly (Yearly) Units Break-even and Monthly (Yearly) Revenue Break-even. Hint: Compute Average Per-Unit Revenue; Average Per-Unit Variable Cost; and Estimated Monthly Fixed Cost 7. When is the payback period for the new investor? 8. Prepare the following ratios for the period FY2020-FY2024: . Current Quick . Total Debt to Total Assets . Net Profit Margin Return on Equity Assets to Sales Current Debt/Total Assets Debt to Equity 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. Oct-20 Sep-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Jun-21 Apr-21 May 21 Jul-21 Aug-21 2,010 1,060 435 780 340 180 120 80 1,500 960 410 216 140 90 1,816 1,300 556 288 160 90 2,394 1,540 700 360 200 100 2.900 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 1,670 730 375 220 110 3,105 1,720 730 375 250 120 3,195 1,800 850 430 330 150 3.560 1,850 850 430 330 150 3,610 350 2,150 1,090 555 380 170 4,345 1,150 550 300 210 90 2.300 2,300 1,100 570 420 180 4,570 160 4,015 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 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 Important Assumptions nun to current economic uncertainties, the company's assumptions are conservative. In judging and 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 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 780 340 180 120 80 1,500 960 410 216 140 90 1,816 1,300 556 288 160 90 2,394 1,540 700 360 200 100 2.900 1,670 730 375 220 110 3,105 1,720 730 375 250 120 3,195 1,800 850 430 330 150 3.560 1,850 850 430 330 150 3,610 2,010 1,060 435 350 160 4,015 2,150 1,090 555 380 170 4,345 2.300 1.100 570 420 180 4,570 1,150 550 300 210 90 2.300 16 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 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 nun to current economic uncertainties, the company's assumptions are conservative. In judging and 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 attemative 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 (Sep19-Aug 20) Manager $22,800 Cook $20,400 Kitchen Staff Member $19,200 Servers (2) $38,400 $7,800 $0 Total People Total Payroll Bonuses and Incentives Other 5 $ 108,600 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: Year 1 $17,892 o Year 2 $27,091 0 Year 3 $37,213 Year 4 $48,613 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 earings, 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 Totol 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 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 ples (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 pies 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 pies or 4% (4,224 pies / 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 pies per day (4,224 pies/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 larger number of pizza, and the individuals usually buy by slices, or order full pies 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 fi.e. 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 /24 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 idle periods, is only 300 pies 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 ples - 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 Based on the above scenarios, the sales forecast and price per ple of the first 12 months (or the business year 2019) are provided for you. Sep-20 Oa 20 New Deco Ian 21 Feb-21 M21 Apr May 21 950 1.100 1.450 Plan for NI Para style 700 340 1,630 710 170 730 375 1.100 556 188 160 90 2010 1010 45 2.150 1.00 310 160 1.800 300 100 200 100 2000 2100 1,100 570 00 180 4570 550 300 210 120 Pura 220 10 3108 40 110 150 3510 30 150 25 120 3195 100 110 2300 To Sele Uw Perfor Pia Healthy Pimen Plus Soda 16 18 16 18 15 18 19 21 16 18 19 21 16 18 11 23 25 16 12 19 25 25 16 11 19 21 25 16 18 19 21 25 15 18 19 21 16 13 19 21 25 16 10 13 21 25 16 10 19 21 75 21 25 21 23 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 39% 29% 12% General Assumptions FY2020 FY2021 FY2022 FY2023 FY2024 Estimated sales growth 10% 10% 5% X Cost of goods sold % of sales) 52% 52% 52% 52% 52% Inventory (of sales) 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% Long-term Interest Rate 12% 12% 12% 12% Corporate Tax Rate 30% 30% 30% 30% 30% 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 5% 5% SN 5% 5% Collection Period Next month following sales Target Inventory 39% of current sales Accounts Payable Cost of goods sold + Targeted Inventory (Ending) 1-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 salvage 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 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. Sep 10 O-30 Nov 20 D20 in 31 feb-21 Mw-21 A21 May 21 in 21 IN Aug 1 1.100 OSWT 2010 960 410 210 1.6 730 2150 100 180 130 NO SE 280 160 1.540 700 360 300 100 3300 1.10 710 175 250 1:30 SER 100 850 10 330 150 1150 550 300 210 OE DEE ENT 555 ONE Seccanita) Pris for AI Plus Healthy Style Pirna Varian Pra Sed Othe Toto Uwa Unit Priors Piusa for NI Pista Healthy Style Para Vara Para Special 2.100 1100 570 420 10 20 2:20 110 J103 06 1220 TO 2015 2.300 16 18 16 IB 16 18 IN 16 10 19 21 16 18 19 16 16 10 19 19 21 21 2525 19 21 16 18 19 16 13 19 21 25 19 21 21 12 10 19 21 25 21 25 75 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 Prepare the projected financial statements for Take-Home Pizza, Inc. for the period FY2020-FY2024, 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 Pro Forma statements (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 5. When will the company start to break even? 6. Calculate the Monthly (Yearly) Units Break-even and Monthly (Yearly) Revenue Break-even. Hint: Compute Average Per-Unit Revenue; Average Per-Unit Variable Cost; and Estimated Monthly Fixed Cost 7. When is the payback period for the new investor? 8. Prepare the following ratios for the period FY2020-FY2024: . Current Quick . Total Debt to Total Assets . Net Profit Margin Return on Equity Assets to Sales Current Debt/Total Assets Debt to Equity 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. Oct-20 Sep-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Jun-21 Apr-21 May 21 Jul-21 Aug-21 2,010 1,060 435 780 340 180 120 80 1,500 960 410 216 140 90 1,816 1,300 556 288 160 90 2,394 1,540 700 360 200 100 2.900 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 1,670 730 375 220 110 3,105 1,720 730 375 250 120 3,195 1,800 850 430 330 150 3.560 1,850 850 430 330 150 3,610 350 2,150 1,090 555 380 170 4,345 1,150 550 300 210 90 2.300 2,300 1,100 570 420 180 4,570 160 4,015 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 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 Important Assumptions nun to current economic uncertainties, the company's assumptions are conservative. In judging and 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 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 780 340 180 120 80 1,500 960 410 216 140 90 1,816 1,300 556 288 160 90 2,394 1,540 700 360 200 100 2.900 1,670 730 375 220 110 3,105 1,720 730 375 250 120 3,195 1,800 850 430 330 150 3.560 1,850 850 430 330 150 3,610 2,010 1,060 435 350 160 4,015 2,150 1,090 555 380 170 4,345 2.300 1.100 570 420 180 4,570 1,150 550 300 210 90 2.300 16 16 18 19 21 25 16 18 19 21 25 16 18 19 21 25 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 nun to current economic uncertainties, the company's assumptions are conservative. In judging and
