Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate without using excel ,just calculate manually i need to see the calculating QUESTION THREE (3) - 20 MARKS A cash budget is an important

image text in transcribedCalculate without using excel ,just calculate manually i need to see the calculating
QUESTION THREE (3) - 20 MARKS A cash budget is an important tool involving the forecasting of cash inflows and outflows over the next short-term financial planning. It helps the financial manager to plan in advance and to start the search for financing before the fund is actually needed. For Changloon Hardware Enterprise, following are some important budget information for the fourth quarter of 2014. October November December Credit sales RM547,200 RM570,240 RM630,720 Credit purchases 211.680 252.720 288,710 Cash disbursement: Expenses 57,240 69,420 72.430 Interest 16,410 16,410 16.410 Equipment purchases 119,520 131,040 0 In addition, Changloon Hardware has anticipated that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of sale, and the remaining 60 percent will be collected in the following month. Moreover, its credit purchases will be paid in the month following the purchase. Meanwhile, in the month of September, both the credit sales and credit purchases were RM302,400 and RM224,640, respectively. As for August, the credit sales were RM206,100 whereas credit purchases were amounting to RM150,780. It is noted that the beginning cash balance for October was RM403,200 and minimum cash balance that need to be maintain every month was RM25,000. You are required to prepare the cash budget for Changloon Hardware for the month of October to November 2020

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Short Term Financial Management

Authors: Terry S. Maness, John T. Zietlow

2nd Edition

0030315131, 978-0030315138

More Books

Students also viewed these Finance questions

Question

What does stickiest refer to in regard to social media

Answered: 1 week ago

Question

What advice would you provide to Jennifer?

Answered: 1 week ago

Question

What are the issues of concern for each of the affected parties?

Answered: 1 week ago