Learn

learn

Activating Autodesk apps using license network (Considerations)

In this post, some considerations and solutions of the errors that appear during the activation of Autodesk applications when using a license network are left. FIRST TIME INSTALLING ANY AUTODESK 2020-2024 PROGRAM? If it is the first program you are installing, either from version 2020 to 2024, just follow the instructions in the text document or watch

Activating Autodesk apps using license network (Considerations) Read More »

Financial Modeling in Excel Your Model Is Full of “Spaghetti” Links

Your Model Is Full of “Spaghetti” Links A link that links to a link, which then, in turn, links to another link, and so on throughout the model is called a spaghetti link. Spaghetti links can be confusing and difficult to follow, and they aren’t good modeling practice. Wherever possible, you’re always much better off

Financial Modeling in Excel Your Model Is Full of “Spaghetti” Links Read More »

Financial Modeling in Excel Ten Common Pitfalls to Avoid

Ten Common Pitfalls to Avoid hroughout my career as a financial modeler, I’ve seen countless things go horribly awry. Many of these problems can be attributed to at least one (or sometimes several) of the pitfalls I describe in this chapter. Why focus on the negative? So you can learn from the mistakes of those

Financial Modeling in Excel Ten Common Pitfalls to Avoid Read More »

Financial Modeling in Excel Taking Note of Excel Error Values

Taking Note of Excel Error Values As irritating as they can be, I actually like seeing Excel errors in my formulas, because it means that something isn’t working and I can fix it. I’d much rather see an error value than a number that looks as though it’s correct when it’s actually completely wrong —

Financial Modeling in Excel Taking Note of Excel Error Values Read More »

Financial Modeling in Excel Stress-Testing with Sensitivity Analysis

Stress-Testing with Sensitivity Analysis After you’ve finished the model, you can test to see if the calculations are working correctly by changing an input and seeing what impact that change has on the numbers. This technique of changing one single input in isolation is called sensitivity analysis (as opposed to scenario analysis, which involves changing

Financial Modeling in Excel Stress-Testing with Sensitivity Analysis Read More »

Financial Modeling in Excel Ten Strategies for Reducing Error

Ten Strategies for Reducing Error f you aren’t absolutely paranoid about making a mistake in your financial model, you should be! Even people with a little experience using Microsoft Excel know how easy it is to get something wrong. Both formula and logic errors are easy to make — and they’re prevalent in corporate financial

Financial Modeling in Excel Ten Strategies for Reducing Error Read More »

Financial Modeling in Excel Budgeting for Capital Expenditure and Depreciation

Budgeting for Capital Expenditure and Depreciation he last two chapters deal with building financial models at quite a high level. In this chapter, you delve into more detail in one part of a financial model: the capital expenditure (CapEx). In Chapter 10, I explain the process of purchasing assets and calculating their depreciation. For example,

Financial Modeling in Excel Budgeting for Capital Expenditure and Depreciation Read More »

Financial Modeling in Excel Building a Discounted Cash Flow Valuation

Building a Discounted Cash Flow Valuation he discounted cash flow (DCF) model is one of the most commonly used methods of finding the value of a company or any other cash flowing asset. In fact, many other methods of valuation — such as cash flow multiples and the leveraged buyout model — are proxies or

Financial Modeling in Excel Building a Discounted Cash Flow Valuation Read More »

Share knowledge