Manage Your Money and Investments with Microsoft Excel
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Health, Relationships and Personal development > Self-help, personal development and practical advice > Personal finance > Manage Your Money and Investments with Microsoft Excel
Manage Your Money and Investments with Microsoft Excel

Manage Your Money and Investments with Microsoft Excel


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Analyze investments and finances to maximize money using Microsoft Excel and templates for financial scenarios; This book will show consumers how to analyze their finances and investments with Excel to get more from their money.; Includes financial advice and easy-to-use template spreadsheets that work with multiple recent versions of Excel or other spreadsheet applications.; Explains how to make money-saving decisions with mortgages, loans, credit cards, taxes, and more Intuit's Quicken and Microsoft Money are personal finance products mostly used for basic "everyday" financial tasks, like checkbook balancing and bill paying. While these tools are great for tracking transactions, many users find their reporting and analysis tools difficult to work with. However, many people already have one of the most powerful tools for realizing financial savings installed on their computer - Microsoft Excel. With Excel's extensive capabilities for analyzing data, performing computations, and displaying charts, it's ideally suited for just about any financial task, if you know how to create the necessary formulas and charts. With Manage Your Money and Investments with Excel, you don't need advanced Excel knowledge to analyze and review your financial information. The book includes a set of professionally designed Excel workbooks for performing commonly needed financial tasks such as: comparing mutual funds over time, evaluating mortgages and home equity loans, deciding whether to buy or lease a car, work with credit card finance charges, and more. All necessary formulas and charts will be built in so readers can add their data and get started quickly. Not only is this book great for those tackling financial management for the first time, but it's also perfect for current Money and Quicken users who are finding some of their software features difficult to use. Readers can download the sample workbooks from www quepublishing.com. The sample workbooks will be created in Excel, and will work in multiple versions of Excel or other spreadsheet applications that can read Excel files.

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.

About the Author :
Peter Aitken has been writing about computers and software for more than 15 years. He has over 40 titles to his credit as well as innumerable magazine and web articles. Peter is an expert Excel developer and has done financial consulting and programming for clients in the real estate industry, including a stint as a Vice President of The Chubb Group of Insurance Companies. Recently Peter wrote Excel Programming Weekend Crash Course (Wiley; 0764540629) and co-wrote Excel Formulas and Functions for Dummies (Wiley, 0764575562).


Best Sellers


Product Details
  • ISBN-13: 9780789734280
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Que Corporation,U.S.
  • Height: 176 mm
  • No of Pages: 288
  • Weight: 481 gr
  • ISBN-10: 0789734281
  • Publisher Date: 07 Jul 2005
  • Binding: SA
  • Language: English
  • Spine Width: 17 mm
  • Width: 231 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Manage Your Money and Investments with Microsoft Excel
Pearson Education (US) -
Manage Your Money and Investments with Microsoft Excel
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Manage Your Money and Investments with Microsoft Excel

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!