Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cash Budget for July, August, and September:1. July:Cash Receipts:Collection from July (60% of RM650,000) = RM390,000Collection from June (40% of RM700,000) = RM280,000Total Receipts: RM390,000
Cash Budget for July, August, and September:1. July:Cash Receipts:Collection from July (60% of RM650,000) = RM390,000Collection from June (40% of RM700,000) = RM280,000Total Receipts: RM390,000 + RM280,000 = RM670,000Disbursements:Raw material payment (50% of June sales) = RM350,000Wages and salaries (10% of RM650,000) = RM65,000Utilities (5% of RM650,000) = RM32,500Rent = RM7,000Tax = RM5,000Loan interest = RM2,083.33Total Disbursements: RM350,000 + RM65,000 + RM32,500 + RM7,000 + RM5,000 + RM2,083.33 = RM461,583.33Net Cash Flow:Net Inflow/Outflow = Total Receipts - Total Disbursements = RM670,000 - RM461,583.33 = RM208,416.67Add Beginning Cash Balance = RM70,000Cash Available = RM208,416.67 + RM70,000 = RM278,416.67Since July Minimum Cash Balance is RM45,000, no short term financing required.Ending Cash Balance = RM278,416.67 - RM45,000 = RM233,416.672. August:Cash Receipts:Collection from August (60% of RM680,000) = RM408,000Collection from July (40% of RM650,000) = RM260,000Total Receipts: RM408,000 + RM260,000 = RM668,000Disbursements:Raw material payment (50% of July sales) = RM325,000Wages and salaries (10% of RM680,000) = RM68,000Utilities (5% of RM680,000) = RM34,000Rent = RM7,000Tax = RM5,000Loan interest = RM2,083.33Total Disbursements: RM325,000 + RM68,000 + RM34,000 + RM7,000 + RM5,000 + RM2,083.33 = RM441,083.33Net Cash Flow:Net Inflow/Outflow = Total Receipts - Total Disbursements = RM668,000 - RM441,083.33 = RM226,916.67Add Beginning Cash Balance = RM70,000 (this should be Ending Cash Balance from July, which is RM233,416.67; correction)Cash Available = RM226,916.67 + RM233,416.67 = RM460,333.34Since August Minimum Cash Balance is RM90,000, no short term financing required.Ending Cash Balance = RM460,333.34 - 90,000 = RM370,333.343. September:Cash Receipts:Collection from September (60% of RM565,000) = RM339,000Collection from August (40% of RM680,000) = RM272,000Total Receipts: RM339,000 + RM272,000 = RM611,000Disbursements:Raw material payment (50% of August sales) = RM340,000Wages and salaries (10% of RM565,000) = RM56,500Utilities (5% of RM565,000) = RM28,250Rent = RM7,000Tax = RM5,000Loan interest = RM2,083.33Total Disbursements: RM340,000 + RM56,500 + RM28,250 + RM7,000 + RM5,000 + RM2,083.33 = RM439,833.33Net Cash Flow:Net Inflow/Outflow = Total Receipts - Total Disbursements = RM611,000 - RM439,833.33 = RM171,166.67Add Beginning Cash Balance = RM70,000 (this should be Ending Cash Balance from August, which is RM370,333.34; correction)Cash Available = RM171,166.67 + RM370,333.34 = RM541,500.01Since September Minimum Cash Balance is RM135,000, no short term financing required.Ending Cash Balance = RM541,500.01 - 135,000 = RM406,500.01So, here is a summary of the monthly calculations for each month:July:Beginning cash balance: RM70,000Total Receipts: RM670,000Total Disbursements: RM461,583.33Ending Cash Balance: RM233,416.67 (above minimum requirement of RM45,000)August:Beginning cash balance: RM233,416.67Total Receipts: RM668,000Total Disbursements: RM441,083.33Ending Cash Balance: RM370,333.34September:Beginning cash balance: RM370,333.34Total Receipts: RM611,000Total Disbursements: RM439,833.33Ending Cash Balance: RM406,500.01These calculations indicate that Maju Jaya Sdn Bhd will maintain a cash balance well above the minimum requirements for each month during this period. can provide this in statement
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Great Lets present the cash budget for Maju Jaya Sdn Bhd for the months of July August and September in statement format based on the given informatio...Get Instant Access with AI-Powered 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