Need help with Balance sheet specifically, Answere plus formulas woukd be ideal, answers themselves good too

The balance sheet needs to be completed

Bubble and Bee Organic - Pro Forma Modeling Template - New Building Scenario Depreciation Expense Existing Equipment Building 30 years New Equipment Total Net Interest Expense Tax Rate XA due to LLC Receivables as a \% of Revenues Inventory as a % of Revenues Accounts Payable as a \% Revenues Accrued 1.iabilities \% of Revenues Additions to PP\&E Debt Additions to Debt - Bank L.oan (Reductions) to Debt - Bank Loan Additions to Debt - Loug Term Debt (Reductions) to Debt - Long Term Debt Equity ouly fancing Divideads - Owner Draws Income Statement Revenues: Cost of Goods Sold Gross Mirgin Expenses Selling General \& Administrative Variable Gerieral \& Administrative Fixed Depreciation Total Expenses EBIT Net Interest Expense Taxable Incoue Taxes Net Incone Cash Flow Statement Total Assets 8 Liabilities \& Shateholder's Equity Current Liabilities Accounts Payable Accrued Liabitites Bank-Loan Total Curteat Liabilities Long Term Liabilities: Total Liabitities Sharebolder's Equity Member's Equity Retained Earrinos Iotal Shareholder's Equity Total L Labilities and Sharebolder's Equity Cash Provi Net Income Phis Deprec Change in W Decrea Decrea: Increase Increase Cash Pi Cash Provid. Additions to P Other Investrt Scrnariop-Rertal Scenarlozthewbullding K L Decrease (increase) in Receivables Decrease (increase) in Inventory Increase (decrease) in Accts. Payable Increase (decrease) in Accrued Liabilities Cash Provided (used) by Operations Cash Provided (used) by Investments Additions to PP\&E Other Investments Cash Provided (used) by Investments Cash Provided (used) by Financing Activities Additions (reductions) to Debt Net issues of Stock (Dividends - Owner Draws) Cash Provided (used) by Financing Activities Net increase (decrease) in cast \begin{tabular}{|r|c|c|c|} \hlineM & N & 0 & P \\ \hline(3,150) & & & \\ \hline(12,687) & & & \\ \hline 8,661 & & & \\ \hline & & & \\ \hline 309,058 & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline(74.400) & & & \\ \hline- & & & \\ \hline(74.400) & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline(42.217) & & & \\ \hline(175.000) & & & \\ \hline(217.217) & & & \\ \hline 12.441 & & & \\ \hline & & & \\ \hline \end{tabular} Assumptions Revesue Growth of about 15% per year Enit Demand Average Selling Price COGS % as a % of Revenues Selling Expense as a \% of Revenues General and Administrative Expense Variable GSA as a % of Revenue Fixed GSA Expense Depreciation Expense Existing Equiptuent Building - 30 years Nev Equipment Iotal Net Interest Expense Tax Rate NA due to LL.C Receivables as a \% of Revenues Inveutory as a % of Revenues Accoubts Payable as a \% Reveaues \begin{tabular}{|l|l|l|l|} \hline 2014 & 2015 & 2016 & 2017 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline 5% & 5% & 5% \\ \hline 600,000 & 650,000 & 700,000 \\ \hline \end{tabular} Bubble and Bee Organic - Pro Forma Modeling Template - New Building Scenario Depreciation Expense Existing Equipment Building 30 years New Equipment Total Net Interest Expense Tax Rate XA due to LLC Receivables as a \% of Revenues Inventory as a % of Revenues Accounts Payable as a \% Revenues Accrued 1.iabilities \% of Revenues Additions to PP\&E Debt Additions to Debt - Bank L.oan (Reductions) to Debt - Bank Loan Additions to Debt - Loug Term Debt (Reductions) to Debt - Long Term Debt Equity ouly fancing Divideads - Owner Draws Income Statement Revenues: Cost of Goods Sold Gross Mirgin Expenses Selling General \& Administrative Variable Gerieral \& Administrative Fixed Depreciation Total Expenses EBIT Net Interest Expense Taxable Incoue Taxes Net Incone Cash Flow Statement Total Assets 8 Liabilities \& Shateholder's Equity Current Liabilities Accounts Payable Accrued Liabitites Bank-Loan Total Curteat Liabilities Long Term Liabilities: Total Liabitities Sharebolder's Equity Member's Equity Retained Earrinos Iotal Shareholder's Equity Total L Labilities and Sharebolder's Equity Cash Provi Net Income Phis Deprec Change in W Decrea Decrea: Increase Increase Cash Pi Cash Provid. Additions to P Other Investrt Scrnariop-Rertal Scenarlozthewbullding K L Decrease (increase) in Receivables Decrease (increase) in Inventory Increase (decrease) in Accts. Payable Increase (decrease) in Accrued Liabilities Cash Provided (used) by Operations Cash Provided (used) by Investments Additions to PP\&E Other Investments Cash Provided (used) by Investments Cash Provided (used) by Financing Activities Additions (reductions) to Debt Net issues of Stock (Dividends - Owner Draws) Cash Provided (used) by Financing Activities Net increase (decrease) in cast \begin{tabular}{|r|c|c|c|} \hlineM & N & 0 & P \\ \hline(3,150) & & & \\ \hline(12,687) & & & \\ \hline 8,661 & & & \\ \hline & & & \\ \hline 309,058 & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline(74.400) & & & \\ \hline- & & & \\ \hline(74.400) & & & \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline(42.217) & & & \\ \hline(175.000) & & & \\ \hline(217.217) & & & \\ \hline 12.441 & & & \\ \hline & & & \\ \hline \end{tabular} Assumptions Revesue Growth of about 15% per year Enit Demand Average Selling Price COGS % as a % of Revenues Selling Expense as a \% of Revenues General and Administrative Expense Variable GSA as a % of Revenue Fixed GSA Expense Depreciation Expense Existing Equiptuent Building - 30 years Nev Equipment Iotal Net Interest Expense Tax Rate NA due to LL.C Receivables as a \% of Revenues Inveutory as a % of Revenues Accoubts Payable as a \% Reveaues \begin{tabular}{|l|l|l|l|} \hline 2014 & 2015 & 2016 & 2017 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|} \hline 5% & 5% & 5% \\ \hline 600,000 & 650,000 & 700,000 \\ \hline \end{tabular}