A set of nine linked worksheets which can be used to produce a full set of accounts, including all of the financial planning documents needed for the AQA A2 Applied Business BS08 portfolio.
The document makes use of detailed formulas and drop-down menus to minimise data input to the following requirements.
1) Sales Forecast
2) Operations (Costs) Forecast
3) Start-up Costs (including appropriate sources of finance required)
From the above data the following can be automatically produced...
4) Break Even Forecast (including graph)
5) Cash Flow Forecast for the start-up phase (3 month) and first year trading
6) Profit & Loss Account (Income Statement) for the first year
7) Balance Sheet for the first day of trading
8) Ratio Analysis (includes NPM, GPM, ROCE, and Gearing)
9) Payback Calculation
Each page is protected to stop students deleting important formulas, but there is no password!
The document makes use of detailed formulas and drop-down menus to minimise data input to the following requirements.
1) Sales Forecast
2) Operations (Costs) Forecast
3) Start-up Costs (including appropriate sources of finance required)
From the above data the following can be automatically produced...
4) Break Even Forecast (including graph)
5) Cash Flow Forecast for the start-up phase (3 month) and first year trading
6) Profit & Loss Account (Income Statement) for the first year
7) Balance Sheet for the first day of trading
8) Ratio Analysis (includes NPM, GPM, ROCE, and Gearing)
9) Payback Calculation
Each page is protected to stop students deleting important formulas, but there is no password!
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£2.00