Question

MINICASE 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, tax returns, and other records, Christina has assembled the is in charge of the design and sale of the surfboards, but his following information: background is in surfing. not business. As a result, the compa- nys financial records are not well maintained. After rooting through old bank statements, sales receipts, 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 Cost of goods sold only for its own store, the investors havent required detailed Cash financial statements from Tad. But thanks to word of mouth Depreciation among professional surfers, sales have picked up recently, and Interest expense Tad is considering a major expansion. His plans include open- ing another surfboard store in Hawaii, as well as supplying his sticks (surfer lingo for boards) to other sellers. 2017 2018 $322,742 55,725 81,559 17,980 65,610 $255,605 36,884 72,158 15,687 50.268 26,186 318,345 501,441 26,136 29.712 160,689 50,318 Selling and administrative Accounts payable Net fixed assets Tads expansion plans require a significant investment, which he plans to finance with a combination of additional Sales funds from outsiders plus some money borrowed from banks. Accounts receivable Naturally, the new investors and creditors require more orga Notes payable nized and detailed financial statements than Tad has previously 387.855 611,224 33,901 32,441 175,340 67.674 19,500 Long-term debt prepared. At the urging of his investors. Tad has hired finan nventr cial analyst Christina Wolfe to evaluate the performance of the company over the past year New equity
48 PART1 Overview of Corporate Finance QUESTIONS 1. How would you describe Sunset Boardss cash fl Sunset Boards currently pays out 40 percent of net income It has a 21 percent tax rate. You are Christinas assistant, and she has asked you to prepare the following: I. An income statement for 2017 and 2018. 2. A balance sheet for 2017 and 2018. 3. Operating cash flow for each year. 2018? Write a brief discussion. 2. In light of your discussion in the previous question, what do you think about Tads expansion plans? 4. Cash flow from assets for 2018. 5. Cash flow to creditors for 2018. 6. Cash flow to stockholders for 2018.

