Question
You are book keeper employed at Nancys Business Services Pty Ltd. You are asked to prepare a worksheet and a set of financial statements based
You are book keeper employed at Nancys Business Services Pty Ltd. You are asked to prepare a worksheet and a set of financial statements based on a list of business transactions in Excel and are required to perform financial analysis in Excel, based on the financial statements you have prepared.
The following business transactions and business events relate to Nancys Business Services Pty Ltd in June:
1 - Nancy commenced business with $15000 given to her by her Aunt Kate.
4 - Purchased new computer for her business $1200 on credit.
5 - Received $500 for services rendered.
6 - Paid rent on office for June $400.
7 - Negotiated with Kerry Ltd regarding possible casual employment contracts totalling $1500.
8 - Aunt Kate injected a further $2000 gift into Nancys business.
9 - Billed a client $500 for services rendered.
10 - Received an invoice for new reception desk $3400.
15 - Paid for telephone connection fee $65.
16 - Sent a quote for a large prospective job $4800.
16 - Paid gas charges $231.
23 - Received $250 for consultation work completed.
28 - Paid in full for the reception desk bought on 10 June.
30 - Paid advertising $200.
Requirements:
(a) Prepare an accounting worksheet for the business transactions in June by filling in the appropriate values and calculations from the above information.
Assets
| Liabilities | Owners Equity | ||||||
| Cash | Accounts Receivable | Office Furniture | Office Equipment | Account Payable | Loan | Capital(+) or Drawings(-) | Profit/Loss Revenue Expenses
|
` | ||||||||
total
| ||||||||
(b) Prepare a statement of profit or loss and statement of financial position in Excel for Nancys Business Services Pty Ltd for the period ending 30 June 2023;
(c) Calculate and interpret two stability ratios to evaluate Nancys financial stability in the long term (refer to session 5 for detailed information regarding ratio analysis).
(b) What additional information may be helpful to provide a more detailed assessment of Nancys financial stability?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started