Question: Old MathJax webview A.complete the table above. All the information is given in the paragraph below the table. kindly solve The actual sales and purchases

Old MathJax webview

Old MathJax webview A.complete the table above. All the information is given

A.complete the table above.

All the information is given in the paragraph below the table. kindly solve

The actual sales and purchases for ABC Co., for August & September 2020, along with its forecast sales and purchases for the period October 2020 through August 2021, follow. Actual & Forecasted Sales 400,000 Actual & Forecasted Purchases ? ? ? ? ? Year Month 2020 August Septembe 2020 r 2020 October Novembe 2020 r 2020 December 2021 January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Sales of every month of the first quarter of the year will increased by 20%, every month of the Second quarter of the year will increased by 30%, every month of the Third quarter of the year will decreased by 10% and every month of the last quarter of the year will increased by 10%. The firm makes 20% of all sales on Cash Sales. Total Purchases are 60% of the forecasted month sales. 40% of Accounts Receivable are collected in first month following the sale and 60% in the 2 months following the sale. Company purchased 30% on Cash and paid 20% of the remaining amount in 1Month following to the purchases and 80% in 2nd Month following to the purchases. Other cash inflows are expected to be Rs. 12,000 in September and April, Rs. 15,000 in January and March, and Rs. 27,000 in February. Payroll amount to 15% of the preceding month's sales. Rent of Rs. 15,000 per month must be paid. Interest payments are 24% per year are due in November, January and April as monthly interest. A principal payment of 20% is also due in April. The total loan amount is Rs. 300,000 The firm expects to pay cash dividends of Rs. 25,000 in March, August and April, Taxes of Rs. 75,000 are due in September. The firm also intends to make a Rs. 65,000 cash purchase of fixed assets in October A. Complete the table given above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!