Architekwiki
  • Home
  • WIKI
  • Start Here
  • Resources
  • Other
    • Reading List
    • Ochre >
      • Ochre
      • Ochre KB
      • Ochre FAQs
      • Ochre Help
    • Details
    • The 3 Aspects
    • About
    • Subscription FAQs
    • Terms of Use
  • Subscribe
  • Home
  • WIKI
  • Start Here
  • Resources
  • Other
    • Reading List
    • Ochre >
      • Ochre
      • Ochre KB
      • Ochre FAQs
      • Ochre Help
    • Details
    • The 3 Aspects
    • About
    • Subscription FAQs
    • Terms of Use
  • Subscribe

Architekwiki

A Resource For Architects
Click here to get good stuff in your inbox

One Of The Ingredients Of CASH FLOW

2/19/2017

 
Cash Flow


Whenever the economy tanks, I get really interested in cash flow. It's a habit that I try to hang onto when things are going well, too, because you can run out of money any time. But there is something about impending doom that gets your attention. Most of the guidance you can find on cash flow is geared to 'small businesses', less than 5,000 employees! This isn't very helpful.

In a nutshell cash flow is predicting your cash-basis profit or loss. It is the nature of predictions to be wrong almost all the time. So a cash flow projection isn't reality, but you want to get close enough that there aren't any devastating surprises.

This simple spreadsheet below is my attempt to get a view of the income side of the cash flow projection. The idea is to quickly allocate your fee for a project over time so you can compare it to the other ingredient - an expense projection.  

Income Projection
This spreadsheet looks at just one project. Copy it onto additional tabs, or copy the file for additional projects. By using the 'If' function, I have turned it into a template so that you have just three entries to make - fee, phase allocations, and durations. (Also check out OFFPLAN for putting it all together.) Here's how it works.

A] FEE
Determine your 'net fee' and enter it here. The net fee does not include any part of the fee that will go to consultants. A number of things get more complicated if the consultants are included, so I choose to leave them out of both income and expenses.

B] PHASE ALLOCATIONS
The five standard phases and their standard percent of the total fee are the defaults. You may not have all the phases. In which case make that phase worth 0% and adjust the other percentages accordingly. If your fee is based on specific tasks instead of phases, rename the phases and overwrite the calculated phase fees in the row below the 'green phase percentages' with the amounts you have quoted for each task.

C] DURATIONS
The durations that I show for each phase are based on my experience with a project worth roughly $1,000,000. Change these durations to suit your project's anticipated schedule. Sometimes there will be two months worth of work, but the duration will be a month or two longer to allow for reviews, revisions, approvals and similar time factors. The duration in the first column is reduced by one as you move to the right. When the duration becomes zero, then through the IF function, the fee becomes zero, too. More columns can be added by copying the cells in the last column to the new columns.

The end result is that I have taken the fee, broken it down into five phases, and then spread the fee for each phase equally over the number of months that I expect the phase to last. Customization of the results is needed several times. First when you are adding a project to your Cash Flow Projection (coming soon) you may have to adjust for how all your projects will be handled, and later almost every time you update your projection to accommodate what is really happening on the income and expense sides of your actual results.

You will want to modify the template so that the defaults are more like your usual project. 

The Income Projection spreadsheet can be downloaded here in PDF format, xlsx format, and in Apple's Numbers format.

This spreadsheet makes it dead simple to do a projection but the real benefit comes from being able to see the impact of all your projections at once and updated. There's a tool for a real cash flow projection. You can find it here.
Picture
If you would like articles like this sent to your inbox, SUBSCRIBE.

Here's how to forecast your revenue. OFFPLAN

Create your competitive edge. Trello-PM. A Project Management guide.

Use FeeCalqs, a digital Fee Calculation tool.

​
​###

Comments are closed.
    Resources

    Start Here

    YouTube Channel

    Join The Mailing List

    Picture

    Terms of Use
    Your use of Architekwiki is implicit agreement with the 
    ​
    Terms of Use.
    Thank You for your donation

    x
    Get Good Stuff in Your Inbox
    Picture
    Subscribe

    RSS Feed


    Archives

    January 2023
    November 2022
    October 2022
    July 2022
    June 2022
    April 2022
    October 2021
    September 2021
    August 2021
    June 2021
    May 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012

    Categories

    All
    Business Development
    Business Management
    Design
    Detail
    Miscellaneous
    Project Management
    Resources

Picture

Picture
VISIT ARCHITEKWIKI'S RESOURCES
​
START HERE
ABOUT
SIGN UP
TERMS OF USE
Architekwiki | Architect's Resource | Greater Cincinnati 
© 2012-2022   Architekwiki​