1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
  • 1 Way Cash Flow Excel Model
Originally published: 10/04/2020 12:23
Last version published: 14/05/2020 08:05
Publication number: ELQ-66055-4
View all versions & Certificate
certified

1 Way Cash Flow Excel Model

Business & Cash Flow Scenario Model built to help small to medium sized businesses in the current COVID19 crisis (V3.0)

Description
This 1 Way Cash Flow Model is intended to assist the many accountants and finance professionals rapidly get their hands on a financial model that they can use to run scenarios and even simulations if they wish.

We are providing it with a 100% discount (for free - make sure your use the discount code COVID100) whilst there is the pandemic.

The model requires input on the historical cash flows for 12 months and only requires an opening balance sheet.

The model has been built with Jan-20 as the closing balance sheet and cash flows 12 months prior to that.

Included is a scenario manager which also includes the ability to run monte carlo simulations using VBA.

There are a number of executive and management dashboard outputs as well as an annual cash flow summary along with a sources and uses of cash.

We have also developed a FREE app to provide feedback and track version of the model which we will continue to update as feedback is provided in regards to logic or accuracy not customisation for specific businesses.

If you need help in applying or customising the model reach out to us via the app.
App link -->https://mc-1-way.glideapp.io/

We are giving this model away for free so that we can educate and assist finance professionals grapple with the huge amount of uncertainty that surrounds the current business conditions and how to cope with them.

The model currently includes assumptions around government stimulus for Australia, but can be applied (with a bit of logic editing) to other countries.

If you wish to edit the logic you are welcome to do so at your own risk. If the model is broken during this editing process we will fix it however will charge for our time to do so.

We are also considering to provide free support for other locations around the world wanting to use this model and include their specific government stimulus measures.

These stimulus measures can easily be exluded via a check box.

Make sure you watch the videos included in the app for further assistance and instructions on navigating and using the model.

A brief summary of the model will also be available here to review.

Please note currennt version is 3.0

Enjoy and stay safe.
- Lance

This Best Practice includes
1. PDF dashboard summary 2. Excel demo model 3. Demo Videos 4. Free App

Acquire business license for $399.00

Add to cart

Add to bookmarks

Discuss

Further information

For education and internal use for the purpose of running different scenarios on a business from a cash flow perspective having regard to different decisions. There is currently areas to input the balance sheet and the prior 12months cash flows along with assumptions for future periods based on drivers including impacts on staff reductions for both salaries and number of FTE amongst other impacts.

The model has not been audited and upon opening assumes that the user accepts the disclaimer attached to it. User can make changes to the model at their own risk. If you find logic that is incorrect please raise this in the app and we will do our best to fix it and update the version as quick as possible.

The tool is not intended to be provided directly to clients without the explicit approval by Model Citizn. The model is not available to be re-sold or provided to others without our explicit approval.

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Lance Rubin

keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for 1 Way Cash Flow Excel Model

The user community and author are here to help. Go ahead!

  • Lance Rubin
    The unlocked version should now be available for editing. Stay safe everyone and happy modelling!
    arrow_drop_uparrow_drop_downReply reply
    • Lance Rubin
      Hi all, apologies for the protected file. I have uploaded an unlocked version. Once approved you should get notification of the update.
      arrow_drop_uparrow_drop_downReply reply
      • Nikole Mackenzie
        hi, I'm trying to edit the excel document but it's protected. Is there a password?
        1arrow_drop_uparrow_drop_downReply reply
      • Dionne Gumbs
        Are you planning to build a version for US based companies and stimulus?
        arrow_drop_uparrow_drop_downReply reply
        • Lance Rubin
          Yes Dionne, we would love to do that...but need someone to help us wade through the complex legislation. 1 complex government stimulus is tough enough. Happy to coauthor with someone in the US. We just need the basic logic and we will integrate it into this tool with a switch to US stimulus.
          arrow_drop_uparrow_drop_downReply reply


        4.9 / 5 (82 votes)

        please wait...