Please check the attachments for the problems before proceeding Using the Assignment Worksheet file from the Assignment 1.5 Worksheet file, complete all nine of the following problems: Balance Sheet

Please check the attachments for the problems before proceeding

• Using the Assignment Worksheet file from the Assignment 1.5 Worksheet file, complete all nine of the following problems:
  1. Balance Sheet: Problems 1, 6 and 7
  2. Income Statement: Problems 2, 3, and 4
  3. Cash Flow: Problems 5, 8, and 9
• Be sure your Excel spreadsheet is prepared in a professional manner, with answers clearly indicated and all your calculations shown.
  1. Full credit will not be given if your process for arriving at the answer is not displayed.

• 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
• 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
• 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.