Question

In: Finance

Jason Company's balance sheet last year was the followingamounts as of December 31st: Cash $10...

Jason Company's balance sheet last year was the following amounts as of December 31st: Cash $10 Accounts payable $15 Accounts receivable 40 Accruals 5 Inventory 50 Short-term debt 20 Net property plant 100 Long-term debt 20 Common stock 20 Retained earnings 120 Total assets $200 Total liabilities and equity $200 Last year the firm's sales were $2,000, and it had a profit margin of 10 percent and a dividend payout ratio of 60 percent. Baxter operated its property plant at full capacity. The company expects to increase its net sales by 37.5 percent, to $2,750, but the profit margin is expected to fall to 2 percent, and the retained earnings ratio is expected to rise to 55 percent. What is Jason's additional funds needed (AFN) for this year?

Solutions

Expert Solution

AFN = Increase in sales - increase in spontaneous Liabilities - Addition to Retained earnings

1. Increase in Assets = Total assets * Sales Growth = 200 * 0.375 = $75

2. Increase in Spontaneous Liabilities = (accounts Payable + Accruals) * Sales Growth = 20 * 0.375 = $7.50

* Short term debt doesn't changes with growth of sales

3. Addition to retained earnings = New Sales * Profit margin * Retained Earning ratio

Addition to retained earnings = 2750 * 2% * 55%

Addition to retained earnings = $30.25

Thus,

AFN = Increase in sales - increase in spontaneous Liabilities - Addition to Retained earnings

AFN = 75 - 7.50 - 30.25

AFN = $37.25


Related Solutions

Create a balance sheet as of December 31st, 2014 and a cash flow statement for the...
Create a balance sheet as of December 31st, 2014 and a cash flow statement for the three months ending 12/31/14 using the following information. A ssume bills are paid in current month unless otherwise indicated.  Take home salary received each week is $450  Utility (electric/gas/water) bills in October were $165, November $195, and December $200.  Bought presents and clothes for $110 in Sept ember, $140 in October, $350 in November. o All purchases we're on credit and...
Problem 15-8 Baskin Company's net income last year was $98,000. Changes in the company's balance sheet...
Problem 15-8 Baskin Company's net income last year was $98,000. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Debit balances: Cash $24,000 Accounts receivable 15,000 Inventory (18,000) Prepaid expenses (6,000) Long-term investments 10,000 Plant and equipment 40,000 Credit balances: Accumulated depreciation 32,000 Accounts payable (14,000) Accrued liabilities 11,000 Taxes payable 4,000 Bonds payable (40,000) Common stock 10,000 Retained earnings 62,000 The company declared and paid cash dividends of $36,000 last year. Required: A. Prepare...
From the following data prepare the balance sheet of X Ltd., as on 31st December, 1999....
From the following data prepare the balance sheet of X Ltd., as on 31st December, 1999. Current ratio 2.5; Quick ratio 1.5; Net working capital Rs.3,00,000 Gross profi t ratio 20% Fixed Assets turnover ratio 2 times Stock turnover ratio (Cost of sales/ Closing stock) 6 times. Average Collection period 2 months Super quick ratio .25 Fixed Assets to shareholders equity .8 Reserves and surpluses to share capital .5 Debt equity ratio .2
Burns Corporation's net income last year was $92,800. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $92,800. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 21,300 Accounts receivable $ 13,400 Inventory $ (17,600 ) Prepaid expenses $ 4,200 Long-term investments $ 11,000 Property, plant, and equipment $ 71,400 Accumulated depreciation $ 33,500 Liability and Equity Accounts: Accounts payable $ (18,400 ) Accrued liabilities $ 17,000 Income taxes payable $ 4,200 Bonds payable $ (64,200...
Burns Corporation's net income last year was $98,300. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $98,300. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 25,000 Accounts receivable $ 14,200 Inventory $ (17,100 ) Prepaid expenses $ 4,100 Long-term investments $ 11,000 Property, plant, and equipment $ 72,100 Accumulated depreciation $ 33,800 Liability and Equity Accounts: Accounts payable $ (19,600 ) Accrued liabilities $ 17,300 Income taxes payable $ 4,200 Bonds payable $ (62,400...
Burns Corporation's net income last year was $96,500. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $96,500. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 18,600 Accounts receivable $ 13,300 Inventory $ (16,300 ) Prepaid expenses $ 4,300 Long-term investments $ 10,300 Property, plant, and equipment $ 74,200 Accumulated depreciation $ 31,600 Liability and Equity Accounts: Accounts payable $ (19,400 ) Accrued liabilities $ 17,600 Income taxes payable $ 4,200 Bonds payable $ (63,600...
Megan Corporation's net income last year was $101,000. Changes in the company's balance sheet accounts for...
Megan Corporation's net income last year was $101,000. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ (5,400 ) Accounts receivable $ (17,000 ) Inventory $ 4,500 Prepaid expenses $ (9,100 ) Long-term investments $ 83,000 Property, plant, and equipment $ 61,000 Accumulated depreciation $ 64,000 Liability and Equity Accounts: Accounts payable $ 0 Accrued liabilities $ 17,020 Income taxes payable $ (12,120 ) Bonds payable...
Burns Corporation's net income last year was $94,600. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $94,600. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 17,000 Accounts receivable $ 13,300 Inventory $ (16,600 ) Prepaid expenses $ 4,300 Long-term investments $ 10,300 Property, plant, and equipment $ 73,500 Accumulated depreciation $ 31,600 Liability and Equity Accounts: Accounts payable $ (18,400 ) Accrued liabilities $ 17,100 Income taxes payable $ 4,200 Bonds payable $ (64,200...
Burns Corporation's net income last year was $97,400. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $97,400. Changes in the company's balance sheet accounts for the year appear below: Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 22,700 Accounts receivable $ 13,800 Inventory $ (16,800 ) Prepaid expenses $ 4,400 Long-term investments $ 10,400 Property, plant, and equipment $ 71,400 Accumulated depreciation $ 32,600 Liability and Equity Accounts: Accounts payable $ (19,400 ) Accrued liabilities $ 17,100 Income taxes payable $ 4,100 Bonds payable $ (64,800...
Burns Corporation's net income last year was $96,500. Changes in the company's balance sheet accounts for...
Burns Corporation's net income last year was $96,500. Changes in the company's balance sheet accounts for the year appear below:    Increases (Decreases) Asset and Contra-Asset Accounts: Cash and cash equivalents $ 18,600 Accounts receivable $ 13,300 Inventory $ (16,300 ) Prepaid expenses $ 4,300 Long-term investments $ 10,300 Property, plant, and equipment $ 74,200 Accumulated depreciation $ 31,600 Liability and Equity Accounts: Accounts payable $ (19,400 ) Accrued liabilities $ 17,600 Income taxes payable $ 4,200 Bonds payable $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT