Chapter Case: Cash Flows and Financial Statements at Sunset Boards, Inc. Sunset
ID: 2737525 • Letter: C
Question
Chapter Case: Cash Flows and Financial Statements at Sunset Boards, Inc.
Sunset Boards is a small company that manufactures and sells surfboards in Malibu. Tad Marks, the founder of the company, is in charge of the design and sale of the surfboards, but his background is in surfing, not business. As a result, the company's financial records are not well maintained.
The initial invesment in Sunset Boards was provided by Tad and his friends and family. Because the initial investment was relatively small, and the company has made surfboards only for its own store, the investors haven't required deteiled financila statments for Tad. But thanks to word of mouth among professional surfers, sales have picked up recently, and Tad is considering a major expansion. His plans include opening another surfboard stoer in Hawaii, as well as supplying his "sticks" (surfer lingo for boards) to other sellers.
Tad's expansion plans require a significant investment, which he plans to finance with a combination of additional funds from outsiders plus some money borrowed from banks. Naturally, the new investors and creditors require more organized and detailed financial statements that Tad has previously prepared. At the urging of his investors, Tad has hired financial analyst Paula Wolfe to evaluate the performance of the company over the past year.
After rooting through old bank statments, sales receipts, tax returns, other records, Paula has assembled the following information:
2013
2014
141,641
178,839
Cash
20,437
30,880
39,983
45,192
8,702
9,962
Selling & Administrative Expenses
27,854
36,355
36,120
40,908
176,400
214,184
277,855
338,688
14,482
18,785
16,464
17,976
89,040
102,480
30,475
41,821
0
16,800
Sunset Boards currently pays out 50% of net income as dividends to Tad and the other original investors, and has a 20% tax rate. You are Paula's assistant, and she has asked you to prepare the financial statments and cash flow calculations.
DUE:
Prepare the following
An income statement for 2013 and 2014.
A balance sheet for 2013 and 2014.
Operating cash flow for 2013 and 2014.
Cash flow from assets for 2014.
Cash flow from creditors for 2014.
Cash flow from stockholders for 2014.
Answer the following:
1. How would you describe Sunset Boards' cash flows for 2010? Write a brief discussion.
2. In light of your discussion in the previous question, what do you think about Tad's expansion plans?
2013
2014
Cost of goods sold141,641
178,839
Cash
20,437
30,880
Depreciation39,983
45,192
Interest Expense8,702
9,962
Selling & Administrative Expenses
27,854
36,355
Accounts Payable36,120
40,908
Net fixed assets176,400
214,184
Sales277,855
338,688
Accounts Receivable14,482
18,785
Notes Payable16,464
17,976
Long-term debt89,040
102,480
Inventory30,475
41,821
New Equity0
16,800
Explanation / Answer
Answer:
Cash flow from assets for 2014:
NWC2013 = CA – CL = $65394 - $52584 = $12810
NWC2014 = $91486 - $58884= $32602
CFFA2014= OCF –NWC-NCS
= OCF – (NWC2014 – NWC2013) – ((NFA2014+D2014)-(NFA2013+D2013)
= $99864 – ($32602 - $12810) – (( $214184 + $45,192 ) – ( $176400+ $39983))
= $99864-19792-(259376-216383)
=37079
Cash flow from creditors for 2014:
= (Long-term) interest expense2014 = ($9962)
Cash flow from stockholders for 2014:
= D2014 = 50% of NI2014 = 0.5 * $54672 = ($27336)
Answer:1 Based on the Statement of Cash Flows below, Sunset Boards barely had a positive cash flow in 2014, owing to minimal cash flow from financing activities . In fact, had there not been an additional contribution of $16800 in capital, the NCF would have been negative. Sunset would have been forced to either seek more leverage, or to increase its plowback ratio (and decrease dividends) – which would probably be recommended, since 1) a 50% dividend ratio is pretty incredible, and 2) a small, private group of investors would probably be more forgiving than a global market.
Answer:2 As mentioned above, Tad’s negative cash flow from investing activities was barely covered by his operating cash flow and financing cash flow. So as expected, he will need significant outside funds to finance the operation.
Income Statements Particulars 2013 2014 Sales 277855 338688 Less: Cost of goods sold 141641 178839 Gross margin 136214 159849 Less: expenses Depreciation 39983 45192 Interest expense 8702 9962 Selling and administrative expenses 27854 36355 earning before tax 59675 68340 Less: tax @20% 11935 13668 Net income 47740 54672 Balance Sheets as of December 31, 2013 and 2014 Particulars 2013 2014 Assets: Current assets: Cash 20437 30880 Accounts receivable 14482 18785 Inventory 30475 41821 Total current assets 65394 91486 Fixed assets: Net fixed assets 176400 214184 Total Assets 241794 305670 Liabilities: Current liabilities: Accounts payable 36120 40908 Notes payable 16464 17976 Total current liabilities 52584 58884 Long term debt 89040 102480 Total liabilities 141624 161364 Equity: Owner equity 76300 76300 Contributed capital 16800 Retained earnings 23870 51206 Total equity 100170 144306 Total liabilities and equity 241794 305670 Particulars 2013 2014 Operating cash flow: Net income 47740 54672 Add: Dep 39983 45192 Operating cash flow 87723 99864Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.