Please answer all questions from 1-6
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins s Cut ta copy ▼ Σ AutoSum ー E ゴWrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Font Alignment Number Styles Cells Edting CH CJ CK CN ca CR CS sunset ANS 1 INCOME STATEMENT boards 2018 501441 611224 255605 322742 50268 65610 72158 81559 123410 141313 1568717980 107723 123333 22622 25900 85101 97433 34040 38973 51061 58460 2017 SALES COGS S & A EXPENSES DEPRECIATION EBIT INTEREST EBT TAX NET INCOME DIVIDEND RETAINED EARNINGS LESS LESS LESS LESS 10 12 13 14 15 16 17 18 19 1 | | OCF CASH FLOW STATW ARM, MSI.confidenceINDEX / CURRENCY , LOAN (CROSS OVER . HEDGING MONEY MARKET / GM HPR AM . TAX GROWTH SUST (PREF AND DIV POLICY . 「 01:59 22-01-2019 1 2 3 4|5|6 7 8 9Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy ▼ в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard CV17 CP 1 ANS 2 Alignment Number Cells ca CR CS CT CU CX CY cz DA DB DC DE BALANCE SHEET 2018 36884 55725 26136 33901 50318 67674 2017 2018 26186 44318 29712 32441 2017 CASH ACCOUNTS RECEIVABLE INVENTORY ACCOUNTS PAYABLE NOTES PAYABLE 4 6 TOTAL CURRENT ASSETS 113338 157300 TOTAL CURRENT LIABILITIES 55898 76759 9 NET FIXED ASSETS 318345 387855 LONG TERM DEBT 160689 175340 10 EQUITY 215096 293056 (215096+ 19500 58460) 12 13 14 15 16 17 18 19 1 | | OCF CASH FLOW STATW TOTAL ASSETS 431683 545155 TOTAL LIABILITIES & EQUITY 431683 545155 ARM, MSi.confidenceINDEX / CURRENCY , LOAN (CROSS OVER HEDGING MONEY MARKET / GM HPR AM . TAX GROWTH SUST (PREF AND DIV POLICY . 「 . 22-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Alignment Number Cells CJ16 CK CL CM CN CO CP CQ CR CS CT CU CV CW 16 17 18 19 ANS3 20 21 OPERATING CASH FLOW EBIT DEPRECIATION TAXES 2017 123410 72158 22622 172946 2018 141313 81559 25900 196972 ADD LESS 23 24 25 26 27 28 29 30 31 32 ANS4 CASHFLOW FROM ASSETS OPERATING CASHFLOW - CHANGES IN WORKING CAPITAL -NET CAPITAL SPENDING WORKING CAPITAL = CURRENT ASSETS-CURRENT LIABILITIES WORKING CAPITAL (2017)- WORKING CAPITAL (2018)- 113338 157300- 55898 76759 57440 80541 NET CAPITAL SPENDING CHANGE IN NET FIXED ASSETS DEPRECIATION (387855 - 318345) 81559- 151069 CASHFLOW FROM ASSETS(2018)-196972. (80541-57440)-151069 22802 34 1 | | OCF CASH FLOW STATW ARM, MSI.confidenceINDEX / CURRENCY , LOAN (CROSS OVER . HEDGING MONEY MARKET / GM HPR AM . TAX GROWTH SUST (PREF AND DIV POLICY . 「 02:01 22-01-2019Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy Σ AutoSum ー E ゴWrap Text Sort &Find & Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Format Painter Cells Edting Number Alignment Clipboard CJ59 CJ CP CQ CR CS CT CU CV CL CM CN CO CK 41 42 43 45 46 ANS 5 47 48 49 ANS6 50 51 52 53 54 CASH FLOW TO CREDITORS-INTEREST PAID-NET NEW BORROWINGS CASH FLOW TO CREDITORS 17980 (175340 160689) 3329 38973 - 19500 19473 CASHFLOW TO STOCK HOLDERS (DIVIDEND PAID NET NEW EQUITY) 56 57 58 59 GROWTH SUST (PREF AND DIV POLICY . 「 ARM, MSI.confidenceINDEX / CURRENCY , LOAN (CROSS OVER . HEDGING MONEY MARKET / GM HPR AM . TAX | OCF CASH FLO N STATW 02:01 22-01-2019

Add a comment
Know the answer?
Add Answer to:
Please answer all questions from 1-6 MINICASE Cash Flows and Financial Statements at Sunset Boards, Inc....
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • MINICASE Cash Flows and Financial Statements at Sunset Boards, Inc. Sunset Boards is a small company...

    MINICASE 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 compa- ny's financial records are not well maintained. After rooting through old bank statements, sales receipts, tax returns, and other records, Christina has assembled the following information:...

  • Please answer question 1 and 2 MINICASE Cash Flows and Financial Statements at Sunset Boards, Inc....

    Please answer question 1 and 2 MINICASE 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 compa- ny's financial records are not well maintained. After rooting through old bank statements, sales receipts returns, and other records, Christina...

  • Please answer in excel and show the formulas. MINICASE Cash Flows and Financial Statements at Sunset...

    Please answer in excel and show the formulas. MINICASE 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, tax returns, and other records, Christina has assembled the is in charge of the design and sale of the surfboards, but his following information: background is in surfing, not business. As a result, the compa- ny's financial records are not well maintained....

  • Please answer 4 , 5 and 6 and question 1 and 2 MINICASE Cash Flows and...

    Please answer 4 , 5 and 6 and question 1 and 2 MINICASE Cash Flows and Financial Statements at Sunset Boards, Inc. company that manufactures and sells After rooting through old bank statements, sales receipts other records, Christina has assembled the 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 compa- ny's financial records are not...

  • Cash Flow and Financial Statements at Sunset Boards, Inc. Sunset Boards is a small company that...

    Cash Flow 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 investment in Sunset Boards was provided by Tad and his friends and family. Because the initial investment was relatively...

  • Cash Flows and Financial Statements at Sunset Boards, Inc. Sunset Boards currently pays out 50 percent...

    Cash Flows and Financial Statements at Sunset Boards, Inc. Sunset Boards currently pays out 50 percent of net income as dividends to Tad and the other original investors, and it has a 20 percent tax rate. You are Christina's assistant, and she has asked you to prepare the following: 1. An income statement for 2010 and 2011. 2. A balance sheet for 2010 and 2011. 3. Operating cash flow for each year. 4. Cash flow from assets for 2011. 5....

  • Cash Flows and Financial Statements at Sunset Boards, Inc. Sunset Boards is a small company that...

    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 investment in Sunset Boards was provided by Tad and his friends and family. Because the initial investment was relatively...

  • Please answer questions 1-6 CHAPTER CASE CASH FLOWS AND FINANCIAL STATEMENTS AT SUNSET BOARDS, INC. 2013...

    Please answer questions 1-6 CHAPTER CASE CASH FLOWS AND FINANCIAL STATEMENTS AT SUNSET BOARDS, INC. 2013 2014 $169,969 24,524 47,980 10,442 33,425 $214.607 26,056 54,230 11,954 43,626 Cost of goods sold Cash Depreciation Interest expense Selling & administrative expenses Accounts payable Net fixed assets Sales Accounts receivable Notes payable Long-term debt Inventory New equity 43,344 211,680 333,426 17,378 19,757 106,848 36,570 0 48,090 264,021 406,427 22,542 21,571 119.976 50,185 20,160 Cunset Boards is a small company that manufac- tures and...

  • Cash Flows and Financial Statements at Sunset Boards, Inc. unset Boards is a small company that m...

    please complete #4-6 cash flow statements in a table format for the above case Cash Flows and Financial Statements at Sunset Boards, Inc. unset 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...

  • CHAPTER CASE CASH FLOWS AND FINANCIAL STATEMENTS AT SUNSET BOARDS, INC. Sunset Boards is a small...

    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 investment in Sunset Boards was provided by Tad and his friends and family. Because the initial investment...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT