Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

The Customer Base Audit The First Step On The Journey To Customer Centricity

Authors: Peter Fader, Bruce G.S. Hardie, Michael Ross

1st Edition

1613631618, 978-1613631614

More Books

Students also viewed these Accounting questions

Question

The Nature of Nonverbal Communication

Answered: 1 week ago

Question

Functions of Nonverbal Communication

Answered: 1 week ago

Question

Nonverbal Communication Codes

Answered: 1 week ago