RealTime CEO
  • About Us
    • Nick Setchell – RealTime CEO
    • Vistage & TEC WorkshopsNick Setchell has been working with Vistage, the world’s largest CEO organization, since 2001.
    • NewsSee what’s happening with RealTime CEO.
    • Economic Update Report
    • Contact UsReach out to us. If you’re interested in booking Nick to give a keynote address or workshop at your conference, please include the date and location.
  • Concepts
    • Fiscal Focus Financial Statement AnalysisUnlock the hidden numbers in your P&L and balance sheet to see how you’re performing in 11 vital metrics.
    • Should We? / Can We?View, in real time, the actual financial impact of the hundreds of business decisions your team makes every month.
    • 24 Month Rolling ForecastingBlend your trailing twelve months with a rolling 12-month forecast to get a complete financial picture of your business.
    • J Curve ManagementTrack the number of investments you’re undertaking, the 3 phases of each, and the 5 rules for managing them.
    • Return on Operations – ROOView your return on operations percentage — your ROO % — the most powerful number to measure business success.
    • CEO Performance AnalysisBenchmark your performance as a private-company CEO against others in your industry.
  • Resource Center
  • Blog
  • Login
  • SUBSCRIBE

  • About Us
    • Nick Setchell – RealTime CEO
    • Vistage & TEC WorkshopsNick Setchell has been working with Vistage, the world’s largest CEO organization, since 2001.
    • NewsSee what’s happening with RealTime CEO.
    • Economic Update Report
    • Contact UsReach out to us. If you’re interested in booking Nick to give a keynote address or workshop at your conference, please include the date and location.
  • Concepts
    • Fiscal Focus Financial Statement AnalysisUnlock the hidden numbers in your P&L and balance sheet to see how you’re performing in 11 vital metrics.
    • Should We? / Can We?View, in real time, the actual financial impact of the hundreds of business decisions your team makes every month.
    • 24 Month Rolling ForecastingBlend your trailing twelve months with a rolling 12-month forecast to get a complete financial picture of your business.
    • J Curve ManagementTrack the number of investments you’re undertaking, the 3 phases of each, and the 5 rules for managing them.
    • Return on Operations – ROOView your return on operations percentage — your ROO % — the most powerful number to measure business success.
    • CEO Performance AnalysisBenchmark your performance as a private-company CEO against others in your industry.
  • Resource Center
  • Blog
  • Login
  • SUBSCRIBE

How to Update Forecast Balance Sheet amounts

The following Balance Sheet lines are forecast:

  • Accounts Receivable
  • Inventory
  • Accounts Payable
  • Fixed Assets

Accounts Receivable

  1. Go to the Forecast Summary screen.
  2. Click the Edit pencil on the Accounts Receivable line. The actual AR balance last loaded is displayed, as well as the AR Days.
  3. Either enter the number of Days or a manual amount to update the forecast.
  4. Click Accept & Save when the data entry is complete.

Inventory

  1. Go to the Forecast Summary screen.
  2. Click the Edit pencil on the Inventory line. The actual Inventory balance last loaded is displayed, as well as the Inventory Days.
  3. Either enter the number of Days or a manual amount to update the forecast.
  4. Click Accept & Save when the data entry is complete.

Accounts Payable

  1. Go to the Forecast Summary screen.
  2. Click the Edit pencil on the Accounts Payable line. The actual AP balance last loaded is displayed, as well as the AP Days.
  3. Either enter the number of Days or a manual amount to update the forecast.
  4. Click Accept & Save when the data entry is complete.

Fixed Assets

  1. Go to the Forecast Summary screen.
  2. Click the Edit pencil on the Fixed Assets line. The actual FA balance last loaded is displayed.
  3. Enter the expected Acquired and Disposed amounts per month.  This shows a running balance of Fixed Assets including depreciation forecast in the Income Statement.
  4. Click Accept & Save when the data entry is complete.



RealTime CEO
Company
  • About
  • Blog
  • Terms of Use
  • Privacy Policy
Contact Us
  • Support
  • Management Consulting
  • Keynote Addresses
Economic Updates
  • Sign up to receive our economic update
    Learn More

© 2023. RealTime CEO. All Rights Reserved