excell ss & apple case questions Rey Writer

profilems12345
excel_sheet_of_case_sfa_template.xlsx
Home>Business & Finance homework help>Economics homework help>excell ss & apple case questions Rey Writer

Company Financial Analysis

Case Name Financial Analysis
(data in thousands [000s], excluding per share data and financial ratios)
FY 2009 FY 2008 FY 2007 FY 2006 FY 2005
Revenue
Cost of Revenue - 0 - 0 - 0 - 0 - 0
Gross Profit
Gross Profit Margin ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
EBIT
Income Tax
NOPAT (Net Operating Profit After Taxes) - 0 - 0 - 0 - 0 - 0
Net Income (includes discontinued operations)
Diluted Weighted Average Shares
Dividends per Share
Diluted Normalized EPS (continuing operations)
Cash Cycle FY 2009 FY 2008 FY 2007 FY 2006 FY 2005
Revenue per day - 0 - 0 - 0 - 0 - 0
Accounts Receivable
Receivable Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Inventory
Inventory Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Accounts Payable
Payable Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Cash Cycle (days) ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Key Ratios FY 2009 FY 2008 FY 2007 FY 2006 FY 2005
Market Value of Book Equity
Price per share ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Earnings per share (continuing operations) - 0 - 0 - 0 - 0 - 0
P/E Ratio ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Return on Invested Capital ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Return on Assets ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Return on Equity ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Return on Revenue ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total Assets
Current Assets
Current Liabilities
Current Ratio ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total Debt
Debt/Equity Ratio ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total Equity (book value)
Shareholders' Equity (minority interests)
Market to Book Value ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Per Employee FY 2009 FY 2008 FY 2007 FY 2006 FY 2005
Number of Employees (continuing operations)
Revenue ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Net Income ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Market Value ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Key Ratio Comparison

Competitor Financial Analysis
(data in thousands [000], excluding per share data and financial ratios)
FY Year Name Name Name
Revenue
Cost of Revenue
Gross Profit - 0 - 0 - 0
Gross Profit Margin ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
EBIT
Income Tax
NOPAT (Net Operating Profit After Taxes) - 0 - 0 - 0
Net Income (includes discontinued operations)
Diluted Weighted Average Shares
Dividends per Share
Diluted Normalized EPS (continuing operations)
Cash Cycle Name Name Name
Revenue per day - 0 - 0 - 0
Accounts Receivable
Receivable Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Inventory
Inventory Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Accounts Payable
Payable Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Cash Cycle (days) ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Key Ratios Name Name Name
Market Value of Equity
Price per share ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
P/E Ratio ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Return on Invested Capital ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Return on Assets ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Return on Equity ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Return on Revenue ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total Assets
Current Assets
Current Liabilities
Current Ratio ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total Debt
Debt/Equity Ratio ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Total Equity (book value)
Shareholders' equity (minority interests)
Market to Book Value ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Per Employee Name Name Name
Number of Employees
Revenue ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Net Income ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Market Value ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!