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: Problems 1, 6 and 7
- Income Statement: Problems 2, 3, and 4
- 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.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlinesOrder Paper Now
- 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:
- Income Statement for 2018 and 2019
- Balance Sheet for 2018 and 2019
In the provided Excel document, also calculate:
- the Operating Cash Flow for each year
- the Cash Flow from Assets for 2019
- the Cash Flow to Creditors for 2019
- the Cash Flow to Stockholders for 2019
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.
- In your Excel document or a separate Word document, write a paragraph explaining whether you feel expansion would be a wise choice and why.