B C D E F G H 1 L M N R S 2020 2021 2022 2023 % of Sales 100% 2016 8995.10 5403.80 3591.30 2017 9488.80 5784.90 3703.90 2018 2019 9893.00 10356,87 6004.70 0.00 3888.30 10356.87 1. Complete the Performa Income Statement and the Performa Balance Sheet Use the Percent of Sales" approach The items in the yellow boxes are considered to vary with sales 2. Forecast sales with the regression function 3. Utilizing the output of the regression function provide the R2 and t-stat for the variable. 2.00 0.00 4.00 0.00 0.00 0.00 1.00 0.00 2606.40 984.90 45.00 -23.20 2.50 919.20 340.10 579.10 0.00 579.10 2689,20 1014.20 58.70 -34.10 0.00 921.40 331.70 589.70 0.00 589.70 2820.40 0.00 1067.90 10356.87 47.60 0.00 3.00 0.00 0.00 0.00 1017.30 0.00 349.00 0.00 668.30 0.00 0.00 0.00 668.30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2016 2017 2018 2019 2020 2021 2022 2023 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 254.30 0.00 1632.60 65.40 1567.20 1446,00 215.20 113.70 304.00 575.50 0.00 0.00 1693.50 1884.50 72.10 77.40 1621.40 1807.10 1424.10 1373.80) 162.50 260.50 113.30 140.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2 INCOME STATEMENT 3 Year 4 Net Sales 5 Less: Cost of Goods Sold 6. Gross Profit 7 Other Operating Revenue 8 Less: Operating Expenses 9 Operating income EBIT 10 Lek: Interest Expense 11 Other Income (Expenses) 12 Gain (Loss) 13 Income before Taxes EBT 14 Less Taxes Related to Operations 15 NL before Min. Em. 16 Gain (Loss) 17 Net Income (Loss) 38 TO BALANCE SHEET 20 Year 21 ASSETS 22 Current Assets 23 Cash 24 Marketable Securities 25 Gross Receivables 26 Less: Allowance for Bad Debts 27 Net Trade Receivables 28 Inventories 29 Prepaid Expenses 30 Other Current Assets 31 32 Total Current Assets 23 34 Long Term Assets 25 Net Tangible (Fixed) Assets (other thi 36. Construction in Progress 37 Intangible Assets 38 Investments 29 Other Nonoperating Assets 40 Other Operating Assets 41 Total Long Term Assets 42 Total Assets 43 LIABILITIES AND EQUITY Current liabilities 5 Accounts Payable 45 Short Term Loans 47 Current Maturity of Lt. Debt 48 Other Current Liabilities 19 Total Current Liabilities 50 Long-Term Liabilities: 51 Long-term Debt 52 Reserves 53 Deferred Liabilities 54 Minority interest 55 Redeemable. Preferred 56 Total Long-term Liabilities 57 Total Liabilities 58 Shareholders' Equity 59 Common Equity-incl. Ret. Er 60 Total Equity 61 Total Liabilities and Equity 62 3596.40 3625.30 4157.70 0.00 1542.10 72.40 1135.10 448,30 410.90 0.00 266.20 1447.80 171.00 397.30 0.00 178.20 437.80 0.00 233.00 1505.52 252.45 454.76 0.00 247.23 1567.17 262.79 473.38 0.00 257.36 1632.67 1695.61 273.77 284.33 493.17 512.18 0.00 0.00 268.11 278.45 1760.25 295.17 531.70 0.00 289.07 2260.50 5856.90 2194.30 5819.60 2285.30 6443.00 2459.97 2459.97 2560.70 2560.70 2667.73 2770.56 2876.19 2667.73 2770.56 2876.19 0.00 543.80 924.20 50.10 621.90 2140.00 432.00 855.30 5.40 504.40 425,20 55.30 851.30 1836,20 804.66 40.44 717.98 7103.32 837.61 42.10 747.38 2189.44 872 62 43.85 778.62 2280.95 906.25 45.54 808,63 2368.87 940.81 47.28 839.16 2459,19 494.00 1786.70 559.18 0.00 129.24 582.08 0.00 134,53 606.40 0.00 140.15 629.78 0.00 145.55 653.79 0.00 151.10 470.30 0.00 110.30 0.00 0,30 580.90 2720.90 435.90 625.90 0.00 0.00 102.20 141.60 0.00 0.00 0.30 0.30 538.40 757.80 2325.10 2604.00 0.33 688.74 2792.06 0.34 716.95 2906.39 0.36 746.91 3027.87 0.37 775.70 3144.58 0.38 805.28 3264,47 3136,00 3136.00 5856,90 3494.50 3839.00 3821.11 3977.57 3494.50 3839.00 3821.11 3977.57 5819.60 5443.00 6613.17 6883.96 4143.82 4303,55 4467.62 4143,82 4303.55 4467.62 7171.697448.13 7732.09 1. Complete the Performa Income Statement and the Performa Balance Sheet Use the "Percent of Sales" approach The items in the yellow boxes are considered to vary with sales 2. Forecast sales with the regression function 3. Utilizing the output of the regression function provide the R2 and t-stat for the x-variable. B C D E F G H 1 L M N R S 2020 2021 2022 2023 % of Sales 100% 2016 8995.10 5403.80 3591.30 2017 9488.80 5784.90 3703.90 2018 2019 9893.00 10356,87 6004.70 0.00 3888.30 10356.87 1. Complete the Performa Income Statement and the Performa Balance Sheet Use the Percent of Sales" approach The items in the yellow boxes are considered to vary with sales 2. Forecast sales with the regression function 3. Utilizing the output of the regression function provide the R2 and t-stat for the variable. 2.00 0.00 4.00 0.00 0.00 0.00 1.00 0.00 2606.40 984.90 45.00 -23.20 2.50 919.20 340.10 579.10 0.00 579.10 2689,20 1014.20 58.70 -34.10 0.00 921.40 331.70 589.70 0.00 589.70 2820.40 0.00 1067.90 10356.87 47.60 0.00 3.00 0.00 0.00 0.00 1017.30 0.00 349.00 0.00 668.30 0.00 0.00 0.00 668.30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2016 2017 2018 2019 2020 2021 2022 2023 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 254.30 0.00 1632.60 65.40 1567.20 1446,00 215.20 113.70 304.00 575.50 0.00 0.00 1693.50 1884.50 72.10 77.40 1621.40 1807.10 1424.10 1373.80) 162.50 260.50 113.30 140.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2 INCOME STATEMENT 3 Year 4 Net Sales 5 Less: Cost of Goods Sold 6. Gross Profit 7 Other Operating Revenue 8 Less: Operating Expenses 9 Operating income EBIT 10 Lek: Interest Expense 11 Other Income (Expenses) 12 Gain (Loss) 13 Income before Taxes EBT 14 Less Taxes Related to Operations 15 NL before Min. Em. 16 Gain (Loss) 17 Net Income (Loss) 38 TO BALANCE SHEET 20 Year 21 ASSETS 22 Current Assets 23 Cash 24 Marketable Securities 25 Gross Receivables 26 Less: Allowance for Bad Debts 27 Net Trade Receivables 28 Inventories 29 Prepaid Expenses 30 Other Current Assets 31 32 Total Current Assets 23 34 Long Term Assets 25 Net Tangible (Fixed) Assets (other thi 36. Construction in Progress 37 Intangible Assets 38 Investments 29 Other Nonoperating Assets 40 Other Operating Assets 41 Total Long Term Assets 42 Total Assets 43 LIABILITIES AND EQUITY Current liabilities 5 Accounts Payable 45 Short Term Loans 47 Current Maturity of Lt. Debt 48 Other Current Liabilities 19 Total Current Liabilities 50 Long-Term Liabilities: 51 Long-term Debt 52 Reserves 53 Deferred Liabilities 54 Minority interest 55 Redeemable. Preferred 56 Total Long-term Liabilities 57 Total Liabilities 58 Shareholders' Equity 59 Common Equity-incl. Ret. Er 60 Total Equity 61 Total Liabilities and Equity 62 3596.40 3625.30 4157.70 0.00 1542.10 72.40 1135.10 448,30 410.90 0.00 266.20 1447.80 171.00 397.30 0.00 178.20 437.80 0.00 233.00 1505.52 252.45 454.76 0.00 247.23 1567.17 262.79 473.38 0.00 257.36 1632.67 1695.61 273.77 284.33 493.17 512.18 0.00 0.00 268.11 278.45 1760.25 295.17 531.70 0.00 289.07 2260.50 5856.90 2194.30 5819.60 2285.30 6443.00 2459.97 2459.97 2560.70 2560.70 2667.73 2770.56 2876.19 2667.73 2770.56 2876.19 0.00 543.80 924.20 50.10 621.90 2140.00 432.00 855.30 5.40 504.40 425,20 55.30 851.30 1836,20 804.66 40.44 717.98 7103.32 837.61 42.10 747.38 2189.44 872 62 43.85 778.62 2280.95 906.25 45.54 808,63 2368.87 940.81 47.28 839.16 2459,19 494.00 1786.70 559.18 0.00 129.24 582.08 0.00 134,53 606.40 0.00 140.15 629.78 0.00 145.55 653.79 0.00 151.10 470.30 0.00 110.30 0.00 0,30 580.90 2720.90 435.90 625.90 0.00 0.00 102.20 141.60 0.00 0.00 0.30 0.30 538.40 757.80 2325.10 2604.00 0.33 688.74 2792.06 0.34 716.95 2906.39 0.36 746.91 3027.87 0.37 775.70 3144.58 0.38 805.28 3264,47 3136,00 3136.00 5856,90 3494.50 3839.00 3821.11 3977.57 3494.50 3839.00 3821.11 3977.57 5819.60 5443.00 6613.17 6883.96 4143.82 4303,55 4467.62 4143,82 4303.55 4467.62 7171.697448.13 7732.09 1. Complete the Performa Income Statement and the Performa Balance Sheet Use the "Percent of Sales" approach The items in the yellow boxes are considered to vary with sales 2. Forecast sales with the regression function 3. Utilizing the output of the regression function provide the R2 and t-stat for the x-variable