Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash Flow Statement: Cash inflows are entered as a positive number: (e.g. 2000) Cash outflows are entered as a negative number (e.g. -2000) Balance Sheet:

Cash Flow Statement: Cash inflows are entered as a positive number: (e.g. 2000) Cash outflows are entered as a negative number (e.g. -2000) Balance Sheet: Increases to assets, liabilities or equity items are shown as a positive number (e.g. 2000) Decreases to assets, liabilities or equity items are shown as a negative number (e.g. -2000) Increases to contra asset items are shown as a negative number (e.g. -2000) Decreases to contra asset items are shown as a positive number (e.g. 2000) Income Statement: Revenues or Income items are shown as a positive number (e.g. 2000) Expense items are shown as a negative number (e.g. -2000) A Profit is shown as a positive number (e.g. 2000) A Loss is shown as a negative number (e.g. -2000) Use negative sign but. DO NOT use a thousand separator. For example, the correct way to type "One Thousand" is *1000, not "1,000" or "1.000". Only enter numbers. Do not enter dollar signs ($) in the cells.

For all transactions, please ignore GST and assume that all transactions are in Australian dollars. 1. Jan 1: Amera signed a 2-year lease for a warehouse and office for $2,000 per month to store all their inventory. They have paid one month of rent in advance. 2. Jan 1: Sarah contributed $25,000 cash to the business. 3. Jan 1: The owners purchased a delivery truck for $80,000 through a bank loan over 5 years with an interest rate of 6.7 per cent per annum. Payments are required on the first day of every month, with the first payment due on February 1. 4. Jan 1: A new forklift was purchased on credit for $30,500. The payment is due in 10 equal instalments over the next 10 months, with the first payment due on January 30. 5. Jan 5: An order was placed for 100 gaming chairs at a cost of $75 each and 100 gaming desks at a cost of $110 each was placed with Gaming Accessories Co. Delivery occurred the same day and the total was paid in cash. 6. Jan 6: An order was placed for 25 gaming PCs for $300 each from Alliance Digital. Delivery occurred the same day and the total was paid in cash. 7. Jan 7: Sold 50 chairs for $130 each, 50 desks for $180 each and 15 gaming PCs for $390 each to BBG Games. BB Games has been given 90 days to pay their account and the products will be delivered to them in 7 days. 8. Jan 13: An order was placed for 100 gaming chairs at a cost of $70 each and 100 gaming desks at a cost of $100 each with gaming Accessories Co. Delivery occurred the same day and the total was paid in cash. 9. Jan 13: An order was placed with Alliance Digital for 30 gaming PCs for $269 each. Delivery occurred the same day, and Digital Field Day have 30 days to pay their account. 10. Jan 14: Total commission income received in cash for the fortnight for the online store is $2,540. 11. Jan 14: Total wages for the fortnight were paid $2,900. 12. Jan 14: Delivered goods to BB Games, following the transaction on January 7. 13. Jan 15: Sold 35 chairs for $135 each, 35 desks for $185 each, and 20 gaming PCs for $390 each to Gamers Rise. Delivery occurred the same day. The customer was given 90 days to pay their account. 14. Jan 24: Sold 100 chairs for $125 each, 100 desks for $175 each and 15 gaming PCs for $395 each to the Digital Computer Store. Delivery occurred on the same day. The customer was given 90 days to pay their account. 15. Jan 28: Total commission income received in cash for the fortnight from the online store is $1,920. 16. Jan 28: Total wages for the fortnight were paid $2.900. 17. Jan 30: A payment for the forklift was made (see information from January 1 above). 18. Jan 31: A payment was made for various business expenses incurred on the corporate credit card for the month of January of $1,150.

image text in transcribedimage text in transcribed
Date in January (e.g. 1 Jan) Op bal 5 Jan 6 Jan 13 Jan 13 Jan 14 Jan Cash Flow Statement Operating Cash Flows Investing Cash Flows Financing Cash Flows Balance Sheet Current Assets Cash 26,500 Accounts Receivable Inventory Prepaid Insurance 2,550 Prepaid Advertising 3,450 Prepaid Rent Non-current Assets Equipment 18,500 Acc. Dep. - Equipment -2,250 Vehicles - Delivery Truck Acc. Dep. - Delivery Truck Vehicles - Forklift Acc. Dep. - Forklift Total Assets 48,750 Current LiabilitiesVenicies - Delivery Truck Acc. Dep. - Delivery Truck Vehicles - Forklift Acc. Dep. - Forklift Total Assets 48,750 Current Liabilities Accounts Payable Wages Payable Interest Payable Non-current Liabilities Bank Loan Equity Capital 47,790 Retained Earnings 960 Total Liabilities and Equity 48,750 Income Statement Sales Revenue Cost of Goods Sold Gross Profit Commission income Wages Expense Other Expenses Profit (Loss)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Principles of Economics

Authors: Robert Frank, Ben Bernanke

5th edition

73511404, 978-0073511405

Students also viewed these Accounting questions