Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION ONE Kupa Ltd. has approached their local banker for an overdraft facility in 2021. The banker has asked to provide a cash budget for

image text in transcribed
QUESTION ONE Kupa Ltd. has approached their local banker for an overdraft facility in 2021. The banker has asked to provide a cash budget for the first six months of 2021. The company has furnished you with the following information. Oct Nov Dec. Jan Feb Mar Apr May Jun July Aug. Sep 202 202 202 202 202 202 202 202 e 202 202 202 0 0 0 1 1 1 1 1 1 1 1 1 190 170 200 180 220 240 210 160 180 220 240 220 202 Sales (Sh.100 0") Sales are made 40% cash. Of credit sales, 30% is collected in the month of sale, 40% one month after sale and 25% two months from sales Gross profit margin is 25%. Goods purchased in a month are sold two months after the month of purchase. Purchases are paid 30% one the month of purchase and the remainder two months thereafter Cash Overheads average 10% of the monthly sales Cash Operating expenses are 15% of the monthly sales. New equipment costing Sh. 24,000 will, be purchased for cash in April. Annual depreciation on this equipment will be 25% of the cost. Tax payments for Sh 40,000 are due in January and March. The beginning cash balance in 2021 is expected to be Sh 250,000. This cash balance has to be maintained. In case of deficits, borrowing in multiples of Sh 20,000 is made at an interest of 4% per month. Interest must be paid when it accrues and the principal amount borrowed has to be paid soonest possible in the same multiples Required: I Prepare Kupa's a Monthly cash payment for the first six months of 2021 b. Monthly cash receipts for the first six months of 2021 c. Monthly cash budget for the first six months of 2021

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

International Finance

Authors: Keith Pilbeam

2nd Edition

0333730976, 978-0333730973

More Books

Students also viewed these Finance questions

Question

Th ey told me Id have to write a lett er. Whos got time for that?

Answered: 1 week ago