Question

In: Finance

Total asset turnover 1.5 times Average collection period​ (assume 365-day​ year) 15 days Fixed asset turnover...

Total asset turnover

1.5

times

Average collection period​ (assume 365-day​ year)

15

days

Fixed asset turnover

5

times

Inventory turnover​ (based on cost of goods​ sold)

3

times

Current ratio

2.0

times

Sales​ (all on​ credit)

​$4,000,000

Cost of goods sold

75%

of sales

Debt ratio

40%

Fill in the assets section of the pro forma balance sheet.  ​(Round all items to the nearest​ dollar.)

Cash

​$

Accounts receivable

Inventories

Net fixed assets

Total assets

​$

Fill in the liabilities and common equity section of the pro forma balance sheet.  ​(Round all items to the nearest​ dollar.)

Current liabilities

​$

​Long-term debt

Total liabilities

​$

Common equity

Total liabilities and common equity

Solutions

Expert Solution

PARTICULARS AMOUNT ($)
Cash 702,283
Account receivables 164,384
Inventories 1,000,000
Net fixed assets 800,000
Total assets 2,666,667
Current liabilities (A) 933,334
Long-term debt (B) 133,333
Total liabilities (A) + (B) 1,066,667
Common equity (C) 1,600,000
Total liabilities and common equity (A) + (B) + (C) 2,666,667

WORKINGS :

Sales = $4,000,000

Cost of goods sold = 75% of sales = $3,000,000

Total Assets = $2,666,667

Fixed Assets = $800,000

Inventory = $1,000,000

Account receivables = $164,384

Cash = Total Assets - Account receivables - Inventories - Fixed Assets

Cash = $2,666,667 - $164,384 - $1,000,000 - $800,000

Cash = $702,283

Total liabilities = $1,066,667

Current Liabilities = $933,334

Total liabilities = Current liabilities + Long-term debt

$1,066,667 = $933,334 + Long-term debt

Long-term debt = $133,333

Total assets = Total liabilities and common equity = $2,666,667

Total liabilities and common equity = Total liabilities + Common equity

$2,666,667 = $1,066,667 + Common equity

Common equity = $1,600,000


Related Solutions

What is the average collection period, inventory turnover, and total asset turnover for P&G from 2016,...
What is the average collection period, inventory turnover, and total asset turnover for P&G from 2016, 2017, and 2018 using http://financials.morningstar.com/balance-sheet/bs.html?t=PG&region=usa&culture=en-US http://financials.morningstar.com/income-statement/is.html?t=PG&region=usa&culture=en-US http://financials.morningstar.com/cash-flow/cf.html?t=PG&region=usa&culture=en-US
The total asset turnover should generally be higher in value than the fixed-asset turnover. A. True...
The total asset turnover should generally be higher in value than the fixed-asset turnover. A. True B. False
The average collection period ratio is defined as shown below: Accounts Receivable / (sales/ 365) It...
The average collection period ratio is defined as shown below: Accounts Receivable / (sales/ 365) It shows how many days, on average, it takes to collect your receivables. If your average collection period was 30 days last year and it is now 45 days, what does that imply? What is happening to your cash position?   What are some things you might do to reduce your average collection period?
A firm has days' sales in an inventory of 105 days, an average collection period of...
A firm has days' sales in an inventory of 105 days, an average collection period of 35 days, and takes 42 days, on average, to pay its accounts payable. Taken together, what do these three figures imply about the firm's operations and its cash flows?
Company Inventory Conversion Period, days Average Collection Period, days Payables Deferral Period, days Cash Conversion Cycle,...
Company Inventory Conversion Period, days Average Collection Period, days Payables Deferral Period, days Cash Conversion Cycle, days Adidas 112 27 57 82 Puma 107 18 49 Nike 128 20 43 105 Under Armor 89 24 21 1)calculate CCC for Puma and UA. 2)pick any 1 company of the 4: how its operational liquidity stands versus competitors (other 3 firms)? how can this company improve its liquidity? What are possible risks/limitations to your proposed changes?
Profit margin is 10%, asset turnover is 1.5 times, financial leverage is 2.0 times, earnings per...
Profit margin is 10%, asset turnover is 1.5 times, financial leverage is 2.0 times, earnings per share are $2.00 and dividends per share are $2.50. Which of the following statements is correct: 1. The return on assets is greater than the return on equity             2. The return on equity is greater than the sustainable growth rate             3. The sustainable growth rate is greater than the return on assets             4. The stock is over valued
Discuss when total asset turnover would be more important than fixed asset turnover. Provide an example.
Discuss when total asset turnover would be more important than fixed asset turnover. Provide an example.
Discuss when total asset turnover would be more important than fixed asset turnover. Provide an example.
Discuss when total asset turnover would be more important than fixed asset turnover. Provide an example.
Mr. Husker’s Tuxedos Corp. ended the year 2021 with an average collection period of 36 days....
Mr. Husker’s Tuxedos Corp. ended the year 2021 with an average collection period of 36 days. The firm’s credit sales for 2021 were $55.7 million. What is the year-end 2021 balance in accounts receivable for Mr. Husker’s Tuxedos? (Enter your answer in dollars not in millions.)
Using fixed asset disclosure to compare companies'/Fixed asset turnover and average age of depreciable assets The...
Using fixed asset disclosure to compare companies'/Fixed asset turnover and average age of depreciable assets The following PP & E information for fiscal year 2017 is available: Harley Davidson Amazon ( in millions) Walgreens Net sales $4,915 $107,006 $117,351 Historical cost $3,285.3 $68,573 $22,935 Accumulated depreciation 2,317.5 19,707 8,600 Net PP & E $ 967.8 $48,866 $14,335 Annual depreciation 222 11,478 1,718 Capital expenditures 206 11,995 1,325 Depreciation method SL SL SL Useful life- Buildings 30 20-40 20-50 Useful life-...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT