Attachments for Assignments
Lashon K 
ProjectTwoFinancialFormulas.xlsxRATIOS
| ACCOUNTING & FINANCIAL RATIOS | |||||||||||||
| CURRENT RATIO (Current Assets / Current Liabilities) | TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) | ||||||||||||
| Current Assets | $110,000 | Total Revenue | $60,000 + $140,000 = $200,000 | ||||||||||
| Current Liabilities | $170,000 | 0.6470588235 | Total Assets | $110,000 + $60,000 = $170,000 | 1.176 | ||||||||
| WORKING CAPITAL (Current Assets - Current Liabilities) : Current Assets are equal to $110,000 and the current liabilities are also equal to $170,000. Therefore, the working capital would be deemed to be $60,000. In such a case, the working capital is one that is deemed to be $60,000 and this result from subtracting the current assets from the current liabilities. | FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) | ||||||||||||
| Current Assets | Total Assets | $170,000 | |||||||||||
| Current Liabilities | 0 | Shareholder's Equity | $200,000 | 0.85 | |||||||||
| DEBT RATIO (Total Debt / Total Assets) | NET PROFIT MARGIN (Net Income / Total Revenue) | ||||||||||||
| Total Debt | $110,000 | Net Income | $60,000 | ||||||||||
| Total Assets | $170,000 | 0.6470588235 | Total Revenue | $200,000 | 0.3 | ||||||||
| EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | RETURN ON ASSETS (Net Income / Total Assets) | ||||||||||||
| Net Income | $60,000 | Net Income | $60,000 | ||||||||||
| Shares Outstanding | $40,000 | 1.5 | Total Assets | $200,000 | 0.3 | ||||||||
| PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | ||||||||||||
| Stock Price | $40,000/$5= $8,000 | NI - Pref. Div. | $50,000 | ||||||||||
| EPS | $100 | $80 | Shareholder's Equity | $100,000 | 0.5 | ||||||||
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 | |||||||||||||||||
