Excel Assignment (Financial Statements) This is an individual assignment, not a team assignment. In order to complete this assignment, you must download the W02 Excel Model template, complete the assignment using the template (fill it out), and turn in a single Excel file (with your name as part of the filename) that includes all three of the following models (found under separate tabs (worksheets) in the template. Keep them on separate sheets...(Just fill out the template. Don't change the format or the order of the calculations. Keep all items within their original cell addresses): Income Statement and Balance Sheet (Separate Worksheets/Tabs) Create an Income Statement and Balance Sheet that are linked to each other. Note that on the template, they are found under separate tabs. Keep it this way. Please account for the following: [Note: For input fields, enter the values given here. For calculation fields, YOU set up the spreadsheet to complete the correct calculation] Revenue $100,000 (input field...put $100,000 as the value) COGS 50% of revenue Taxes 35% rate Sales/Gen/Admin Expense $10,000 (input field...put $10,000 as the value) Dividends 50% of Net Income Interest Expense 12% of Long-Term Debt (from Balance Sheet) Depreciation 20% of Net Fixed Assets