Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Add header Excel Assignment 1E (Financial Statements and Ratios) THIS IS AN INDIVIDUAL ASSIGNMENT, NOT a team assignment In order to complete this assignment, you
Add header Excel Assignment 1E (Financial Statements and Ratios) THIS IS AN INDIVIDUAL ASSIGNMENT, NOT a team assignment In order to complete this assignment, you must turn in a SINGLE Excel file (WITH your name) that includes the following (you may put them on separate worksheets or pages, but make sure that they are clearly labeled): E: Key Ratio Calculations 1. Create a single sheet that calculates the ratios listed below based on the financial statement 2. Please see Demo 1E for suggestions on how to complete this exercise (the ratios demo may not be exactly the same for this assignment. Please make sure to include the ratios listed HERE): a. Ratios: Current, Quick, Inventory Turnover, Average Collection Period, Fixed Assets Turnover, Total Asset Turnover, Debt Ratio, Debt to Equity, Times Interest Earned, Gross Profit Margin, Net Profit Margin, Return on Assets, Return on Equity Balance Sheet Assets Liabilities and Owners Equity Current Assets Current Liabilities Cash $ 20,000.00 Accounts Receivable 10,000.00 Accounts Payable $ 10,000.00 Inventory 20,000.00 Notes Payable 10,000.00 Total Current Assets 50,000.00 Total Current Liabilities $ 20,000.00 Long Term Debt 20,000.00 Fixed Assets Net Fixed Assets $ 85,000.00 Owners Equity Total Owners Equity $ 95,000.00 Total Assets $ 135,000.00 Total Liabilities and Owners Equity $ 135,000.00 Income Statement Revenue (all sales are credit) COGS Depreciation EBIT Interest expense EBT Taxes Net Income $ 100,000.00 45,000.00 15,000.00 40,000.00 5,000.00 35,000.00 10,000.00 $ 25,000.00 Number of shares outstanding 100,000.00 EPS $ 0.25
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started