FIN3704
Assignment 2 Semester 1 2026
Unique number:
Due Date: 24 April 2026
QUESTION 1
1.1
Two Excel functions used to gather and analyse financial statement data are:
SUM function – used to add totals such as total revenue, total expenses, or total
assets.
AVERAGE function – used to calculate averages, for example average monthly
sales or expenses.
Terms of use
By making use of this document you agree to:
Use this document as a guide for learning, comparison and reference purpose,
Terms of use
Not to duplicate, reproduce and/or misrepresent the contents of this document as your own work,
By making
Fully accept the consequences should use ofor
you plagiarise this document
misuse you agree to:
this document.
Use this document solely as a guide for learning, reference, and comparison purposes,
Ensure originality of your own work, and fully accept the consequences should you plagiarise or misuse this document.
Comply with all relevant standards, guidelines, regulations, and legislation governing academic and written work.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is" without any express or
implied representations or warranties. The author accepts no responsibility or liability for any actions taken based on the
information contained within this document. This document is intended solely for comparison, research, and reference purposes.
, +27 81 278 3372
QUESTION 1
1.1
Two Excel functions used to gather and analyse financial statement data are:
SUM function – used to add totals such as total revenue, total expenses, or
total assets.
AVERAGE function – used to calculate averages, for example average
monthly sales or expenses.
1.2
Two key components to consider when constructing a cash budget in Excel are:
Cash inflows – this includes money coming into the business such as sales
receipts, loans received, or investment income.
Cash outflows – this includes payments such as salaries, rent, suppliers, and
other operating expenses.
1.3
Two steps for projecting financial performance using historical data are:
Analyse past data trends – review previous financial data such as sales and
expenses to identify patterns or growth trends.
Apply growth assumptions or forecasting formulas – use Excel tools like
formulas or trend functions to estimate future values based on historical
performance.
2.3
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
Assignment 2 Semester 1 2026
Unique number:
Due Date: 24 April 2026
QUESTION 1
1.1
Two Excel functions used to gather and analyse financial statement data are:
SUM function – used to add totals such as total revenue, total expenses, or total
assets.
AVERAGE function – used to calculate averages, for example average monthly
sales or expenses.
Terms of use
By making use of this document you agree to:
Use this document as a guide for learning, comparison and reference purpose,
Terms of use
Not to duplicate, reproduce and/or misrepresent the contents of this document as your own work,
By making
Fully accept the consequences should use ofor
you plagiarise this document
misuse you agree to:
this document.
Use this document solely as a guide for learning, reference, and comparison purposes,
Ensure originality of your own work, and fully accept the consequences should you plagiarise or misuse this document.
Comply with all relevant standards, guidelines, regulations, and legislation governing academic and written work.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is" without any express or
implied representations or warranties. The author accepts no responsibility or liability for any actions taken based on the
information contained within this document. This document is intended solely for comparison, research, and reference purposes.
, +27 81 278 3372
QUESTION 1
1.1
Two Excel functions used to gather and analyse financial statement data are:
SUM function – used to add totals such as total revenue, total expenses, or
total assets.
AVERAGE function – used to calculate averages, for example average
monthly sales or expenses.
1.2
Two key components to consider when constructing a cash budget in Excel are:
Cash inflows – this includes money coming into the business such as sales
receipts, loans received, or investment income.
Cash outflows – this includes payments such as salaries, rent, suppliers, and
other operating expenses.
1.3
Two steps for projecting financial performance using historical data are:
Analyse past data trends – review previous financial data such as sales and
expenses to identify patterns or growth trends.
Apply growth assumptions or forecasting formulas – use Excel tools like
formulas or trend functions to estimate future values based on historical
performance.
2.3
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
