Company Name is Disney
Brian_1234
FIN320ProjectTwoFinancialFormulas1.xlsxMonthly
| 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 | |||||||||||||||||
Quarter Ended 04032021
| ACCOUNTING & FINANCIAL RATIOS | |||||||||||||
| CURRENT RATIO (Current Assets / Current Liabilities) | TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) | ||||||||||||
| Current Assets | 32877000 | Total Revenue | 15613000 | ||||||||||
| Current Liabilities | 26642000 | 1.2340289768 | Total Assets | 200250000 | 0.0779675406 | ||||||||
| WORKING CAPITAL (Current Assets - Current Liabilities) | FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) | ||||||||||||
| Current Assets | 32877000 | Total Assets | 200250000 | ||||||||||
| Current Liabilities | 26642000 | 6235000 | Shareholder's Equity | 89786000 | 2.2303031653 | ||||||||
| DEBT RATIO (Total Debt / Total Assets) | NET PROFIT MARGIN (Net Income / Total Revenue) | ||||||||||||
| Total Debt | 110464000 | Net Income | 901000 | ||||||||||
| Total Assets | 200250000 | 0.5516304619 | Total Revenue | 15613000 | 0.05770832 | ||||||||
| EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | RETURN ON ASSETS (Net Income / Total Assets) | ||||||||||||
| Net Income | 901000 | Net Income | 901000 | ||||||||||
| Shares Outstanding | 1817000 | 0.495872317 | Total Assets | 200250000 | 0.0044993758 | ||||||||
| PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | ||||||||||||
| Stock Price | 188.97 | NI - Pref. Div. | 901000 | ||||||||||
| EPS | 0.495872317 | 381.0860044395 | Shareholder's Equity | 89786000 | 0.010034972 | ||||||||
Quarter Ended 03282020
| ACCOUNTING & FINANCIAL RATIOS | |||||||||||||
| CURRENT RATIO (Current Assets / Current Liabilities) | TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) | ||||||||||||
| Current Assets | 33274000 | Total Revenue | 18009000 | ||||||||||
| Current Liabilities | 35473000 | 0.9380091901 | Total Assets | 206294000 | 0.0872977401 | ||||||||
| WORKING CAPITAL (Current Assets - Current Liabilities) | FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) | ||||||||||||
| Current Assets | 33274000 | Total Assets | 206294000 | ||||||||||
| Current Liabilities | 35473000 | -2199000 | Shareholder's Equity | 94877000 | 2.1743309759 | ||||||||
| DEBT RATIO (Total Debt / Total Assets) | NET PROFIT MARGIN (Net Income / Total Revenue) | ||||||||||||
| Total Debt | 111417000 | Net Income | 460000 | ||||||||||
| Total Assets | 206294000 | 0.5400884175 | Total Revenue | 18009000 | 0.0255427842 | ||||||||
| EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | RETURN ON ASSETS (Net Income / Total Assets) | ||||||||||||
| Net Income | 460000 | Net Income | 460000 | ||||||||||
| Shares Outstanding | 1808000 | 0.2544247788 | Total Assets | 206294000 | 0.0022298273 | ||||||||
| PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | ||||||||||||
| Stock Price | 96.4 | NI - Pref. Div. | 460000 | ||||||||||
| EPS | 0.2544247788 | 378.8939130435 | Shareholder's Equity | 94877000 | 0.0048483826 | ||||||||
