Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Current Attempt in Progress You are provided with the following information taken from Ivanhoe Inc's March 31. 2025, balance sheet. Additional information concerning Ivanhoe Inc.

image text in transcribed
image text in transcribed
image text in transcribed
Current Attempt in Progress You are provided with the following information taken from Ivanhoe Inc's March 31. 2025, balance sheet. Additional information concerning Ivanhoe Inc. is as follows. 1. Gross profit is 27% of sales. 2. Actual and budgeted sales data: 3. Sales are both cash and credit. Cash collections expected in April are: April 30.2025 Beginningcash balance Add Cash receipts March cash purchases Collections from customers Total receipts: Total avaliable cash Less 0 : Cash disbursements March cash purchases 22540 Payment of April purchases \begin{tabular}{r} 22540 \\ \hline \end{tabular} Cashoperating costs \begin{tabular}{|l|l|} \hline 28730 & i \\ \hline \end{tabular} Payment of March purchases \begin{tabular}{|r|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline 66310 \\ \hline 34920 \\ \hline \end{tabular} Total disbursements Excess (deficiency) of available cash over disbursements Financing Add : : Borrowings 34076.8 Less Repayments Ending cash balance \begin{tabular}{|r|} \hline \\ \hline \\ \hline \\ \hline \\ \hline 125076.8 \\ \hline \end{tabular} 4. Half of a month's purchases are paid for in the month of purchase and haif in the following month. Cashe 5. Cash operating costs are anticipated to be $12,510 for the month of April. 6. Equipment costing $2,510 will be purchased for cash in April: 7. The company wishes to maintain a minimum cash balance of $12,570. An open line of credit is available at the bank. All borrowing is done at the beginning of the month, and all repayments are made at the end of the month. The interest rate is 15% per year, and interest expense is accrued at the end of the month and paid in the following month. Prepare a cash budget for the month of April. Determine how much cash Ivanhoe Inc. must borrow, or can repay, in April. (List items that increase cash balance first.)

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

Practical Auditing Techniques For ISO/TS 16949

Authors: Raymond Ness

1st Edition

978-0595273126

More Books

Students also viewed these Accounting questions