1 and 2 both to deal with finacial accouting.

. Financial Management Excel Assignment 41 1. During 2020, Starline Corporation had Revenue of $623,000 Cost of Goods Sold of $250,000 Operating expenses of $68,000 Interest expense of $4.000 Depreciation Expense of $13,000 During the year Starline Corporation paid 60% of net income in dividends 21% in corporate taxes a Prepare a multi-step income statement on Sheet 1 of your spreadsheet. Rename Sheet1 "Income Statement" Every calculation needs a working Excel formula". Include the dividend end additions to Retained Earnings below the income statement . b Calculate Starline's Operating Cash Flow beneath the Income Statement. Be sure to label it. 2. The following data refers to the 2020 year-end account balances for Starline. However, the Retained Earnings balance is as of 12/31/2019. The accounts are listed in alphabetical order $ Accounts Payable 25,000 Accounts Receivable 16,000 Accumulated Depreciation 175,000 Cash 44.000 Common Stock 120,000 Fixed Assets (gros) 390,000 Inventory 135,000 Long Term Debt 111,000 Retained Earnings (2019) 52.992 Salary Payable 11,000 a Prepare a classified Balance Sheet for Starline on Sheet 2 of your spreadsheet. Rename Sheet 2 "Balance Sheet" Include working Excel formulas for all calculations 6. Calculate Starline's Net Working Capital beneath the balance sheet. Be sure to label it Working Excel Formulas must contain cell references and not numeric values Working Excel formula example: "Al+A2 NOT a Working Excel formula =500-200 You will know you have a working Excel formula if you were to change one number in your spreadsheet and all the formulas automatically re-calculate for you. NO FORMULAS=NO GRADE!!!!! 30 30 Grading Rubric Malti Step Income Statement layout --heading, titles, order, correct accounts and correct calculations Classified Balance Sheet layout heading, titles, order, current vs. noncurrent account differentsation, correct calculations Net Working Capital Calculation Operating Cash Flow Calculation Inclusion of Working Excel Formulas for all calculations 10 10 10