FIN 320 Milestone Two
MJones13
FIN320ProjectTwoFinancialFormulas.xlsxRATIOS
| ACCOUNTING & FINANCIAL RATIOS | |||||||||||||
| CURRENT RATIO (Current Assets / Current Liabilities) | TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) | ||||||||||||
| Current Assets | 339660 | Total Revenue | 170220 | ||||||||||
| Current Liabilities | 274130 | 1.2390471674 | Total Assets | 20222.1 | 8.4175234026 | ||||||||
| WORKING CAPITAL (Current Assets - Current Liabilities) | FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) | ||||||||||||
| Current Assets | 339660 | Total Assets | 20222.1 | ||||||||||
| Current Liabilities | 274130 | 65530 | Shareholder's Equity | 867410 | 0.0233131968 | ||||||||
| DEBT RATIO (Total Debt / Total Assets) | NET PROFIT MARGIN (Net Income / Total Revenue) | ||||||||||||
| Total Debt | -78370 | Net Income | 11230 | ||||||||||
| Total Assets | 2022210 | -0.0387546298 | Total Revenue | 170220 | 0.0659734461 | ||||||||
| EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | RETURN ON ASSETS (Net Income / Total Assets) | ||||||||||||
| Net Income | 11230 | Net Income | 11230 | ||||||||||
| Shares Outstanding | 18180 | 0.6177117712 | Total Assets | 20222.1 | 0.5553330267 | ||||||||
| PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | ||||||||||||
| Stock Price | 551740 | NI - Pref. Div. | 9180 | ||||||||||
| EPS | 0.51 | 1081843.1372549 | Shareholder's Equity | 867410 | 0.0105832305 | ||||||||
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 | |||||||||||||||||
