|
|
|
|
|
A How-To-Do-It Book & CD-ROM
Finance Guide with Formulated Solutions for Excel
Subtitle: Finance Applications, Formulas and Mathematics
By Roger S. Bennitt |
|
|
|
|
| For over 25 years, Roger S. Bennitt, CFO of Contact Systems, Inc., a manufacturing company, has collected, developed, and analyzed finance formulas and applications. The result is a book and CD-ROM with 292 computer worksheets linked for use with Microsoft® Excel for Windows. |
|
| With a computer projector and the CD-ROM, you can you can do "what if" calculations live in front of your audience.
Includes original applications and formulas not available anywhere else.Readers report of searching for years to find the information covered here.
Targeted users include corporate finance, CPAs, financial planners, management consultants, entrepreneurs, individual investors, educators, and daily users of Excel.
You never need to manually enter a formula. The easy-to-use computerized data is supportive of today's "real time" work environment. Real time means computerized data, easy to use, and with random access. Just fill in the variables and the answers spill out!
Examples from the CD-ROM and sample pages from the book can be viewed in PDF format:
Examples from the CD-ROM
Page 145 Structured Settlement
Page 206 Future Value
Page 55 Budgeted Loan Payments
|
|
 |
|
| The range of topics includes |
- Borrowing,
- Business profitability,
- Capital spending,
- Discounted cash flow,
- Financial planning,
- Investing,
- Leasing,
- Probability,
- Statistics,
- Valuation,
and improving your Excel skills.
A challenging and difficult subject is made easy in a simple and innovative way. The concept and procedural techniques are explained.
All formulas are presented in a single-line format with variables spelled out, with variables entered into the formulas, and again with cell addresses for variables.
For each application, a case study is solved, the calculation shown, and the answer explained.
|
|
|
|
|
|
By
Roger S. Bennitt
|
|
Rated five stars by
Amazon.com |
|
| Top Ten Reasons why you need this book & CD-ROM! |
|
|
|
|
Top Ten Reasons
why you need Finance Guide with
Formulated Solutions for Excel Book & CD-ROM
|
|
|
| 1 |
The book and software
are a complete finance reference for corporate, advisory, government, non-profit,
and personal finance use. |
6 |
When you review the book page by page, you will be amazed at what you can do and explain to others with no significant effort on your part. |
| 2 |
All 292 computer worksheets are linked on a CD-ROM for easy access to any Excel spreadsheet version 97 or later. The linked files provide a source of material for Power Point presentations. The CD-ROM also contains 80 loan amortization templates. |
7 |
Valuation! Use the
dedicated applications and discounted cash flow formulas to value anything,
such as a business, a structured settlement, bonds, the IRS real estate
valuation method, a pension with fixed or COLA payments including a do-it-yourself
COLA pension to preserve purchasing power, and the value to buy or sell
a fixed or adjustable rate mortgage. |
| 3 |
Save research and
startup time on your next project. You get completed applications and a
quick source of formulas for adapting to your continuing needs. Includes
all of the discounted cash flow formulas that you will ever need. Just fill
in the variables and the answers spill out. |
8 |
Uncover the flaws
in your strategic plan with the breakeven and profitability models. Manage
business profitability to the dollar using different scenarios of expansion,
downsizing and right sizing for any business regardless of size. The profitability
models are so dynamic, concise, and easy to understand that you will proudly
use this application for your next presentation to your CEO and Board. |
| 4 |
A special chapter, Microsoft Excel Training Guide, lists commands in alphabetical order for a quick reference. Little-known commands, shortcuts, and interactions with other programs will increase both productivity and your enjoyment of using Excel. |
9 |
Includes standard
deviation, exponential smoothing, statistical sampling, sample sizes, and
probability. Predict the outcome of elections. Calculate sample sizes for
inspection, audits, and even the Neilsen TV ratings. Solve ROI for a single
investment with an automated date calculation and an original ROI formula
never before published. |
| 5 |
Includes the economic value added,
free cash flow, and the Black & Scholes volatility and option pricing
formulas. Also has the capital or operating lease 90% test, interest rate
of a lease, lease payment calculator for lessors, and net present value
of lease payments. |
10 |
Have you seen the
recent articles in the Wall Street Journal? Employers must now advise employees
about retirement planning or face class action litigation for the opportunity
cost of their selecting low-yield investments. There are applications for
retirement income planning, opportunity cost, IRA minimum distribution or
substantially equal payments, and social security planning and payout. |
| |
Unique! The only reference book and CD-ROM on the subject.
Includes a bibliography, glossary, and index.
|
|
|
| Top |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
