Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Silk Ltd will commence trading in June 2023 with Share Capital of 50,000. The company will spend 60,000 on equipment. They have arranged a loan

image text in transcribed Silk Ltd will commence trading in June 2023 with Share Capital of 50,000. The company will spend 60,000 on equipment. They have arranged a loan of 120,000 with interest at 10% p.a. over five years. Repayments of capital and interest are 2,433 each month. The loan interest for the period included in the repayments is 2,367. Sales are expected to be as follows: June 120,000 : July 120,000 : August 150,000. 40% of sales are for cash and attract a discount of 5%. The remainder of sales is on credit terms and collected 1 month later. Opening inventory of 60,000 is paid for in June, further inventory is purchased at 45% of sales each month. Suppliers are paid one month in arrears. Closing inventory should also be 60,000 Wages are forecasted to be 11,000 per month, payable in the month they are incurred. Overheads, which include 2,000 depreciation expense, are forecast to be 13,500 per month and paid in the month they are incurred. Rent is 18,000 per year payable half in June and half in Dec. Equipment will be depreciated at 10% of cost per year. Required Forecast monthly cash flow statement for the three months to 31st August 2023 . Silk Ltd will commence trading in June 2023 with Share Capital of 50,000. The company will spend 60,000 on equipment. They have arranged a loan of 120,000 with interest at 10% p.a. over five years. Repayments of capital and interest are 2,433 each month. The loan interest for the period included in the repayments is 2,367. Sales are expected to be as follows: June 120,000 : July 120,000 : August 150,000. 40% of sales are for cash and attract a discount of 5%. The remainder of sales is on credit terms and collected 1 month later. Opening inventory of 60,000 is paid for in June, further inventory is purchased at 45% of sales each month. Suppliers are paid one month in arrears. Closing inventory should also be 60,000 Wages are forecasted to be 11,000 per month, payable in the month they are incurred. Overheads, which include 2,000 depreciation expense, are forecast to be 13,500 per month and paid in the month they are incurred. Rent is 18,000 per year payable half in June and half in Dec. Equipment will be depreciated at 10% of cost per year. Required Forecast monthly cash flow statement for the three months to 31st August 2023

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

Financial Accounting And Controlling In SAP AFS Solution

Authors: David Jones

1st Edition

1521738092, 978-1521738092

More Books

Students also viewed these Accounting questions

Question

5. Recognize your ability to repair and let go of painful conflict

Answered: 1 week ago