Answered step by step
Verified Expert Solution
Link Copied!

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... 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

Managerial Accounting

Authors: Morse Hartgraves

8th Edition

1618532359, 9781618532350

More Books

Students also viewed these Finance questions