g Text Version
Beauty & Self
Books & Music
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
News & Politics
Religion & Spirituality
Travel & Culture
TV & Movies

Bored? Games!
Take a Quiz
Rate My Photo

Natural Living
Folklore and Mythology
Distance Learning

All times in EST

Clairvoyance: 08:00 PM

Full Schedule
g Accounting Site

BellaOnline's Accounting Editor


Predict Financial Outcomes with Excel

Guest Author - Consuelo Herrera, CAMS, CFE

Have you been confronted with a situation where you need to predict outcomes based on changes in different variables? I have. After struggling with different kinds of spreadsheets, I finally found my way by using the "What If" Scenarios.

If you were given today $1,000,000 dollars, what factors would you take into consideration when deciding what to do with that amount of money? First and foremost, you would look for strategies that help maximize return, reduce risk, etc. Your options would be to place that money into a savings account, a CD, buy gold, or invest in the stock market.

Higher returns pose a higher level of risks. Some of the risks would be loss of the investment, high taxation, anxiety that comes with the possibility of losing that money.

By making simulations using What If scenarios you may anticipate some outcomes and predict in advance the possible consequences of your decisions.

Sound investment decisions are based primarily on the potential rate of return that is why when evaluating whether or not to invest the potential rate of return must be carefully analyzed. Just as one would analyze whether or not a required rate of return could be realized a business person would analyze his or her decision of increase prices, eliminate a product, etc.

Most of the decision-analysis tools on the market focus on one specific analytical technique, like simulation or decision trees. They may be tailored to a specific industry need. One integrated set of tools that combines the best analytical methods, can be applied to different problems, and is reasonably priced is Microsoft Excel. By using this tool, accountants add value to their organizations.

The measure of any business intelligence solution is its ability to derive knowledge from data. Business analysis tools such as the one described by Excel in the video attached here, have the capability to identify patterns, trends, and rules and create “what-if” analyses.

Microsoft Education provides a Step-by-step How To:

  1. Start Microsoft Excel and either open a file that includes some formulas that you would like to test, or start from a new spreadsheet, and then type in your text and formulas.
  2. Plan how you would like to test different changes to the values in your spreadsheet.

  3. To create a new scenario, select Scenarios from the Tools menu.

  4. Click Add.

  5. In the Scenario name box, type a name for the new scenario.

  6. In the Changing cells box, enter the references for the cells that you want to change. Note: To preserve the original values for the changing cells, create a scenario that uses the original cell values before you create scenarios that change the values.

  7. Under Protection, select the options that you want, and then click OK.

  8. Next, in the Scenario Values dialog box, type the values that you want for the changing cells and then click OK.

  9. If you want to create additional scenarios, click Add again, and then repeat the steps above. When you finish creating scenarios, click OK, and then click Close in the Scenario Manager dialog box.

  10. Try out the different scenarios by clicking Scenarios on the Tools menu. See how your spreadsheet changes as you analyze the "what-if" possibilities.

    Goal Seek IS an analytical function, which allows a value in a formula to be adjusted in order to reach a desired result or answer. It can eliminate unnecessary calculations. Goal Seek repeatedly tries news values in the variable cell to reflect changes in outcomes.

    Clik here to a Microsoft video that teaches how to use What If Scenarios.Just Play Demo. It is worth to follow it along.

This site needs an editor - click to learn more!

Add Predict+Financial+Outcomes+with+Excel to Twitter Add Predict+Financial+Outcomes+with+Excel to Facebook Add Predict+Financial+Outcomes+with+Excel to MySpace Add Predict+Financial+Outcomes+with+Excel to Digg Predict+Financial+Outcomes+with+Excel Add Predict+Financial+Outcomes+with+Excel to Yahoo My Web Add Predict+Financial+Outcomes+with+Excel to Google Bookmarks Add Predict+Financial+Outcomes+with+Excel to Stumbleupon Add Predict+Financial+Outcomes+with+Excel to Reddit

Forensic Accounting Quiz
Enabling Fraud Environments
Big Personality Traits of Accountants
Related Articles
Editor's Picks Articles
Top Ten Articles
Previous Features
Site Map

For FREE email updates, subscribe to the Accounting Newsletter

Past Issues

Printer Friendly
tell friend
Tell a Friend
Email Editor

Content copyright © 2018 by Consuelo Herrera, CAMS, CFE. All rights reserved.
This content was written by Consuelo Herrera, CAMS, CFE. If you wish to use this content in any manner, you need written permission. Contact BellaOnline Administration for details.


g features
Archives | Site Map


Past Issues

Note: BellaOnline uses cookies to help provide a consistent user experience. Our advertisers may use cookies to help customize ads. Please contact us with any question about our cookie use.

Summertime Foods
Corn on the Cob
Burgers on the Grill
Apple Pie


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2018 Minerva WebWorks LLC. All rights reserved.

BellaOnline Editor