Wk 4 – Summative Assessment: Financial Performance Calculations Index Workbook Index Financial Calculations Financial Performance Summary Fina

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Wk 4 – Summative Assessment: Financial Performance Calculations Index

Workbook Index

Financial Calculations

Financial Performance Summary

Financial Calculations

Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60.

Table 1: Hillside, Inc. Balance Sheet ($ in Millions)

ASSETS LIABILITIES

Cash & Marketable Securities 449.90 Accounts Payable 1,611.20

Accounts Receivable 954.80 Salaries Payable 225.20

Inventories 3,645.20 Other Current Liabilities 1,118.80

Other Current Assets 116.60 Total Current Liabilities 2,955.20

Total Current Assets 5,165.27

Other Liabilities 693.40

Machinery & Equipment 1,688.90

Land 1,129.70 Total Liabilities 3,648.60

Buildings 2,348.40

Depreciation (575.60) SHAREHOLDER’S EQUITY

Property, Plant & Equip. – Net 4,591.40 Common Stock 828.50

Other Long Term Assets 120.90 Retained Earnings 5,401.70

Total Long-Term Assets 4,712.30 Total Shareholder’s Equity 6,230.20

Total Assets 9,877.57 Total Liabilities & Equity 9,878.80

Table 2: Hillside, Inc. Income Statement ($ in Millions)

Revenue 28,681.10

Cost Of Goods Sold 20,768.80

Gross Profit 7,912.30

Operating Expenses:

Selling, General & Admin. 5,980.80

Depreciation 307.30

Operating income 1,624.20

Interest – 0

Other Expense (Income) (13.10)

Income Before Taxes 1,637.30

Income Taxes 618.10

Net Income 1,019.20

Number of Common Stock

Shares Outstanding 1,032,271

Table 3: Financial Performance Calculations

Liquidity Ratios No data Answers

Current Ratio (times) No data Input the current ratio.

Quick Ratio (times) No data Input the quick ratio.

Average Payment Period (days) No data Input the average payment period.

Asset Management Ratios No data

Total Asset Turnover (times) No data Input the total asset turnover.

Average Collection Period (days) No data Input the average collection period.

Inventory Turnover (times) No data Input the inventory turnover.

Financial Leverage Ratios No data

Total Debt to Total Assets No data Input the debt to total assets.

Equity Multiplier (times) No data Input the equity multiplier.

Profitability Ratios No data

Operating Profit Margin No data Input the operating profit margin.

Net Profit Margin No data Input the net profit margin.

Return on Total Assets No data Input the return on total assets.

Return on Equity No data Input the return on equity.

Earnings per Share No data Input the earnings per share.

&”Arial,Regular”&10 Wk 4 Financial Performance Worksheet
HCS/385 v4
Page &P of &N

&”Arial,Regular”&10HCS/385 v4

&”Arial,Regular”&8Copyright© 2020 by University of Phoenix. All rights reserved.

&”Arial,Regular”&8Copyright© 2020 by University of Phoenix. All rights reserved.

Financial Performance Summary

Financial Performance Summary: Provide a brief summary of your financial analysis from the Financial Calculations.

Insert your summary.

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality