Invest for Excel Start Guide
Contents
1. Invest for Excel Start Guide D DataPartner for Excel Cash flow modeling in Microsoft Office D DataPartner Invest for Excel Start Guide Contents 1 INVEST FOR EXCEL INFORMATION sivicssicecesscccincasittestienccneesaawesaanecaasepnnceavecaswassesaeupearanes 3 Invest for Excel Application Areas rrrarrnrnnnnranrrnnnrnvanernarrrnanernnnernerernareraernvnernnanrennarnnesennn 3 About Invest for ESA 0 EEE 3 Uninstalling Invest for Excel r rarrrrrnrnrennnrerrnnnrrnnnnrrnnnrerannrenanrnnannrnnanrrerannnnannrnnnernnnnerenanane 3 The 30 day test period has OXPIVe cccccccccccsscsssccsuccsuscceeeseuensuensucesuesseeesesessuensnseaueeaeees 3 2 INVEST FOR EXCEL No TALIA TION sinnene dende 4 Installation from CD 0 cccccccccecccsecccsneccseeecsuecssucnseeesseseseseessseesseeeeseeesseeessnecesesenseeesaeessaeesenecesaes 4 3 STARTING INVEST FOR GAC EL vsiccenscccsavusnnicnannastansdanasnwesasntenavtaiteiccatasesasnensnanasvsenntacanenad A Start Invest for Excel BO 0 gt EEE 4 Activate Invest for Excel 1ccccccccsecccsecccseeecsececseecsusesseeessueeeseeensusesseesseeenseesseeessaeessneessesenans 5 4 INVEST FOR EXCEL STRUCTURE saiscccniessncsansnswasandtbedganmuweneannecsescentuenanenuseeqsasideraceananands 6 LENS ELG Exca Homo 8 2 6 2 a ee ee er EE 6 User Guide and User Manual cccccccccsecccsecccsuecscecesuesseeeessecssaeessseesseeesseeeesseeesnscssneesanses 6 5 HOW TO MAKE A BASIC INVESTMENT CALCUL2. ATION nurnnnrnnnnnnnnnennnnnnnnennnnennnnennnnr 6 OE EEE EEE EE 6 Invest for Excel Application Area Investment Calculation example c ccccccseeeenececneenens 6 CALCULATIONS EXAMPLE FILES eee 11 7 TRAINING amp WORKSHOPS wissiicasasicstcaesasinasinessaccsancesnn ssaziacsinessacendnensaataipnenansacaternsnacienes 12 8 DATAPARTNER CONTACT INFORMATION ennnnnnnernnnnnnnnennnnennnnnnnnannnnnnnnnnnnnnunnnnnnnnnennn 12 D DataPartner Dear User This Invest for Excel start guide is intended to help you install and start using Invest for Excel software However please note that it provides very basic information and does not include description of all functions and features available in the software Datapartner organizes training and workshops to let you acquire all skills to build cash flow models in Invest for Excel and take advantage of software functionality We wish you successful testing 1 INVEST FOR EXCEL INFORMATION Invest for Excel Application Areas Invest for Excel is the advanced software for calculation of the profitability of new or renewal investments regardless of your line of business or the size of your company Invest for Excel is a tool that can be used in many different areas of cash flow modeling e investment feasibility studies investment calculations and post audit calculations valuations acquisitions impairment tests business planning outsourcing life cycle calculations strategi
3. bility Analysis report Profitability Analysis in the result section presents a report on your calculation including the most important profitability ratios El PROFITABILITY ANALYSIS Project description Project x 1 000 Required rate of return 12 00 Calculation term 50 years 12006 12 7010 Present value of business cash flaws PY of operative cash flow PY of residual value Present value of business cash flows Investment proposal Mominal Proposed investments in assets 500 Het Present Value NPY 0 Invest Internal Rate of Return RR 12 Invest Modified Internal Rate of Return 12 Invest Profitability Index Ph 1 Invest Return on net as sets ROMA Average 3 years Economic Value Added EWA Average 3 years Payback time years From discounted free cash flow Profitability Analysis report IN ANALYSIS SECTION 8 Analyse the sensitivity of project variables In the Analysis tables you can quickly examine the sensitivity of the critical factors on the result of the project 10 D DataPartner Total investments impact on profitability Total investment 1000 a 400 450 500 550 600 Change 20 0 10 10 0 0 10 0 20 0 134 93 52 11 32 Met Present Value NPY Change 1552 77 6 00 783 160 3 Met Present Value MP 400 Key figures 12o x 400 450 550 EBIT Operating income 441 40 0 35 9 31 8 Sensitivity Anal
4. c planning cash flow modeling of projects research amp development marketing and personnel investment project financing About Invest for Excel Test version The test version will work 30 days from the date of installation The functionality of the software is fully available with 3 exceptions e the discount factor is set to a default value e the sensitivity analysis of discount factor on profitability is calculated according to a default value e the interest rate in financing module is set to a default value Uninstalling Invest for Excel Invest for Excel can be uninstalled from the computer at any time Notice that it is not possible to reinstall the 30 day test version on the same computer twice The 30 day test period has expired If the 30 day test period expired but you wish to prolong your testing phase please contact Datapartner Help Desk for support D DataPartner 2 INVEST FOR EXCEL INSTALLATION Installation from CD Note that Administrator rights are needed for installation in program files directory When you insert the Invest for Excel CD wait a moment and the Invest for Excel installation program will start automatically for Excel installation c Run from network server Netset Install DataPartner Oy aatihuoneenkatu FIN 06100 Porvoo Tel 358 19 54 10 100 Fax 358 19 54 10111 E mail datapartner datapartner fi DataPartner Oy vww datapartner fi If the installation does not star
5. g all rows to the level 1 4 Define the income and costs of the project in Profit Calculation Table Enter the expected income and costs of the project in the next table Profit Calculation PROFIT CALCULATION lz z El 1000 42006 12 2006 12 2007 12 2008 42 2009 12 2010 ear Months per interval Oooo o ooa F o a Income specified Sales 156 Income Other operating income variable costs Raw materials and consumables External charges Staff costs Other variable costs Gross margin Fixed costs Staff costs Rents Other fixed costs Depreciation 100 100 100 100 100 2 em sy sj 2 EBIT Operating income Profit Calculation table D DataPartner You can create additional rows by clicking the button on the left of income or cost grey rows Invest for Excel includes many powerful modeling features Please refer to the User manual pdf about Processing rows of data under Profit Calculation Hide show rows and Copy Distribute Function You can also use Microsoft Excel functions for making formulas copying etc 5 Define Working Capital If you want to take into account working capital enter the relevant values to Working Capital table 6 Analyse Reports Cash Flow Statement and Balance Sheet Cash Flow Statement and Balance Sheet reports provide accurate and versatile overview on the investment IN THE RESULT SECTION Analyse Profita
6. ion term for your cash flows in the dialog box The outlook of the dialog box can vary depending on the version of Invest for Excel you are running Calculation Term Calculation Term Periodization Financial years Starts in the beginning of year 2006 EYY Calculation point Number of years a Ends in the end of year 2010 Ort Residual value Financial year ends in month Include historical periods Define mr ee Calculation term dialog box The calculation term is often the same as the investing time and planned operation time of the investment If necessary you can split the investment in different periods with Periodization In this dialog box you can also choose the calculation point to which the cash flows will be discounted residual value the end of financial year or if you want to include historical periods After you have completed the Calculation term dialog box you will return to Basic values table If you want to return to the Calculation term dialog box click the button in the Basic values table BASIC VALUES gam Project description Calculation term years 5years Interval length months Number of intervals CMM Calculation term begins 01 2006 fin the beginning of period Feels Calculation point 01 2006 fin the beginning of period Calculation term ends 12 2010 fin the end of the period Figures 1 1000 1000000 6 1000 Currency Discount rate per an
7. nstruction applies for Invest for Excel Test version The first time you start the software you need to enter the Activation code Demo Code in the following dialogue box The Activation code Demo Code has been sent to your e mail address when you downloaded the test version from the Internet or provided with the test CD Invest for Excel Demo code Please enter Demo code to activate this test version m The Demo code has been sent to the email address you reported on the Download page Cancel Instruction applies for Invest for Excel License version You will be asked to activate Invest for Excel license the first time you start the software Enter the control number in the dialog box The control number has been provided with your CD You find the Control number on the REGISTRATION INFORMATION CARD DataPartner Invest Registration control number missing Please enter D DataPartner 4 INVEST FOR EXCEL STRUCTURE Invest for Excel Homepage Invest for Excel opens with the homepage as on the picture below The outlook can vary a little depending on what version of Invest for Excel you are running ee 7 PRO DEMO Investment Calculations for Excel Program version 3 2 Input Values Calculations Result Analysis L Basic Values L Investment L Profitability Analysis C Discount Factor L Contact Information Profit Calculation L Comparison Table C Total Investment Working Capital C Margin Calcula
8. num race ex 17 00 required rate of return 2006 2007 2008 2009 2010 gt Income tax Basic Values table D DataPartner In the Basic Values table enter Unit of figures Currency Discount rate and Income tax Note that particularly the Discount rate has a big impact on the outcome of the calculation Contact information along with comments about the project can be entered for information purposes in the Contact information table After completing the basic values table the next step to complete is the Investment table in Calculations section IN CALCULATIONS SECTION 3 Define the investments in the Investments table Ej x INVESTMENTS REALIZATIONS ml 1000 PE BEIGE 41 2006 12 2006 12 2007 12 2008 12 2009 12 2010 Residual Months per interval Depr et 122010 100 100 100 Depreciation straight line 2 Depreciation straight line 3 Depreciation straight line 4 Depreciation straight line Investments ws Realizations Depreciation 1 oa 1 x 1 oa Realization profit loss Book value JR EE EG AG a SS Investments table Enter the investment expenditure s as negative figures Select depreciation method by clicking the button on the left of each investment row Straight line depreciation is default Note that you can easily change outline level using the controls B g from the most detailed level 5 Showin
9. t automatically run Setup exe from the CD Select Local installation this computer when you want to install Invest for Excel program files on a local workstation or a server Select Netset when Invest for Excel program files already are installed on a network server and you want only to place shortcuts on this computer Press Install button Follow the instructions of installation wizard The installation program will create a program group named Datapartner which include start up icons for the program and user guides 3 STARTING INVEST FOR EXCEL Start Invest for Excel software Start Invest for Excel from the Windows menu Start Programs DataPartner program group There you can also find user guides in different languages If the Security Warning dialog box appears select Always trust macros from this source and then press Enable Macros D DataPartner Security Warning C Program Files DataPartner Invest INVEST xls contains macros by SE Datapartner Oy EIS Macros may contain viruses It is always safe to disable macros but if the macros are legitimate you might lose some Functionality IV Always trust macros from this source Disable Macros i j More Info If Invest for Excel doesn t start the Macro Security level might be set to High Select from Microsoft Excel Menu Tools gt Macro Security level and set it to Medium Start the program again Activate Invest for Excel I
10. tion L Income C Folders and Files C Cash Flow C Consolidation O Variable Costs C Balance C impairment Test L Fixed Costs User Guide Verification J Income variable User Manual pdf L Financing C Investment Proposal _ Charts 0 Investment File Mot open Ikl Comparison File Mot open 0 Proposal File Mot open Ikl Financing File Mot open D DataPartner weee datapartner fi oe Invest for Excel Homepage The homepage shows the main 4 sections of Invest for Excel in a recommended workflow Input values Calculations Result and Analysis User Guide and User Manual In order to get more information on each software section you can activate User Guide tick the box of User Guide Then while you are moving to various sections of the software information boxes will appear with explanation on contents For detailed instruction on Invest for Excel open User Manual pdf 5 HOW TO MAKE ABASIC INVESTMENT CALCULATION Imagine you need to assess profitability of an investment Follow the steps to create and analyze your calculation model Important rules There are a few basic rules to keep in mind 1 You can only enter data in the grey fields and yellow fields 2 Cash flow Investments and operational costs should be entered as negative values 3 Remember to save your work regularly or at least before closing Use the buttons on the left to move from one calculation table to the next This way yo
11. u will move in a recommended work order D DataPartner Invest for Excel Application Area Investment calculation example IN HOMEPAGE SECTION 1 Create a new investment file Start from Homepage section Input Values on the left followed by Calculations Result and Analysis This is the order in which you should proceed the first time you make a calculation You can return to the homepage at any time by clicking the home button 1 1 Select Basic Values from the homepage 1 2 Select New to create a new file Invest for Excel Could not detect an open Investment file Open From Save in Private folder Common Folder The next step applies to Invest for Excel Enterprise version users only and will not be shown in versions Pro Standard and Lite 1 3 Choose type of calculation to create In this case choose 1 Asset investment project or business planning to create a standard investment calculation In versions Pro Standard and Lite this file type will open as default Mew Investment File Type of calculation 2 Corporate acquisition I valuation 3 Impairment Test Save In W Private Folder Common Folder Cancel New Investment file dialog box 1 4 Save the calculation file at this point but do not close it Now you are able to start modeling your project DataPartner IN BASIC VALUES SECTION 2 Define the Basic Values for your calculation Define the calculat
12. ysis table E You have completed your basic investment calculation 6 CALCULATIONS EXAMPLE FILES You will find some ready example calculations that you can open from Local Disc C gt Program Files gt DataPartner gt Invest for Excel gt Calc gt Examples_in_English Look in O Examples_in_English uaununununnmunnunnmunnunnmunnununun Default location of examnles folder 4 BFReal estate xls Se Local Disk Cs My Recent Bf Machine xls IG Program Files Documents 7 DataPartner IG Invest For Excel IG Calc Examples in English My Documents My Computer My Network l Places Files of type Investment files x zip vi The example files in different languages are provided under the Calc folder which is the default folder when you open Invest for Excel 11 D DataPartner 7 TRAINING amp WORKSHOPS Visit Datapartner website for current training and workshops schedule Datapartner website www datapartner fi gt News amp Events gt Events 8 DATAPARTNER CONTACT INFORMATION Datapartner Oy Raatihuoneenkatu 8 00610 Porvoo Finland Tel 358 19 54 10 100 Fax 358 19 54 10 111 E mail support datapartner fi www datapartner fi Thank you for testing Invest for Excel 12
Download Pdf Manuals
Related Search