Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

table [ [ Aug , Sep,Oet,Nov,Dec ] , [ $ 3 2 , 0 0 0 , $ 3 6 , 0 0 0

image text in transcribed
\table[[Aug,Sep,Oet,Nov,Dec],[$32,000,$36,000,$48,000,$46,000,$55,000]]
Additional information provided is as follows:
(i) Sales for June and July of the current year were $40,000 and $45,000 respectively.
(ii) Sixty (60%) percent of sales will be for cash; 30% will be collected in the first month following the sale; and the remaining 10% will be collected in the second month following the sale.
(iii) Raw material purchases are settled a month after purchase. Each month's purchases is shown below:
\table[[July,Aug,Sep,Oct,Nov],[$22,400,$25,200,$33,600,$32,200,$38,500]]
(iv) Wages total $5,400 monthly.
(v) Other expenses are $1,500 in August but is expected to increase by $500 each month;
(vi) Equipment costing $20,000 will be ordered in August. A deposit of 25% of the cost will be required at the time of the order, with the balance payable at delivery three months later.
(vii) Income tax of $7,500 is due in September, at the end of the quarter.
(viii) The company's starting cash balance on August I will be $12,000; however, a new minimum balance of $20,000 will be applied going forward.
(ix) Short-term credit is arranged at an interest rate of 18 percent per annum month to be paid monthly. The interest on any short-term borrowing is paid in the month after it is incurred.
Required: Prepare St Lucia's LLC cash budget for August to September 2017.
image text in transcribed

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

College Accounting A Practical Approach Chapters 1-25

Authors: Jeffrey Slater

13th Edition

0133791009, 978-0133791006

More Books

Students also viewed these Accounting questions

Question

=+46. Monthly gas prices, part 3. Using the data from Exercise

Answered: 1 week ago