File Name: manual_EFM-CE.pdf
File Size: 4.79 MB
File Type: Application/pdf
Last Modified: 1 year
Status: Available
Last checked: 9 hours ago!
This Document Has Been Certified by a Professional
100% customizable
Language: English
We recommend downloading this file onto your computer
Version: Classic Economy 2.04.1001Last update of this manual: 14 Jun 2021 Excel-Financial-Model The easy way to plan, launch and run your business! Financial Modelling Videos „Tell me and I forget
Show me and I remember
Let me do and I understand.“Confucius (551 B.C. - 479 B.C.) Content 3 Table Of Contents I Using this Manual 4 II Legal Disclaimer and License Agreement 7 III About the Author and Financial Modelling Videos 10 IV Getting Started 13 4.1 Loading ..................................................................................................................................
and Using the Excel-File 14 4.2 Password ..................................................................................................................................
for changing and editing worksheets 20 4.3 Financial ..................................................................................................................................
Modelling and FAST Standard 21 4.4 Custom ..................................................................................................................................
cell style set 22 4.5 Overview ..................................................................................................................................
and Familiarization 24 V Quick Start Guide 26 VI Planning Process - Guidance on Entering Assumptions 31 6.1 Sheet ..................................................................................................................................
Inputs 32 6.2 Sheet ..................................................................................................................................
Sales 45 6.3 Sheet ..................................................................................................................................
Human Resources 46 6.4 Sheet ..................................................................................................................................
Costs 01 47 6.5 Sheet ..................................................................................................................................
Costs 02 49 6.6 Sheet ..................................................................................................................................
Costs 03 51 6.7 Sheet ..................................................................................................................................
Capex 51 6.8 Sheet ..................................................................................................................................
Financing 53 VII Error Messages 57 VIII Changing Excel-Financial-Model 60 IX Version History 64www.excel-financial-model.com Using this ManualPart I 5 Using this Manual1 Using this Manual Notice to Users This manual and the associated software Excel-Financial-Model (EFM) are supplied under a license agreement and may be used only in accordance with the terms and conditions of the licence agreement set out in detail here 8
Read the legal disclaimer and the license agreement 8 carefully. The use of Excel- Financial-Model constitutes your unconditional and irrevocable acceptance of the terms and conditions of both the legal disclaimer and the license agreement. If you do not agree to both, do not install or use EFM. The use of Excel-Financial-Model is irrevocably conditional upon full and constant compliance by you with the terms and conditions of the license agreement
Excel-Financial-Model (Version: Classic Economy) As Financial Modelling Videos has a policy of continual product improvement, the information and data contained in this manual are subject to change without notice and do not represent a commitment by the vendor. Neither the manual nor software may be copied or reproduced in any form, in whole or in part, without prior written permission of Financial Modelling Videos or Fimovi GmbH
© Copyright 2021. Fimovi GmbH. All rights reserved
This manual relates to the software: Excel-Financial-Model (Classic Economy) Version: 2.04.1001 Last update of this manual: 14 Jun 2021www.excel-financial-model.com 6 Excel-Financial-Model (Classic Economy) Offline Help File We also offer our help files as eBook (Windows executable containing an embedded viewer). Download the Windows eBbook help file here
Additional Information In addition to this manual the Excel-file contains a sheet named "Quick Start Guide" with some introductory information. Furthermore we have added numerous explanatory notes as cell comments. When a cell contains a comment, a small, red triangle is displayed in the upper-right corner of that cell. The comment is visible when you hover over the cell that contains the comment
Where possible, data validation option of Excel has been used to prevent data input errors and avoid miscalculations
No information contained in this manual or software should be construed as legal, financial, investment, accounting or tax advice, nor should it be considered a substitute for such advice
© 2021 Fimovi GmbH. All Rights reserved
Legal Disclaimer and License Agreement Part II 8 Excel-Financial-Model (Classic Economy)2 Legal Disclaimer and License Agreement Legal Disclaimer No information contained in this Software (as defined below) or obtained from Fimovi GmbH or Fimovi should be construed as legal, financial, investment, accounting or tax advice, nor should it be considered a substitute for such advice
This Software is supplied under a license agreement and may be used only in accordance with the terms and conditions of the license agreement set out below. The use of this Software is conditional upon the irrevocable and constant compliance by the user with the terms and conditions of the license agreement
License Agreement Application: This agreement applies to the commercial or registered/upgraded version of Excel-Financial-Model (also referred to as “EFM” or “Software”), comprising workbook, related files and supporting documentation
License grant: Fimovi GmbH grants registered users, i.e. a company, entity or individual, a license to use this Software on any compatible hardware product (PC, notebook, smartphone, tablet), to which the registered user has exclusive or primary access. “Use” means storing, loading, installing, executing or displaying the Software
Ownership: The owner and copyright holder of the Software is Fimovi GmbH. The granted license confers no title of ownership to the Software and should not be construed as a sale of any rights to the Software. This license is not transferable to any other company, entity or individual
Copyright: The Software is protected by copyright law. You unconditionally and irrevocably acknowledge that no title to the intellectual property in the Software is transferred to you. You further unconditionally and irrevocably acknowledge that title and full ownership rights to the Software remains the exclusive property of Fimovi GmbH and you do not acquire any rights to the Software except as expressly set forth in this license agreement. You agree that any copies of the Software will also contain the same proprietary notices which appear on and in the Software itself
Unauthorized Use: You may not modify the Software or disable any licensing or control features of the Software. You may not use, copy, rent, lease, sell, modify, decompile, disassemble, otherwise reverse engineer, or transfer the Software except as provided in this license agreement. Any such unauthorized use shall result in the immediate and automatic termination of this license agreement. The Software's worksheet (“Fimovi”) and VBA routines must not be altered under any circumstances
Registered users may make backups of the Software for backup purposes and for the purpose of creating additional sets of projections
© 2021 Fimovi GmbH. All Rights reserved
9 Legal Disclaimer and License Agreement Limited Warranty: This software is provided on an “as is” basis. Fimovi GmbH disclaims all warranties relating to this software, whether expressed or implied, including but not limited to any implied warranties of merchantability or fitness for a particular purpose. Neither Fimovi nor anyone else involved in the creation, production or delivery of this software shall be liable for any indirect, consequential or incidental damages arising out of the use or inability to use such software, even in the case that Fimovi GmbH has been advised of the possibility of such damages or claims. The person using the software bears all risk regarding the quality and performance of the software. In no event shall any theory of liability exceed the license fee paid to Fimovi GmbH
Governing Law: This Agreement shall be governed exclusively by the laws of the Federal Republic of Germany to the exclusion of the UN Sales Convention and the conflicts of law rules
Reserved Rights: Fimovi GmbH retains all rights not expressly granted here
Trademarks Disclaimer All product and company names are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them
• Excel, Office and Windows are registered trademarks of Microsoft Corporation in the United States and other countries
• Mac and Mac OS are registered trademarks of Apple Inc., registered in the U.S
and other countries
• Adobe and Acrobat are trademarks or registered trademarks of Adobe Systems Incorporated in the U.S. and other countries
Copyright 2021. Fimovi GmbH. All rights reserved
www.excel-financial-model.com About the Author and Financial Modelling Videos Part III 11 About the Author and Financial Modelling Videos3 About the Author and Financial Modelling Videos About the Author Dirk Gostomski, founder and CEO of Financial Modelling Videos, has extensive experience in the development and review of financial models
Dirk has been building complex project and operational models and valuating financial models for a broad range of industries including mining, infrastructure, and energy for more than 17 years. He is also engaged in developing and reviewing corporate planning and budgeting models for both established and start-up companies
Working as a consultant for SMEs and venture capital firms - offering business planning, financial due diligence and capital raising services - the idea was born to develop and provide flexible, easy-to-use and robust Excel- based financial modelling tools. The primary objective is to help entrepreneurs, senior managers and investors create detailed financial models to gain full visibility into all of the assumptions, cash requirements, profitability, scalability and the ramp-up of their respective business. You need not fear the financial section of your business plan, and you do not need an MBA to get it right
About Financial Modelling Videos Financial Modelling Videos enables its customers to develop flexible and robust financial plans and cash-flow models using Excel. The Germany based company provides a broad range of financial modelling related services for clients across many industry sectors
Our financial modelling video training courses are “hands-on” with users learning concepts by building Excel financial models from scratch
Our templates and excel tools are designed and built to be flexible, future-proof, robust and user-friendly
www.excel-financial-model.com 12 Excel-Financial-Model (Classic Economy) Our seminar and workshop training services, enable entrepreneurs, corporate clients, and investors to apply best practices when developing financial models. These tools support and enhance their business decisions, transactions and strategies
What Financial Modelling Videos can do for you: • Ready-to-use Excel tools and templates for corporate planning, budgeting, valuation, cash-flow planning and project finance • Development of tailor-made, individual models • Model review, optimization and audit • Seminars and workshops Contact us Financial Modelling Videos is offered by Fimovi GmbH
Fimovi GmbH Sandstraße 104 40789 Monheim am Rhein, Germany Email: [email protected] Internet: www.excel-financial-model.com © 2021 Fimovi GmbH. All Rights reserved
Loading and Using the Excel-File Excel-Financial-Model has been developed for Excel 2007 (v12.0) and later for PCs and Excel 2011 (v14.0) and later for Macs. EFM does not work in …
Another position is that neoclassical economics is essentially continuous with classical economics. To scholars promoting this view, there is no hard and fast line between classical and neoclassical economics.
New classical economics emerged in the early 1970s through the work of Robert Lucas. It flourishes at the University of Chicago and Minnesota. Some of the names of the new classical economists are: The latter two then develop the real business cycle (RBC).
This theory explains the business cycle occurs because of a fundamental problem on the side of aggregate supply. External shocks such as technological innovation are responsible for random fluctuations in productivity levels and shifting constant growth trends up or down. The new classical economists are proponents of the free market.