Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare an Excel Workbook with the following Financial Statements. -Income Statements -Prepare a Consolidated Balance Sheet -Prepare a Statement of Cash Flows using the Indirect
Prepare an Excel Workbook with the following Financial Statements.
-Income Statements
-Prepare a Consolidated Balance Sheet
-Prepare a Statement of Cash Flows using the Indirect Method.
CHAPTER CASE Cash Flows and Financial Statements at Sunset Boards, Inc. unset Boards is a small company that manufactures 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 pro- vided by Tad and his friends and family. Because the ini- tial 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 surf- ers, sales have picked up recently, and Tad is consider- ing a major expansion. His plans include opening another surfboard store in Hawaii, as well as supplying his "sticks" (surferlingo for boards) to other sellers. Tad's expansion plans require a significant invest- ment, which he plans to finance with a combination of additional funds from outsiders plus some money bor- rowed 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 com- pany over the past year. After rooting through old bank statements, sales re- ceipts, tax returns, and other records, Jameson has as- sembled the following information: 2018 2019 $224,359 $283,281 32,372 34,394 63,334 71,584 13.783 44,121 57,586 15,780 Cost of goods sold Cash Depreciation Interest expense Selling and administrative expenses Accounts payable Net fixed assets Sales Accounts receivable Notes payable Long-term debt Inventory New equity 57,220 279,419 440,122 22,939 26,079 141,040 48,272 0 63,479 348,508 536.483 29.755 28,474 158,368 66.244 27,157 Sunset Boards currently pays out 50 percent of net income as dividends to Tad and the other original inves- tors and has a 21 percent tax rate. You are Jameson's assistant, and he has asked you to prepare the followingStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started