Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Best Books of the Year | December 10, 2014

    Mary Jo Schimelpfenig: IMG Best Fantasy/Sci-Fi of 2014



    Here are the books that knocked my socks off in 2014. All of them would make great gifts; each of them was truly something that evoked that... Continue »

    spacer

On Order

$27.25
New Trade Paper
Currently out of stock.
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
- Local Warehouse Business- Accounting and Finance

Manage Your Money and Investments with Microsoft Excel

by

Manage Your Money and Investments with Microsoft Excel Cover

 

Synopses & Reviews

Publisher Comments:

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:
  • Perform basic financial calculations.
  • Track and analyze investments.
  • Compare mutual fund options.
  • Manage mortgages, loans, and escrow accounts.
  • Balance checking accounts and manage credit card debt.
  • Track your net worth.
Discover new ways to make money-saving decisions and manage your finances with Manage Your Money and Investments with Excel.

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

Introduction.

    Why Excel?

    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

    Setting Goals

    What Excel Can Do for You

      Why Excel and Not Quicken or Money?

      Excel Versions

    Using the Worksheet Templates

      Template Conventions

    About Percentages

2. Using Excel to Work with Money.

    Excel Basics

      Getting Around

      Selecting Cells

      Entering and Editing Data

      Formatting the Worksheet

    Formulas in Excel

      Excel Functions

    Excel and Money

      Cash Flow

      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?

    Budget Fundamentals

    The Home Budget Calculator

      The Overview

      Transactions

      Paychecks

      Entering Transactions

      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

      Cheap Checks

      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

      Entering Transactions

      Sorting Transactions

      Editing Transactions

      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

      Reward Cards

    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

      Balloon Mortgages

      Hybrid Mortgages

    Your Mortgage Payment

    Other Mortgage Costs

      Origination Fee

      Points

      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.

    Why Refinance?

    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

      Closing Costs

      Ownership Costs

    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 Conditions

    Lease Payment Calculator

    The Lease or Buy Calculator

IV. MANAGING YOUR INVESTMENTS.

14. Learning the Fundamentals of Investing.

    Investment Vehicles

      Stocks

      Bonds

      Mutual Funds

      Exchange Traded Funds

      Treasury Bills

      Savings Accounts

      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.

    Long-term Planning

      Accounting for Inflation

      The Inflation Effects Calculator

      Predicting Your Needs

      Not Over-Saving

    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?

      Annuities

      The Retirement Planner Workbook

APPENDICES.

A. Workbook Reference.

    Chapter 4: Net Worth Calculator

    Chapter 5: Budget Workbook

      The Budget Menu

      The Transactions Worksheet

      The Transaction Entry Form

      Entering Paychecks

      The Overview Worksheet

    Chapter 6: Checkbook Register Workbook

      The Register Menu

      Entering Transactions

      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.

Index.

Product Details

ISBN:
9780789734280
Author:
Aitken, Peter G.
Publisher:
Que
Author:
Aitken, Peter
Subject:
Investments
Subject:
Financial Applications - General
Subject:
Finance, personal
Subject:
Accounting - Financial
Subject:
Finance, Personal -- Computer programs.
Subject:
Investments -- Computer programs.
Subject:
Business-Accounting and Finance
Copyright:
Edition Description:
Trade paper
Publication Date:
June 2005
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
288
Dimensions:
9.1 x 7 x 0.7 in 499 gr

Related Subjects

Business » Accounting and Finance
Business » Investing
Business » Personal Finance
Computers and Internet » Personal Computers » Applications
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

Manage Your Money and Investments with Microsoft Excel New Trade Paper
0 stars - 0 reviews
$27.25 Backorder
Product details 288 pages Que - English 9780789734280 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.