Project Two The assignment is attached.

You will also need to use the link below to assist with this assignment.

https://www-mergentonline-com.ezproxy.snhu.edu/basicsearch.php RATIOS

ACCOUNTING & FINANCIAL RATIOS

CURRENT RATIO (Current Assets / Current Liabilities) TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets)

Current Assets Total Revenue

Current Liabilities ERROR:#DIV/0! Total Assets ERROR:#DIV/0!

WORKING CAPITAL (Current Assets – Current Liabilities)

: *Note to students: Be mindful of the scale being used in Mergent Online when filling this out. If a number is written as 12.53, that does not mean the total for that item is $12.53. There could be numerous zeros written after it, depending on the scale labeled above. In this example, 12.53 is actually $12,530,000. (To delete this comment, right-click on the “WORKING CAPITAL” box, then select Delete Comment from the drop-down menu.) FINANCIAL LEVERAGE (Total Assets / Shareholder’s Equity)

Current Assets Total Assets

Current Liabilities 0 Shareholder’s Equity ERROR:#DIV/0!

DEBT RATIO (Total Debt / Total Assets) NET PROFIT MARGIN (Net Income / Total Revenue)

Total Debt Net Income

Total Assets ERROR:#DIV/0! Total Revenue ERROR:#DIV/0!

EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) RETURN ON ASSETS (Net Income / Total Assets)

Net Income Net Income

Shares Outstanding ERROR:#DIV/0! Total Assets ERROR:#DIV/0!

PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) RETURN ON EQUITY (Net Income – Preferred Dividends / Shareholder’s Equity)

Stock Price NI – Pref. Div.

EPS ERROR:#DIV/0! Shareholder’s Equity ERROR:#DIV/0!

Monthly

Time Value of Money – Monthly Compounding

Rate of Return Year 1

Initial Investment Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 2

Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 3

Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 4

Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 5

Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 6

Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 7

Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 8

Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 9

Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Year 10

Month 1 2 3 4 5 6 7 8 9 10 11 12

Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Annual

Time Value of Money – Annual Compounding

Rate of Return Year 1 2 3 4 5 6 7 8 9 10

Initial Investment Interest $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Investment Value $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

PV

Time Value of Money – Present Value Annuity

Number of Years

Rate of Return $0.00

Payment

FV

Time Value of Money – Future Value Annuity

Number of Years

Rate of Return $0.00

Payment

PV – Lump Sum

Time Value of Money – Present Value of Lump Sum

Rate

Years $0.00

Initial Investment

FV – Lump Sum

Time Value of Money – Future Value of Lump Sum

Rate

Years $0.00

Initial Investment

NPV

Net Present Value (NPV) Calculator

Building

Initial Investment Year 1 2 3 4 5 6 7 8 9 10

Annual Cash Inflows Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Discount Rate NPV = $0 Year 11 12 13 14 15 16 17 18 19 20

Number of Years Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Salvage Value

Equipment

Initial Investment Year 1 2 3 4 5 6 7 8 9 10

Annual Cash Inflows Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Discount Rate NPV = $0 Year 11 12 13 14 15 16 17 18 19 20

Number of Years Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Salvage Value

Bonds

Initial Investment

Annual Cash Inflows

Discount Rate NPV = $0 Year 1 2 3 4 5 6 7 8 9 10

Number of Years Cash Flows $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Principal Returned