Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Hands-On Financial Modeling with Excel for Microsoft 365

You're reading from   Hands-On Financial Modeling with Excel for Microsoft 365 Build your own practical financial models for effective forecasting, valuation, trading, and growth analysis

Arrow left icon
Product type Paperback
Published in Jun 2022
Publisher Packt
ISBN-13 9781803231143
Length 346 pages
Edition 2nd Edition
Languages
Tools
Arrow right icon
Author (1):
Arrow left icon
Shmuel Oluwa Shmuel Oluwa
Author Profile Icon Shmuel Oluwa
Shmuel Oluwa
Arrow right icon
View More author details
Toc

Table of Contents (19) Chapters Close

Preface 1. Part 1 – Financial Modeling Overview
2. Chapter 1: An Introduction to Financial Modeling and Excel FREE CHAPTER 3. Chapter 2: Steps for Building a Financial Model 4. Part 2 – The Use of Excel Features and Functions for Financial Modeling
5. Chapter 3: Formulas and Functions – Completing Modeling Tasks with a Single Formula 6. Chapter 4: Referencing Framework in Excel 7. Chapter 5: An Introduction to Power Query 8. Part 3 – Building an Integrated 3-Statement Financial Model with Valuation by DCF
9. Chapter 6: Understanding Project and Building Assumptions 10. Chapter 7: Asset and Debt Schedules 11. Chapter 8: Preparing a Cash Flow Statement 12. Chapter 9: Ratio Analysis 13. Chapter 10: Valuation 14. Chapter 11: Model Testing for Reasonableness and Accuracy 15. Part 4 – Case Study
16. Chapter 12: Case Study 1 – Building a Model to Extract a Balance Sheet and Profit and Loss from a Trial Balance 17. Chapter 13: Case Study 2 – Creating a Model for Capital Budgeting 18. Other Books You May Enjoy

The main ingredients of a financial model

First of all, there needs to be a situation or problem that requires you to make a financial decision. Your decision will depend on the outcome of two or more alternative scenarios as described in the following subsections.

Financial decisions can be divided into three main types:

  • Investment
  • Financing
  • Distributions or dividends

Investment

We will now look at some reasons for investment decisions:

  • Purchasing new equipment: You may already have the capacity and know-how to make or build the equipment in-house. There may also be similar equipment already in place. Considerations will thus be whether to make, buy, sell, keep, or trade in the existing equipment.
  • Business expansion decisions: This could mean taking on new products, opening up a new branch, or expanding an existing branch. The considerations would be to compare the following:
    1. The cost of the investment: Isolate all costs specific to the investment, for example, construction, additional manpower, added running costs, adverse effects on existing business, marketing costs, and so on.
    2. The benefit gained from the investment: We could gain additional sales. There will be a boost in other sales as a result of the new investment, along with other quantifiable benefits. Regarding the return on investment (ROI), a positive ROI would indicate that the investment is a good one.

Financing

Financing decisions primarily revolve around whether to obtain finance from personal funds or external sources:

  • Individual: For example, if you decided to get a loan to purchase a car, you would need to decide how much you wanted to put down as your deposit so that the bank would lend you the difference. The considerations would be as follows:
    • Interest rates: The higher the interest rate, the less you would seek to finance externally.
    • Tenor of the loan: The longer the tenor, the lower the monthly repayments, but the longer you remain indebted to the bank.
    • How much you can afford to contribute: This will establish the least amount you will require from the bank, no matter what interest rate they are offering.
    • Amount of monthly repayments: How much you will be required to pay monthly to repay the loan.
  • Company: A company would need to decide whether to seek finance from internal sources (approach shareholders for additional equity) or external sources (obtain bank funding). We can see the considerations in the following list:
    • Cost of finance: The cost of finance can be easily obtained with the interest and related charges. These finance charges will have to be paid whether or not the company is making a profit. Equity finance is cheaper since the company does not have to pay dividends every year, also the amount paid is at the discretion of the directors.
    • Availability of finance: It's generally difficult to squeeze more money out of shareholders unless perhaps there has been a run of good results and decent dividends. So, the company may have no other choice than external finance.
    • The risk inherent in the source: With external finance, there is always the risk that the company may find itself unable to meet the repayments as they fall due. This exposes the company to all the consequences of defaulting, including security risk and embarrassment among other things.
    • The desired debt-to-equity ratio: The management of a company will want to maintain a debt-to-equity ratio that is commensurate with their risk appetite. Risk takers will be comfortable with a ratio of more than 1:1, while risk-averse management would prefer a ratio of 1:1 or less.

Dividends

Distributions or dividend decisions are made when there are surplus funds. The decision would be whether to distribute all the surplus, part of the surplus, or none at all. We can see the considerations in the following list:

  • The expectations of the shareholders: Shareholders provide cheap funds and are generally patient. However, shareholders want to be assured that their investment is worthwhile. This is generally manifested by profits, growth, and in particular, dividends, which have an immediate effect on their finances. The funds are considered cheap because payment of dividends is not mandatory but at the discretion of the directors.
  • The need to retain surplus for future growth: It is the duty of the directors to temper the urge to succumb to pressure to declare as many dividends as possible, with the necessity to retain at least part of the surplus for future growth and contingencies.
  • The desire to maintain a good dividend policy: A good dividend policy is necessary to retain the confidence of existing shareholders and to attract potential investors.

You should now have a better understanding of financial decision making. Let's now look at mathematical models that are created to facilitate financial decision making.

You have been reading a chapter from
Hands-On Financial Modeling with Excel for Microsoft 365 - Second Edition
Published in: Jun 2022
Publisher: Packt
ISBN-13: 9781803231143
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at ₹800/month. Cancel anytime