Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Assumptions : Sales will increase by 15% COGS will increase by 150 Basis Points General and Admin Expenses will Increase by 50 basis points R
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!
\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}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started