000			11325nam a2200433Ii 4500
005			20250919002907.0
008			150407s2015 maua 001 0 eng
020			_a1285432274
020			_a9781285432274 (paperback) _cRM467.31
039		9	_a201506221551 _batika _c201506160944 _dhamudah _y04-07-2015 _zhamudah
090			_aHG4012.5.M397 2015
090			_aHG4012.5 _b.M397 2015
100	1		_aMayes, Timothy R., _eauthor.
245	1	0	_aFinancial analysis with microsoft excel / _cTimothy R. Mayes, Metropolitan State College of Denver, Todd M. Shank, University of South Florida - St. Petersburg.
250			_aSeventh edition.
264		1	_aBoston, MA : _bCengage Learning, _c[2014]
264		4	_cò015
300			_axxiii 520 pages : _billustrations ; _c25 cm
336			_atext _2rdacontent
337			_aunmediated _2rdamedia
338			_avolume _2rdacarrier
500			_aCover title: Financial Analysis with MicrosoftŸcel{u0CB0}13.
500			_aIncludes index.
505	0	0	_aMachine generated contents note: _gch. 1 _tIntroduction to Excel 2013 -- _tSpreadsheet Uses -- _tStarting Microsoft Excel -- _tParts of the Excel Screen -- _tThe File Tab and Quick Access Toolbar -- _tThe Home Tab -- _tThe Formula Bar -- _tThe Worksheet Area -- _tSheet Tabs -- _tStatus Bar -- _tNavigating the Worksheet -- _tSelecting a Range of Cells -- _tUsing Defined Names -- _tEntering Text and Numbers -- _tFormatting and Alignment Options -- _tFormatting Numbers -- _tAdding Borders and Shading -- _tEntering Formulas -- _tCopying and Moving Formulas -- _tMathematical Operators -- _tParentheses and the Order of Operations -- _tUsing Excel's Built-In Functions -- _tUsing the Insert Function Dialog Box -- _t'Dot Functions' in Excel 2013 -- _tUsing User-Defined Functions -- _tCreating Graphics -- _tCreating Charts in a Chart Sheet -- _tCreating Embedded Charts -- _tFormatting Charts -- _tChanging the Chart Type -- _tCreating Sparkline Charts -- _tPrinting -- _tUsing Excel with Other Applications -- _tQuitting Excel -- _tBest Practices for Spreadsheet Models -- _tSummary -- _tProblems -- _tInternet Exercise -- _gch. 2 _tThe Basic Financial Statements -- _tThe Income Statement -- _tBuilding an Income Statement in Excel -- _tThe Balance Sheet -- _tBuilding a Balance Sheet in Excel -- _tImproving Readability: Custom Number Formats -- _tCommon-Size Financial Statements -- _tCreating Common-Size Income Statements -- _tCreating a Common-Size Balance Sheet -- _tBuilding a Statement of Cash Flows -- _tUsing Excel's Outliner -- _tCommon-Size Statement of Cash Flows -- _tSummary -- _tProblems -- _tInternet Exercise -- _gch. 3 _tThe Cash Budget -- _tThe Worksheet Area -- _tUsing Date Functions -- _tCalculating Text Strings -- _tSales and Collections -- _tPurchases and Payments -- _tCollections and Disbursements -- _tCalculating the Ending Cash Balance -- _tRepaying Short-Term Borrowing -- _tUsing the Cash Budget for What-If Analysis -- _tThe Scenario Manager -- _tAdding Interest and Investment of Excess Cash -- _tCalculating Current Borrowing -- _tUsing the Formula Auditing Tools to Avoid Errors -- _tCalculating Current Investing -- _tWorking Through the Example -- _tSummary -- _tProblems -- _gch. 4 _tFinancial Statement Analysis Tools -- _tLiquidity Ratios -- _tThe Current Ratio -- _tThe Quick Ratio -- _tEfficiency Ratios -- _tInventory Turnover Ratio -- _tAccounts Receivable Turnover Ratio -- _tAverage Collection Period -- _tFixed Asset Turnover Ratio -- _tTotal Asset Turnover Ratio -- _tLeverage Ratios -- _tThe Total Debt Ratio -- _tThe Long-Term Debt Ratio -- _tThe Long-Term Debt to Total Capitalization Ratio -- _tThe Debt to Equity Ratio -- _tThe Long-Term Debt to Equity Ratio -- _tCoverage Ratios -- _tThe Times Interest Earned Ratio -- _tThe Cash Coverage Ratio -- _tProfitability Ratios -- _tThe Gross Profit Margin -- _tThe Operating Profit Margin -- _tThe Net Profit Margin -- _tReturn on Total Assets -- _tReturn on Equity -- _tReturn on Common Equity -- _tDuPont Analysis -- _tAnalysis of EPI's Profitability Ratios -- _tFinancial Distress Prediction -- _tThe Original Z-Score Model -- _tThe Z-Score Model for Private Firms -- _tUsing Financial Ratios -- _tTrend Analysis -- _tComparing to Industry Averages -- _tCompany Goals and Debt Covenants -- _tAutomating Ratio Analysis -- _tEconomic Profit Measures of Performance -- _tSummary -- _tProblems -- _tInternet Exercise -- _gch. 5 _tFinancial Forecasting -- _tThe Percent of Sales Method -- _tForecasting the Income Statement -- _tForecasting Assets on the Balance Sheet -- _tForecasting Liabilities on the Balance Sheet -- _tDiscretionary Financing Needed -- _tUsing Iteration to Eliminate DFN -- _tOther Forecasting Methods -- _tLinear Trend Extrapolation -- _tRegression Analysis -- _tStatistical Significance -- _tSummary -- _tProblems -- _tInternet Exercises -- _gch. 6 _tBreak-Even and Leverage Analysis -- _tBreak-Even Points -- _tCalculating Break-Even Points in Excel -- _tOther Break-Even Points -- _tUsing Goal Seek to Calculate Break-Even Points -- _tLeverage Analysis -- _tThe Degree of Operating Leverage -- _tThe Degree of Financial Leverage -- _tThe Degree of Combined Leverage -- _tExtending the Example -- _tLinking Break-Even Points and Leverage Measures -- _tSummary -- _tProblems -- _tInternet Exercise -- _gch. 7 _tThe Time Value of Money -- _tFuture Value -- _tUsing Excel to Find Future Values -- _tPresent Value -- _tAnnuities -- _tPresent Value of an Annuity -- _tFuture Value of an Annuity -- _tSolving for the Annuity Payment -- _tSolving for the Number of Periods in an Annuity -- _tSolving for the Interest Rate in an Annuity -- _tDeferred Annuities -- _tGraduated Annuities -- _tPresent Value of a Graduated Annuity -- _tFuture Value of a Graduated Annuity -- _tUneven Cash Flow Streams -- _tSolving for the Yield in an Uneven Cash Flow Stream -- _tNonannual Compounding Periods -- _tContinuous Compounding -- _tSummary -- _tProblems -- _gch. 8 _tCommon Stock Valuation -- _tWhat Is Value? -- _tFundamentals of Valuation -- _tDetermining the Required Rate of Return -- _tA Simple Risk Premium Model -- _tCAPM: A More Scientific Model -- _tValuing Common Stocks -- _tThe Constant-Growth Dividend Discount Model -- _tThe Two-Stage Growth Model -- _tThree-Stage Growth Models -- _tAlternative Discounted Cash Flow Models -- _tThe Earnings Model -- _tThe Free Cash Flow Model -- _tRelative Value Models -- _tPreferred Stock Valuation -- _tSummary -- _tProblems -- _tInternet Exercise -- _gch. 9 _tBond Valuation -- _tBond Valuation -- _tValuing Bonds Between Coupon Dates -- _tUsing Excel's Advanced Bond Functions -- _tBond Return Measures -- _tCurrent Yield -- _tYield to Maturity -- _tYield to Call -- _tReturns on Discounted Debt Securities -- _tThe U.S. Treasury Yield Curve -- _tBond Price Sensitivities -- _tChanges in the Required Return -- _tChanges in Term to Maturity -- _tComparing Two Bonds with Different Maturities -- _tComparing Two Bonds with Different Coupon Rates -- _tDuration and Convexity -- _tDuration -- _tModified Duration -- _tVisualizing the Predicted Price Change -- _tConvexity -- _tSummary -- _tProblems -- _tInternet Exercise -- _gch. 10 _tThe Cost of Capital -- _tThe Appropriate'Hurdle' Rate -- _tThe Weighted Average Cost of Capital -- _tDetermining the Weights -- _tWACC Calculations in Excel -- _tCalculating the Component Costs -- _tThe Cost of Common Equity -- _tThe Cost of Preferred Equity -- _tThe Cost of Debt -- _tUsing Excel to Calculate the Component Costs -- _tThe After-Tax Cost of Debt -- _tThe Cost of Preferred Stock -- _tThe Cost of Common Stock -- _tThe Role of Flotation Costs -- _tAdding Flotation Costs to Our Worksheet -- _tThe Cost of Retained Earnings -- _tThe Marginal WACC Curve -- _tFinding the Break-Points -- _tCreating the Marginal WACC Chart -- _tSummary -- _tProblems -- _tInternet Exercise -- _gch. 11 _tCapital Budgeting -- _tEstimating the Cash Flows -- _tThe Initial Outlay -- _tThe Annual After-Tax Operating Cash Flows -- _tThe Terminal Cash Flow -- _tEstimating the Cash Flows: An Example -- _tCalculating the Relevant Cash Flows -- _tMaking the Decision -- _tThe Payback Method -- _tThe Discounted Payback Period -- _tNet Present Value -- _tThe Profitability Index -- _tThe Internal Rate of Return -- _tProblems with the IRR -- _tThe Modified Internal Rate of Return -- _tSensitivity and Scenario Analysis -- _tNPV Profile Charts -- _tScenario Analysis -- _tThe Optimal Capital Budget -- _tOptimal Capital Budget Without Capital Rationing -- _tOptimal Capital Budget Under Capital Rationing -- _tOther Techniques -- _tSummary -- _tProblems -- _gch. 12 _tRisk and Capital Budgeting -- _tReview of Some Useful Statistical Concepts -- _tThe Expected Value -- _tMeasures of Dispersion -- _tUsing Excel to Measure Risk -- _tThe Freshly Frozen Fish Company Example -- _tIntroducing Uncertainty -- _tSensitivity Analysis -- _tScenario Analysis -- _tCalculating the Expected NPV from the Scenarios -- _tCalculating the Variance and Standard Deviation -- _tCalculating the Probability of a Negative NPV -- _tMonte Carlo Simulation -- _tThe Risk-Adjusted Discount Rate Method -- _tThe Certainty-Equivalent Approach -- _tSummary -- _tProblems -- _gch.
505	0	0	_t13 _tPortfolio Statistics and Diversification -- _tPortfolio Diversification Effects -- _tDetermining Portfolio Risk and Return -- _tPortfolio Standard Deviation -- _tChanging the Weights -- _tPortfolios with More than Two Securities -- _tCreating a Variance/Covariance Matrix -- _tCalculating the Portfolio Standard Deviation -- _tThe Efficient Frontier -- _tLocating Portfolios on the Efficient Frontier in Excel -- _tCharting the Efficient Frontier -- _tThe Capital Market Line -- _tCharting the Capital Market Line -- _tIdentifying the Market Portfolio -- _tUtility Functions and the Optimal Portfolio -- _tCharting Indifference Curves -- _tThe Capital Asset Pricing Model -- _tThe Security Market Line -- _tSummary -- _tProblems -- _tInternet Exercise -- _gch. 14 _tWriting User-Defined Functions with VBA -- _tWhat Is a Macro? -- _tTwo Types of Macros -- _tThe Visual Basic Editor -- _tThe Project Explorer -- _tThe Code Window -- _tThe Parts of a Function -- _tWriting Your First User-Defined Function -- _tWriting More Complicated Functions -- _tVariables and Data Types -- _tThe If-Then-Else Statement -- _tLooping Statements -- _tUsing Worksheet Functions in VBA -- _tUsing Optional Arguments -- _tUsing ParamArray for Unlimited Arguments -- _tDebugging VBA Code -- _tBreakpoints and Code Stepping -- _tThe Watch Window -- _tThe Immediate Window -- _tCreating Excel Add-Ins -- _tBest Practices for VBA -- _tSummary -- _tProblems -- _gch. 15 _tAnalyzing Datasets with Tables and Pivot Tables -- _tCreating and Using an Excel Table -- _tRemoving Duplicate Records from the Table -- _tFiltering the Table -- _tSorting and Filtering Numeric Fields -- _tUsing Formulas in Tables -- _tUsing Pivot Tables -- _tCreating a Pivot Table
630	0	0	_aMicrosoft Excel (Computer file)
650		0	_aCorporations _xFinance _xComputer programs.
650		0	_aBusiness _xComputer programs.
650		0	_aElectronic spreadsheets.
700	1		_aShank, Todd M., _eauthor.
907			_a.b16114826 _b2019-11-12 _c2019-11-12
942			_c01 _n0 _kHG4012.5.M397 2015
914			_avtls003583136
990			_anab
991			_aFakulti Ekonomi dan Pengurusan
998			_at _b2015-07-04 _cm _da _feng _gmau _y0 _z.b16114826
999			_c590467 _d590467