Question

The firm currently uses straight line depreciation so that depreciation expense in 2017 will be the...

The firm currently uses straight line depreciation so that depreciation expense in 2017 will be the same as in 2018. Depreciation expense in 2017 was $5,000. Sales are expected to grow by 30% in 2018. All net income is paid out in dividends and no new stock issues are planned. Notes payable at the end of 2017 will be paid off in 2018.

Calculate projected total assets and additional funds needed for 2018.

End of year 2017

            Cash                                            $15,000                  

            Accounts Receivable                     20,000

            Inventory 35,000

            Fixed Assets, gross                       75,000

            Accumulated Depreciation 15,000                  

            Fixed Assets, net                          60,000

            Accounts Payable                         15,000

            Notes Payable                               25,000

            Long-Term Debt 30,000

Common Equity 60,000

Homework Answers

Answer #1

Total Assets in 2017 = Cash + AR + Inventory + Net Fixed Assets = 15000+20000+35000+60000 = $ 130000

Depreciation amount in Year 2018 is same as that of Year 2017 , so Depreciation amount = $ 5000

Net fixed Assets in Year 2018 = $ 60000-$ 5000 = $ 55000

Notes payable in 2017 =$ 25000 to be paid in 2018

As mentioned in the question, no new stock issue is planned, therefore there will be no change in Stock value in 2018 , and it will be at same level of $ 35000

Also, as mentioned in the question, Sales will increase by 30% in 2018, it is assumed that Accounts receivables will also increase by 30% from last year i.e. $ 20000 + 30% = $ 26000

Similarly, on the basis of increase in Sales, purchase will also be increased by 30% , so, Accounts payable in 2018 will be $ 15000 + 30% = $19500

Total Assets in 2018 =Accounts Payable + Equity + Debt = 19500+60000+30000 = $ 109500

Also , Assets will be reduced by $ 25000 on payment of Notes

Cash Balance in 2018 = $ 109500 - (Net FA +AR + Inventory-25000) = $ 109500 - 55000 - 26000 - 35000 +25000 = $ 18500

