Originally published: 10/04/2020 12:23
Last version published: 14/05/2020 08:05
Publication number: ELQ-66055-4
View all versions & Certificate
Last version published: 14/05/2020 08:05
Publication number: ELQ-66055-4
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)
by Lance RubinCEO & Founder of Model Citizn and professional financial modeler and trainer for FMIFollow 247
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 (82 votes)- 88%
- 11%
- 1%
- -
- -
Write a review
People using this Best Practice also downloaded
Yield Curve Simulation Excel Model & Automated Commentary
Yield Curve Simulation Model (automated commentary) showing global impacts of yield curves on bond valuations290Discussadd_shopping_cart$25.00by Lance Rubin
Gasoline/CNG/Petrol/Diesel Station Company Financial Model
This financial model focuses on valuation/analysis of a company in business of Gasoline/CNG/Petrol/Diesel selling.328Discussadd_shopping_cart$49.00by Karan Kaushal
Excel Financial Modelling Course
Financial modelling using different scenarios to create robust structure, report setup, to create Excel magic.8491add_shopping_cart$300.00by Marcus Small
Market Analysis - Crisis Scenarios Template
A PowerPoint Slide for any economist or business analyst to forecast the effects of a Crisis on a defined key variable.349Discussadd_shopping_cart$9.00by Tim Demoures
10 Years Financial Forecast and Valuation Excel Model
Three statement financial model to forecast the Company's P&L account, BS, Cash Flow and Company's Valuation2,1122add_shopping_cart$50.00by Jair Almeida
Generic Monthly 5-Year 3 Statement Rolling Financial Projection Model with Scenario Analysis
COVID-19 ready rolling 3 statement excel projection model across 5 year period with scenario analysis431Discussadd_shopping_cart$45.00by Projectify
Pre-Sold Apartments Real Estate Model Excel Template
Model presents the case where a land plot is purchased and an apartment complex is built and pre sold to clients.3432add_shopping_cart$49.00by Big4WallStreet
10-Year Financial Projections Excel Model
This is a professional, highly detailed financial projection model for your company over a 10-year period.333Discussadd_shopping_cartGYNECOLOGY CENTER BUSINESS PLAN FINANCIAL MODEL EXCEL TEMPLATE TRIAL
Complete Gynecology Center Business Plan to forecast Cash Flow. Check how to start your own Gynecology Center!33Discussadd_shopping_cartfreeby Henry Sheykin
Used Car Dealership - 5 Year Pro-Forma Excel Financial Model
A bottom up financial model to forecast the revenue, expenses, and cash flows of a used car dealership startup business.2,071Discussadd_shopping_cart$45.00by Jason Varner
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,0397add_shopping_cart$185.00Powerful Dynamic Arrays Model with Monte Carlo Simulation
Newly released Dynamic Arrays functionality by Microsoft means models are now more powerful than ever!4441add_shopping_cart$299.00Property Valuations Modeling
Simple Property Valuation Model showing the 3 primary methods for valuing property assets with an interactive visual.2,895Discussadd_shopping_cart$9.50Hedging Policy Tool & Simulation
Foreign Exchange Hedging Policy Tool to enable simulation of hedged and unhedged exposures using derivatives.1952add_shopping_cart$25.003-way Banking Financial Model converted into an App
Demonstration tool of a 3-way banking financial model converted into an interactive visualisation App1,693Discussadd_shopping_cart$9.50PowerBI 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,025Discussadd_shopping_cart$35.00Yield Curve Simulation Excel Model & Automated Commentary
Yield Curve Simulation Model (automated commentary) showing global impacts of yield curves on bond valuations290Discussadd_shopping_cart$25.003-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.739Discussadd_shopping_cart$399.00Debt Modeling Workbook (Training)
Train yourself at generating loan schedules for personal loans1,663Discussadd_shopping_cartfreeFuture of Finance (FOF) Course
A 4 Part Course on the Future of Finance and where it is headed.127Discussadd_shopping_cartfreeFirst 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.701Discussadd_shopping_cartfreeData 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.412Discussadd_shopping_cartfree
Discussion feed for 1 Way Cash Flow Excel Model
The user community and author are here to help. Go ahead!
- Hi all, apologies for the protected file. I have uploaded an unlocked version. Once approved you should get notification of the update.
- hi, I'm trying to edit the excel document but it's protected. Is there a password?
- Same for me
- Sorry need to release it. Will submit an updated file.
- Are you planning to build a version for US based companies and stimulus?
- 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.
Downloadable Best Practice Authorstar