Question
Pauls Fresh Fruits is completing its cash budget for the month of May, but has yet to complete its cash payments schedule. Critical details are
Pauls Fresh Fruits is completing its cash budget for the month of May, but has yet to complete its cash payments schedule. Critical details are as follows:
- Inventory purchases in April were $32,70732,707 and May were $31,79731,797. Inventory invoices are paid in the month following purchase
- Wages in April were $8,0728,072 and May were $4,9434,943. Wages are paid in the month incurred.
- Amortization is $4,1224,122 per month.
- The interest rate on the loan is 33% per annum.
- The business had an opening loan balance of $13,86613,866 and the minimum cash requirement was $1,0001,000. The business pays its interest in the current month based on the prior month's ending loan balance.
Round all your all figures to the nearest whole number. Do not enter commas as digit separators (i.e. enter 10000, not 10,000)
Cash Payments | May |
Inventory | $Answer
|
Wages | $Answer
|
Interest | $Answer
|
Amortization | $Answer
|
Total | $XX,XXX |
Now assume that your total cash payments was $38,76538,765 and the opening loan balance is the same as what is stated above. The minimum cash requirement is $1,0001,000.
Complete the below cash budget and calculate the ending loan balance. Use a negative sign for any negative figures (not brackets)
Cash Budget | May |
Cash Receipts | $30,48030,480 |
Cash Payments | $Answer
|
Net Cash Flow | $Answer
|
Beginning Cash | $Answer
|
Subtotal | $Answer
|
Bank Loan (repayment) | $Answer
|
Ending Cash | $Answer
|
Ending loan balance: $Answer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started