Additional net cash requirement will be $18500 - $ 15000 = $ 3500

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
The balance sheet for December 31, 2018, December 31, 2017, and the income statement for the...
The balance sheet for December 31, 2018, December 31, 2017, and the income statement for the year ended December 31, 2018, for Rocket Company follows. Rocket Company Balance Sheet December 31, 2018 and 2017 2018    2017 Assets Cash $ 25,000    $ 20,000 Accounts receivable, net 60,000    70,000 Inventory 80,000    100,000 Land 50,000    50,000 Building and equipment 130,000*   115,000 Accumulated depreciation (85,000)   (70,000) Total assets $260,000    $285,000 Liabilities and Stockholders' Equity Accounts payable $ 30,000    $ 35,000 Income taxes payable 4,000   ...
a comparative balance sheet for ALPHAinc at December 31,2017 is shown below. 2017 2016 Change cash...
a comparative balance sheet for ALPHAinc at December 31,2017 is shown below. 2017 2016 Change cash 30,000 35,000 -5,000    accounts receivable 55,000 45,000 10,000 inventory 65,000 45,000 20,000 preppaid expense 15,000 25,000 -10,000 land 70,000 40,000 30,000 right of use of asset 100,000 0 100,000 equipment 90,000 75,000 15,000 accumulated depreciation -18,000 -8,000 -10,000 total 407,000 257,000 150,000 Accounts payable 65,000 52,000 13,000 accrued expense 15,000 18,000 3,000 notes payable 0 23,000 -23,000 bonds payable 30,000 0 30,000 lease...
Alpha Company has EBIT of $50,000 during a particular year. Its depreciation expenses total $10,000 and...
Alpha Company has EBIT of $50,000 during a particular year. Its depreciation expenses total $10,000 and it paid income taxes of $12,000. It spent $20,000 net on fixed assets and $5,000 on net working capital. The only cash flow to stockholders is dividends of $15,000. Determine cash flow to creditors during the year. a. $8,000 b. $33,000 c. $35,000 d. $18,000 The fixed assets section of CTC’s balance sheet is given below. Depreciation expense during the year is $15,000. Calculate...
Wickersham Brothers, Inc. reported the following information: 2018 2017 Balance Sheet Assets     Cash $50,000 $72,000     Accounts...
Wickersham Brothers, Inc. reported the following information: 2018 2017 Balance Sheet Assets     Cash $50,000 $72,000     Accounts Receivable 80,000 70,000     Merchandise Inventory 60,000 65,000     Property And Equipment 110,000 60,000     Less: Accumulated Depreciation (30,000) (15,000) Total Assets $270,000 $252,000 Liabilities:     Accounts Payable $10,000 $12,000     Salaries and Wages Payable 2,000 1,000     Bonds Payable, Long-Term 50,000 60,000 Stockholders’ Equity:     Common Stock 100,000 80,000     Retained Earnings 108,000   99,000 Total Liabilities and Stockholders’ Equity $270,000 $252,000 Income Statement     Sales $200,000     Cost of Goods Sold 110,000     Depreciation...
What would the depreciation expense be for the year with the following information: 2018: Plant assets:...
What would the depreciation expense be for the year with the following information: 2018: Plant assets: 325,000 Accumulated depreciation: (65,000) 2017: Plant assets: 250,000 Accumulated depreciation: (60,000) - Old plant assets costing $25,000 were sold for $10,000 cash when book value was $13,000.
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and 2017 follows. Prepare a cash flow statement using the indirect method. Properly title the statement. 2018 2017 Cash balance $113,500 $37,500 Net income 142,500 162,000 Depreciation Expense 42,000 35,000 Purchase of Plant Assets 135,000 125,000 Disposal of Plant Assets 40,000 50,000 Gain (Loss) on Disposal of Plant Assets (10,000) 5,000 Accounts Receivable Balance 64,500 58,000 Accounts Payable Balance 42,000 39,000 Interest Expense 8,000 6,000...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and 2017 follows. Prepare a cash flow statement using the indirect method. Properly title the statement. 2018 2017 Cash balance $113,500 $37,500 Net income 142,500 162,000 Depreciation Expense 42,000 35,000 Purchase of Plant Assets 135,000 125,000 Disposal of Plant Assets 40,000 50,000 Gain (Loss) on Disposal of Plant Assets (10,000) 5,000 Accounts Receivable Balance 64,500 58,000 Accounts Payable Balance 42,000 39,000 Interest Expense 8,000 6,000...
Selected financial information for the Microsoft Company for the fiscal years ended December 31, 2018 and...
Selected financial information for the Microsoft Company for the fiscal years ended December 31, 2018 and 2017 follows. Prepare a cash flow statement using the indirect method. Properly title the statement. 2018 2017 Cash balance $113,500 $37,500 Net income 142,500 162,000 Depreciation Expense 42,000 35,000 Purchase of Plant Assets 135,000 125,000 Disposal of Plant Assets 40,000 50,000 Gain (Loss) on Disposal of Plant Assets (10,000) 5,000 Accounts Receivable Balance 64,500 58,000 Accounts Payable Balance 42,000 39,000 Interest Expense 8,000 6,000...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and...
Selected financial information for the Adelphi Company for the fiscal years ended December 31, 2018 and 2017 follows. Prepare a cash flow statement using the indirect method. Properly title the statement. 2018 2017 Cash balance $113,500 $37,500 Net income 142,500 162,000 Depreciation Expense 42,000 35,000 Purchase of Plant Assets 135,000 125,000 Disposal of Plant Assets 40,000 50,000 Gain (Loss) on Disposal of Plant Assets (10,000) 5,000 Accounts Receivable Balance 64,500 58,000 Accounts Payable Balance 42,000 39,000 Interest Expense 8,000 6,000...
The 2017 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2017 Sales $ 390,000...
The 2017 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2017 Sales $ 390,000 Costs 245,000 EBIT $ 145,000 Interest expense 29,000 Taxable income $ 116,000 Taxes (at 35%) 40,600 Net income $ 75,400 Dividends $ 30,160 Addition to retained earnings 45,240    BALANCE SHEET, YEAR-END, 2017 Assets Liabilities Current assets Current liabilities Cash $ 8,000 Accounts payable $ 15,000 Accounts receivable 13,000 Total current liabilities $ 15,000 Inventories 29,000 Long-term debt 290,000 Total current assets $ 50,000...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT