Prepare Income statement

Instructions

  1. In an Excel document, prepare the following financial statements for the mini-case “Cash Flows and Financial Statements at Sunset Boards, Inc.” on pages 47 and 48 of the textbook:
    1. Income Statement for 2014 and 2015
    2. Balance Sheet for 2014 and 2015
  2. In the Excel document, also calculate:
    1. the Operating Cash Flow for each year
    2. the Cash Flow from Assets for 2015
    3. the Cash Flow to Creditors for 2015
    4. the Cash Flow to Stockholders for 2015
  1. Tad Marks, the company’s founder, is considering expanding the business, which will require a substantial investment. 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.