Remaining Time: 2 hours, 10 minutes, 00 seconds. Question Completion Status: QUESTION 1 Use the following information on Company and perform proforma financial modeling using a planned expansion method to answer the following questions. Assume that the percentage vakres with respect to sales of the costs except depreciation on cash and equivalents, accounts receivable, im inventories, and accounts payable will stay fixed at the values corresponding for 2020. Assume that costs except depreciation in 2020 513.500,000 and that income tax will remain foed 35% of the Pretax income Company Y sells a product for which in 2020 the total market se was of 5.000.000 units of which Company owned a share of the total market sure is expected to grow at a rate. Company market share is espected to remain. The price of de product is 100 in 2020 and is expected to violve according to the valuessed in the following Table 2021 TABLE: Market Analyse Market Analysis Market Sue Mathare Pod Volume Average Sales Sie 2020 5.000.000 9.00 5.400,000 9.00 000 2022 5.832.000 9.00 52 511661 2023 6.298.560 9.00 S80 S125.97 150.000 $100.00 $10.00 5 2 3 $ 4 % 5 6 &7 8 1 0 9 9 w e r t u 0 a S d f bo n jk Z C V b n > m Question Completion Status: Sales In 2020, the outstanding debt of Company is $1,000,000, for which the company makes yearly Interest payments of 5%. The executives of Company Y are considering making a significant capital Investment in 2021 of $3,000,000 to purchase new machinery and be able to satisfy forecasted future market demand. The company plans to finance this investment with a 20 year loan that makes yearly Interest payments equivalent to 5% of its principal. The principal is paid when the loan matures. The following table summarizes the debt and interest payment of Company Y. 2021 2022 TABLE: Debt and Interest Table Debt and Interest Table Outstanding Debt New Net Borrowing Interest on Debt 2020 1,000,000 Currently, Company makes yearly expenditures on replacement capital investment of $210,000. the company makes the planned expansion is considering the starting in 2022. the total yearly expenditures on replacement capitalistment will be $420,000. The current and the planned expenditures on replacement of capital trestment will be financed by the company's cash flow The following tables contains for 2020 Company is values of opening book value capital Dk Shikam O @ 2 # 3 $ 4 unde a> & 7 8 W e r t u i o e s d f g h j Question Completion Status: Currently, Company Ymakes yearly expenditures on replacement capital investment of 5210,000. If the company makes the planned expansion it is considering then starting in 2022- the total yearly expenditures on replacement capital investment will be $420,000. The current and the planned expenditures on replacement of capital investment will be financed by the company's cash flow, The following table contains for 2020 Company Ys values of opening book value. Il capital investment, ill. depreciation, and closing book value. The Table also indicates the 2021-2022 forecast values of capital depreciation if the planned expansion were to occur in 2021. TABLE: Fixed Assets & Capital Investment 2022 Fixed Assets & Capital Investment Opening Book Value Capital Investment Depreciation Closing Book Value 2020 3,000,000 210,000 (288,900) 2,921,100 2021 2.921,100 3,210,000 (551,799) 420,000 (539,937) The following table contains company is income statement for 2020 TABLE income Statement 17 Click Save and Subscribers O o 0 * # 3 $ 4 % 5 & 7 2 6 8 9 w Le e r t t u i o s d f 09 h j k I Remaining Time: 2 hour, ULUS Question Completion Status: 2021 TABLE: income Statement Income Statement: Sales Costs except Depr. EBITDA Depreciation EBIT Interest Expense (net Pretax Income Income Tax Net Income 2020 45,000,000 -13,500,000 31,500,000 -288.900 31.211,100 -50,000 31.161,100 -10.906,385 20,254,715 The following table contains company's balance sheet for 2020 TABLE. Balance Sheet Balance Sheet Chiwamo manches 9 Dll O 2 $ 4 % 5 3 & 7 6 8 9 0 a W e r t u i 3 S d d f g h i Romaning * Question Completion Status: TABLE: Balance Sheet Balance Sheet 2020 2021 Assets Cash and Equivalents Accounts Receivable Inventories Total Current Assets Property Plant and Equipment Total Assets 13,500,000 9,000,000 6,750,000 29,250,000 2,921,100 32.171.100 Liabilities and Equity Accounts Payable Total Current Liabilities Debe Total Liabilities Stockholders' Equity 12,600,000 12,600,000 1.000.000 13,600,000 Click and bitrate 5 Oll o # 3 2 $ 4 % 5 & 7 6 8 9 0 9 W e r t U i O a S d f bc h C i any edu/websplasses Remaining Time: 2 hours, 09 minutes, 31 seconds. Question Completion Status: Total Current Assets Property Plant and Equipment Total Assets 29,250,000 2,921,100 32,171,100 12,600,000 12,600,000 1,000,000 13,600,000 Liabilities and Equity Accounts Payable Total Current Liabilities Debt Total Liabilities Stockholders' Equity Starting Stockholders' Equity Net Income Dividends Stockholders' Equity Total Liabilities and Equity 9,500,000 20.254,715 -11,183615 18,571,100 32,171,100 Click Save and watch TV M O . - $ 4 % 5 od N 2 3 6 8 ON t u Jet i o soll I g i K What is Company Ys forecast for property, plant and equipment for 20217" QUESTION 9 Before making any adjustments to balance Total Assets with Total Liabilities and Equity, what is Company Y s forecast value of Total Liabilities and Equity for 20217* QUESTION 10 According to the 2021 forecasts for Company Y, Is there needs for new financing or excess cash? Specify the value of new financing needed (express with a positive sign) or excess cash available (express with a negative sign). Answer in strictly numerical terms Remaining Time: 2 hours, 10 minutes, 00 seconds. Question Completion Status: QUESTION 1 Use the following information on Company and perform proforma financial modeling using a planned expansion method to answer the following questions. Assume that the percentage vakres with respect to sales of the costs except depreciation on cash and equivalents, accounts receivable, im inventories, and accounts payable will stay fixed at the values corresponding for 2020. Assume that costs except depreciation in 2020 513.500,000 and that income tax will remain foed 35% of the Pretax income Company Y sells a product for which in 2020 the total market se was of 5.000.000 units of which Company owned a share of the total market sure is expected to grow at a rate. Company market share is espected to remain. The price of de product is 100 in 2020 and is expected to violve according to the valuessed in the following Table 2021 TABLE: Market Analyse Market Analysis Market Sue Mathare Pod Volume Average Sales Sie 2020 5.000.000 9.00 5.400,000 9.00 000 2022 5.832.000 9.00 52 511661 2023 6.298.560 9.00 S80 S125.97 150.000 $100.00 $10.00 5 2 3 $ 4 % 5 6 &7 8 1 0 9 9 w e r t u 0 a S d f bo n jk Z C V b n > m Question Completion Status: Sales In 2020, the outstanding debt of Company is $1,000,000, for which the company makes yearly Interest payments of 5%. The executives of Company Y are considering making a significant capital Investment in 2021 of $3,000,000 to purchase new machinery and be able to satisfy forecasted future market demand. The company plans to finance this investment with a 20 year loan that makes yearly Interest payments equivalent to 5% of its principal. The principal is paid when the loan matures. The following table summarizes the debt and interest payment of Company Y. 2021 2022 TABLE: Debt and Interest Table Debt and Interest Table Outstanding Debt New Net Borrowing Interest on Debt 2020 1,000,000 Currently, Company makes yearly expenditures on replacement capital investment of $210,000. the company makes the planned expansion is considering the starting in 2022. the total yearly expenditures on replacement capitalistment will be $420,000. The current and the planned expenditures on replacement of capital trestment will be financed by the company's cash flow The following tables contains for 2020 Company is values of opening book value capital Dk Shikam O @ 2 # 3 $ 4 unde a> & 7 8 W e r t u i o e s d f g h j Question Completion Status: Currently, Company Ymakes yearly expenditures on replacement capital investment of 5210,000. If the company makes the planned expansion it is considering then starting in 2022- the total yearly expenditures on replacement capital investment will be $420,000. The current and the planned expenditures on replacement of capital investment will be financed by the company's cash flow, The following table contains for 2020 Company Ys values of opening book value. Il capital investment, ill. depreciation, and closing book value. The Table also indicates the 2021-2022 forecast values of capital depreciation if the planned expansion were to occur in 2021. TABLE: Fixed Assets & Capital Investment 2022 Fixed Assets & Capital Investment Opening Book Value Capital Investment Depreciation Closing Book Value 2020 3,000,000 210,000 (288,900) 2,921,100 2021 2.921,100 3,210,000 (551,799) 420,000 (539,937) The following table contains company is income statement for 2020 TABLE income Statement 17 Click Save and Subscribers O o 0 * # 3 $ 4 % 5 & 7 2 6 8 9 w Le e r t t u i o s d f 09 h j k I Remaining Time: 2 hour, ULUS Question Completion Status: 2021 TABLE: income Statement Income Statement: Sales Costs except Depr. EBITDA Depreciation EBIT Interest Expense (net Pretax Income Income Tax Net Income 2020 45,000,000 -13,500,000 31,500,000 -288.900 31.211,100 -50,000 31.161,100 -10.906,385 20,254,715 The following table contains company's balance sheet for 2020 TABLE. Balance Sheet Balance Sheet Chiwamo manches 9 Dll O 2 $ 4 % 5 3 & 7 6 8 9 0 a W e r t u i 3 S d d f g h i Romaning * Question Completion Status: TABLE: Balance Sheet Balance Sheet 2020 2021 Assets Cash and Equivalents Accounts Receivable Inventories Total Current Assets Property Plant and Equipment Total Assets 13,500,000 9,000,000 6,750,000 29,250,000 2,921,100 32.171.100 Liabilities and Equity Accounts Payable Total Current Liabilities Debe Total Liabilities Stockholders' Equity 12,600,000 12,600,000 1.000.000 13,600,000 Click and bitrate 5 Oll o # 3 2 $ 4 % 5 & 7 6 8 9 0 9 W e r t U i O a S d f bc h C i any edu/websplasses Remaining Time: 2 hours, 09 minutes, 31 seconds. Question Completion Status: Total Current Assets Property Plant and Equipment Total Assets 29,250,000 2,921,100 32,171,100 12,600,000 12,600,000 1,000,000 13,600,000 Liabilities and Equity Accounts Payable Total Current Liabilities Debt Total Liabilities Stockholders' Equity Starting Stockholders' Equity Net Income Dividends Stockholders' Equity Total Liabilities and Equity 9,500,000 20.254,715 -11,183615 18,571,100 32,171,100 Click Save and watch TV M O . - $ 4 % 5 od N 2 3 6 8 ON t u Jet i o soll I g i K What is Company Ys forecast for property, plant and equipment for 20217" QUESTION 9 Before making any adjustments to balance Total Assets with Total Liabilities and Equity, what is Company Y s forecast value of Total Liabilities and Equity for 20217* QUESTION 10 According to the 2021 forecasts for Company Y, Is there needs for new financing or excess cash? Specify the value of new financing needed (express with a positive sign) or excess cash available (express with a negative sign). Answer in strictly numerical terms