Student Details
Student ID No:
Student Name:
Instruction
Please complete the following question and tasks based of the study of the learner guide for SITXFIN002 Interpret Financial Information and your working knowledge of the subject.
This assessment is deigned to assess your ability to calculate and interpret data in a balance sheet, profit and loss and banking transactions.
There are 3 Tasks to this Assessment.
1. Balance Sheet
2. Income Statement /Profit and Loss Statement
3. Banking and Merchant Information
Task 1 - Balance sheet
INSTRUCTIONS
This Assessment contains two PARTS (PART A and PART B)
PART A
• Complete the calculations then save the file and print a copy of the completed Balance sheet and attach this to this task.
• Answer the written questions and submit.
PART B
• Print a copy of the Balance Sheet displaying the formulas that you have used.
PART A
Instructions
• You are provided with an excel spread sheet called Task 1 Balance sheet. This spread sheet is a Balance sheet for the “Top of the Town Hotel”.
• When you open the spread sheet you will see that you are already provided with some figures in the Balance Sheet.
1. Calculate the following:
Total Current Assets Total Current Liabilities
Total Non-current Assets Total Owner’s equity
Total Assets Total Liabilities & Owner’s Equity
2. Explain how and why you have calculated the following:
Total Current Assets
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Total Non-current Assets
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Total Assets
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Total Current Liabilities
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Total Non -Current Liabilities
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Total Owner’s equity
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Total Liabilities
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Total Liabilities & Owner’s Equity
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Net Assets
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
3. Based on your calculations you are now required to analyse and review the Balance sheet to assess the Financial Position of “Top of the Town Hotel”. Do you think that business is able to pay all its Total Liabilities? If so, how much do they owe in Total Liabilities? If they pay the Total Liabilities what will be their Net Assets and Owner’s Equity.
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Part B
Print a copy of the Balance Sheet displaying the formulas that you have used for your calculations.
Task 2 – Income Statement /Profit and Loss Statement
Instructions
Background information
• You have been provided with the Income Statement / Profit or Loss Statement for the Blueberry Cafe.
• As you will see some of the key figures have been provided to you already.
• Tax is calculated at a flat rate of 30%
Your Task
Perform the following calculations to complete this income statement/ Profit or Loss Statement and then analyse the findings.
1. Gross Profit
2. After Labour Profit
3. Total of all the operating expenses
4. Profit before Tax
5. Income Tax (to be calculated at a flat rate of 30%)
6. Profit after Tax
7. Calculate the percentages for
a. Cost of Sales
b. Gross Profit
c. Less Labour
d. Total of the Less operating expenses
e. Profit before Tax
f. Profit after Tax
Blueberry Cafe
Income Statement for the month ended 30th June 2016
Sales 75,000 100%
Less cost of Sales 17,500 %
Gross Profit %
Less Labour 21,000 %
After Labour Profit %
Less operating expenses
Gas 1,800
Water 1,100
Interest expenses 2,000
Maintenance 3,000
Cleaning 2,000
Fuel 900
Vehicle repairs 500
Electricity 2,500
Miscellaneous 300
Advertising 1,500
Profit before Tax
Income Tax
Profit after Tax
How is the performance overall, given common ratios in the TH&E industry?
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
Task 3 – Banking and Merchant Information
Instructions
Complete the 4 questions below regarding banking and merchant information for Blueberry Café.
1. Banking Summary
Complete the below banking summary for the 8th May 2016 using the transactions in the table showing a summary for the 8th May for Blueberry Café.
Date Account Amount Type
8/5/16 Register 300 CA
8/5/16 Joseph Marsh 50 CA
8/5/16 Italiano 360 CQ
8/5/16 Register 945.50 CC
8/5/16 Register 91.00 PP
8/5/16 A-Z Stationery 3255.00 DD
8/5/16 Register 75 Amex
8/5/16 Emerald Jewellery 450 CC
8/5/16 Register 651.20 EFT
Banking Summary Date ___________________
Total Cash $____________
Total Cheques $____________
Total Banking $____________
Total Eftpos $____________
Total Credit Cards $____________
Total Direct Debits $____________
Amex or Diners $____________
Cancelled receipts $____________
Paypal $____________
Total Monies Received $____________
2. Credit Card Transaction Statement
The following purchases were made by Joe at Blueberry Café using the company credit card between 2nd and 5th May 2017.
2.5.17 Purchased $123.00 of Google Ads.
2.5.17 Payment of $95 to Optus for mobile phone bill.
3.5.17 Purchased $12.50 worth of magazines at Airport Newsagency.
3.5.17 Deposit $359 to pay off outstanding balance.
4.5.17 Purchased US$30.50 of food at TGI Fridays in Los Angeles (exchange rate 0.7495)
4.5.17 Purchased US$397 of accommodation at Roosevelt Hotel (exchange rate 0.7495)
Complete the below extract from Credit Card Transaction Statement by inserting the transactions above and updating the outstanding amount after each transaction.
Date Description Transaction Amount
1.5.17 Opening Balance $359.52 CR
5.5.17 Closing Balance
3. Merchant Statements
Complete the total column by calculating the transaction fee charged in the below merchant statement for the 30.4.17 for Blueberry Café.
Credit Card Type Total Sales Transaction fee % Total Merchant fee
Amex $349.50 2.4% $
Visa $1039.85 1.4% $
Mastercard $280.00 1.4% $
Total Merchant Fees 30.4.17 $
4. Merchant Summary
Below is a merchant summary example from Paypal for Blueberry Café. Using the below statement, how much is the value of the sales for the 23rd to the 24th September that have successfully transacted through the system?
$ _____________________
Screenshot from - https://www.securepay.com.au/developers/products-and-services/reporting/merchant-login/
GET ANSWERS / LIVE CHAT