Reader small image

You're reading from  Hands-On Financial Modeling with Microsoft Excel 2019

Product typeBook
Published inJul 2019
PublisherPackt
ISBN-139781789534627
Edition1st Edition
Tools
Right arrow
Author (1)
Shmuel Oluwa
Shmuel Oluwa
author image
Shmuel Oluwa

Shmuel Oluwa is a financial executive and seasoned instructor, of over 25 years, in a number of finance related fields, with a passion for imparting knowledge. He has developed considerable skill in the use of Microsoft Excel and has organised training courses in Business Excel, Financial Modeling with Excel, Forensics and Fraud Detection with Excel, Excel as an Investigative Tool, Accounting for Non-Accountants, Credit Analysis with Excel amongst others. He has given classes in Nigeria, Angola, Kenya and Tanzania but his online community of students covers several continents. Shmuel divides his time between London and Lagos with his pharmacist wife. He is fluent in 3 languages. English, Yoruba and Hebrew.
Read more about Shmuel Oluwa

Right arrow

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 options. Let's look at the various aspects of a financial model:

Financial decisions: 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:

  1. Purchasing new equipment: You may already have the capacity and know how to make or build in-house. There may also be similar equipment already in place. Considerations will thus be whether to make or buy, sell, keep, or trade-in the existing equipment.
  2. 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:
  • The cost of the investment: Isolates all costs specific to the investment, for example, construction, additional manpower, added running costs, adverse effect on existing business, marketing costs, and so on.
  • The benefit gained from the investment: We can gain additional sales. There will be a boost in other sales as a result of the new investment, along with other quantifiable benefits. To get the return on investment (ROI), a positive ROI would indicate that the investment is a good one.

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

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 contribution, so that the bank would make up the difference. The considerations would be as follows:

  • Interest rates: The higher the interest rate, the lower the amount you would seek to finance externally
  • Tenor of 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 put a platform on the least amount you will require from the bank, no matter what interest rate they are offering
  • Number of monthly repayments: How much you will be required to pay monthly as a result of the foregoing inputs

Financing

A company would need to decide whether to seek finance from internal sources (approach shareholders for additional equity) or external sources (obtain bank facility). We can see the considerations in the following list:

  • Cost of finance: The cost of bank finance can be easily obtained as the interest and related charges. These finance charges will have to be paid whether or not the company is making 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 are due.
  • The desired debt or 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:

  • Expectation of the shareholders: Shareholders provide the cheap finance options and are generally patient. However, they 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 need to retain surplus for future growth: It is the duty of the directors to temper the urge to satisfy the pressure to declare as much dividend 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 future investors.
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Hands-On Financial Modeling with Microsoft Excel 2019
Published in: Jul 2019Publisher: PacktISBN-13: 9781789534627

Author (1)

author image
Shmuel Oluwa

Shmuel Oluwa is a financial executive and seasoned instructor, of over 25 years, in a number of finance related fields, with a passion for imparting knowledge. He has developed considerable skill in the use of Microsoft Excel and has organised training courses in Business Excel, Financial Modeling with Excel, Forensics and Fraud Detection with Excel, Excel as an Investigative Tool, Accounting for Non-Accountants, Credit Analysis with Excel amongst others. He has given classes in Nigeria, Angola, Kenya and Tanzania but his online community of students covers several continents. Shmuel divides his time between London and Lagos with his pharmacist wife. He is fluent in 3 languages. English, Yoruba and Hebrew.
Read more about Shmuel Oluwa