Question

In: Finance

Consider the following 2017 information for your company, which began operations on January 1, 2017. (So...

Consider the following 2017 information for your company, which began operations on January 1, 2017. (So it did not exist in 2016, and therefore had no balance sheet.)

- Number of units sold in 2017: 1,000

- Price per unit: $1,000

- Cost of goods sold for each unit: 65% of the price

- Other expenses (except depreciation): $50,000

- On January 1, the company bought $500,000 of fixed assets. You assume these assets will last 5 years

and have no salvage value (i.e., after 5 years you will need to scrap them and will not be able to sell

them for any money). You will depreciate these assets linearly over the five years.

- On January 1, the company received $200,000 as investment from its shareholders.

- On January 1, the company borrowed $400,000 from the bank at a rate of 5.0%. At the end of the

year, the company will pay the interest due on that amount only. (In other words, it will not pay

down the loan, since this is not an amortizing loan.)

- The tax rate is 20% and the company will pay its taxes at the end of the year.

- The company paid the owners $25,000 in dividends at the end of the year.

Using the above information, answer the questions below.

a. Create an income statement for the company. Remember to consider interest expense and depreciation. (5 points)

b. Calculate the operating cash flow (EBIT – Tax + Depreciation). (2 points)

c. Calculate the cash flow to creditors/debt. (2 points)

d. Calculate the cash flow to stockholders/equity. (2 points)

e. Calculate the cash flow from assets (CFFA). (2 points)

f. Can you calculate the changes in net working capital? If so, how much was it? (1 point)

g. How would the income statement change if the fixed assets were depreciated over 10 years instead of 5 years? Explain/calculate. (3 points)

h. If the fixed assets were depreciated over 10 years instead of 5 years as discussed in question 7 above, how would it affect the operating cash flow of the company? Explain/calculate. (3 points)

Solutions

Expert Solution

The income statement is as below:

Note the following:

(i). Sales revenue = 1000 units sold at $1000 each hence 1000 * 1000 = 1000000

(ii). Cost of good sold is given as 65% of sales price

(iii). Depreciation is given as straight line for 5 years with no salvage value hence (500000/5) = $ 100000 per year.

(iv). The shareholder investment and borrowing do not impact P&L; the annual interest cost at 5% has been accounted for

(v). Dividend is distributed after taxes and all other expenses, hence shown accordingly

b. operating cash flows = EBIT - Tax + Depreciation = 200000-36000+100000 = $ 264,000

c. Cash flow to creditors will be = Interest paid - net new borrowings; since this is the first year of operations, all the borrowings are net new borrowing. Thus cash flow to creditors = 20000 - 400000 = - $ 380,000

d. Cash flow to equity stock holders = Dividend paid - new equity issued = 25000 - 200000 = - $ 175,000

e. Cash flow from Assets = Operating cash flow - capital spending - change in net working capital

Operating cash flow we have from above at $264000 and capital spending is given as $ 500000 but we do not have net working capital number. Hence we will use another formula which states that cash flow from assets is sum of cash flow to creditors and cash flow to equity stockholders. Hence

cash flow from assets = -380000 - 175000 = - $ 555,000

f. From above we can estimate the change in net working capital = cash flow from assets - operating cash flow - capital spending hence change in net working capital = -555000 - 264000 - (-500000) = - $ 209000

g. If the fixed assets were depreciated for 10 year period then on straight line basis the annual depreciation will decrease from $100000 to $ 50000 only and P&L will look like below:

As we see the Profit after tax has increased by (50000 * (1-20%)) - 20% is the tax rate.

h. Operating cash flows = EBIT + Depreciation - Taxes = 250000 + 50000 - 46000 = $ 254000

hence we see that the operating cash flows have decreased by $ 10000 (which is the increase in the taxes) due the above change.


Related Solutions

Cambi Company began operations on January 1, 2016. In the second quarter of 2017, it adopted...
Cambi Company began operations on January 1, 2016. In the second quarter of 2017, it adopted the FIFO method of inventory valuation. In the past, it used the LIFO method. The company’s interim income statements as originally reported under the LIFO method follow: 2016 2017 1stQ 2ndQ 3rdQ 4thQ 1stQ Sales $ 22,000 $ 24,000 $ 26,000 $ 28,000 $ 30,000 Cost of goods sold (LIFO) 5,200 6,200 7,000 8,200 9,700 Operating expenses 3,200 3,400 3,800 4,200 4,400 Income before...
Cambi Company began operations on January 1, 2016. In the second quarter of 2017, it adopted...
Cambi Company began operations on January 1, 2016. In the second quarter of 2017, it adopted the FIFO method of inventory valuation. In the past, it used the LIFO method. The company’s interim income statements as originally reported under the LIFO method follow: 2016 2017 1stQ 2ndQ 3rdQ 4thQ 1stQ Sales $ 24,000 $ 26,000 $ 28,000 $ 30,000 $ 32,000 Cost of goods sold (LIFO) 5,400 6,400 7,200 8,400 9,900 Operating expenses 3,400 3,600 4,000 4,400 4,600 Income before...
Sims Company, a manufacturer of tablet computers, began operations on January 1, 2017. Its cost and...
Sims Company, a manufacturer of tablet computers, began operations on January 1, 2017. Its cost and sales information for this year follows. Manufacturing costs Direct materials $ 35 per unit Direct labor $ 55 per unit Overhead costs for the year Variable overhead $ 2,100,000 Fixed overhead $ 8,400,000 Selling and administrative costs for the year Variable $ 800,000 Fixed $ 4,750,000 Production and sales for the year Units produced 105,000 units Units sold 75,000 units Sales price per unit...
Blago Wholesale Company began operations on January 1, 2017, and uses the average cost method in...
Blago Wholesale Company began operations on January 1, 2017, and uses the average cost method in costing its inventory. Management is contemplating a change to the FIFO method in 2018 and is interested in determining how such a change will affect net income. Accordingly, the following information has been developed: 2017 2018 Final inventory: Average cost $ 150,000 $ 255,000 FIFO 160,000 270,000 Condensed income statements for Blago Wholesale appear below: 2017 2018 Sales $ 1,000,000 $ 1,200,000 Cost of...
Sims Company, a manufacturer of tablet computers, began operations on January 1, 2017. Its cost and...
Sims Company, a manufacturer of tablet computers, began operations on January 1, 2017. Its cost and sales information for this year follows. Manufacturing costs Direct materials $ 30 per unit Direct labor $ 50 per unit Overhead costs for the year Variable overhead $ 2,000,000 Fixed overhead $ 8,000,000 Selling and administrative costs for the year Variable $ 775,000 Fixed $ 4,250,000 Production and sales for the year Units produced 100,000 units Units sold 70,000 units Sales price per unit...
Sims Company, a manufacturer of tablet computers, began operations on January 1, 2017. Its cost and...
Sims Company, a manufacturer of tablet computers, began operations on January 1, 2017. Its cost and sales information for this year follows. Manufacturing costs Direct materials $ 40 per unit Direct labor $ 60 per unit Overhead costs for the year Variable overhead $ 4,400,000 Fixed overhead $ 6,600,000 Selling and administrative costs for the year Variable $ 750,000 Fixed $ 4,250,000 Production and sales for the year Units produced 110,000 units Units sold 80,000 units Sales price per unit...
Selk Steel Co., which began operations on January 4, 2017, had the following subsequent transactions and...
Selk Steel Co., which began operations on January 4, 2017, had the following subsequent transactions and events in its long-term investments. 2017 Jan. 5 Selk purchased 80,000 shares (30% of total) of Kildaire's common stock for $1,200,000. Oct. 23 Kildaire declared and paid a cash dividend of $4.80 per share. Dec. 31 Kildaire's net income for 2017 is $1,324,000, and the fair value of its stock at December 31 is $22.00 per share. 2018 Oct. 15 Kildaire declared and paid...
Selk Steel Co., which began operations on January 4, 2017, had the following subsequent transactions and...
Selk Steel Co., which began operations on January 4, 2017, had the following subsequent transactions and events in its long-term investments. 2017 Jan. 5 Selk purchased 80,000 shares (30% of total) of Kildaire's common stock for $1,200,000. Oct. 23 Kildaire declared and paid a cash dividend of $4.80 per share. Dec. 31 Kildaire's net income for 2017 is $1,324,000, and the fair value of its stock at December 31 is $22.00 per share. 2018 Oct. 15 Kildaire declared and paid...
Selk Steel Co., which began operations on January 4, 2017, had the following subsequent transactions and...
Selk Steel Co., which began operations on January 4, 2017, had the following subsequent transactions and events in its long-term investments.     2017 Jan. 5 Selk purchased 60,000 shares (20% of total) of Kildaire's common stock for $1,560,000. Oct. 23 Kildaire declared and paid a cash dividend of $3.20 per share. Dec. 31 Kildaire’s net income for 2017 is $1,164,000, and the fair value of its stock at December 31 is $30.00 per share. 2018 Oct. 15 Kildaire declared and...
Geyser Company began operations in 2017 and has provided the following information. Pretax financial income for...
Geyser Company began operations in 2017 and has provided the following information. Pretax financial income for 2017 is $200,000. The tax rate enacted for 2017 and future years is 40%. Differences between the 2017 income statement and tax return are listed below: Warranty expense accrued for financial reporting purposes amounts to $10,000. Warranty deductions per the tax return amount to $4,000. Gross profit on construction contracts using the percentage-of-completion method for book purposes amounts to $184,000. Gross profit on construction...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT