I need this project done by 04/17, the assumptions are at the bottom, I have attached the formulas and the template
maddiehuneycutt
FIN320ProjectTwoFinancialFormulas.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 | |||||||||||||||||
RATIOS
| ACCOUNTING & FINANCIAL RATIOS | |||||||||||||
| CURRENT RATIO (Current Assets / Current Liabilities) | TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) | ||||||||||||
| Current Assets | 51,237,000,000 | Total Revenue | 82,584,000,000 | ||||||||||
| Current Liabilities | 42,493,000,000 | 1.2057750688 | Total Assets | 174,894,000,000 | 0.4721945864 | ||||||||
| 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 thiscurrent 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 | 51,237,000,000 | Total Assets | 174,894,000,000 | ||||||||||
| Current Liabilities | 42,493,000,000 | 8744000000 | Shareholder's Equity | 63,278,000,000 | 2.7638989854 | ||||||||
| DEBT RATIO (Total Debt / Total Assets) | NET PROFIT MARGIN (Net Income / Total Revenue) | ||||||||||||
| Total Debt | 34,434,000,000 | Net Income | 14,714,000,000 | ||||||||||
| Total Assets | 174,894,000,000 | 0.1968849703 | Total Revenue | 82,584,000,000 | 0.1781701056 | ||||||||
| EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | RETURN ON ASSETS (Net Income / Total Assets) | ||||||||||||
| Net Income | 14,714,000,000 | Net Income | 14,714,000,000 | ||||||||||
| Shares Outstanding | 2,632,512,000.00 | 5.5893382442 | Total Assets | 174,894,000,000 | 0.0841309593 | ||||||||
| PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | ||||||||||||
| Stock Price | 165.01 | NI - Pref. Div. | 4,233,000,000 | ||||||||||
| EPS | 5.51 | 29.9473684211 | Shareholder's Equity | 63,278,000,000 | 0.0668952875 | ||||||||
