Please fill out the tables.

PARTI: Use the following information on Company Y and perform pro-forma financial modeling using a planned expansion method to answers the following questions. To do this assume that the percentage values with respect to sales of the 2020 (i) costs except depreciation. (ii) cash and equivalents, (iii) accounts receivable. (iv) inventories, and (v) accounts payable will remain fixed at their respective percentage values in 2019. Assume also that income tax will remain at 30% of the Pretax Income. Company Y sells a product for which in 2019 the total market size was of 500.000 units, of which Company Y owned a share of 20%. Both, the total market size and Company Y's market share are expected to grow at a 25% yearly rate for the next five years. The price of the product is $114 in 2019 and is expected to remain at that price for the next years. *****TABLE B.1 In 2019, the outstanding debt of Company Y is $250,000, for which the company makes yearly interest payments of 8%. The executives of Company Y are considering making a significant capital investment in 2020 of $1,000,000 to purchase new machinery. The company plans to finance this investment with a 30-year loan that makes yearly interest payments equivalent to 8% of its principal. The principal is paid when the loan matures. The following table summarizes the debt and interest payment of Company Y. ********TABLE B.2 Currently. Company Y makes yearly expenditures on replacement capital investment of $25,000. if the company makes the planned expansion, it has been decided that it will continue making replacement capital investment of $25.000 until and including 2020; and starting in 2021 it will perform yearly expenditures on replacement capital investment of $70,000. The current and the planned expenditures on replacement of capital investment will be financed by the company's cash flow. The following table indicates for 2019 Company Y's values of i. opening book value, ii. capital investment, iii. depreciation, and iv. closing book value. The Table also indicates the 2020-2021 forecast values of capital depreciation if the planned expansion were to occur in 2020. Because no decision has yet been done about dividends, before making any balancing adjustments to the Balance Sheet, assume that these will be SO in 2020. ********TABLE B.3 The following table contains Company Y's income statement for 2019. ********TABLE B.4 The following table contains Company Y's balance sheet for 2019. ********TABLE B.5 TARU 2019 2020 2021 2022 500.000 625.000 25.000% 781.250 31.250% 976,563 39,063% 20.000% Market Analysis Market Size Market Share Production Volume Average Sales Price: Sales 100.000 114 TABLE B2 2019 2020 2021 250.000 1,250,000 Debt and Interest Table Outstanding Debt New Net Borrowing Interest on Debt 250,000 1,000,000 TABLE 2019 2020 2021 300,000 Fixed Assets & Capital Investment Opening Book Value Capital Investment Depreciation Closing Book Value 25,000 -26.250 -76,188 -75,878 498.750 PARTI: Use the following information on Company Y and perform pro-forma financial modeling using a planned expansion method to answers the following questions. To do this assume that the percentage values with respect to sales of the 2020 (i) costs except depreciation. (ii) cash and equivalents, (iii) accounts receivable. (iv) inventories, and (v) accounts payable will remain fixed at their respective percentage values in 2019. Assume also that income tax will remain at 30% of the Pretax Income. Company Y sells a product for which in 2019 the total market size was of 500.000 units, of which Company Y owned a share of 20%. Both, the total market size and Company Y's market share are expected to grow at a 25% yearly rate for the next five years. The price of the product is $114 in 2019 and is expected to remain at that price for the next years. *****TABLE B.1 In 2019, the outstanding debt of Company Y is $250,000, for which the company makes yearly interest payments of 8%. The executives of Company Y are considering making a significant capital investment in 2020 of $1,000,000 to purchase new machinery. The company plans to finance this investment with a 30-year loan that makes yearly interest payments equivalent to 8% of its principal. The principal is paid when the loan matures. The following table summarizes the debt and interest payment of Company Y. ********TABLE B.2 Currently. Company Y makes yearly expenditures on replacement capital investment of $25,000. if the company makes the planned expansion, it has been decided that it will continue making replacement capital investment of $25.000 until and including 2020; and starting in 2021 it will perform yearly expenditures on replacement capital investment of $70,000. The current and the planned expenditures on replacement of capital investment will be financed by the company's cash flow. The following table indicates for 2019 Company Y's values of i. opening book value, ii. capital investment, iii. depreciation, and iv. closing book value. The Table also indicates the 2020-2021 forecast values of capital depreciation if the planned expansion were to occur in 2020. Because no decision has yet been done about dividends, before making any balancing adjustments to the Balance Sheet, assume that these will be SO in 2020. ********TABLE B.3 The following table contains Company Y's income statement for 2019. ********TABLE B.4 The following table contains Company Y's balance sheet for 2019. ********TABLE B.5 TARU 2019 2020 2021 2022 500.000 625.000 25.000% 781.250 31.250% 976,563 39,063% 20.000% Market Analysis Market Size Market Share Production Volume Average Sales Price: Sales 100.000 114 TABLE B2 2019 2020 2021 250.000 1,250,000 Debt and Interest Table Outstanding Debt New Net Borrowing Interest on Debt 250,000 1,000,000 TABLE 2019 2020 2021 300,000 Fixed Assets & Capital Investment Opening Book Value Capital Investment Depreciation Closing Book Value 25,000 -26.250 -76,188 -75,878 498.750