QUESTION 1REQUIREDPrepare the Cash Budget for a project of Aston Enterprises for the period 01 May 2021 to 31 July2021. (Ensure that your cash budget has separate monetary columns for each month.)INFORMATIONThe following information was provided by Aston Enterprises:1. The bank balance on 30 April 2021 is expected to be R50 000 (favourable).2. Expected sales (excluding discounts) are as follows:AprilMayJuneJulyRRR.RCash sales100 000120 000160 000170 000Credit sales140 000150 000180 000230 0003. A discount of 5% is given to customers on cash sales.4. Customers who purchase on credit usually pay one month after the sale.5. The production estimates reveal the following:Production costsMarchAprilMayJuneJulyRRRRRDirect materials75 00077 00045 00055 00060 000Direct labour32 00035 00036 00039 00041 000Overheads25 00027 00029 00033 00035 000 6. Fifty percent (50%) of the materials purchases are for cash. The balance is purchased oncredit and creditors are usually paid two months after the purchase.7.Employees involved in the production of finished goods are paid monthly.8. The payment of production overheads is delayed by one month.9. Selling and administrative costs are paid for in the month in which they are incurred. Theyare forecast at 10% of sales (excluding any discounts).10. A loan of R300 000 is expected to be obtained on 01 July 2021. Loan repayments of RS 000per month plus interest at 12% per annum is payable at the end of each month commencingJuly 2021.

Name: QUESTION 1REQUIREDPrepare the Cash Budget for a project of Aston Ente
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: QUESTION 1REQUIREDPrepare the Cash Budget for a project of Aston Enterprises for the period 01 May 2021 to 31 July2021. (Ensure that your cash budget has separate monetary columns for each month.)INFORMATIONThe following information was provided by

Cash budget of the business shows expected cash receipts and cash payments to be made along with…

Business

Accounting

QUESTION 1 REQUIRED Prepare the Cash Budget for a project of Aston Enterprises for the period 01 May 2021 to 31 July 2021. (Ensure that your cash budget has separate monetary columns for each month.) INFORMATION The following information was provided by Aston Enterprises: 1. The bank balance on 30 April 2021 is expected to be RSO 000 (favourable). 2. Expected sales (excluding discounts) are as follows: April May June July R R R R Cash sales 100 000 160 000 170 000 120 000 Credit sales 140 000 150 000 180 000 230 000 3. A discount of 5% is given to customers on cash sales. 4. Customers who purchase on credit usually pay one month after the sale. 5. The production estimates reveal the following: Production costs March April May June July R R Direct materials 45 000 55 000 60 000 75 000 77 000 Direct labour 32 000 35 000 36 000 39 000 41 000 Overheads 25 000 27 000 29 000 33 000 35 000

QUESTION 1 REQUIRED Prepare the Cash Budget for a project of Aston Enterprises for the period 01 May 2021 to 31 July 2021. (Ensure that your cash budget has separate monetary columns for each month.) INFORMATION The following information was provided by Aston Enterprises: 1. The bank balance on 30 April 2021 is expected to be RSO 000 (favourable). 2. Expected sales (excluding discounts) are as follows: April May June July R R R R Cash sales 100 000 160 000 170 000 120 000 Credit sales 140 000 150 000 180 000 230 000 3. A discount of 5% is given to customers on cash sales. 4. Customers who purchase on credit usually pay one month after the sale. 5. The production estimates reveal the following: Production costs March April May June July R R Direct materials 45 000 55 000 60 000 75 000 77 000 Direct labour 32 000 35 000 36 000 39 000 41 000 Overheads 25 000 27 000 29 000 33 000 35 000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A. Cash flows it is typical for Jane to plan, monitor, and assess her financial position using cash flowsover a given period, typically a month. Jane has a savings account, and her bank loans money at 6%per year while it offers short-term investment rates of 5%. Jane’s cash flows during August were asfollows: 10 points Item Cash inflows Cash outflowsClothes ₱ 1,000Interest received ₱ 450Dining out 500Groceries 800Salary 4,500Auto payment 355Utilities 280Mortgage 1,200Gas 222 a. Determines Jane’ total cash inflows and outflows.b. Determine the net cash flow for the month of August.c. If there is a shortage, what are the few options open to Jane?d. If there is a surplus, what would be a prudent strategy for her to follow?
Question A Franklin’s investment fund had a balance of $290,000 on January 1, 1995 and a balance of $448,000 two years later. The amount of interest earned during the two years was $34,000, and the annual yield rate on the fund was 5.4%. Estimate the (dollar-weighted) average date of contributions to the account. Answer: September 26, 1996 Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Cash flows It is typical for Jane to plan, monitor, and assess her financial position using cash flows over a given period, typically a month. Jane has a savings account and her bank loans money at 6% per year while it offers short-term investment rates of 5%. Jane's cash flows during Augu were as follows: a. Determine Jane's total cash inflows and cash outflows. b. Determine the net cash flow for the month of August. c. If there is a shortage, what are a few options open to Jane? d. If there is a surplus, what would be a prudent strategy for her to follow? Data table (Click the icon here in order to copy the contents of the data table below into a spreadsheet.) Item Clothes Interest received Dining out Groceries Salary Auto payment Utilities Mortgage Gas Cash inflow Cash outflow $1,100 $440 $4,400 $450 $820 $359 $290 $1,310 $219 X
Prepare statement of cash flow for ShafNita Sdn. Bhd. for the year ended 31 December 2020
Please solve subpart A,B max 30-45 minutes thank u AmN companies will get capital from several options where the total funds must be obtained of 1.1 billion rupiah. The following is currently available market information:1. Debt interest rate is 12% per year2. State Bonds with minimal risk (risk free) of 5%3. JCI has a market return of 8%4. The company tax applied is 25%5. The company's performance is good so it has a stock Beta of 1.12The available options relate to the source of AmN's company capital, namely from Debt (direct tobank) and Equity (through ordinary shares) with the following explanation:1. Fully capital obtained from debt2. Fully capital obtained from equity3. The DER policy applied is 1/3 (or DER = 0.3333) Based on the narrative above you are asked to:A. Calculate WACC from the three available optionsB. Decide on the best choice with the reasons.
Don't provide answers in image format
Question (6) Post Company's 20Y1 net sales were $10,000,000, cash cost of goods sold was $5,500,000, and inventory days on hand was 62 days. The company projects its 20Y2 net sales will be $11,000,000, cash cost of goods sold will be $6,100,000, and inventory days on hand will be 57 days. What would be the cash flow impact of the five-day shortening of inventory days on hand? OA decrease of $75,342. O An increase of $75,342. OA decrease of $83,562. O An increase of $83,562.
DO THIS IN EXCEL ONLY AND SHOW THE FORMULAS. IF COMPLETE I WILL UPVOTE THANK YOU
SHOW YOUR SOLUTION ON GOOD ACCOUNTING FORM
What amount of nonspontaneous, additional funds (AFN) will be needed during the next year? Lux Co. December 31 balance sheet is given below