Originally published: 19/03/2018 10:48
Publication number: ELQ-54509-1
View all versions & Certificate

Modelling Assets - Spark Financial Model

This video covers modelling assets within the Spark Financial Model.

First, you have to turn on the switch and give your asset a name, e.g. coffee carts that we need to sell coffee. Similarly to indirect costs, the model allows a one-off, fixed input for asset acquisition, or a dynamic input linked to certain drivers. This will be set to 'ongoing,' and link it to the number of distribution channels, which, coincidentally is also the number of coffee carts. So for each additional distribution channel, we'll need to buy another vehicle. Let's say this costs $10,000 per cart, and this price increases by inflation each year. We then get to input how we expect this to be funded. This example uses a bank loan, so 100% funded by debt, so a particular debt tranche that we need to set up is selected. If we expect to use this vehicle for at least 6 years, by turning the switch on, you're allowing the model to automatically purchase another vehicle once this one reaches the end of its life.

Watch this video to run through the rest of the tutorial so that you can learn how to manage assets within the model.

If you'd like to purchase the Spark Financial Model, you can do so here:

Length: 2 minutes 56 seconds

This Best Practice includes
1 Video File

Add to bookmarks

Did David Liu's Best Practice help you? You can make a small financial contribution to support the author.


5.0 / 5 (1 votes)

please wait...