Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedAssumptions :

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

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

The Handbook Of Pairs Trading

Authors: Douglas S. Ehrman

1st Edition

0471727075, 9780471727071

More Books

Students also viewed these Finance questions