I need something like P1 and P2 based off the information found in P3 and P4. I also need help with the X's in P4.
The assumptions for our projection are as follows: 1. :4??? Revenue: The base price per piece of $75 with a growth of 10% tor Year 1 & 2, gal 25% thereafter. The base volume 300 units per month with a growth 25% for Year 1 & 2 and 75% thereafter. ' ' Cost of sales includes price paid to supplier and storage costs. Supplier shall be paid at 30% of selling price for Year 1 & 2 and 35% thereae'. Storage costs shall be incurred from Year 3 onwards at $18,000 per annum growing at 5%. . Expenses include general and administrative expenses like legal, insurance, marketing, travel and payments to Shopify for the website. It also includes salaries for the entrepreneurs from Year 3 onwards. The tax rate used is 25%. Cash is maintained at 30% of revenue for Year 1&2 and 25% thereafter. Inventory is assumed at two months average sales level. Accounts payable is assumed at two months average cost of sales. Conclusion Based on the above valuation and the sensitivity analysis reports, we believe that a conservative $2million is a fair valuation of our company. We are requesting $250,000 for a 12.5% equity stake in our company. We believe in the authenticity of our product and the potential market and think that our business model will help meet the needs of consumers while positively impacting the lives of Indian artisans. Balance Sheet SLIDE # 7 Fiscal Period 2019 2020 | 2021 2022 2023 ASSETS Current Assets Cash $ 13 , 762 $ 29 , 589 $49 , 564 $76 , 269\ $ 12 2 , 537 Inventory 5 9, 600 $11 , 040 $12 , 960 $14 , 592 $19 , 200 Short Term Marketable Securities $ 5 , 000 $5 , 750 $6 , 750 $7 , 600 $10 , 000 Total Assets $ 28 , 362 $46 , 379 $69 , 274 $98 , 461 $151 , 737 LIABILITIES Current Liabilities Accounts Payable* $ 3 , 250 $3 , 738 $4 , 388 $ 4 , 940 $6 , 500 EQUITY Share Capital $ 3 , 642 $3 , 960 $ 2 , 970 $ 8 , 571 $ 23 , 347 Retained Earnings $ 16 , 470 $35 , 681 $57 , 916 $82 , 950 $1 15 , 890 Shareholders Equity $ 5 , 000 $ 3 , 000 $ 4 , 000 $ 2 , 000 $ 6 , 000 Total Liabilities and Equity $ 28 , 362 $46 , 379 $69 , 274 $98 , 461 $151 , 737 Income Statement SLIDE # 8 Fiscal Period 2019 2020 2021 2022 2023 Income Statement Revenues $ 30 , 000 $34 , 500 $ 40 , 500 $45 , 600 $60 , 000 Cost of Sales $ ( 9600 ) $ ( 1 1 , 040 )| $ ( 12 , 960 ) $ ( 14 , 592 ) $ ( 19 , 200 ) Gross Margin $ 20 , 400 $ 23 , 460 $ 27 , 540 $31 , 008 $40 , 800 General & Administrative Expenses $ 1 750 ) $ 1 - 863 ) $ ( 1 , 013 ) $ ( 1 , 140 ) $ ( 1500 ) Earnings before Taxes $19 , 650 $2 2 , 598 $ 26 , 528 $ 29 , 868 $39 , 300 Provision for Income Tax $ ( 3180 ) $ ( 3 , 657 ) $ ( 4 , 293 ) $ ( 4 , 834 ) $ ( 6 , 360 ) Net Income $16 , 470 $18 , 941 $22 , 235 $25 , 034 $32 , 940Fiscal Period 2019 2020 2021 2022 2023 Net profit for the year Changes in working capital: Increase in inventory Increase in accounts payable Cash flow from operation activities Increase in marketable securities Cash flow from investing activities [Em- 5-5.750 -$7,763 -$11,779 -$23,598 Increasein share capital $8,642 $9,938 $13,417 E 40,787 Cash Flow from financing activities $8,642 $9,938 $13,417 $20,393 40,787 Cash from operations $13,762 $15,827 $19,975 $26,705 $46,268 Opening balance of cash - $13,762 $29,589 $49,564 $76,269 Balance at the end of the year $13,762 $29,589 $49,564 $76,269 $122,537 0 Valuation using the Discounted Cash Flow Model SLIDE # 10 Cost of equity re 20% Growth Rate 15% Cash flow from operations $13,762 $15,827 $19,975 $26,705 $46,268 Terminal Value (X) Total Cash Flows $13,762 $15,827 $19,975 $26,705 $46,268 PV @ 20% (X) (X) (X) (X) (X) Discounted Cash Flows (X) (X) (X) (X) (X) 0 Valuation using the Venture Capital Method SLIDE # 10 Net Income 5 years out 5 (X) Multiple * 10 $ (X) Cost of equity re (X) PV @ 20% (X) Value of the business $(X)