For your assignment this week, you are going to build a simple Income statement, Balance Sheet, and cash flow statement for the business you have been considering in earlier weeks.

/in /by

Managing cash flow and pricing for profit on an Excel Spreadsheet
Course Objective: CO6 Apply techniques for managing cash flow and pricing for profit Prompt: For your assignment this week, you are going to build a simple Income statement, Balance Sheet, and cash flow statement for the business you have been considering in earlier weeks. This is not an exercise in business planning, it’s an exercise in thinking about the various elements that make up these three key financial statements every entrepreneur is required to understand. This assignment is formulated to get you a little more comfortable with how to read and interpret a basic income statement, a balance sheet, and a cash flow statement. If you have diligently completed all of the steps above, even if the numbers don’t make complete sense, you’ll do fine on this assignment. Instructions: Watch this 50 minute video lecture on financial statements https://youtu.be/ah0JNx8IYc0 Take screen shots for your notes of each of the financial statements. So, when the presenter starts talking about the Income statement, stop the presentation, make a screenshot (PRTSCR on keyboard) and copy and paste it to your first tab in an Excel workbook. Do this same procedure for all three financial statements using one Microsoft Excel workbook that you will submit. Put each statement on a separate tab and label the tabs accordingly. There is no template for this project, you are on your own to design a professional looking Income Statement, Balance Sheet, and Cash Flow Statement. Proforma numbers are needed and include appropriate sums, nets, totals, averages, etc. I will be checking that each form “foots” to the bottom of the form. and that each sheet works properly. Complete this process for all three statements, save the workbook and submit it. Grading Rubric See grading rubric for details on how the assignment will be evaluated. There are no templates for this week’s assignment, you will be submitting an excel spreadsheet file with three tabs; one tab for each of the assigned financial statements.