Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Do the new balance sheet with the assumptions in excel Sales Cost of Goods Sold Gross Profit Operating Expenses Depreciation EBIT Interest Expense EBT Taxes
Do the new balance sheet with the assumptions in excel Sales Cost of Goods Sold Gross Profit Operating Expenses Depreciation EBIT Interest Expense EBT Taxes Net Income Dividende Additional Retained 5,000,000 2.000.000 3,000,000 1,000,000 500.000 1.500.000 100 000 1.400.000 420.000 980.000 588.0001 392.000 Current Assets Cash Account Receivable Inventoly Total 500.000 600,000 1.000.000 2.100.000 Net Fixed Assets 3,000,000 Total Assets 5.100,000 Current Liabilities Accounts Payable Accruals Notes Payable Total Long-term Debt Total Liabilities 250,000 350,000 900.000 1,500,000 1.200.000 2,700,000 Common Stock Retained Earnings Total Equity 1,700,000 700.000 2.400.000 Total Liabilities and Equity 5.100.000 Assumption Sales growth - 10% COGS as a percentage of sales increases by 100 bps Operating Expenses as a percentage of sales decreases by 100 bps Cash, Accounts Receivable. Inventory and net fixed assets remain the same percent of sales Accounts Payable and Accruals remain the same percent of sales The tax rate and dividend payout rate do not change No change in notes payable, long-term debt or common stock Depreciation increases by 8% Sales Cost of Goods Sold Gross Profit Operating Expenses Depreciation EBIT Interest Expense EBT Taxes Net Income Dividende Additional Retained 5,000,000 2.000.000 3,000,000 1.000.000 500 000 1,500,000 100.000 1.400,000 420.000 980.000 588.000 392 000 Current Assets Cash Account Receivable Inventory Total 500.000 600.000 1.000.000 2.100.000 Net Fixed Assets 3.000.000 Total Assets 5.100.000 Current Liabilities Accounts Payable Accruals Notes Payable Total 250,000 350,000 900,000 1.500.000 Long-berry Debt 1.200.000 Total Liabilities 2,700,000 Common Stock Retained Earnings Total Equity 1.700.000 700 000 2.400.000 Total Liabilities and Equity 5.100.000 Assum Sales growth 10% COGS as a percentage of sales increase by 100 bps Operating Express a percentage of sales decrease by 100 Cash. Accounts Receivable. Inventory and not fixed ass remain the same percent of sale Accounts Payable and Accruals icmain the same percented sales The tax rate and dividend payout rate do not change No change in ses payable, long-term dcbitor cock Depreciation in why
Do the new balance sheet with the assumptions in excel
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