Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Aircraft Finance Strategies For Managing Capital Costs In A Turbulent Industry

Authors: Bijan Vasigh, Reza Taleghani, Darryl Jenkins

1st Edition

1604270713, 9781604270716

More Books

Students also viewed these Finance questions

Question

3. Use personal best goals, not between-student competition.

Answered: 1 week ago

Question

Select the primary colors from the following

Answered: 1 week ago

Question

What problem(s) does this public have related to this issue?

Answered: 1 week ago

Question

Who is your key public?

Answered: 1 week ago