Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Lily Potter is the owner of a Gift Shop. Lily wants to make a cash budget for the second three months of the calendar year

Lily Potter is the owner of a Gift Shop. Lily wants to make a cash budget for the second three months of the calendar year 2022. Her sales and purchase departments have given her the following estimates: Marks: 20 Month Sales in BDT Purchases in BDT January 2022 221,000 110,000 February 2022 226,000 120,000 March 2022 228,000 130,000 April 2022 230,000 140,000 May 2022 236,000 150,000 June 2022 238,000 160,000 Sales are made on cash basis only. The payments for purchases are made: payment within the same month of purchase will be 40%, payment in the month following purchase: 50%, and payment in the second month following purchase: 10%. Lily plans to offer 5% discount to the customers who make payments within the same month of sales. General and administrative salaries will be 9% of monthly sales. Lease payments will amount to BDT 63,000 a month. Depreciation expenses are expected to be BDT 53,000 a month. Tax payment of BDT 25,000 will be due in June. Cash on hand on April 1 might be BDT 48,000. The Gift Shop wants to maintain a target minimum cash balance of BDT 120,000 a month.

(a) Prepare cash budget for the Gift Shop for the second three months of 2022 (April to June).

(b) In which months, can the Gift Shop go for an investment of BDT 45,000?

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_2

Step: 3

blur-text-image_3

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

Tidy Finance With R

Authors: Christoph Scheuch, Stefan Voigt, Patrick Weiss

1st Edition

1032389346, 978-1032389349

More Books

Students also viewed these Finance questions