Make a cash budget for the month of April

Assignment Help Financial Accounting
Reference no: EM132927737

Question - You are provided with the following information taken from Shamrock, Inc.'s March 31, 2022, balance sheet.

Cash $12,500

Accounts receivable 20,900

Inventory 36,330

Property, plant, and equipment, net of depreciation 124,600

Accounts payable 22,990

Common stock 154,500

Retained earnings 11,940

Additional information concerning Shamrock, Inc. is as follows.

1. Gross profit is 26% of sales.

2. Actual and budgeted sales data:

March (actual) $47,400

April (budgeted) 71,600

3. Sales are both cash and credit. Cash collections expected in April are:

March $18,960 (40% of $47,400)

April 42,960 (60% of $71,600)

$61,920

4. Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expected in April are:

Purchases March $22,990

Purchases April 28,770

$51,760

5. Cash operating costs are anticipated to be $11,600 for the month of April.

6. Equipment costing $2,710 will be purchased for cash in April.

7. The company wishes to maintain a minimum cash balance of $12,290. 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 12% per year, and interest expense is accrued at the end of the month and paid in the following month.

Required - Make a cash budget for the month of April. Determine how much cash Shamrock, Inc. must borrow, or can repay, in April.

Reference no: EM132927737

Questions Cloud

What price would you recommend as the IPO price : If you believe that investors require a 17 percent rate of return on a stock of this risk, what price would you recommend as the IPO price for Konawalski
What is the expected or promised gross return on the loan : What is the expected or promised gross return on the loan? The loan terms include a default risk-free borrowing rate of 8 percent, a risk premium of 3 percent
Calculate the duration of a two-year corporate bond : Calculate the duration of a two-year corporate bond paying 6 percent interest annually, selling at par. Principal of $20,000,000 is due at the end of two years.
What is the impact on the dealer market value of equity : What is the impact on the dealer's market value of equity per $100 of assets if the change in all interest rates is an increase of 0.5 percent.
Make a cash budget for the month of April : Make a cash budget for the month of April. Determine how much cash Shamrock, Inc. must borrow, or can repay, in April
Question - Benchmark - Fraud Case Study : Question - Benchmark - Fraud Case Study - research the Internet and select a fraud- What tax laws could your case be trying to circumvent
How many years are there until the bond matures : Beam Inc. bonds are trading today for a price of $1,777.72. The bond has a yield to maturity of 2.99%. How many years are there until the bond matures
Prepare in proper form a post-closing trial balance : Question - From the following accounts, prepare in proper form a post-closing trial balance for Ahearn Company on December 31, 2004
Find what is the current price of the bond : €1,000, 23 years to maturity and a coupon rate of 3.8% paid annually. If the yield to maturity is 4.7%, what is the current price of the bond?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd