help for finance…

There is a word document attached and a excel sheet is attached. Got to work on both…..Once you open the word document the instructions are there……Just follow the instruction, that’s going to help you do the work……I need it by july 20th that’s saturday before 6 PM……..If you don’t understand please let me…

Company selection – week – 1

Choose your term paper companies – two companies should be selected – and upload them via the Week 1 Dropbox titled “Company Selection.” Your choices will be reviewed, and you will receive feedback and/or approval for your choices. Your selections must be publicly traded companies that compete with one another, and I encourage you to select the company you work for, or wish to work for, in order to learn more about the company and the industry. Please ensure to include the ticker symbol with the company name to ensure that is publicly traded on one of the stock exchanges. Ticker symbols can be found on Yahoo! Finance.

Course Project Horizontal Analysis – Week 2

Your outline should include (but is not limited to) the following.

I. Choice of Companies and an Overview of Their Operations and Industry – Briefly outline what each company does and its industry. (5 points)

II. Discussion of Current Issues Impacting Financial Statements – Include any relevant current event information, news that has affected financial statements, or world events that could impact the businesses. Research will have to be done on this. Some good sources of information include the most recent annual reports for each company (these can be found online for all publicly-traded companies; utilize the most current year-end annual reports available), Yahoo! Finance, the MSN Money website (this will provide current information on your company and some ratio information), and various business magazines. You can find the websites suggested under the Webliography tab in the course. (5 points)

III. Relevant Ratios and Discussion – List what ratios you think are relevant to your companies and industry. Go to the Excel spreadsheet in Doc Sharing, review the ratios listed under the ratio tab, and pick what you think may be relevant. In one to two paragraphs, briefly discuss ten ratios you think may be important, and include ratios from the different categories. The ratios will be automatically calculated on the spreadsheet (please see section IV regarding this). (10 points)

IV. Excel Spreadsheet FinSAS.xls – Manually input the financial data for your company under the input tab on the spreadsheet. You should insert numbers highlighted only in blue. These numbers should be found in the company’s most recent year-end annual reports (utilize the most year-end numbers; the spreadsheet has it starting at 2008, but change the year to 2009 and go five years historically from there to 2005), which can be obtained online under your company choice. Complete a separate spreadsheet for each company. Write that you completed the input for the spreadsheet for both companies and that the spreadsheet works. To check this, once you input the data in the input tab only, check the other tabs (ratio, vertical analysis) to ensure that you see the automated calculations. (20 points)

V. Bibliography

Written content and explanations can be completed in a separate (Word) document

Course Project Vertical Analysis – Week 3

Your outline should include (but is not limited to) the following.

I. Identification of Significant Asset Items, Liability Items, and Comments on Revenue and Profitability – List specific issues that you think affect these items. For example, economic factors, new product launches, and recent news developments can affect the items. Information can be obtained from annual report write-ups, financial notes, and the Internet. Briefly comment on how they affect financial numbers such as sales, profitability, costs, revenue, and so forth. (10 points)

II. Relevant Ratios and Discussion of Your Findings of Vertical Analysis – Discuss briefly your vertical analysis findings, which are calculated automatically on the spreadsheet under the vertical analysis tab. Then, identify any key ratios that you think impact vertical analysis. (10 points)

III. Excel Spreadsheet FinSAS.xlsx, Calculations of Vertical Ratio Analysis – This is a separate tab under the project spreadsheet and will calculate automatically, based on what you inserted in the input tab during Week 2. Ensure that it has calculated, and provide a brief analysis of your findings. The spreadsheet does not need to be submitted this week; just state that the spreadsheet is calculating correctly for each company. (20 points)

a. Bibliography
b. Other back material, as needed: detailed tables, extended quotations from which shorter quotes are taken, and so forth.

Written content and explanations can be completed in a separate (Word) document

Course Project Final Ratio Analysis – Week 4

Your outline should include (but is not limited to) the following.

I. Explaining Business Objectives and the Effect of the Objectives on the Ratios – Briefly highlight if the ratios meet the criteria of the business objectives. These objectives can be found in the annual reports under CEO comments and business summaries. (10 points)

II. Identification of the Three Most Important Ratios for Your Companies and Support – Include why you think these ratios are the most important; what do they indicate about the financial health of each company? All ratios should be automatically calculated based on your input sheet from Week 2. (10 points)

III. Computation of Relevant Ratios and Comparison to Industry Data – Verify that all ratios have been automatically calculated on the spreadsheet. On a separate document, list the ratios in comparison to the industry. Industry ratios can be found on various financial websites. The list should be in a table format, showing Company A, Company B, and then the industry ratio. (20 points)

a. Bibliography
b. Other back material, as needed: detailed tables, extended quotations from which shorter quotes are taken, and so forth.

Written content and explanations can be completed in a separate (Word) document.

General Expectations for your Final Course Project Submission – Week 7

This week, you should integrate the work you did on the group project over the past six weeks to create a Course Project, and submit it to the Dropbox under the Course Project tab by Thursday of Week 7. A Word document, as well as the Excel document for each company, must be submitted. Also, submit a spreadsheet for each company completed.

This week, you should also be sure that you answered the following: “Which company has better financial ratios and why? What do the ratios indicate? Compare the financial ratios for the latest year to the industry averages. Is each company above or below the industry averages? Compare for each ratio.” All this information should come from your previous weeks’ submissions. A suggestion is to include a section in the paper that responds to each of these questions stated. A paper clearly outlined with separate sections generally reads easier

Don’t forget to cite your sources properly, both parenthetically and in your bibliography or works cited.

>Instructions FinSAS Version

0211 FinSAS: Financial Statement Analysis Spreadsheet by Dr. Donald V. Saftner donald.saftner@utoledo.edu To Accompany Financial Reporting and Analysis: Using Financial Accounting Information 11/e by Dr. Charles Gibson Copyright © 2009 Cengage Learning All rights reserved FinSAS: Financial Statement Analysis Spreadsheet allows users to input the reported data from the financial statements, notes, and other sources. FinSAS then computes the ratios found in Financial Reporting and Analysis: Using Financial Accounting Information 11/e. Using this tool, you can spend more time analyzing the statements and less time crunching the numbers. In addition to the ratios, both a vertical and horizontal analysis are performed. Instructions: Note the sheet tabs below. The following instructions use the names of those tabs as section headings. Click on a tab to see that sheet after reading the instructions below.

Input

On the Input sheet, enter values into all appropriate cells (i.e., those with blue font). The figures in black font are calculated based on your input. By entering the Company Name, Analyst Name(s), and Most Recent Year Available in the first three input cells, those items will appear on all subsequent output sheets. They make it easy to identify any printouts you make. The next two input cells (Years Available for Income Statement and Balance Sheet) are particularly important to the functioning of the model. Changing these numbers (while keeping them within the range one through five) changes the number of columns of data that are available on the Input sheet and all subsequent output sheets. In a single annual report/10K, there are often three years of income statements and two years of balance sheets. The annual report/10K you are using may have more and/or you may want to use multiple years’ worth of annual report/10Ks to increase the amount of data available to analyze. The maximum years that FinSAS can accept is five years. Fill in all remaining input cells for which you can find data. There are many different names for the same account. You must translate the terminology used by the company to the generic terms used in FinSAS. When the detail is not needed, FinSAS requests a summary figure. For instance, on the published income statement there may be several operating expenses (e.g., wages, utilities, rent), but FinSAS only needs the sum of those, which would be entered as Operating Expenses. Be sure to read the footnotes to the financial statements and the comparative data section. Those sources include some of the information you need to complete the Input sheet. Also be sure to match key subtotals (e.g. the FinSAS total current asset should be same as the figure on the balance sheet even though the detail lines may be different.) Be consistent in ignoring a certain number of decimal places. Many financial statements have “in thousands, except par values,” “millions except share and per share amounts,” or similar statements. When entering data into FinSAS, it is usually best to follow the same convention as the financial statements in choosing the number of decimal places to assume have been removed. An exception is the second statement above. Only “per share” data should be entered as dollars with no decimal places removed. Account balances and total share information should consistently have the same number of decimal places removed. If the share and account balances have a different number of decimal places removed then ratios such as “book value per share” and “operating cash flow per share” will be inaccurate.

Source of Input

This is the place to document where you found the information you entered on the previous sheet. This can be very useful for you and for anyone who reviews your work. For instance if most of it came from the company’s annual report/10K, then state that at the top. Individual lines of input in FinSAS might be the sum of a few lines in the published financial statements. Indicate on this sheet how you determined the FinSAS inputs from the statements. For some of the inputs, you may have used information from the footnotes or comparative information section. Indicate that information on this sheet and include page numbers wherever possible. Of course, other sources of information should be cited.

Vertical Analysis

After you insert your data, you can see the result of the vertical analysis. It compares each amount on the income statement and balance sheet with a base amount (net sales on the income statement and total assets on the balance sheet) selected from the same year.

Horizontal Analysis

After you insert your data, you can see the result of the horizontal analysis. It compares each amount on the income statement and balance sheet with the same amount for the oldest year available. Ratios – avg. After you insert your data, you can see the result of the ratio analysis. For the ‘Ratio – Average’, the average of beginning of year values and end of year values is used when appropriate. Note that if you only have two years of balance sheet information, then for those ratios that use the average of two years of balance sheet information, only one year’s worth of ratios can be calculated. Since it is desirable to compare the ratios across time to determine possible trends, a solution to only having one year’s worth of ratios should be sought. Some possible solutions are to find additional years’ worth of data and/or use the Ratio

–

end. sheet. Ratios with a negative cash flow or negative profit measure in the numerator will display #N/A, which means not available or not applicable. This makes it less likely that invalid conclusions will be made during your analysis.

You may want to determine how a certain ratio is calculated. You may do this in one of two ways. If you select the cell in which the ratio appears, then the formula for that cell appears near the top of the screen. You will then have to determine what accounts the cell refers to by looking at the Input screen. Alternatively, you can refer to the

Documentation

screen for the definition.

Ratios – end. For the ‘Ratio – End’, the end of year values are used instead of the average values. The ‘*’ marks indicate the ratios for which the end of year values are used whereas the averages are used on the previous sheet.

For the

Ratios – end.

sheet, the end of year values are used instead of the average values. The ‘*’ marks indicate the ratios for which the end of year values are used whereas the averages are used on the previous sheet. Note that the

Ratios – avg.

sheet is theoretically superior in that averages for balance sheet information (point in time) is compared to income statement or cash flow statements (period of time).

Documentation
The Documentation sheet provides you the definitions of the ratios using the row labels of the Input sheet or other ratio results.

Input

1 2

010211

Input

2008

= = = =

2008

– – – – –

–

0 0 0 0 0

– – – – –

0 0 0 0 0

– – – – –

0 0 0 0 0

– – – – –

0 0 0 0 0

– – – – –

0 0 0 0 0

– – – – –

0 0 0 0 0

Gain (Loss) 0 0 0 0 0

Gain (Loss) 0 0 0 0 0
– – – – –

0 0 0 0 0

= = = = = =

2008 2007 2006 2005 2004

– – – – – –

0 0 0 0 0

– – – – –

0 0 0 0 0

– – – – –

0 0 0 0 0

– – – – –

0 0 0 0 0

– – – – –

0 0 0 0 0

– – – – –

0 0 0 0 0

= = = = = =

2008 2007 2006 2005 2004

– – – – – –

0.0 0.0 0.0 0.0

0.0 0.0 0.0 0.0 0.0

0.000 0.000 0.000 0.000

0.0 0.0 0.0 0.0 0.0

0.000 0.000 0.000 0.000 0.000

0.0 0.0 0.0 0.0 0.0

FinSAS Version

2008

Company:

Company name here

Analyst:

Your name(s) here

Most Recent Year Available:

Years Available for:

Income Statement (1-5)

Balance Sheet (1-5)

INCOME STATEMENT

2007

2006

2005

2004

Net Sales

Less: Cost of Goods Sold

Gross Profit

Other Operating Revenue

Less: Operating Expenses

Operating Income

Less: Interest Expense

(no capitalized interest)

Other Income (Expenses)

Unusual or Infreq. Item;

Gain (Loss)

Equity in Earnings of Assoc.;

Profit (Loss)

Income before Taxes

Less:Taxes Related to Operations

N.I. before Min. Ern.

Minority Share of Earnings (Loss)

N.I. before Nonrecurring Items

Oper. of Discontinued Segment;

Income (Loss)

Disposal of Discont. Segment;

Extraordinary Item;

Cum. Effect of Acct Change;

Net Income (Loss)

BALANCE SHEET

ASSETS

Current Assets:

Cash

Marketable Securities

Gross Receivables

Less: Allowance for Bad Debts

Net Trade Receivables

Inventories

Prepaid Expenses

Other Current Assets

Total Current Assets

Long-Term Assets:

Net Tangible (Fixed) Assets (other than construction in progress)

Construction in Progress

Intangible Assets

Investments

Other Nonoperating Assets

Other Operating Assets

Total Long-Term Assets

Total Assets

LIABILITIES AND EQUITY

Current Liabilities:

Accounts Payable

Short Term Loans

Current Maturity of L.t. Debt

Other Current Liabilities

Total Current Liabilities

Long-Term Liabilities:

Long-term Debt

Reserves

Deferred Liabilities

Minority Interest

Redeemable Preferred

Other Long-term Liabilities

Total Long-term Liabilities

Total Liabilities

Shareholders’ Equity:

Preferred Equity

Common Equity-incl. Ret. Ern.

Total Equity

Total Liabilities and Equity

OTHER DATA

Capitalized Interest

0.0

Interest Portion of Rentals

Liquidation Value of Pref. Stock

Dividends on Redeemable Pref.

Dividends on Nonredeemable Pref.

Dividends per Common Share

0.00

Total Cash Dividends

Dil. Earn. per Sh. before Nonrec. Items

Market Price per Common Share

Tax Rate (0-1)

Common Shares Outstanding

Diluted Weighted Average Common Shares

Cash Flow from Operations

Options:

Option expense

Net income bef. nonrec. items
not incl. opt. exp.

Source of Input

Company: Company name here
Analyst: Your name(s) here
Most Recent Year Available: 2008
Years Available for:
Income Statement (1-5) 5
Balance Sheet (1-5) 5
=

INCOME STATEMENT

–

Net Sales
Less: Cost of Goods Sold
Gross Profit
Other Operating Revenue
Less: Operating Expenses
Operating Income
Less: Interest Expense

(no capitalized interest)

Other Income (Expenses)

Unusual or Infreq. Item;

Gain (Loss)

Equity in Earnings of Assoc.;

Profit (Loss)
Income before Taxes
Less:Taxes Related to Operations
N.I. before Min. Ern.
Minority Share of Earnings (Loss)
N.I. before Nonrecurring Items

Oper. of Discontinued Segment;

Income (Loss)

Disposal of Discont. Segment;
Gain (Loss)
Extraordinary Item;
Gain (Loss)
Cum. Effect of Acct Change;
Gain (Loss)

Net Income (Loss)

BALANCE SHEET

–
ASSETS
Current Assets:

Cash
Marketable Securities
Gross Receivables
Less: Allowance for Bad Debts
Net Trade Receivables
Inventories
Prepaid Expenses
Other Current Assets
Total Current Assets

Long-Term Assets:

Net Tangible (Fixed) Assets (other than construction in progress)
Construction in Progress
Intangible Assets
Investments
Other Nonoperating Assets
Other Operating Assets
Total Long-Term Assets
Total Assets

LIABILITIES AND EQUITY
Current Liabilities:

Accounts Payable
Short Term Loans
Current Maturity of L.t. Debt
Other Current Liabilities
Total Current Liabilities

Long-Term Liabilities:

Long-term Debt
Reserves
Deferred Liabilities
Minority Interest
Redeemable Preferred
Other Long-term Liabilities
Total Long-term Liabilities
Total Liabilities

Shareholders’ Equity:

Preferred Equity
Common Equity-incl. Ret. Ern.
Total Equity
Total Liabilities and Equity

OTHER DATA

–

Capitalized Interest
Interest Portion of Rentals
Liquidation Value of Pref. Stock
Dividends on Redeemable Pref.
Dividends on Nonredeemable Pref.
Dividends per Common Share
Total Cash Dividends
Market Price per Common Share
Tax Rate (0-1)
Common Shares Outstanding
Diluted Weighted Average Common Shares
Cash Flow from Operations

Options:

Option expense
Net income bef. nonrec. items
not incl. opt. exp.

					FinSAS Version 2008010211
Dil. Earn. per Sh. before nonrec. items

Vertical Analysis

FinSAS Version 2008010211

Vertical Analysis

Company: Company name here
Analyst: Your name(s) here
Most Recent Year Available: 2008
Years Available for:
Income Statement (1-5) 5
Balance Sheet (1-5) 5
= = = = = =
INCOME STATEMENT 2008 2007 2006 2005 2004

–

———- ———- ———-

Net Sales

0.00% 0.00% 0.00% 0.00%

Less: Cost of Goods Sold 0.00% 0.00% 0.00% 0.00% 0.00%
———- ———- ———- ———- ———-
Gross Profit 0.00% 0.00% 0.00% 0.00% 0.00%
Other Operating Revenue 0.00% 0.00% 0.00% 0.00% 0.00%
Less: Operating Expenses 0.00% 0.00% 0.00% 0.00% 0.00%

———- ———- ———- ———- ———-

Operating Income 0.00% 0.00% 0.00% 0.00% 0.00%
Less: Interest Expense 0.00% 0.00% 0.00% 0.00% 0.00%

(no capitalized interest)

Other Income (Expenses) 0.00% 0.00% 0.00% 0.00% 0.00%

Unusual or Infreq. Item;

Gain (Loss) 0.00% 0.00% 0.00% 0.00% 0.00%

Equity in Earnings of Assoc.;

Profit (Loss) 0.00% 0.00% 0.00% 0.00% 0.00%

———- ———- ———- ———- ———-

Income before Taxes 0.00% 0.00% 0.00% 0.00% 0.00%
Less:Taxes Related to Operations 0.00% 0.00% 0.00% 0.00% 0.00%

———- ———- ———- ———- ———-

N.I. before Min. Ern. 0.00% 0.00% 0.00% 0.00% 0.00%
Minority Share of Earnings (Loss) 0.00% 0.00% 0.00% 0.00% 0.00%

———- ———- ———- ———- ———-

N.I. before Nonrecurring Items 0.00% 0.00% 0.00% 0.00% 0.00%

Oper. of Discontinued Segment;

Income (Loss) 0.00% 0.00% 0.00% 0.00% 0.00%

Disposal of Discont. Segment;
Gain (Loss) 0.00% 0.00% 0.00% 0.00% 0.00%
Extraordinary Item;
Gain (Loss) 0.00% 0.00% 0.00% 0.00% 0.00%
Cum. Effect of Acct Change;
Gain (Loss) 0.00% 0.00% 0.00% 0.00% 0.00%
———- ———- ———- ———- ———-

Net Income (Loss) 0.00% 0.00% 0.00% 0.00% 0.00%

= = = = = =
BALANCE SHEET 2008 2007 2006 2005 2004

– ——— ——— ——— ——— ———

ASSETS
Current Assets:

Cash 0.00% 0.00% 0.00% 0.00% 0.00%
Marketable Securities 0.00% 0.00% 0.00% 0.00% 0.00%
Gross Receivables 0.00% 0.00% 0.00% 0.00% 0.00%
Less: Allowance for Bad Debts 0.00% 0.00% 0.00% 0.00% 0.00%
Net Trade Receivables 0.00% 0.00% 0.00% 0.00% 0.00%
Inventories 0.00% 0.00% 0.00% 0.00% 0.00%
Prepaid Expenses 0.00% 0.00% 0.00% 0.00% 0.00%
Other Current Assets 0.00% 0.00% 0.00% 0.00% 0.00%
——— ——— ——— ——— ———
Total Current Assets 0.00% 0.00% 0.00% 0.00% 0.00%

Long-Term Assets:

Net Tangible (Fixed) Assets (other than construction in progress) 0.00% 0.00% 0.00% 0.00% 0.00%
Construction in Progress 0.00% 0.00% 0.00% 0.00% 0.00%
Intangible Assets 0.00% 0.00% 0.00% 0.00% 0.00%
Investments 0.00% 0.00% 0.00% 0.00% 0.00%
Other Nonoperating Assets 0.00% 0.00% 0.00% 0.00% 0.00%
Other Operating Assets 0.00% 0.00% 0.00% 0.00% 0.00%

——— ——— ——— ——— ———

Total Long-Term Assets 0.00% 0.00% 0.00% 0.00% 0.00%
Total Assets 0.00% 0.00% 0.00% 0.00% 0.00%

LIABILITIES AND EQUITY
Current Liabilities:

Accounts Payable 0.00% 0.00% 0.00% 0.00% 0.00%
Short Term Loans 0.00% 0.00% 0.00% 0.00% 0.00%
Current Maturity of L.t. Debt 0.00% 0.00% 0.00% 0.00% 0.00%
Other Current Liabilities 0.00% 0.00% 0.00% 0.00% 0.00%

——— ——— ——— ——— ———

Total Current Liabilities 0.00% 0.00% 0.00% 0.00% 0.00%

Long-Term Liabilities:

Long-term Debt 0.00% 0.00% 0.00% 0.00% 0.00%
Reserves 0.00% 0.00% 0.00% 0.00% 0.00%
Deferred Liabilities 0.00% 0.00% 0.00% 0.00% 0.00%
Minority Interest 0.00% 0.00% 0.00% 0.00% 0.00%
Redeemable Preferred 0.00% 0.00% 0.00% 0.00% 0.00%
Other Long-term Liabilities 0.00% 0.00% 0.00% 0.00% 0.00%

——— ——— ——— ——— ———

Total Long-term Liabilities 0.00% 0.00% 0.00% 0.00% 0.00%
Total Liabilities 0.00% 0.00% 0.00% 0.00% 0.00%

Shareholders’ Equity:

Preferred Equity 0.00% 0.00% 0.00% 0.00% 0.00%
Common Equity-incl. Ret. Ern. 0.00% 0.00% 0.00% 0.00% 0.00%

——— ——— ——— ——— ———

Total Equity 0.00% 0.00% 0.00% 0.00% 0.00%
Total Liabilities and Equity 0.00% 0.00% 0.00% 0.00% 0.00%

= = = = = =

1.00	2.00	3.00	4.00	5.00
					———	———-
							0.00%

Horizontal Analysis

1.00 2.00 3.00 4.00 5.00
FinSAS Version 2008010211

Horizontal Analysis

Net Sales 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Less: Cost of Goods Sold 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
———- ———- ———- ———- ———- – –
Gross Profit 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
0.00 0.00
Other Operating Revenue 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Less: Operating Expenses 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

———- ———- ———- ———- ———- – –

Operating Income 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Less: Interest Expense 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
(no capitalized interest) 0.00 0.00
Other Income (Expenses) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Unusual or Infreq. Item; 0.00 0.00
Gain (Loss) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Equity in Earnings of Assoc.; 0.00 0.00
Profit (Loss) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

———- ———- ———- ———- ———- – –

Income before Taxes 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

0.00 0.00

Less:Taxes Related to Operations 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

———- ———- ———- ———- ———- – –

N.I. before Min. Ern. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

0.00 0.00

Minority Share of Earnings (Loss) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

———- ———- ———- ———- ———- – –

N.I. before Nonrecurring Items 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

0.00 0.00

Oper. of Discontinued Segment; 0.00 0.00
Income (Loss) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Disposal of Discont. Segment; 0.00 0.00

Gain (Loss) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

Extraordinary Item; 0.00 0.00

Gain (Loss) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

Cum. Effect of Acct Change; 0.00 0.00

Gain (Loss) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
———- ———- ———- ———- ———- – –

Net Income (Loss) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

= = = = = =
BALANCE SHEET 2008 2007 2006 2005 2004
– ———- ———- ———- ———- ———-
ASSETS
Current Assets:

Cash 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Marketable Securities 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Gross Receivables 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Less: Allowance for Bad Debts 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Net Trade Receivables 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Inventories 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Prepaid Expenses 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Other Current Assets 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

———- ———- ———- ———- ———- – –

Total Current Assets 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Long-Term Assets: 0.00 0.00
Net Tangible (Fixed) Assets (other than construction in progress) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Construction in Progress 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Intangible Assets 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Investments 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Other Nonoperating Assets 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Other Operating Assets 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

———- ———- ———- ———- ———- – –

Total Long-Term Assets 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Total Assets 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
LIABILITIES AND EQUITY 0.00 0.00
Current Liabilities: 0.00 0.00
Accounts Payable 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Short Term Loans 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Current Maturity of L.t. Debt 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Other Current Liabilities 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

———- ———- ———- ———- ———- – –

Total Current Liabilities 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Long-Term Liabilities: 0.00 0.00
Long-term Debt 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Reserves 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Deferred Liabilities 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Minority Interest 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Redeemable Preferred 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Other Long-term Liabilities 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

———- ———- ———- ———- ———- – –

Total Long-term Liabilities 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Total Liabilities 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Shareholders’ Equity: 0.00 0.00
Preferred Equity 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Common Equity-incl. Ret. Ern. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00

———- ———- ———- ———- ———- – –

Total Equity 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
Total Liabilities and Equity 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 0.00
= = = = = = = =

Ratios – avg.

1.00 2.00 3.00 4.00 5.00

FinSAS Version 2008010211

Company: Company name here
Analyst: Your name(s) here
Most Recent Year Available: 2008
Years Available for:
Income Statement (1-5) 5
Balance Sheet (1-5) 5

– – – – – –

2008 2007 2006 2005 2004

– – – – – –

0.00 0.00 0.00 0.00 0.00

– 0 – 0 – 0 – 0

– 0 – 0 – 0 – 0 – 0

0.00 0.00 0.00 0.00 0.00

– 0 – 0 – 0 – 0 – 0

– – – – – –

2008 2007 2006 2005 2004

– – – – – –

0.00 0.00 0.00 0.00 0.00

0.00% 0.00% 0.00% 0.00% 0.00%

– – – – – –

2008 2007 2006 2005 2004

– – – – – –

0.00% 0.00% 0.00% 0.00% 0.00%

0.00 0.00 0.00 0.00 0.00

0.00% 0.00% 0.00% 0.00% 0.00%

0.00 0.00 0.00 0.00 0.00

0.00% 0.00% 0.00% 0.00% 0.00%

0.00 0.00 0.00 0.00 0.00

0.00% 0.00% 0.00% 0.00% 0.00%

– – – – – –

2008 2007 2006 2005 2004

– – – – – –

0.00 0.00 0.00 0.00 0.00

0.00% 0.00% 0.00% 0.00% 0.00%

– 0 – 0 – 0 – 0 – 0

0.00% 0.00% 0.00% 0.00% 0.00%

0.00 0.00 0.00 0.00 0.00

= = = = = =

Ratios – average

Minimum Years

Minimum Years (BS-1)

Maximum Years

LIQUIDITY

Days’ Sales in Receivables

Accounts Receivable Turnover

A/R Turnover in Days

Days’ Sales in Inventory

Inventory Turnover

Inventory Turnover in Days

Operating Cycle

Working Capital

– 0

Current Ratio

Acid Test

Cash Ratio

Sales to Working Capital

Cash Flow/Cur. Mat. of Debt & NP

LONG-TERM DEBT-PAYING ABILITY

Times Interest Earned

Fixed Charge Coverage

Debt Ratio

Debt/Equity

Debt to Tangible Net Worth

Cash Flow/Total Debt

PROFITABILITY

Net Profit Margin

Total Asset Turnover

Return on Assets

Operating Income Margin

Operating Asset Turnover

Return on Operating Assets

Sales to Fixed Assets

Return on Investment

Return on Total Equity

Return on Common Equity

Gross Profit Margin

INVESTOR ANALYSIS

Degree of Financial Leverage

Earnings per Share

Price/Earnings Ratio

Percentage of Earnings Retained

Dividend Payout

Dividend Yield

Book Value per Share

Materiality of Options

Oper. Cash Flow per Share

Oper. Cash Flow/Cash Dividends

Year-end Market Price

Ratios – end.

1.00 2.00 3.00 4.00 5.00

FinSAS Version 2008010211

Company: Company name here
Analyst: Your name(s) here
Most Recent Year Available: 2008
Years Available for:
Income Statement (1-5) 5
Balance Sheet (1-5) 5
Minimum Years 5
Minimum Years (BS-1) 4
Maximum Years 5

– – – – – –
LIQUIDITY 2008 2007 2006 2005 2004
– – – – – –
Days’ Sales in Receivables 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

Days’ Sales in Inventory 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00

Working Capital – 0 – 0 – 0 – 0 – 0
Current Ratio – 0 – 0 – 0 – 0 – 0
Acid Test – 0 – 0 – 0 – 0 – 0
Cash Ratio – 0 – 0 – 0 – 0 – 0

0.00 0.00 0.00 0.00 0.00

Cash Flow/Cur. Mat. of Debt & NP – 0 – 0 – 0 – 0 – 0
– – – – – –
LONG-TERM DEBT-PAYING ABILITY 2008 2007 2006 2005 2004
– – – – – –

Times Interest Earned – 0 – 0 – 0 – 0 – 0
Fixed Charge Coverage – 0 – 0 – 0 – 0 – 0

Debt Ratio 0.00% 0.00% 0.00% 0.00% 0.00%
Debt/Equity 0.00% 0.00% 0.00% 0.00% 0.00%
Debt to Tangible Net Worth 0.00% 0.00% 0.00% 0.00% 0.00%
Cash Flow/Total Debt 0.00% 0.00% 0.00% 0.00% 0.00%
– – – – – –
PROFITABILITY 2008 2007 2006 2005 2004
– – – – – –
Net Profit Margin 0.00% 0.00% 0.00% 0.00% 0.00%

0.00 0.00 0.00 0.00 0.00

0.00% 0.00% 0.00% 0.00% 0.00%

Operating Income Margin 0.00% 0.00% 0.00% 0.00% 0.00%

0.00 0.00 0.00 0.00 0.00

0.00% 0.00% 0.00% 0.00% 0.00%

0.00 0.00 0.00 0.00 0.00

0.00% 0.00% 0.00% 0.00% 0.00%

Gross Profit Margin 0.00% 0.00% 0.00% 0.00% 0.00%
– – – – – –
INVESTOR ANALYSIS 2008 2007 2006 2005 2004
– – – – – –

Degree of Financial Leverage – 0 – 0 – 0 – 0 – 0
Earnings per Share – 0 – 0 – 0 – 0 – 0
Price/Earnings Ratio – 0 – 0 – 0 – 0 – 0

Percentage of Earnings Retained 0.00% 0.00% 0.00% 0.00% 0.00%
Dividend Payout 0.00% 0.00% 0.00% 0.00% 0.00%
Dividend Yield 0.00% 0.00% 0.00% 0.00% 0.00%
Book Value per Share – 0 – 0 – 0 – 0 – 0
Materiality of Options 0.00% 0.00% 0.00% 0.00% 0.00%

Oper. Cash Flow per Share – 0 – 0 – 0 – 0 – 0
Oper. Cash Flow/Cash Dividends – 0 – 0 – 0 – 0 – 0

Year-end Market Price 0.00 0.00 0.00 0.00 0.00
= = = = = =

Ratios – ending

* EOY values instead of averages

* Accounts Receivable Turnover

* A/R Turnover in Days

* Inventory Turnover

* Inventory Turnover in Days

* Operating Cycle

* Sales to Working Capital

* Total Asset Turnover

* Return on Assets

* Operating Asset Turnover

* Return on Operating Assets

* Sales to Fixed Assets

* Return on Investment

* Return on Total Equity

* Return on Common Equity

Documentation

FinSAS Version 2008010211 Documentation

–

LIQUIDITY

–

Days’ Sales in Receivables

Accounts Receivable Turnover

A/R Turnover in Days

Days’ Sales in Inventory

Inventory Turnover

Inventory Turnover in Days

Operating Cycle

Working Capital

Current Ratio

Acid Test

Cash Ratio

Sales to Working Capital

Cash Flow/Cur. Mat. of Debt & NP

–

LONG-TERM DEBT-PAYING ABILITY

–

Times Interest Earned

Fixed Charge Coverage

Debt Ratio

Debt/Equity

Debt to Tangible Net Worth

Cash Flow/Total Debt

–

PROFITABILITY

–

Net Profit Margin

Total Asset Turnover

Return on Assets

Operating Income Margin

Operating Asset Turnover

Return on Operating Assets

Sales to Fixed Assets

Return on Investment

Return on Total Equity

Return on Common Equity

Gross Profit Margin

–

INVESTOR ANALYSIS

–

Degree of Financial Leverage

Earnings per Share Dil. Earn. per Sh. before Nonrec. Items
Price/Earnings Ratio

Percentage of Earnings Retained

Dividend Payout

Dividend Yield

Book Value per Share

Materiality of Options

Oper. Cash Flow per Share

Oper. Cash Flow/Cash Dividends

Year-end Market Price Market Price per Common Share

Gross Receivables
—————————
Net Sales / 365

Net Sales
—————————————-
Average (Gross Receivables)

365
——————————————–
Accounts Receivable Turnover

Ending Inventory
———————————–
Cost of Goods Sold / 365

Cost of Goods Sold
———————————
Average (Inventories)

365
————————————–
Inventory Turnover

A/R Turnover in Days + Inventory Turnover in Days

Total Current Assets – Total Current Liabilities

Total Current Assets
———————————-
Total Current Liabilities

Cash + Marketable Securities + Net Trade Receivables
———————————————————————————
Total Current Liabilities

Cash + Marketable Securities
———————————————
Total Current Liabilities

Net Sales
————————————
Average (Working Capital)

Cash Flow from Operations
———————————————————————
Short Term Loans + Current Maturity of L.t. Debt

Income before Taxes + Interest Expense (no capitalized interest) – Equity in Earnings of Assoc.; Profit (Loss)
——————————————————————————————————————————————————–
Interest Expense (no capitalized interest) + Capitalized Interest

Income before Taxes + Interest Expense (no capitalized interest) – Equity in Earnings of Assoc.; Profit (Loss) + Interest Portion of Rentals
—————————————————————————————————————————————————————————————–
Interest Expense (no capitalized interest) + Capitalized Interest + Interest Portion of Rentals

Total Liabilities
——————————–
Total Assets

Total Liabilities
————————
Total Equity

Total Liabilities
———————————————–
Total Equity – Intangible Assets

Cash Flow from Operations
—————————————-
Total Liabilities

N.I. before Min. Ern. – Equity in Earnings of Assoc.; Profit (Loss)
—————————————————————————————
Net Sales

Net Sales
———————————
Average (Total Assets)

N.I. before Min. Ern.
—————————–
Average (Total Assets)

Operating Income
————————-
Net Sales

Net Sales
————————————————————————————————————————————————————–
Average (Total Assets – Construction in Progress – Intangible Assets – Investments – Other Nonoperating Assets)

Operating Income
————————————————————————————————————————————————————–
Average (Total Assets – Construction in Progress – Intangible Assets – Investments – Other Nonoperating Assets)

Net Sales
——————————————————————————————————-
Average (Net Tangible (Fixed) Assets (other than construction in progress))

N.I. before Min. Ern. + {(1- Tax Rate) * Interest Expense (no capitalized interest)}
————————————————————————————————
Average (Total Liabilities and Equity – Total Current Liabilities)

N.I. before Nonrecurring Items – Dividends on Redeemable Pref.
—————————————————————————————-
Average (Total Equity)

N.I. before Nonrecurring Items – Dividends on Redeemable Pref. – Dividends on Nonredeemable Pref.
———————————————————————————————————————————————
Average (Common Equity-incl. Ret. Ern.)

Gross Profit
——————–
Net Sales

Income before Taxes + Interest Expense (no capitalized interest) – Equity in Earnings of Assoc.; Profit (Loss)
——————————————————————————————————————————————————
Income before Taxes – Equity in Earnings of Assoc.; Profit (Loss)

Market Price per Common Share
———————————————-
Dil. Earn. per Sh. before Nonrec. Items

N.I. before Nonrecurring Items – Total Cash Dividends
———————————————————
N.I. before Nonrecurring Items

Dividends per Common Share
———————————————-
Dil. Earn. per Sh. before Nonrec. Items

Dividends per Common Share
———————————————-
Market Price per Common Share

Common Equity-incl. Ret. Ern.
———————————————
Common Shares Outstanding

Option expense
—————————————————————
Net income bef. nonrec. items not incl. opt. exp.

Cash Flow from Operations – Dividends on Redeemable Pref. – Dividends on Nonredeemable Pref.
—————————————————————————————————————————————
Diluted Weighted Average Common Shares

Cash Flow from Operations
—————————————
Total Cash Dividends

Turn in your highest-quality paper
Get a qualified writer to help you with

“ help for finance… ”

Get high-quality paper

Guarantee! All work is written by expert writers!

Still stressed from student homework?

Get quality assistance from academic writers!

Order now