FAC1602 - Elementary Financial Accounting And Reporting (FAC1602)
Other
FAC1602 Excel Template for Assessment 1 - 2023
22 views 0 purchase
Course
FAC1602 - Elementary Financial Accounting And Reporting (FAC1602)
Institution
University Of South Africa (Unisa)
This is an excel spreadsheet with the layout of the following:
1. STATEMENT OF PROFIT OR LOSS AND OTHER COMPREHENSIVE INCOME
2. STATEMENT OF CHANGES IN EQUITY FOR THE YEAR (for partners)
3.STATEMENT OF FINANCIAL POSITION
It contains formulas for the calculations as well as detailed instructions...
FAC1602 - Elementary Financial Accounting And Reporting (FAC1602)
All documents for this subject (98)
Seller
Follow
yvonneg46
Content preview
Instructions
1. Make a copy of this template and call it the exercise or the exam you are working on.
2. Fill in the values in cells with no colour. The coloured cells have formulas or links
3. The formula cells are not protected - you can override them.
4. Practice exercises with the template to become familiar with how it works.
5. During the assignment, save a copy of your workings for each of the questions. There are normally 2 long qu
6. You can add in your own calculations and workings as needed
7. You still need to know and understand the work. This helps you get the calculations done quickly and accura
the layouts.
8. Below is a guide showing you where to fill in the values on the template. After filling these in, you need to ap
Put in SoCie sheet
Depreciation table in
SoFP
Existing Credit Loss
Allowance in the Break out
box for Credit Loss on the
Statement of Profit or Loss
sheet
Cash and Equivalents (4)
in SoFP
These expenses can be placed
anywhere in Distribution,
Administrative and Other
Expenses (Debit Balances) on
the Statement of Profit or
Loss. Be careful not to
overwrite the 2 formula
fields : Depreciation and
Credit Losses
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller yvonneg46. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.56. You're not tied to anything after your purchase.