Sensitivity analysis is a model to show how to target variables that are affected by changes in input variables. Sensitivity analysis determines how different values of independent variables affect a particular dependent variable under a given set of assumptions.
In this Case Study, I set a strategy were adopted from one January, what the cash balance closest to at the end of 2020, if:
– sales price increases by 12%
– forecast volume is lower going forward by 5%
– direct costs per unit are maintained.
In which quarter the cash shortfall peak, which month run out of the cash, what is the total of indirect cost forecast expected for the three years forecast, what is the closing accounts payable in December 2020, what is the forecast revenue in January 2019.
You as a financial analysis need to forecast the cash flow for the coming three years with a particular focus on the next twelve month, you will design a sensitivity financial model to determinate who the small change in the input assumption will effect in cash flow and revenue in the output, in which point of input assumption the cash flow is so sensitive, what strategy you need to set to a swift improvement in cash flow, to keep the businesses afloat.
This model template comes as a PREMIUM version in .xlsx file type which can be opened using MS Excel.
Similar Products
Other customers were also interested in...
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Due Diligence P&L – Exhaustive Revenue a...
Model for in depth understanding of high level profit and loss and revenue analysis. Big-4 like chec... Read more
Advanced Financial Model with DCF & Valuation
New Version Updates:• Model is now dynamic. Users can select the desired forecast length for up to... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
3 Statement Financial Modeling with DCF & Rel...
Financial Modeling Tutorial guides user via step by step approach on how to build financial models w... Read more
Franchisor Licensing: Financial Model with Cap Tab...
Build up to a 10 year financial forecast with assumptions directly related to the startup and operat... Read more
Financial Analysis Template
Financial analysis is used to evaluate economic trends, set financial policy, build long-term plans ... Read more
Complete Three-Statement Monthly Budget with Scena...
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Joint Venture and Fund Cash Flow Waterfall Templat...
Here are all the spreadsheets I've built that involve cash flow distributions between GP/LP. Include... Read more
You must log in to submit a review.