Cash Flows and Financial Statements at Sunset Boards, Inc. Already got answered but not well answered. Please post excel sheet as well
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 investment 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 detailed financial statements from 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 store 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 than Tad has previously prepared. At the urging of his investors, Tad has hired financial analyst Jameson Reid to evaluate the performance of the company over the past year. After rooting through old bank statements, sales receipts, tax returns, and other records, Jameson has assembled the following information: 2018 2019 $ $ 238,567 31,546 62,145 285,890 33,686 72,573 12,980 16,389 43,189 58,528 Cost of goods sold Cash Depreciation Interest expense Selling & Administrative Accounts payable Fixed assets Sales Accounts receivable Notes payable Long-term debt Inventory New equity 56,978 278,675 430,455 64,321 349,765 537,568 23,987 30,867 25,678 29,765 140,567 47,654 159,765 65,435 26,109 Sunset Boards currently pays out 50 percent of net income as dividends to Tad and the other original investors and has a 21 percent tax rate. You are Jameson's assistant, and he has asked you to prepare the following: 1. An income statement for 2018 and 2019. 2. A balance sheet for 2018 and 2019. 3. Operating cash flow for each year. 4. Cash flow from assets for 2019. 5. Cash flow to creditors for 2019. 6. Cash flow to stockholders for 2019. QUESTIONS 1. How would you describe Sunset Boards's cash flows for 2019? Write a brief discussion. 2. In light of your discussion in the previous question, what do you think about Tad's expansion plans? 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 investment 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 detailed financial statements from 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 store 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 than Tad has previously prepared. At the urging of his investors, Tad has hired financial analyst Jameson Reid to evaluate the performance of the company over the past year. After rooting through old bank statements, sales receipts, tax returns, and other records, Jameson has assembled the following information: 2018 2019 $ $ 238,567 31,546 62,145 285,890 33,686 72,573 12,980 16,389 43,189 58,528 Cost of goods sold Cash Depreciation Interest expense Selling & Administrative Accounts payable Fixed assets Sales Accounts receivable Notes payable Long-term debt Inventory New equity 56,978 278,675 430,455 64,321 349,765 537,568 23,987 30,867 25,678 29,765 140,567 47,654 159,765 65,435 26,109 Sunset Boards currently pays out 50 percent of net income as dividends to Tad and the other original investors and has a 21 percent tax rate. You are Jameson's assistant, and he has asked you to prepare the following: 1. An income statement for 2018 and 2019. 2. A balance sheet for 2018 and 2019. 3. Operating cash flow for each year. 4. Cash flow from assets for 2019. 5. Cash flow to creditors for 2019. 6. Cash flow to stockholders for 2019. QUESTIONS 1. How would you describe Sunset Boards's cash flows for 2019? Write a brief discussion. 2. In light of your discussion in the previous question, what do you think about Tad's expansion plans
