MARC details
| 000 -LEADER |
|---|
| fixed length control field |
11325nam a2200433Ii 4500 |
| 005 - DATE AND TIME OF LATEST TRANSACTION |
|---|
| control field |
20250919002907.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
|---|
| fixed length control field |
150407s2015 maua 001 0 eng |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
1285432274 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER |
|---|
| International Standard Book Number |
9781285432274 (paperback) |
| Terms of availability |
RM467.31 |
| 039 #9 - LEVEL OF BIBLIOGRAPHIC CONTROL AND CODING DETAIL [OBSOLETE] |
|---|
| Level of rules in bibliographic description |
201506221551 |
| Level of effort used to assign nonsubject heading access points |
atika |
| Level of effort used to assign subject headings |
201506160944 |
| Level of effort used to assign classification |
hamudah |
| y |
04-07-2015 |
| z |
hamudah |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN) |
|---|
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) |
HG4012.5.M397 2015 |
| 090 ## - LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN) |
|---|
| Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR) |
HG4012.5 |
| Local cutter number (OCLC) ; Book number/undivided call number, CALL (RLIN) |
.M397 2015 |
| 100 1# - MAIN ENTRY--PERSONAL NAME |
|---|
| Personal name |
Mayes, Timothy R., |
| Relator term |
author. |
| 245 10 - TITLE STATEMENT |
|---|
| Title |
Financial analysis with microsoft excel / |
| Statement of responsibility, etc. |
Timothy R. Mayes, Metropolitan State College of Denver, Todd M. Shank, University of South Florida - St. Petersburg. |
| 250 ## - EDITION STATEMENT |
|---|
| Edition statement |
Seventh edition. |
| 264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Place of production, publication, distribution, manufacture |
Boston, MA : |
| Name of producer, publisher, distributor, manufacturer |
Cengage Learning, |
| Date of production, publication, distribution, manufacture, or copyright notice |
[2014] |
| 264 #4 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE |
|---|
| Date of production, publication, distribution, manufacture, or copyright notice |
ò015 |
| 300 ## - PHYSICAL DESCRIPTION |
|---|
| Extent |
xxiii 520 pages : |
| Other physical details |
illustrations ; |
| Dimensions |
25 cm |
| 336 ## - CONTENT TYPE |
|---|
| Content type term |
text |
| Source |
rdacontent |
| 337 ## - MEDIA TYPE |
|---|
| Media type term |
unmediated |
| Source |
rdamedia |
| 338 ## - CARRIER TYPE |
|---|
| Carrier type term |
volume |
| Source |
rdacarrier |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Cover title: Financial Analysis with MicrosoftŸcel{u0CB0}13. |
| 500 ## - GENERAL NOTE |
|---|
| General note |
Includes index. |
| 505 00 - FORMATTED CONTENTS NOTE |
|---|
| Formatted contents note |
Machine generated contents note: |
| Miscellaneous information |
ch. 1 |
| Title |
Introduction to Excel 2013 -- |
| -- |
Spreadsheet Uses -- |
| -- |
Starting Microsoft Excel -- |
| -- |
Parts of the Excel Screen -- |
| -- |
The File Tab and Quick Access Toolbar -- |
| -- |
The Home Tab -- |
| -- |
The Formula Bar -- |
| -- |
The Worksheet Area -- |
| -- |
Sheet Tabs -- |
| -- |
Status Bar -- |
| -- |
Navigating the Worksheet -- |
| -- |
Selecting a Range of Cells -- |
| -- |
Using Defined Names -- |
| -- |
Entering Text and Numbers -- |
| -- |
Formatting and Alignment Options -- |
| -- |
Formatting Numbers -- |
| -- |
Adding Borders and Shading -- |
| -- |
Entering Formulas -- |
| -- |
Copying and Moving Formulas -- |
| -- |
Mathematical Operators -- |
| -- |
Parentheses and the Order of Operations -- |
| -- |
Using Excel's Built-In Functions -- |
| -- |
Using the Insert Function Dialog Box -- |
| -- |
'Dot Functions' in Excel 2013 -- |
| -- |
Using User-Defined Functions -- |
| -- |
Creating Graphics -- |
| -- |
Creating Charts in a Chart Sheet -- |
| -- |
Creating Embedded Charts -- |
| -- |
Formatting Charts -- |
| -- |
Changing the Chart Type -- |
| -- |
Creating Sparkline Charts -- |
| -- |
Printing -- |
| -- |
Using Excel with Other Applications -- |
| -- |
Quitting Excel -- |
| -- |
Best Practices for Spreadsheet Models -- |
| -- |
Summary -- |
| -- |
Problems -- |
| -- |
Internet Exercise -- |
| Miscellaneous information |
ch. 2 |
| Title |
The Basic Financial Statements -- |
| -- |
The Income Statement -- |
| -- |
Building an Income Statement in Excel -- |
| -- |
The Balance Sheet -- |
| -- |
Building a Balance Sheet in Excel -- |
| -- |
Improving Readability: Custom Number Formats -- |
| -- |
Common-Size Financial Statements -- |
| -- |
Creating Common-Size Income Statements -- |
| -- |
Creating a Common-Size Balance Sheet -- |
| -- |
Building a Statement of Cash Flows -- |
| -- |
Using Excel's Outliner -- |
| -- |
Common-Size Statement of Cash Flows -- |
| -- |
Summary -- |
| -- |
Problems -- |
| -- |
Internet Exercise -- |
| Miscellaneous information |
ch. 3 |
| Title |
The Cash Budget -- |
| -- |
The Worksheet Area -- |
| -- |
Using Date Functions -- |
| -- |
Calculating Text Strings -- |
| -- |
Sales and Collections -- |
| -- |
Purchases and Payments -- |
| -- |
Collections and Disbursements -- |
| -- |
Calculating the Ending Cash Balance -- |
| -- |
Repaying Short-Term Borrowing -- |
| -- |
Using the Cash Budget for What-If Analysis -- |
| -- |
The Scenario Manager -- |
| -- |
Adding Interest and Investment of Excess Cash -- |
| -- |
Calculating Current Borrowing -- |
| -- |
Using the Formula Auditing Tools to Avoid Errors -- |
| -- |
Calculating Current Investing -- |
| -- |
Working Through the Example -- |
| -- |
Summary -- |
| -- |
Problems -- |
| Miscellaneous information |
ch. 4 |
| Title |
Financial Statement Analysis Tools -- |
| -- |
Liquidity Ratios -- |
| -- |
The Current Ratio -- |
| -- |
The Quick Ratio -- |
| -- |
Efficiency Ratios -- |
| -- |
Inventory Turnover Ratio -- |
| -- |
Accounts Receivable Turnover Ratio -- |
| -- |
Average Collection Period -- |
| -- |
Fixed Asset Turnover Ratio -- |
| -- |
Total Asset Turnover Ratio -- |
| -- |
Leverage Ratios -- |
| -- |
The Total Debt Ratio -- |
| -- |
The Long-Term Debt Ratio -- |
| -- |
The Long-Term Debt to Total Capitalization Ratio -- |
| -- |
The Debt to Equity Ratio -- |
| -- |
The Long-Term Debt to Equity Ratio -- |
| -- |
Coverage Ratios -- |
| -- |
The Times Interest Earned Ratio -- |
| -- |
The Cash Coverage Ratio -- |
| -- |
Profitability Ratios -- |
| -- |
The Gross Profit Margin -- |
| -- |
The Operating Profit Margin -- |
| -- |
The Net Profit Margin -- |
| -- |
Return on Total Assets -- |
| -- |
Return on Equity -- |
| -- |
Return on Common Equity -- |
| -- |
DuPont Analysis -- |
| -- |
Analysis of EPI's Profitability Ratios -- |
| -- |
Financial Distress Prediction -- |
| -- |
The Original Z-Score Model -- |
| -- |
The Z-Score Model for Private Firms -- |
| -- |
Using Financial Ratios -- |
| -- |
Trend Analysis -- |
| -- |
Comparing to Industry Averages -- |
| -- |
Company Goals and Debt Covenants -- |
| -- |
Automating Ratio Analysis -- |
| -- |
Economic Profit Measures of Performance -- |
| -- |
Summary -- |
| -- |
Problems -- |
| -- |
Internet Exercise -- |
| Miscellaneous information |
ch. 5 |
| Title |
Financial Forecasting -- |
| -- |
The Percent of Sales Method -- |
| -- |
Forecasting the Income Statement -- |
| -- |
Forecasting Assets on the Balance Sheet -- |
| -- |
Forecasting Liabilities on the Balance Sheet -- |
| -- |
Discretionary Financing Needed -- |
| -- |
Using Iteration to Eliminate DFN -- |
| -- |
Other Forecasting Methods -- |
| -- |
Linear Trend Extrapolation -- |
| -- |
Regression Analysis -- |
| -- |
Statistical Significance -- |
| -- |
Summary -- |
| -- |
Problems -- |
| -- |
Internet Exercises -- |
| Miscellaneous information |
ch. 6 |
| Title |
Break-Even and Leverage Analysis -- |
| -- |
Break-Even Points -- |
| -- |
Calculating Break-Even Points in Excel -- |
| -- |
Other Break-Even Points -- |
| -- |
Using Goal Seek to Calculate Break-Even Points -- |
| -- |
Leverage Analysis -- |
| -- |
The Degree of Operating Leverage -- |
| -- |
The Degree of Financial Leverage -- |
| -- |
The Degree of Combined Leverage -- |
| -- |
Extending the Example -- |
| -- |
Linking Break-Even Points and Leverage Measures -- |
| -- |
Summary -- |
| -- |
Problems -- |
| -- |
Internet Exercise -- |
| Miscellaneous information |
ch. 7 |
| Title |
The Time Value of Money -- |
| -- |
Future Value -- |
| -- |
Using Excel to Find Future Values -- |
| -- |
Present Value -- |
| -- |
Annuities -- |
| -- |
Present Value of an Annuity -- |
| -- |
Future Value of an Annuity -- |
| -- |
Solving for the Annuity Payment -- |
| -- |
Solving for the Number of Periods in an Annuity -- |
| -- |
Solving for the Interest Rate in an Annuity -- |
| -- |
Deferred Annuities -- |
| -- |
Graduated Annuities -- |
| -- |
Present Value of a Graduated Annuity -- |
| -- |
Future Value of a Graduated Annuity -- |
| -- |
Uneven Cash Flow Streams -- |
| -- |
Solving for the Yield in an Uneven Cash Flow Stream -- |
| -- |
Nonannual Compounding Periods -- |
| -- |
Continuous Compounding -- |
| -- |
Summary -- |
| -- |
Problems -- |
| Miscellaneous information |
ch. 8 |
| Title |
Common Stock Valuation -- |
| -- |
What Is Value? -- |
| -- |
Fundamentals of Valuation -- |
| -- |
Determining the Required Rate of Return -- |
| -- |
A Simple Risk Premium Model -- |
| -- |
CAPM: A More Scientific Model -- |
| -- |
Valuing Common Stocks -- |
| -- |
The Constant-Growth Dividend Discount Model -- |
| -- |
The Two-Stage Growth Model -- |
| -- |
Three-Stage Growth Models -- |
| -- |
Alternative Discounted Cash Flow Models -- |
| -- |
The Earnings Model -- |
| -- |
The Free Cash Flow Model -- |
| -- |
Relative Value Models -- |
| -- |
Preferred Stock Valuation -- |
| -- |
Summary -- |
| -- |
Problems -- |
| -- |
Internet Exercise -- |
| Miscellaneous information |
ch. 9 |
| Title |
Bond Valuation -- |
| -- |
Bond Valuation -- |
| -- |
Valuing Bonds Between Coupon Dates -- |
| -- |
Using Excel's Advanced Bond Functions -- |
| -- |
Bond Return Measures -- |
| -- |
Current Yield -- |
| -- |
Yield to Maturity -- |
| -- |
Yield to Call -- |
| -- |
Returns on Discounted Debt Securities -- |
| -- |
The U.S. Treasury Yield Curve -- |
| -- |
Bond Price Sensitivities -- |
| -- |
Changes in the Required Return -- |
| -- |
Changes in Term to Maturity -- |
| -- |
Comparing Two Bonds with Different Maturities -- |
| -- |
Comparing Two Bonds with Different Coupon Rates -- |
| -- |
Duration and Convexity -- |
| -- |
Duration -- |
| -- |
Modified Duration -- |
| -- |
Visualizing the Predicted Price Change -- |
| -- |
Convexity -- |
| -- |
Summary -- |
| -- |
Problems -- |
| -- |
Internet Exercise -- |
| Miscellaneous information |
ch. 10 |
| Title |
The Cost of Capital -- |
| -- |
The Appropriate'Hurdle' Rate -- |
| -- |
The Weighted Average Cost of Capital -- |
| -- |
Determining the Weights -- |
| -- |
WACC Calculations in Excel -- |
| -- |
Calculating the Component Costs -- |
| -- |
The Cost of Common Equity -- |
| -- |
The Cost of Preferred Equity -- |
| -- |
The Cost of Debt -- |
| -- |
Using Excel to Calculate the Component Costs -- |
| -- |
The After-Tax Cost of Debt -- |
| -- |
The Cost of Preferred Stock -- |
| -- |
The Cost of Common Stock -- |
| -- |
The Role of Flotation Costs -- |
| -- |
Adding Flotation Costs to Our Worksheet -- |
| -- |
The Cost of Retained Earnings -- |
| -- |
The Marginal WACC Curve -- |
| -- |
Finding the Break-Points -- |
| -- |
Creating the Marginal WACC Chart -- |
| -- |
Summary -- |
| -- |
Problems -- |
| -- |
Internet Exercise -- |
| Miscellaneous information |
ch. 11 |
| Title |
Capital Budgeting -- |
| -- |
Estimating the Cash Flows -- |
| -- |
The Initial Outlay -- |
| -- |
The Annual After-Tax Operating Cash Flows -- |
| -- |
The Terminal Cash Flow -- |
| -- |
Estimating the Cash Flows: An Example -- |
| -- |
Calculating the Relevant Cash Flows -- |
| -- |
Making the Decision -- |
| -- |
The Payback Method -- |
| -- |
The Discounted Payback Period -- |
| -- |
Net Present Value -- |
| -- |
The Profitability Index -- |
| -- |
The Internal Rate of Return -- |
| -- |
Problems with the IRR -- |
| -- |
The Modified Internal Rate of Return -- |
| -- |
Sensitivity and Scenario Analysis -- |
| -- |
NPV Profile Charts -- |
| -- |
Scenario Analysis -- |
| -- |
The Optimal Capital Budget -- |
| -- |
Optimal Capital Budget Without Capital Rationing -- |
| -- |
Optimal Capital Budget Under Capital Rationing -- |
| -- |
Other Techniques -- |
| -- |
Summary -- |
| -- |
Problems -- |
| Miscellaneous information |
ch. 12 |
| Title |
Risk and Capital Budgeting -- |
| -- |
Review of Some Useful Statistical Concepts -- |
| -- |
The Expected Value -- |
| -- |
Measures of Dispersion -- |
| -- |
Using Excel to Measure Risk -- |
| -- |
The Freshly Frozen Fish Company Example -- |
| -- |
Introducing Uncertainty -- |
| -- |
Sensitivity Analysis -- |
| -- |
Scenario Analysis -- |
| -- |
Calculating the Expected NPV from the Scenarios -- |
| -- |
Calculating the Variance and Standard Deviation -- |
| -- |
Calculating the Probability of a Negative NPV -- |
| -- |
Monte Carlo Simulation -- |
| -- |
The Risk-Adjusted Discount Rate Method -- |
| -- |
The Certainty-Equivalent Approach -- |
| -- |
Summary -- |
| -- |
Problems -- |
| Miscellaneous information |
ch. |
| 505 00 - FORMATTED CONTENTS NOTE |
|---|
| Title |
13 |
| -- |
Portfolio Statistics and Diversification -- |
| -- |
Portfolio Diversification Effects -- |
| -- |
Determining Portfolio Risk and Return -- |
| -- |
Portfolio Standard Deviation -- |
| -- |
Changing the Weights -- |
| -- |
Portfolios with More than Two Securities -- |
| -- |
Creating a Variance/Covariance Matrix -- |
| -- |
Calculating the Portfolio Standard Deviation -- |
| -- |
The Efficient Frontier -- |
| -- |
Locating Portfolios on the Efficient Frontier in Excel -- |
| -- |
Charting the Efficient Frontier -- |
| -- |
The Capital Market Line -- |
| -- |
Charting the Capital Market Line -- |
| -- |
Identifying the Market Portfolio -- |
| -- |
Utility Functions and the Optimal Portfolio -- |
| -- |
Charting Indifference Curves -- |
| -- |
The Capital Asset Pricing Model -- |
| -- |
The Security Market Line -- |
| -- |
Summary -- |
| -- |
Problems -- |
| -- |
Internet Exercise -- |
| Miscellaneous information |
ch. 14 |
| Title |
Writing User-Defined Functions with VBA -- |
| -- |
What Is a Macro? -- |
| -- |
Two Types of Macros -- |
| -- |
The Visual Basic Editor -- |
| -- |
The Project Explorer -- |
| -- |
The Code Window -- |
| -- |
The Parts of a Function -- |
| -- |
Writing Your First User-Defined Function -- |
| -- |
Writing More Complicated Functions -- |
| -- |
Variables and Data Types -- |
| -- |
The If-Then-Else Statement -- |
| -- |
Looping Statements -- |
| -- |
Using Worksheet Functions in VBA -- |
| -- |
Using Optional Arguments -- |
| -- |
Using ParamArray for Unlimited Arguments -- |
| -- |
Debugging VBA Code -- |
| -- |
Breakpoints and Code Stepping -- |
| -- |
The Watch Window -- |
| -- |
The Immediate Window -- |
| -- |
Creating Excel Add-Ins -- |
| -- |
Best Practices for VBA -- |
| -- |
Summary -- |
| -- |
Problems -- |
| Miscellaneous information |
ch. 15 |
| Title |
Analyzing Datasets with Tables and Pivot Tables -- |
| -- |
Creating and Using an Excel Table -- |
| -- |
Removing Duplicate Records from the Table -- |
| -- |
Filtering the Table -- |
| -- |
Sorting and Filtering Numeric Fields -- |
| -- |
Using Formulas in Tables -- |
| -- |
Using Pivot Tables -- |
| -- |
Creating a Pivot Table |
| 630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE |
|---|
| Uniform title |
Microsoft Excel (Computer file) |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Corporations |
| General subdivision |
Finance |
| -- |
Computer programs. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Business |
| General subdivision |
Computer programs. |
| 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
|---|
| Topical term or geographic name entry element |
Electronic spreadsheets. |
| 700 1# - ADDED ENTRY--PERSONAL NAME |
|---|
| Personal name |
Shank, Todd M., |
| Relator term |
author. |
| 907 ## - LOCAL DATA ELEMENT G, LDG (RLIN) |
|---|
| a |
.b16114826 |
| b |
2019-11-12 |
| c |
2019-11-12 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) |
|---|
| Koha item type |
AM |
| Suppress in OPAC |
No |
| Call number prefix |
HG4012.5.M397 2015 |
| 914 ## - VTLS Number |
|---|
| VTLS Number |
vtls003583136 |
| 990 ## - EQUIVALENCES OR CROSS-REFERENCES [LOCAL, CANADA] |
|---|
| Link information for 9XX fields |
nab |
| 991 ## - LOCAL NOTE (NAMA FAKULTI/INSTITUT/PUSAT) |
|---|
| a |
Fakulti Ekonomi dan Pengurusan |
| 998 ## - LOCAL CONTROL INFORMATION (RLIN) |
|---|
| Library |
PERPUSTAKAAN TUN SERI LANANG |
| Operator's initials, OID (RLIN) |
2015-07-04 |
| Cataloger's initials, CIN (RLIN) |
m |
| Material Type (Sierra) |
Printed Books |
| Language |
English |
| Country |
|
| -- |
0 |
| -- |
.b16114826 |
