4.5893 reviews

Last updated

22 February 2018

This spreadsheet contains the following:

A Balance Sheet Template
A Profit and loss Template
Accounting ratios automatically calculated for
Gross Profit Margin
Net Profit Margin
ROCE
Current Ratio
Quick Ratio
Creditor Payment Period
Debtors Collection Period
Stock Turnover

A sheet to enter data from periods accounting periods and industry standard

Graph showing Efficiency Ratios (2 years data against industry standard)

Graph showing profit ratios (2 years data against industry standard)

Graph showing Liquidity Ratios (2 years data against industry standard)

Tes paid licenceHow can I reuse this?

Get this resource as part of a bundle and save up to 67%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

Unit 3 Personal and Business Finance - BTEC Level 3 Revision booklet - Learning Aim A and B

This resource contains two revision booklet for BTEC Business Level 3 - Unit 3 Personal and Business Finance The first booklet covers Learning aim A - Personal Finance Functions and Role of Money (A1) Different ways to pay (A2) Current Accounts (A3) Managing Personal Finance (A4) The second booklet covers Learning aim B - Explore the personal finance sector. Features of Financial Institutions (B1) Communicating with customers (B2) Consumer Protection in relation to personal finance (B3) Information guidance and advice (B4) The student booklets contain revision activities and exam style questions. The teacher answer booklets contains answers to all the revision activities and mark schemes for the exam style questions. I am currently working on revision booklet for the other Learning Aims and also plan to produce a mock exam. Also included are some spreadsheet templates for ratio analysis, break even and cash flow which will help with the later learning aims.

£4.00