Answered step by step
Verified Expert Solution
Question
1 Approved Answer
BCD Computers Inc. is attempting to estimate its needs for funds during the months covering the third quarter of 2022. Pertinent information is given
BCD Computers Inc. is attempting to estimate its needs for funds during the months covering the third quarter of 2022. Pertinent information is given as follows: a) Past estimated future sales for 2022 are: July April May RM80000 RM95000 August June RM70000 September October RM90000 RM130000 b) Rent expense is RM2500 per month c) A quarterly interest payment on RM100000 in 7% notes payable is to be paid during September 2022. d) Wages and salaries estimated as follows: July August September RM8000 RM10000 RM12000 h) i) i) RM110000 RM140000 e) Payments are made within the month in which the wages are earned. f) 60% of the sales are for cash, with the remaining collected in the month following the sale. g) BCD pays 80% of the sales price for the merchandise and makes payment in the same month in which the sales occur, although purchases are made in the month prior to the anticipated sales. BCD plans to pay RM7500 in cash for a new forklift truck in July Short term loan can be obtained in the end of each month at 13% annual interest with interest paid during each month for which the loan is outstanding. BCD's ending cash balance for June 30, 2022 is RM67000; the minimum balance the firm wishes to have in any month is RM35000 REQUIRED: Set up a cash budget for BCD for the quarter ended September 30, 2022.
Step by Step Solution
★★★★★
3.41 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
Cash Budget for BCD Computers Inc Quarter Ended September 30 2022 Month Cash Balance at Beginning of ...Get Instant Access to Expert-Tailored 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