Financial Analysis with Microsoft Excel 2007
Help your students master THE calculating tool of choice for today’s financial professionals -- Excel -- while gaining a strong foundation in corporate finance. With Mayes/Shank’s FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2007, 5th Edition, you can take your students to a new level of proficiency in using Excel 2007 to solve real financial problems. The book’s solid content covers all of the topics from today’s corporate finance course, including financial statements, budgets, the Market Security Line, pro forma statements, cost of capital, equities, and debt. A reader-friendly, self-directed learning approach and numerous study tools make this book an ideal resource for independent learning as well as a valuable long-term reference tool. Because today’s typical students enter college with basic spreadsheet skills, this new edition takes learning to a new level -- covering the basics early and moving quickly into many of the more advanced and most powerful features of Excel. The book’s easy-to-understand presentation helps students build upon or transfer skills from other spreadsheet programs as they establish a strong understand of contemporary corporate finance. Give your students the valuable, highly marketable skills in Excel and corporate finance that they need to succeed now and throughout their careers with the latest in Mayes/Shank’s FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2007, 5th Edition.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
What people are saying - Write a review
Introduction to Excel 2007
The Basic Financial Statements
The Cash Budget
Financial Statement Analysis Tools
BreakEven and Leverage Analysis
The Time Value of Money
Common Stock Valuation
Other editions - View all
add-in after-tax amount annual annuity assume average balance sheet bond borrowing break-point built-in function calculate cash budget cash flows cell Chapter chart choose column common stock copy this formula create defined determine dialog box discount rate discounted payback dividend dividend discount model EBIT efficient frontier enter the formula enter the label EPI’s equation example Excel Exhibit expected return Figure firm firm’s forecast future value growth rate income statement insert investment investors leverage long-term debt maturity menu NOPAT Note number format P/E ratio payback period payment percentage preferred stock present value problem range rate of return ratio required rate required return result right-click risk premium scenario analysis securities Solver spreadsheet standard deviation Supreme Shoe TABLE Total Assets unadjusted cash user-defined function WACC workbook worksheet yield yield to maturity