Assignment:

Prepare an income statement and a balance sheet for this company using the information provided. Calculate $($and show your work in Excel using Excel formulas$)$:

Net Profit Margin $(\%)$

Total Net Profit $($Not $\%-$ in $$$)$

Inventory to Net Working Capital

Total Debt to Assets

Quick Ratio

Total Debt to Equity

Return on Equity

Average Receiveables Collection Period

Working Cap to Assets

Sales to Assets Ratio

The intent of this assignment is just basic accounting and financial statement construction. These will get more complicated over the course of the semester, but this one is just to ensure that everyone is on the same page. Pay close attention to the notes at the end of the assignment and the definitions posted to the blackboard site $($Ratio Definitions and Case Analysis$).$ You will only need each number on time. Check the syllabus for the due date!

Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below.

$\backslash$table$[[$Sales$,609952],[$Operating Costs,$414976],[$Deprrciation Expense,$10000],[$Interest Expense,$5000],[$Tax Expense,$29408],[$Cash$,2344],[$Receivables$,47330],[$Inventories$,76492],[$Fixed Assets, Net,$50000],[$Payables$,11000],[$Accrued Expenses,$10000],[$Long$-$Term Loan,$50000],[$Common Equity,$105166]]$