Here is the initial data :

Assumptions :

Sales will increase by 15%
COGS will increase by 150 Basis Points
General and Admin Expenses will Increase by 50 basis points
R & D, Current Assets and Current Liabilities will remain the same
percent of sales as in the previous year
Depreciation will increase by $285,000
Net fixed assets will increase by 18%
The tax rate and dividend payout rate will not change
Asssume no change in long-term debt or common stock

Using the assumption please provide me

Sales

Cost of Goods Sold

Gross Profit

Operating Expenses

Depreciation

EBIT

Interest Expense

EBT

Taxes

Net Income

Dividends

Additional Retained

Also provide current assets and liabillies :

Current Assets

Cash

Account Receivable

Inventory

Total

Net Fixed Assets

Total Assets

Current Liabilities

Accounts Payable

Accruals

Notes Payable

Total

Long-term Debt

Total Liabilities

Also provide :

Common Stock

Retained Earnings

Total Equity

Total Liabilities and Equity

External Required

I WILL GIVE A THUMBS UP PLEASE SHOW ALL WORK IN EXCEL!

inital data is the assumptions

done

added

it has been added

\begin{tabular}{|c|c|c|c|} \hline 2 & A & B & C \\ \hline \multicolumn{4}{|l|}{1} \\ \hline 2 & Sales & & 120,000,000 \\ \hline 3 & COGS & & 44,400,000 \\ \hline 4 & Gross Profit & & 75,600,000 \\ \hline 5 & General and Admin Exp & & 42,000,000 \\ \hline 6 & Research and Dev & & 18,000,000 \\ \hline 7 & Depreciation & & 2,488,000 \\ \hline 8 & EBIT & & 13,112,000 \\ \hline 9 & Interest Exp & & 2,625,000 \\ \hline 10 & EBT & & 10,487,000 \\ \hline 11 & Taxes & & 3,565,580 \\ \hline 12 & Net Income & & 6,921,420 \\ \hline 13 & Dividends & & 1,730,355 \\ \hline 14 & Add. Retained & & 5,191,065 \\ \hline \multicolumn{4}{|l|}{15} \\ \hline \multicolumn{4}{|l|}{16} \\ \hline \multicolumn{4}{|l|}{17} \\ \hline 18 & Current Assets & & 36,000,000 \\ \hline 19 & Net Fixed assets & & 66,500,000 \\ \hline 20 & Total Assets & & 102,500,000 \\ \hline \multicolumn{4}{|l|}{21} \\ \hline 22 & Current Liabilities & & 40,800,000 \\ \hline 23 & Long-Term Debt & & 31,800,000 \\ \hline 24 & Common Stock & & 12,500,000 \\ \hline 25 & Retained Earnings & & 17,400,000 \\ \hline 26 & Total Liabilities \& Equity & & 102,500,000 \\ \hline \multicolumn{4}{|l|}{27} \\ \hline 28 & Sales will increase by 15% & & \\ \hline 29 & COGS will increase by 150 Basis Points & & \\ \hline 30 & \multicolumn{3}{|c|}{ General and Admin Expenses will Increase by 50 basis points } \\ \hline 31 & \multicolumn{3}{|c|}{ R \& D, Current Assets and Current Liabilities will remain the same } \\ \hline 32 & percent of sales as in the previous year & & \\ \hline \multicolumn{4}{|l|}{33} \\ \hline 34 & Depreciation will increase by $285,000 & & \\ \hline \multicolumn{4}{|l|}{35} \\ \hline 36 & Net fixed assets will increase by 18% & & \\ \hline \multicolumn{4}{|l|}{37} \\ \hline 38 & \multicolumn{3}{|c|}{ The tax rate and dividend payout rate will not change } \\ \hline \multicolumn{4}{|l|}{39} \\ \hline 40 & \multicolumn{2}{|c|}{ Asssume no change in long-term debt or common stock } & \\ \hline 41 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2 & A & B & C \\ \hline \multicolumn{4}{|l|}{1} \\ \hline 2 & Sales & & 120,000,000 \\ \hline 3 & COGS & & 44,400,000 \\ \hline 4 & Gross Profit & & 75,600,000 \\ \hline 5 & General and Admin Exp & & 42,000,000 \\ \hline 6 & Research and Dev & & 18,000,000 \\ \hline 7 & Depreciation & & 2,488,000 \\ \hline 8 & EBIT & & 13,112,000 \\ \hline 9 & Interest Exp & & 2,625,000 \\ \hline 10 & EBT & & 10,487,000 \\ \hline 11 & Taxes & & 3,565,580 \\ \hline 12 & Net Income & & 6,921,420 \\ \hline 13 & Dividends & & 1,730,355 \\ \hline 14 & Add. Retained & & 5,191,065 \\ \hline \multicolumn{4}{|l|}{15} \\ \hline \multicolumn{4}{|l|}{16} \\ \hline \multicolumn{4}{|l|}{17} \\ \hline 18 & Current Assets & & 36,000,000 \\ \hline 19 & Net Fixed assets & & 66,500,000 \\ \hline 20 & Total Assets & & 102,500,000 \\ \hline \multicolumn{4}{|l|}{21} \\ \hline 22 & Current Liabilities & & 40,800,000 \\ \hline 23 & Long-Term Debt & & 31,800,000 \\ \hline 24 & Common Stock & & 12,500,000 \\ \hline 25 & Retained Earnings & & 17,400,000 \\ \hline 26 & Total Liabilities \& Equity & & 102,500,000 \\ \hline \multicolumn{4}{|l|}{27} \\ \hline 28 & Sales will increase by 15% & & \\ \hline 29 & COGS will increase by 150 Basis Points & & \\ \hline 30 & \multicolumn{3}{|c|}{ General and Admin Expenses will Increase by 50 basis points } \\ \hline 31 & \multicolumn{3}{|c|}{ R \& D, Current Assets and Current Liabilities will remain the same } \\ \hline 32 & percent of sales as in the previous year & & \\ \hline \multicolumn{4}{|l|}{33} \\ \hline 34 & Depreciation will increase by $285,000 & & \\ \hline \multicolumn{4}{|l|}{35} \\ \hline 36 & Net fixed assets will increase by 18% & & \\ \hline \multicolumn{4}{|l|}{37} \\ \hline 38 & \multicolumn{3}{|c|}{ The tax rate and dividend payout rate will not change } \\ \hline \multicolumn{4}{|l|}{39} \\ \hline 40 & \multicolumn{2}{|c|}{ Asssume no change in long-term debt or common stock } & \\ \hline 41 & & & \\ \hline \end{tabular}