Question: solve without excel and show all calculations .6 Set. (A) From the following particulars prepare monthly cash budget for the quarter ended 31 March 2020.

solve without excel and show all calculations
solve without excel and show all calculations .6 Set. (A) From the

.6 Set. (A) From the following particulars prepare monthly cash budget for the quarter ended 31" March 2020. (Rs. in lakhs) [10 Marks] Additional Information a. 10 percent sales and purchases are on cash b. Credit to debtors: one month on an average, 50% of debtor will make payment on the due date while the rest will make payment one month thereafter c. Credit from creditors: 2 months d. Wages to be paid twice in a month on the 1st and 16th respectively e. Expenses are generally paid within the month f. Plant costing Rs. 1.00 lakh will be installed in February on payment of 25% of the cost in addition to the installation cost of Rs. 5000 , balance to be paid in three equal instalments from the following moth. g. Opening cash balance is Rs.2 lakhs .6 Set. (A) From the following particulars prepare monthly cash budget for the quarter ended 31" March 2020. (Rs. in lakhs) [10 Marks] Additional Information a. 10 percent sales and purchases are on cash b. Credit to debtors: one month on an average, 50% of debtor will make payment on the due date while the rest will make payment one month thereafter c. Credit from creditors: 2 months d. Wages to be paid twice in a month on the 1st and 16th respectively e. Expenses are generally paid within the month f. Plant costing Rs. 1.00 lakh will be installed in February on payment of 25% of the cost in addition to the installation cost of Rs. 5000 , balance to be paid in three equal instalments from the following moth. g. Opening cash balance is Rs.2 lakhs

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!