A F8 > > AutoSave ON .. . FIN 320 Project Two Spread sheet - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 14 AA D Wrap Text v General Paste BI Uv A Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze ormatting as Table Styles Filter Select Data D5 X V fx B C D E F G H K M N O P Q R S ACCOUNTING & FINANCIAL RATIOS - W N - CURRENT RATIO (Current Assets / Current Liabilities) TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) Current Assets Total Revenue Current Liabilities #DIV/O! Total Assets #DIV/O! WORKING CAPITAL (Current Assets - Current Liabilities) FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) Current Assets Total Assets Current Liabilities o Shareholder's Equity #DIV/O! DEBT RATIO (Total Liabilities / Total Assets) NET PROFIT MARGIN (Net Income / Total Revenue) Total Liabilities Net Income Total Assets #DIV/O! Total Revenue #DIV/O! EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) RETURN ON ASSETS (Net Income / Total Assets) Net Income Net Income Shares Outstanding #DIV/O! Total Assets #DIV/O! 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 #DIV/O! Shareholder's Equity #DIV/O! 40 RATIOS Monthly Annual PV FV PV - Lump Sum FV - Lump Sum NPV + Ready - + 100%A FB ) ? " AutoSave ON .. . FIN 320 Project Two Spread sheet - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri 12 Share AA Comments D Wrap Text v General Paste BI Uv A FE Merge & Center v $ ~ % " Conditional Format Cell J V Insert Delete Format V ormatting as Table Sort & A11 Styles Find & X Analyze fx Filter Select Data B D E F G H L M N P Q R S Rate of Return Time Value of Money - Monthly Compounding U V W X Y Z AA AWN Initial Investment Month Year 1 2 3 4 5 6 Interest So 8 9 10 $0 11 12 Investment Value SO sol sol $0 sol sol $0 $0 sol $0 sol $0 SO $0 so So Year 2 Month Interest SO So so 5 6 so 8 Investment Value $0 so $0 so 9 10 12 So So SO So So SO So SO sol sol So Year 3 so Month 2 3 4 Interest 5 6 SO So 8 9 So SO 10 11 12 Investment Value sol sol so sol so so so sol so so sol SO so SO 18 5 sot Month Year 4 SO 4 Interest 5 6 8 9 So so so sol 10 11 12 Investment Value SO So so SO so so so SO so SO SO so SO so Month Year 5 2 Interest 4 6 so SO 7 SO SO 8 9 SO so so 10 11 12 Investment Value SO SO $0 SO So sol so SO So so Year 6 so Month Interest 4 6 $0 so SO 8 9 10 12 Investment Value sol sol sol sol SO SO so sol so sol so Year 7 so Month Interest so SO 5 6 7 SO 8 so 9 so 10 11 12 Investment Value so sol so sol So sol so sol so so sol Year 8 so Month 2 3 Interest 4 So SO so sol 6 sol So 8 9 10 Investment Value sol $0 11 12 so so So so so so sol sol so so SO SO Year 9 SO so Month 4 5 Interest 6 8 9 So So $0 10 11 12 Investment Value SO so So So SO so so $0 sol SO SO Year 10 so so SO SO Month 2 Interest 5 6 So $0 $0 8 9 10 12 Investment Value so so $0 11 SO SO SO SO SO SO SO sol SO 50 so 43 44 RATIOS Monthly Annual PV FV PV - Lump Sum FV - Lump Sum NPV Ready + - + 100%A FB ) ? " AutoSave ON .. . FIN 320 Project Two Spread sheet - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 12 AA D Wrap Text v General Paste BI U v A = FE Merge & Center v v % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze ormatting as Table Styles Filter Select Data C17 X V fx B C D E F G H K L M N O P Q R S T U V W X Y Z AA Time Value of Money - Annual Compounding Rate of Return Year 6 8 9 W N 10 Initial Investment Interest 50 So $0 SO Investment Value SO so SO so SO So sol So So so 43 44 D RATIOS Monthly Annual PV FV PV - Lump Sum FV - Lump Sum NPV + Ready - + 100%A FB ) ? " AutoSave ON ... FIN 320 Project Two Spread sheet - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 14 AA D Wrap Text General J V Paste BI UV A Merge & Center v $ Conditional Format Cell Insert Delete Format Sort & Find & Analyze ormatting as Table Styles Filter Select Data A1 X V fx Time Value of Money - Present Value Annuity B C D E H K M N O P Q R S U V W X Z AA Time Value of Money - Present Value Annuity 2 Number of Year A W Rate of Return $0.00 Payment 43 44 RATIOS Monthly Annual PV FV PV - Lump Sum FV - Lump Sum NPV + Ready - + 100%A FB ) ? " AutoSave ON ... FIN 320 Project Two Spread sheet - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 14 AA D Wrap Text v General J V Paste BIUV A Merge & Center v $ Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data A1 X V fx Time Value of Money - Future Value of Lump Sum B C D E F G H K M N O P Q R S T U V W X Y Z AA AB Time Value of Money - Future Value of Lump Sum 2 Rate 3 Years $0.00 4 Initial Investment 43 RATIOS Monthly Annual PV FV PV - Lump Sum FV - Lump Sum NPV + Ready - + 100%A F8 > > AutoSave ON .. . FIN 320 Project Two Spread sheet - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 12 AA D Wrap Text v Percentage Paste BIU v A Merge & Center v v % " 508 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data B6 X V fx A B C D E F G H J K L M N O P Q R S U V W X Y Net Present Value (NPV) Calculator Building W N 4 Initial Investment Year 1 2 3 4 5 6 7 8 9 10 5 Annual Cash Inflows Cash Flows $0 so $0 $0 $0 SO 6 Discount Rate NPV= So Year 11 12 13 14 15 16 17 18 19 20 7 Number of Years Cash Flows So $0 $0 SO $0 SO 8 Salvage Value 12 Equipment 13 14 Initial Investment Year 1 2 3 4 5 6 7 8 9 10 15 Annual Cash Inflows Cash Flows $O so $ol SO $0 So SO So SO 16 Discount Rate NPV = $0 Year 11 12 13 14 15 16 17 18 19 20 7 Number of Years Cash Flows So So SO So SO So so $O 8 Salvage Value Bonds Initial Investment 5 Annual Cash Inflows 26 Discount Rate NPV = [ Year 1 2 3 4 5 8 9 10 27 Number of Years Cash Flows SO SO SO SO so so SO SO SO SO 8 Principal Returned 29 RATIOS Monthly Annual PV FV PV - Lump Sum FV - Lump Sum NPV + Ready - + 100%