Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

for Inventory Turnover rate and Days Inventory held (note how long the business has been in operation) - 3 months Use the following template to

for Inventory Turnover rate and Days Inventory held (note how long the business has been in operation) - 3 months

  1. Use the following template to prepare an email to the partners. Your email should be based on the financial reports you prepared above and include the following:
    • Current ratio
    • Quick ratio
    • Gross prot ratio
    • Net prot rate
    • Inventory turnover (assume when calculating average inventory, the Opening Inventory = $0)
    • Days inventory is held
    • Make three suggested changes the partners could make that would help business growth. For each, describe how it will benet the business in the longer term.
    • Explain the advantages and disadvantages of the ratio analysis you have completed
    • Comment on how the liquidity, protability and activity of the business compares with the following industry averages:
Ratio name Industry Averages
Current ratio 2:1
Quick ratio 1.38:1
Inventory turnover rate 5 times
Average days inventory is held 61 days
Gross profit rate 34%
Net profit rate 12%
Income statement
3 months ended 30 June 2022
$ $ $
Sales 35,680.00
Less COGS
Purchases 22,160.00
Packaging 754.00
Cost of Goods available for sale 22,914.00
Less: Closing inventory - 9,334.00 13,580.00
Gross Profit 22,100.00
Less: Operating expenses
Marketing and distribution
Advertising 480.00
Delivery Costs 502.00 982.00
Administration
Accounting Fees 542.00
Depreciation 360.00
Insurance 375.00
Order Costs 714.00
Rent 1,200.00
Telephone and Internet 1,007.00
Website Maintenance 420.00 4,618.00
Total Expenses 5,600.00
Net Profit 16,500.00
To James Cross 5,500
To Leona Riley 5,500
To Brady Chan 5,500

Balance sheet
as at 30 June 2022
$ $ $
Current Assets
Cash 39,681.10
Inventory 9,334.00
Prepaid Insurance 1,125.00 50,140.10
Non-Current Assets
Equipment 5,000.00
Equipment Depreciation -250.00 4,750.00
Furniture 800.00
Furniture Depreciation -20.00 780.00
Software 1,800.00
Software Depreciation -90.00 1,710.00
Total Non-Current Assets 7,240.00
Total Assets 57,380.10
Current Liabilities
GST Collected 3,568.00
Less: GST Paid -3,187.90 380.10
Total Liabilities 380.10
Net Assets 57,000.00
Owners Equity
James Capital 15,000.00
James Current 4,000.00 19,000.00
Leona Capital 10,000.00
Leona Current 4,000.00 14,000.00
Brady Capital 15,000.00
Brady Current 4,000.00 19,000.00
Total Equity 57,000.00

Cash flow statement
3 months ended 30 June 2022
$
Cash Flows from Operating Activities
Recipts from customers (including GST) 39,248.00
Payments for inventory (including GST) -25,205.40
expenses paid (including GST) -7,001.50
GST paid on purchases of non-current assets -260
net cash from operating expenses 6,781.10
Cash flows from investing activities
payments for furnaiture -800
payments for software -1,800.00
net cash from investing activities -2,600.00
cash flows from financing activities
capital invested by partners 40,000.00
payments for drawings -4,500.00
net cash from finacing activities 35,500.00
change in cash balance 39,681.10
add: cash at start of period
Cash at end of period 39,681.10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting IFRS

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield

4th Edition

1119607515, 978-1119607519

More Books

Students also viewed these Accounting questions

Question

Explain the importance of intersectionality in sampling.

Answered: 1 week ago

Question

What is meant by planning or define planning?

Answered: 1 week ago

Question

Define span of management or define span of control ?

Answered: 1 week ago

Question

What is meant by formal organisation ?

Answered: 1 week ago

Question

What is meant by staff authority ?

Answered: 1 week ago

Question

4. What is the goal of the others in the network?

Answered: 1 week ago

Question

2. What we can learn from the past

Answered: 1 week ago