Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I need this answer in the 4 min please. Suppose that ABC organization's current Sales = 20,000. Also, suppose ABC has forecast the following values:

I need this answer in the 4 min please.

Suppose that ABC organization's current Sales = 20,000. Also, suppose ABC has forecast the following values:

Costs of goods sold (% of sales)

0.85

General, selling, and administrative expenses (% of Sales)

0.10

Cash and securities (days sales cash)

15

Accounts receivable (collection period)

50

Inventories (inventory turnover)

10

Accounts payable (payables period)

60

Where days sales cash = cash / (sales/day), the collection period = AR / (sales/day), and the payables period = AP / (cost of sales/day).

Complete the template below before solving for the additional funds, or the external funding, needed to finance a 30% increase in sales.

Income Statement

Sales

Cost of goods sold

Gross profit

Expenses:

General, selling, and administrative expenses

Net interest expense

100

Earnings before taxes

Tax

Earnings after tax

Balance Sheet

Assets

Current assets:

Cash and securities

Accounts receivable

Inventories

Prepaid expenses

20

Total current assets

Net fixed assets

300

Total assets

Liabilities and owners' equity

Current liabilities

Bank loan

0

Accounts payable

Current portion of long-term debt

100

Accrued wages

30

Total current liabilities

Long-term debt

700

Common stock

150

Retained earnings

1500

Tota

Suppose that ABC organization's current Sales = 20,000. Also, suppose ABC has forecast the following values:

Costs of goods sold (% of sales)

0.85

General, selling, and administrative expenses (% of Sales)

0.10

Cash and securities (days sales cash)

15

Accounts receivable (collection period)

50

Inventories (inventory turnover)

10

Accounts payable (payables period)

60

Where days sales cash = cash / (sales/day), the collection period = AR / (sales/day), and the payables period = AP / (cost of sales/day).

Complete the template below before solving for the additional funds, or the external funding, needed to finance a 30% increase in sales.

Income Statement

Sales

Cost of goods sold

Gross profit

Expenses:

General, selling, and administrative expenses

Net interest expense

100

Earnings before taxes

Tax

Earnings after tax

Balance Sheet

Assets

Current assets:

Cash and securities

Accounts receivable

Inventories

Prepaid expenses

20

Total current assets

Net fixed assets

300

Total assets

Liabilities and owners' equity

Current liabilities

Bank loan

0

Accounts payable

Current portion of long-term debt

100

Accrued wages

30

Total current liabilities

Long-term debt

700

Common stock

150

Retained earnings

1500

Total liabilities and owners' equity

External funding required

???

l liabilities and owners' equity

External funding required

???

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Elementary Statistics

Authors: Mario F. Triola

12th Edition

0321836960, 978-0321836960

Students also viewed these Finance questions

Question

Show enthusiasm for the position (but not too much).

Answered: 1 week ago

Question

ON WHAT ITEMS DOES ACTIVITY-BASED MANAGEMENT FOCUS? LO.1

Answered: 1 week ago