Financial Analysis: Using ratios and data, prepare an income statement, balance sheet
Not what you're looking for?
Financial reports for 20X3:
Stock price $18.37
Inventory balance $300000
Expenses(excluding OGS) $1120000
Shares outstanding 290000
Average issue price of shares $5.00
Gross margin 40%
Interest rate 8%
TIE ratio 8
Inventory turnover 12X
Current ratio 1.5
Quick ratio .75
Fixed asset turnover 1.5
Q.
Complete the following abbreviated financial statements and calculate per share ratios indicated. (Hint: Start by subtracting the formula for the quick ratio from that for the current ratio and equating that to the numerical difference.)
Income Statement
Revenue
COGS
GM
Expense
EBIT
Interest
EBT
Tax
EAT
Balance Sheet
Current assets
Fixed assets
Total assets
Current liabilities
Long-term debt
Equity:
Paid-in capital(Common stock + Paid-in excess)
Retained earnings
Total equity
Total liabilities & equity
Ratios
Book value per share
Market value per share
Purchase this Solution
Solution Summary
With good explanations and calculations, the problem is solved.
Solution Preview
See attached file.
Computations:
Inventory= Current Ratio- Quick Ratio
300000= 1.25-.75
Numerical difference for .5 = 300000
For Current Assets =1.25= 300000*1.25/.5
$750,000.00
For Current Liabilities=.75= 300000*.75/.5
$450,000.00
Cost of Goods Sold= Inventory * Inventory turnover
= 12* ...
Purchase this Solution
Free BrainMass Quizzes
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Introduction to Finance
This quiz test introductory finance topics.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)