Question

Tropical, Inc. has provided the following financial information in its application for a loan. Assets Liabilities...

Tropical, Inc. has provided the following financial information in its application for a loan.

Assets Liabilities and Equity
___________________________________________________
Cash $ 20 Accounts Payable $ 30
Accounts Receivables $ 90 Notes Payable $ 90
Inventory $ 90 Accruals $ 30
Long Term Debt $150
Plant and equipment $500 Equity $400
-----------------------------------------------------------------------------------

Also assume sales = $500, cost of goods sold = $360, taxes = $56, interest payments = $40, net income = $44, the dividend payout ratio is 50%, and the market value of equity is equal to the book value.

What is the Altman discriminant function value for Tropical, Inc.? Recall that:

Net working capital = Current assets minus current liabilities.
Current assets = Cash + accounts receivable + inventories.
Current liabilities = Accounts payable + accruals + notes payable.
EBIT = Revenues - Cost of goods sold - depreciation.
Taxes = (EBIT - Interest) (tax rate).
Net income = EBIT - interest - taxes.
Retained earnings = Net income (1 - dividend payout ratio)

Altman’s discriminant function is given by:
Z = 1.2X1+ 1.4X2 + 3.3X3 + 0.6X4 + 1.0X5
Assume prior retained earnings are zero.
X1= Working capital/total assets
X2 = Retained earnings/ total assets
X3 = EBIT/ total assets
X4 = Market value of equity/long term debt
X5 = Sales/ total assets

Homework Answers

Answer #1

Working capital (WC) = Current Assets (CA) - Current Liabilities (CL)

Current Assets (CA) = Cash + Accounts Receivables + Inventory = 20 +90 +90 = 200

Current Liabilities (CL) = Accounts payable + Notes Payable + Accruals = 30+90+30 = 150

Thus, Working capital (WC) = 200 - 150 = 50

Total assets = Current Assets + Plant and equipment = 200 + 500 = 700

X1= Working capital/total assets = 50/700 = 0.071428

Retained earnings = Net income (1 - dividend payout ratio)

Retained earnings = 44*(1-50%) = 22

X2 = Retained earnings/ total assets = 22/700 = 0.031428

EBIT = revenues – cost of goods sold – depreciation

EBIT = 500 - 360 - 0 = 140

X3 = EBIT/ total assets = 140/700 = 0.2

Since the market value of equity is equal to the book value.

Thus, the market value of equity = 400

X4 = Market value of equity/long term debt = 400/150 = 2.67

X5 = Sales/ total assets = 500/700 = 0.7143

Altman’s discriminant function is given by:

Z = 1.2X1+ 1.4X2 + 3.3X3 + 0.6X4 + 1.0X5

Putting the calculated values, we get:

Z = 1.2*0.071428+ 1.4*0.031428 + 3.3*0.2 + 0.6*2.67 + 1.0*0.7143

Z = 3.106

