Answered step by step
Verified Expert Solution
Question
1 Approved Answer
last page is from page 5 since the numbers in the table are unclear AGBU 292: Agribusiness Final Year Project - Financial Plan Exercise Instructions:
last page is from page 5 since the numbers in the table are unclear
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 Manager Cook Kitchen Staff Member Servers (2) Bonuses and Incentives Other Total People Total Payroll Year 1 (Sep19-Aug 20) $22,800 $20,400 $19,200 $38.400 $7,800 $0 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 o Year 3 $37,213 o 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 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, pleza 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 52.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 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 ples). 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 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 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 lice, 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 724 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 pies 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 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. 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 On New 20 unt Apr 21 Map 11 M21 1 1.850 NI Het Style Faria 750 340 IND 120 NO 960 410 216 140 16 70 10 1540 356 700 220 140 150 200 DOO 2294 3.300 7 175 150 130 1.125 1.800 A50 410 310 IS 3560 210 110 415 3 150 010 2010 1.00 as 350 162 2015 SO 1,00 555 380 10 2,100 1100 570 co 10 1.150 350 100 20 9 1115 Sk UW Pro Parafi 16 16 10 10 19 21 16 10 19 11 18 19 19 Par man Para Spec O 36 19 21 19 21 16 18 19 23 75 16 18 19 21 25 16 16 19 21 16 10 10 21 1H 19 21 25 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 29% 30% 10% General Assumptions FY2020 FY2021 FY2022 FY2023 FY2024 Estimated sales growth 10% 10% S% % 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% Long-term interest Rate 12% 12% 12% 12% 12% Corporate Tax Rate 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% Inflation Rate 5% 5% 5X 5X 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 years) Note: Costs/expenses following year I should be adjusted for inflation (which is hypothesized to be 5%). Questions 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. 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 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 435 960 410 216 140 90 1,816 1,300 556 288 160 90 2394 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,150 1,090 555 380 170 4,345 350 160 4015 2,300 1.100 570 420 180 4570 1,150 550 300 210 90 2,300 16 16 16 18 19 21 25 16 18 19 21 25 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 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 Estimated sales growth Cost of goods sold % of sales) FY2021 10% 52% 39% FY2022 10% 52% 39% FY2023 5% 52% 39% FY2024 % 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 Manager Cook Kitchen Staff Member Servers (2) Bonuses and Incentives Other Total People Total Payroll Year 1 (Sep19-Aug 20) $22,800 $20,400 $19,200 $38.400 $7,800 $0 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 o Year 3 $37,213 o 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 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, pleza 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 52.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 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 ples). 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 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 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 lice, 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 724 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 pies 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 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. 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 On New 20 unt Apr 21 Map 11 M21 1 1.850 NI Het Style Faria 750 340 IND 120 NO 960 410 216 140 16 70 10 1540 356 700 220 140 150 200 DOO 2294 3.300 7 175 150 130 1.125 1.800 A50 410 310 IS 3560 210 110 415 3 150 010 2010 1.00 as 350 162 2015 SO 1,00 555 380 10 2,100 1100 570 co 10 1.150 350 100 20 9 1115 Sk UW Pro Parafi 16 16 10 10 19 21 16 10 19 11 18 19 19 Par man Para Spec O 36 19 21 19 21 16 18 19 23 75 16 18 19 21 25 16 16 19 21 16 10 10 21 1H 19 21 25 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 29% 30% 10% General Assumptions FY2020 FY2021 FY2022 FY2023 FY2024 Estimated sales growth 10% 10% S% % 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% Long-term interest Rate 12% 12% 12% 12% 12% Corporate Tax Rate 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% Inflation Rate 5% 5% 5X 5X 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 years) Note: Costs/expenses following year I should be adjusted for inflation (which is hypothesized to be 5%). Questions 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. 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 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 435 960 410 216 140 90 1,816 1,300 556 288 160 90 2394 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,150 1,090 555 380 170 4,345 350 160 4015 2,300 1.100 570 420 180 4570 1,150 550 300 210 90 2,300 16 16 16 18 19 21 25 16 18 19 21 25 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 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 Estimated sales growth Cost of goods sold % of sales) FY2021 10% 52% 39% FY2022 10% 52% 39% FY2023 5% 52% 39% FY2024 % 52% 39% 52% 39% 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