Pro forma income statement^

Pro Forma Balance sheet ^

Please fill in empty blue cells with work shown on how each answer was dealt with

\begin{tabular}{|l|r|r|r|} \hline Assets & 2017 & \multicolumn{1}{c}{2018} & \multicolumn{1}{l}{2019} \\ \hline Cash and Equivalents & 94.00 & 95.00 & 95.00 \\ \hline Accounts Receivable & 360.00 & 390.00 & \\ \hline Inventory & 740.00 & 875.00 & \\ \hline Total Current Assets & 1,194.00 & 1,360.00 & 95.00 \\ \hline Plant \& Equipment & 450.00 & 500.00 & \\ \hline Accumulated Depreciation & 129.00 & 153.00 & 153.00 \\ \hline Net Fixed Assests & 321.00 & 347.00 & 153.00 \\ \hline Total Assets & 1,515.00 & 1,707.00 & \\ \hline Liabilities and Owner's Equity & & & \\ \hline Accounts Payable & 175.00 & 185.00 & 221.58 \\ \hline Other Current Liabilities & 340.00 & 330.00 & 330.00 \\ \hline Total Current Liabilities & 515.00 & 515.00 & 551.58 \\ \hline Long-term Debt & 360.00 & 360.00 & 360.00 \\ \hline Total Liabilities & 875.00 & 875.00 & 911.58 \\ \hline Common Stock & 500.00 & 500.00 & 500.00 \\ \hline Retained Earnings & 140.00 & 332.00 & 5,041.00 \\ \hline Total Shareholder's Equity & 640.00 & 832.00 & 5,541.00 \\ \hline Total Liabilities and Owner's Equity & 1,515.00 & 1,707.00 & 6,452.58 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline Discretionary Financing Needed & & \\ \hline Net addition to plant and equip & 60.00 \\ \hline New depreciation (straight-line) & 6.00 & 6,452.58 Surplus \\ \hline (Based on 10 year life ofnew equipment) \end{tabular} Using the percent-of-sales method, what are 2019 Cost of Good Sold A. and SG& A Expenses A. Question 2 (6 points) Using the appropriate formulas and references, what are the 2019* Depreciation Expense Using the percent-of-sales method, what are the 2019* Accounts Receivables A. , Inventory A. , and Total Assets A. Question 4 (6 points) The Pro-Forma Balance Sheet will not be balanced at first. Use Excel's Solver tool with Long-term Debt to make it balance. What is the new amount of Long-term Debt A. and therefore, what is discretionary The Pro-Forma Balance Sheet will not be balanced at first. Use Excel's Solver tool with Long-term Debt to make it balance. What is the new amount of Long-term Debt \begin{tabular}{|l|r|r|r|} \hline Assets & 2017 & \multicolumn{1}{c}{2018} & \multicolumn{1}{l}{2019} \\ \hline Cash and Equivalents & 94.00 & 95.00 & 95.00 \\ \hline Accounts Receivable & 360.00 & 390.00 & \\ \hline Inventory & 740.00 & 875.00 & \\ \hline Total Current Assets & 1,194.00 & 1,360.00 & 95.00 \\ \hline Plant \& Equipment & 450.00 & 500.00 & \\ \hline Accumulated Depreciation & 129.00 & 153.00 & 153.00 \\ \hline Net Fixed Assests & 321.00 & 347.00 & 153.00 \\ \hline Total Assets & 1,515.00 & 1,707.00 & \\ \hline Liabilities and Owner's Equity & & & \\ \hline Accounts Payable & 175.00 & 185.00 & 221.58 \\ \hline Other Current Liabilities & 340.00 & 330.00 & 330.00 \\ \hline Total Current Liabilities & 515.00 & 515.00 & 551.58 \\ \hline Long-term Debt & 360.00 & 360.00 & 360.00 \\ \hline Total Liabilities & 875.00 & 875.00 & 911.58 \\ \hline Common Stock & 500.00 & 500.00 & 500.00 \\ \hline Retained Earnings & 140.00 & 332.00 & 5,041.00 \\ \hline Total Shareholder's Equity & 640.00 & 832.00 & 5,541.00 \\ \hline Total Liabilities and Owner's Equity & 1,515.00 & 1,707.00 & 6,452.58 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline Discretionary Financing Needed & & \\ \hline Net addition to plant and equip & 60.00 \\ \hline New depreciation (straight-line) & 6.00 & 6,452.58 Surplus \\ \hline (Based on 10 year life ofnew equipment) \end{tabular} Using the percent-of-sales method, what are 2019 Cost of Good Sold A. and SG& A Expenses A. Question 2 (6 points) Using the appropriate formulas and references, what are the 2019* Depreciation Expense Using the percent-of-sales method, what are the 2019* Accounts Receivables A. , Inventory A. , and Total Assets A. Question 4 (6 points) The Pro-Forma Balance Sheet will not be balanced at first. Use Excel's Solver tool with Long-term Debt to make it balance. What is the new amount of Long-term Debt A. and therefore, what is discretionary The Pro-Forma Balance Sheet will not be balanced at first. Use Excel's Solver tool with Long-term Debt to make it balance. What is the new amount of Long-term Debt