- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Currently out of stock.
available for shipping or prepaid pickup only
Manage Your Money and Investments with Microsoft Excelby Peter G. Aitken
Synopses & Reviews
Sure you want to save money. We all do. But saving money is sometimes easier said than done. Did you know that there is a program probably already installed on your computer that can help you manage your money better? It's Microsoft Excel, part of the Microsoft Office suite. Manage Your Money and Investments with Excel can help you take control of your finances with Excel. Learn how to:
Book News Annotation:
This volume, aimed at beginners, explains how to use Microsoft Excel for managing finances. Aitken's reasoning for using the program is its simplicity over financial software and that it comes with most computers, and he notes that the book can be used with older versions. He begins with the basics; describes how to set up financial calculations, track net worth, and work with a budget; and explains using the program for checking accounts, credit cards, mortgages and loans for a car, and managing investments. He not only explains using the program, but also defines terms--types of mortgages, for instance. The CD-ROM contains templates that can be used with recent versions of Excel (2000, XP, and 2003) in the book, as well as a searchable electronic version of it. Aitken works in application development and technical writing and has written many books and articles on computer and software topics.
Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)
Book News Annotation:
This volume, aimed at beginners, explains how to use Microsoft Excel for managing finances. Aitken's reasoning for using the program is its simplicity over financial software and that it comes with most computers, and he notes that the book can be used with older versions. He begins with the basics; describes how to set up financial calculations, track net worth, and work with a budget; and explains using the program for checking accounts, credit cards, mortgages and loans for a car, and managing investments. He not only explains using the program, but also defines terms--types of mortgages, for instance. The CD-ROM contains templates that can be used with recent versions of Excel (2000, XP, and 2003) in the book, as well as a searchable electronic version of it. Aitken works in application development and technical writing and has written many books and articles on computer and software topics. Annotation Â©2006 Book News, Inc., Portland, OR (booknews.com)
About the Author
Peter Aitken was writing about computers and software before the first version of Excel was released. Since then he has written more than 40 books and innumerable magazine and Web articles on topics ranging from office applications and personal finance to application development and digital photography. Peter is also the proprietor of PGA Consulting, providing application development and technical writing services to clients since 1996. You can learn more about Peter's books at http://www.pgacon.com/books.htm.
© Copyright Pearson Education. All rights reserved.
Table of Contents
Who This Book Is For
More Information and Updates
I. UNDERSTANDING THE BASICS OF FINANCIAL CALCULATIONS.
1. Taking Control of Your Finances.
Facing the Problem
What Excel Can Do for You
Why Excel and Not Quicken or Money?
Using the Worksheet Templates
2. Using Excel to Work with Money.
Entering and Editing Data
Formatting the Worksheet
Formulas in Excel
Excel and Money
Formatting Money and Percentage Values
Charting Your Course
3. Working with Basic Financial Calculations.
Calculating Loan Payments
Calculating Principal Payments
Working with Future Value
Using the Present Value Function
Calculating Interest Rate
4. Tracking Your Net Worth.
What Is Net Worth?
Assets to Include
Liabilities to Include
The Net Worth Calculator
Interpreting Your Net Worth
Keeping Track over Time
II. TAKING CONTROL OF YOUR BANK AND CREDIT CARD ACCOUNTS.
5. Managing Your Money with a Budget.
What Is a Budget?
The Home Budget Calculator
Getting Started with Your Budget
Living with a Budget
Analyze Your Spending
Live Within Your Means
Balancing Your Budget
Watch Impulse Buying
Look for Sales
Learn to Cook
6. Being Smart with Your Checking Accounts.
How Checking Accounts Work
Types of Checking Accounts
Other Checking Account Fees
Understanding Debit Cards
Be Smart with ATM Cards
Other Account Services
How to Get a Free Checking Account
The Checkbook Register Application
How the Checkbook Register Workbook Works
Getting Started with the Register
Keeping Headings in View
Reconciling Your Register
7. Getting the Most From Your Credit Cards.
How Credit Cards Work
Credit Card Interest Rates
Credit Card Fees
Credit Card Advantages
What About Debit Cards?
Hooray for the Grace Period
Using Your Credit Cards Wisely
Never Charge Anything You Cannot Pay Off
Use the Grace Period
Get a Rewards Card
Be Careful to Make Payments on Time
Mind Your Credit Limit
How Much Will It Really Cost?
The Real Cost Calculator
Why Carrying a Balance Is to Be Avoided
Paying Off Your Balance
The Payoff Calculator
Using a Credit Card for Cash Advances
Understanding Cash Advances
The Cash Advance Cost Calculator
III. FINANCING YOUR HOME AND CAR.
8. Understanding Mortgages-And Getting the One That's Best for You.
The Many Benefits of Home Ownership
Types of Mortgages
Traditional Fixed Rate Mortgages
Adjustable Rate Mortgages
Your Mortgage Payment
Other Mortgage Costs
Private Mortgage Insurance
The Tax Benefits of Home Ownership
Understanding Mortgage Amortization
How Much Can I Borrow?
The Maximum Mortgage Calculator
The Mortgage Detail Calculator
9. Considering Home Equity Loans.
What Is a Home Equity Loan?
How They Work
How Much Can I Borrow?
Home Equity Loan Cautions
Home Equity Calculations
10. Refinancing Your Mortgage.
Costs of Refinancing
Making a Decision
The Mortgage Refinance Breakeven Calculator
How to Use the Calculator
11. Understanding Escrow Accounts.
Escrow Is for Taxes and Insurance
Canceling Your Escrow Account
The Escrow Cancellation Calculator
12. Renting Versus Buying Your Home-Making the Right Choice.
Why Buy a Home?
Financial Factors of Home Ownership
The Down Payment
The Rent Versus Buy Calculator
13. Your New Car- Lease or Buy?
Do You Really Need a New Car?
Understanding Auto Leases
Advantages and Disadvantages of Leasing
Types of Leases
Lease Payment Calculator
The Lease or Buy Calculator
IV. MANAGING YOUR INVESTMENTS.
14. Learning the Fundamentals of Investing.
Exchange Traded Funds
Certificates of Deposit
Money Market Accounts
Risk Versus Return
Your Investment Timeframe
Choosing a Brokerage Account
Dividend Reinvestment Plans
15. Tracking Your Investments.
Why Track Investments?
The Investment Portfolio Workbook
The Holdings Worksheet
The Query Worksheet
Using the Investment Portfolio Template
16. Comparing Mutual Funds.
Choosing Mutual Funds
The Mutual Fund Comparator
17. Planning for College or Retirement.
Accounting for Inflation
The Inflation Effects Calculator
Predicting Your Needs
Saving for College
The College Cost Calculator
The College Savings Calculator
Saving for Retirement
What About Social Security?
How Much Retirement Income Will You Need?
How Much Do You Need to Save?
The Retirement Planner Workbook
A. Workbook Reference.
Chapter 4: Net Worth Calculator
Chapter 5: Budget Workbook
The Budget Menu
The Transactions Worksheet
The Transaction Entry Form
The Overview Worksheet
Chapter 6: Checkbook Register Workbook
The Register Menu
Sorting the Transactions
Calculating the Totals
Chapter 7: Real Cost Calculator
Chapter 7: Payoff Calculator
Chapter 7: Cash Advance Cost Calculator
Chapter 8: Mortgage Payment Calculator
Chapter 8: Mortgage Points Comparator
Chapter 8: Mortgage Tax Savings Calculator
Chapter 8: Maximum Mortgage Calculator
Chapter 8: Mortgage Detail Calculator
Chapter 9: Home Equity Line of Credit Calculator
Chapter 10: Mortgage Refinance Breakeven Calculator
Chapter 11: Escrow Cancellation Calculator
Chapter 12: Rent Versus Buy Calculator
The Input Worksheet
The Output Worksheet
The Chart Worksheet
Chapter 13: Lease Payment Calculator
Chapter 13: Lease or Buy Calculator
Chapter 15: Investment Portfolio Workbook
Chapter 16: Mutual Fund Comparator
Chapter 17: Inflation Effects Calculator
Chapter 17: College Cost Calculator
Chapter 17: College Savings Calculator
Chapter 17: Retirement Planner Workbook
B. Glossary of Financial Terms.
What Our Readers Are Saying
Business » Accounting and Finance