Answered step by step
Verified Expert Solution
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
- 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
Get Instant Access to Expert-Tailored 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