Cash Flows and Financial Statements at Sunset Boards

  1. Review the attached powerpoint for knowledge
  2. Download the Excel file attached
  3. In an Excel document, prepare the following financial statements for the mini-case “Cash Flows and Financial Statements at Sunset Boards, Inc.” from the Assignment 1.6 Worksheet file:
    1. Income Statement for 2018 and 2019
    2. Balance Sheet for 2018 and 2019
  4. In the provided Excel document, also calculate:
    1. the Operating Cash Flow for each year
    2. the Cash Flow from Assets for 2019
    3. the Cash Flow to Creditors for 2019
    4. the Cash Flow to Stockholders for 2019
  5. Tad Marks, the company’s founder, is considering expanding the business, which will require a substantial investment.
    1. Evaluate the financial statements you have developed and Sunset Board’s cash flow.
    2. In your Excel document or a separate Word document, write a paragraph explaining whether you feel expansion would be a wise choice and why.