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...
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...
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...
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...
FREE CASH FLOW Arlington Corporation’s financial statements (dollars and shares are in millions) are provided here....
FREE CASH FLOW Arlington Corporation’s financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2018                     2017 Assets Cash and equivalents                      $ 15,000               $ 14,000 Accounts receivable                        35,000                   30,000 Inventories                                         33,320                   27,000 Total current assets                        $ 83,320               $ 71,000 Net plant and equipment             48,000                  46,000 Total assets                                        $131,320             $ 117,000 Liabilities and Equity Accounts payable                             $ 10,100               $ 9,000 Accruals                                              ...
The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to...
The most recent financial statements for Scott, Inc., appear below. Sales for 2020 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate also will remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. SCOTT, INC. 2019 Income Statement   Sales $ 759,000   Costs 594,000   Other expenses 30,000   Earnings before interest and taxes $ 135,000   Interest expense 26,000   Taxable income $ 109,000   Taxes (21%)...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 760,000   Costs 595,000   Other expenses 31,000   Earnings before interest and taxes $ 134,000   Interest paid 27,000   Taxable income $ 107,000   Taxes (22%) 23,540...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT