
Last version published: 02/01/2021 10:37
Publication number: ELQ-66055-5
View all versions & Certificate

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)
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
4.9 / 5 (87 votes)- 87%
- 11%
- 1%
- -
- -
Write a review
- Very goodVery nice
People using this Best Practice also downloaded
More Best Practices from Lance Rubin
Financial Modeling Institute (AFM) Exam Solution
This is our FMI Exam solution created by Model Citizn. The model demonstrates other alternatives to the exam solution.2,1247add_shopping_cart$185.00by Lance Rubin
Powerful Dynamic Arrays Model with Monte Carlo Simulation
Newly released Dynamic Arrays functionality by Microsoft means models are now more powerful than ever!5101add_shopping_cart$299.00by Lance Rubin
Property Valuations Modeling
Simple Property Valuation Model showing the 3 primary methods for valuing property assets with an interactive visual.2,981Discussadd_shopping_cart$9.50by Lance Rubin
Hedging Policy Tool & Simulation
Foreign Exchange Hedging Policy Tool to enable simulation of hedged and unhedged exposures using derivatives.2102add_shopping_cart$25.00by Lance Rubin
3-way Banking Financial Model converted into an App
Demonstration tool of a 3-way banking financial model converted into an interactive visualisation App1,730Discussadd_shopping_cart$9.50by Lance Rubin
PowerBI Financial data for learning and growth mindset.
Use the files provided to create your own dashboards in PowerBI and learn for free. Take advantage today.2,108Discussadd_shopping_cart$35.00by Lance Rubin
Yield Curve Simulation Excel Model & Automated Commentary
Yield Curve Simulation Model (automated commentary) showing global impacts of yield curves on bond valuations334Discussadd_shopping_cart$25.00by Lance Rubin
3-way Financial Model with PowerBI visualisation including Google Analytics
Excel with structured table export from 3-way model to PowerBI already transformed. Google Analytics Data included too.1,036Discussadd_shopping_cart$399.00by Lance Rubin
Debt Modeling Workbook (Training)
Train yourself at generating loan schedules for personal loans1,708Discussadd_shopping_cartfreeby Lance Rubin
Future of Finance (FOF) Course
A 4 Part Course on the Future of Finance and where it is headed.138Discussadd_shopping_cartfreeby Lance Rubin
First Basic Modeler Project File demonstrating how to create a simply interactive app with Excel and Powerpoint
This is a simple example of how to connect Excel and Powerpoint using Modeler which then enables interactive visuals.744Discussadd_shopping_cartfreeby Lance Rubin
Data analysis & dynamic reporting for cloud accounting Xero and QBO using Excel
USING EXCEL TO AUTOMATE PROCESS IN XERO AND QBO? YES YOU CAN Using DataDear you are able to both pull and push data.453Discussadd_shopping_cartfreeby Lance Rubin
Discussion feed for 1 Way Cash Flow Excel Model
The user community and author are here to help. Go ahead!