Please comment in case of any doubts or queries. Please Thumbs UP!!

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Assets 2019 Net Sales $5,000,000.00 Cash & equivalents $20,000.00 Variable Cost (75% of sales) $3,750,000.00 Accounts...
Assets 2019 Net Sales $5,000,000.00 Cash & equivalents $20,000.00 Variable Cost (75% of sales) $3,750,000.00 Accounts Receivable $15,000.00 Inventory $10,000.00 Gross profit $1,250,000.00 Total current assets $45,000.00 Fixed Cost $100,000.00 Net Plant and equipment $50,000.00 Earnings before interest, taxes dp and amort. $1,150,000.00 Total assets $95,000.00 Depreciation $35,000.00 Net OP. Income (EBIT) $1,115,000.00 Liabilities and equity Interest $12,000.00 Accounts payable $5,000.00 Earnings before taxes $1,103,000.00 Accruals $2,000.00 Taxes (40%) $441,200.00 Notes payable $10,000.00 Net Income $661,800.00 Total current liabilities $17,000.00...
The most recent financial statements for Retro Machine, Inc., follow. Sales for 2017 are projected to...
The most recent financial statements for Retro Machine, Inc., follow. Sales for 2017 are projected to grow by 10 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets and accounts payable increase spontaneously with sales. RETRO MACHINE, INC. 2016 Income Statement Sales $ 744,050 Costs 578,850 Other expenses 15,550 Earnings before interest and taxes $ 149,650 Interest paid 11,300 Taxable income $ 138,350 Taxes (35%) 48,423...
Financing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December...
Financing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016 Cash $   180,000 Accounts payable $   360,000 Receivables 360,000 Notes payable 156,000 Inventories 720,000 Line of credit 0 Total current assets $1,260,000 Accruals 180,000 Fixed assets 1,440,000 Total current liabilities $   696,000 Common stock 1,800,000 Retained earnings 204,000 Total assets $2,700,000 Total liabilities and equity $2,700,000 Income Statement for December 31, 2016 Sales $3,600,000 Operating costs 3,279,720 EBIT $  320,280 Interest 18,280 Pre-tax earnings $  302,000 Taxes...
Problem 12-09 Financing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as...
Problem 12-09 Financing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016 Cash $   180,000 Accounts payable $   360,000 Receivables 360,000 Notes payable 156,000 Inventories 720,000 Line of credit 0 Total current assets $1,260,000 Accruals 180,000 Fixed assets 1,440,000 Total current liabilities $   696,000 Common stock 1,800,000 Retained earnings 204,000 Total assets $2,700,000 Total liabilities and equity $2,700,000 Income Statement for December 31, 2016 Sales $3,600,000 Operating costs 3,279,720 EBIT $  320,280 Interest 18,280 Pre-tax earnings...
The most recent financial statements for Moose Tours, Inc., follow. Sales for 2017 are projected to...
The most recent financial statements for Moose Tours, Inc., follow. Sales for 2017 are projected to grow by 15 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, and accounts payable increase spontaneously with sales. MOOSE TOURS, INC. 2016 Income Statement Sales $ 995,000 Costs (782,000 ) Other expenses (15,000 ) Earnings before interest and taxes $ 198,000 Interest paid (21,670 ) Taxable income $ 176,330...
Use the financial statements below to determine the CFO, CFF and CFI for the current year....
Use the financial statements below to determine the CFO, CFF and CFI for the current year. Income Statement (current year) Sales $7,035,600 Cost of goods sold 5,800,000 Depreciation 120,000 Other expenses 612,960 EBIT $502,640 Interest expense 80,000 EBT $422,640 Taxes (40%) 169,056 Net income $253,584 Retained Earnings $198,584 Dividends $55,000 Balance Sheet Last year Current year Last year Current year Liabilities and Equity Cash $7,282 $14,000 Accounts payable $324,000 $359,800 Accounts receivable 652,160 $949,632 Notes payable 720,000 $300,000 Inventories 1,287,360...
A company has the following income statement and balance sheet: INCOME STATEMENT Sales $1,000 Costs 600...
A company has the following income statement and balance sheet: INCOME STATEMENT Sales $1,000 Costs 600 Depreciation 240 EBIT $ 160 Interest expenses 60 EBT $ 100 Taxes (40%) 40 Net income $ 60 BALANCE SHEET Cash $ 20 Accounts payable $ 30 Short-term investments 30 Accruals 50 Accounts receivable 20 Notes payable 10 Inventory 60 Current liabilities 90 Current assets 130 Long-term debt 70 Gross fixed assets 140 Common stock 30 Accumulated deprec. 40 Retained earnings 40 Net fixed...
Consider the following sets of financial statements and answer the questions that follow: Pettijohn Inc. The...
Consider the following sets of financial statements and answer the questions that follow: Pettijohn Inc. The balance sheet and income statement shown below are for Pettijohn Inc. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. Balance Sheet (Millions of $) Assets 2016 Cash and securities $  1,554.0 Accounts receivable 9,660.0 Inventories   13,440.0 Total current assets...
Canadian Bacon Inc. financial statements are presented in the table below.             Based on the information in...
Canadian Bacon Inc. financial statements are presented in the table below.             Based on the information in the table, and using a 365-day year, calculate operating cycle. Round the answers to two decimal places    Balance Sheet December 31, 2014 Cash and marketable securities $132,000 Accounts payable $399,000 Accounts receivable $311,000 Notes payable $98,500 Inventories $512,000 Accrued expenses $89,300 Prepaid expenses $11,300 Total current liabilities $586,800 Total current assets $966,300 Long-term debt $799,400 Gross fixed assets $2,104,000 Par value and paid-in-capital...
Bailey Corporation's financial statements (dollars and shares are in millions) are provided here. Bailey Corporation (in...
Bailey Corporation's financial statements (dollars and shares are in millions) are provided here. Bailey Corporation (in million of dollars) Balance Sheets as of December 31 2016 2015 Assets Cash and cash equivalents $     14,000 $       13,000 Accounts receivable         30,000            25,000 Inventories         28,125            21,000 Total current assets $     72,125 $       59,000 Net fixed assets         50,000            47,000 Total assets $   122,125 $     106,000 Liabilities and equity Accounts payable $     10,800 $          9,000 Notes payable            6,700...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT