Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete Balance sheet and Income statement Plastic Sports, Inc. Income Statement In thousands of dollars begin{tabular}{|l|l|r|r|r|} hline 4 & & 2022 & 2021 & 2020

Complete Balance sheet and Income statement
image text in transcribed
image text in transcribed
image text in transcribed
Plastic Sports, Inc. Income Statement In thousands of dollars \begin{tabular}{|l|l|r|r|r|} \hline 4 & & 2022 & 2021 & 2020 \\ \hline \hline 5 & Sales & 7,150.7 & 6,272.6 & 5,359.3 \\ \hline 6 & Cost of Goods & 5,005.5 & 4,728.8 & 4,076.5 \\ \hline 7 & Gross Profit & 2,145.2 & 1,543.8 & 1,282.8 \\ \hline 8 & Selling and G\&A Expenses & 654.9 & 595.4 & 536.9 \\ \hline 9 & Fixed Expenses & 195.0 & 195.0 & 195.0 \\ \hline 10 & EBITDA & 1,295.3 & 753.4 & 550.9 \\ 11 & Depreciation & 100.0 & 78.0 & 65.0 \\ \hline 12 & Operating Income (EBIT) & 1,195.3 & 675.4 & 485.9 \\ \hline 13 & Interest Expense & & 138.6 & 132.3 \\ \hline 14 & Pre-tax Income & & 536.8 & 353.6 \\ \hline 15 & Tax & & 118.1 & 77.8 \\ \hline 16 & Net Income & & 418.7 & 275.8 \\ \hline 17 & & & \\ \hline \end{tabular} 18 Notes: 19 Tax Rate 20 Shares Outstanding 22% 21 Dividend per share 22 Balance Sheet In thousands of dollars Ise % of sales method and the following assumptions to create the pro-formas: 1 The firm has forecasted sales growth of 14%-that is, sales in 2022 are expected 14% higher than in 2021 2 The cost of goods sold (COGS) in 2022 is expected to change with sales at rate of 70.0% of sales due to a new cost saving mechanical production process 3 The selling and G\&A expenses in 2022 are expected to change with sales at a rate of 10% based on estimates that take the new production process into consideration. 4 Depreciation will increase due to a new capital investment described in point seven below. 5 The tax rate is expected at 22%, in line with the previous two years 6 Cash, accounts receivable, inventory, accounts payable, and acerued expenses are expected to change with sales at rates of 3%,11%,13.5%,7% and 1.5% of sales respec T The firm pians an investment of $1,000,000 in a repair equipment in 2022. The equipment has an estimated useful life of 10 years and no salvage value. This equipment will be depreciated using the straight line depreciation method. There are no other additional capital expenditures planned for 2022 . 8 fixed expense, Notes Payable, Long Term Debt, Common Stock and Additional Paid-in Capital will remain at their 2021 levels in 2022. 9 Assume the firm pays 15% interest on short-term debt and 9% on long term debt. 10 The management would like to increase the dividend per share by 25 cents compared to 2021 Plastic Sports, Inc. Income Statement In thousands of dollars \begin{tabular}{|l|l|r|r|r|} \hline 4 & & 2022 & 2021 & 2020 \\ \hline \hline 5 & Sales & 7,150.7 & 6,272.6 & 5,359.3 \\ \hline 6 & Cost of Goods & 5,005.5 & 4,728.8 & 4,076.5 \\ \hline 7 & Gross Profit & 2,145.2 & 1,543.8 & 1,282.8 \\ \hline 8 & Selling and G\&A Expenses & 654.9 & 595.4 & 536.9 \\ \hline 9 & Fixed Expenses & 195.0 & 195.0 & 195.0 \\ \hline 10 & EBITDA & 1,295.3 & 753.4 & 550.9 \\ 11 & Depreciation & 100.0 & 78.0 & 65.0 \\ \hline 12 & Operating Income (EBIT) & 1,195.3 & 675.4 & 485.9 \\ \hline 13 & Interest Expense & & 138.6 & 132.3 \\ \hline 14 & Pre-tax Income & & 536.8 & 353.6 \\ \hline 15 & Tax & & 118.1 & 77.8 \\ \hline 16 & Net Income & & 418.7 & 275.8 \\ \hline 17 & & & \\ \hline \end{tabular} 18 Notes: 19 Tax Rate 20 Shares Outstanding 22% 21 Dividend per share 22 Balance Sheet In thousands of dollars Ise % of sales method and the following assumptions to create the pro-formas: 1 The firm has forecasted sales growth of 14%-that is, sales in 2022 are expected 14% higher than in 2021 2 The cost of goods sold (COGS) in 2022 is expected to change with sales at rate of 70.0% of sales due to a new cost saving mechanical production process 3 The selling and G\&A expenses in 2022 are expected to change with sales at a rate of 10% based on estimates that take the new production process into consideration. 4 Depreciation will increase due to a new capital investment described in point seven below. 5 The tax rate is expected at 22%, in line with the previous two years 6 Cash, accounts receivable, inventory, accounts payable, and acerued expenses are expected to change with sales at rates of 3%,11%,13.5%,7% and 1.5% of sales respec T The firm pians an investment of $1,000,000 in a repair equipment in 2022. The equipment has an estimated useful life of 10 years and no salvage value. This equipment will be depreciated using the straight line depreciation method. There are no other additional capital expenditures planned for 2022 . 8 fixed expense, Notes Payable, Long Term Debt, Common Stock and Additional Paid-in Capital will remain at their 2021 levels in 2022. 9 Assume the firm pays 15% interest on short-term debt and 9% on long term debt. 10 The management would like to increase the dividend per share by 25 cents compared to 2021

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Letter Of Credit Learners Guide To Letter Of Credit

Authors: Nisha S Koshal

1946822078, 978-1946822079

More Books

Students also viewed these Accounting questions