Prepare a cash budget for april may and june

Assignment Help Cost Accounting
Reference no: EM13906475

During the last week of March, Sony Stereo's owner approaches the bank for a $ 80,000 loan to be made on April 1 and repaid on June 30 with annual interest of 12%, for an interest cost of $ 2,400. The owner plans to increase the store's inventory by $ 60,000 in April and needs the loan to pay for inventory acquisitions. The bank's loan officer needs more information about Sony Stereo's ability to repay the loan and asks the owner to forecast the store's June 30 cash position. On April 1, Sony Stereo is expected to have a $ 3,000 cash balance, $ 135,000 of accounts receivable, and $ 100,000 of accounts payable. Its budgeted sales, merchandise purchases, and various cash disbursements for the next three months follow.

The budgeted April merchandise purchases include the inventory increase. All sales are on account. The company predicts that 25% of credit sales is collected in the month of the sale, 45% in the month following the sale, 20% in the second month, 9% in the third, and the remainder is uncollectible. Applying these percents to the March credit sales, for example shows that $ 81,000 of the $ 180,000 will be collected in April $ 36,000 in May, and $ 16,200 in June. All merchandise is purchased on credit; 80% of the balance is paid in the month following a purchase and the remaining 20% is paid in the second month. For example, of the $ 100,000 0 March purchases, $ 80,000 will be paid in April and $ 20,000 in May. 

Required: 

Prepare a cash budget for April, May, and June for Sony Stereo. Show supporting calculations asneeded 

1536_267-B-C-A-B (757).png

Reference no: EM13906475

Questions Cloud

How a third-party intermediary could facilitate salazar : Salazar Inc., a Colorado company, is relocating to a nearby town. Explain how a third-party intermediary could facilitate Salazar's like-kind exchange.
Calculate the geometric angle of attack : Its maximum gross weight is 2450 lbs. The wing uses a NACA 65-415 airfoil, which has a lift slope of 0.10331deg^-1 and alpha(L=0)= -3.0deg. Assume that tau = 0.12 . If the airplane is cruising at 120 mph at standard sea level at its maximum gross ..
Describe the attributes of these segments : Companies use many tools to learn more about the specific market segments they plan to target. An example of one of those tools is PRIZM. Visit ZIP Code Look-Up and search by a ZIP code of your choice. Some options to consider include Beverly Hills 9..
How do the tax laws ensure that the gains are deferred : Why does the tax code allow taxpayers to defer gains on like-kind exchanges? How do the tax laws ensure that the gains (or losses) are deferred and not per- manently excluded from a taxpayer's income?
Prepare a cash budget for april may and june : Prepare a cash budget for April, May, and June for Sony Stereo. Show supporting calculations asneeded
Segmenting consumer and business markets segmentation : Segmenting Consumer and Business Markets Segmentation bases (variables) are used to identify particular characteristics, attributes, or traits of consumers or businesses. Consumer markets are typically segmented using 5 bases, including geographic, d..
Calculate the stress at a point away from the hole : Calculate the stress at a point away from the hole, to the right of the beam toward the end and Calculate the stress at the hole?
Compute the daily wage of an employee : Write a JAVA program that will input Employee Name, Rate per hour, No. of hours worked and will compute the daily wage of an employee. If the number of hours worked exceeds eight hours add 30% to each excess hours as overtime rate.
Describe some of the personal and psychological factors : 1. Describe some of the personal and psychological factors that may influence what consumers buy and when they buy it. Ch. 3 2. Identify the ways in which business-to-business (B2B) markets differ from business-to-consumer (B2C) markets. Ch. 4

Reviews

Write a Review

Cost Accounting Questions & Answers

  Cost accounting assignment

Evaluate Method of measuring costs associated with production, budgeting process, normal job-order costing system , master budget, cycle time.

  Prepare the journal entries

Prepare the journal entries to record the bond issue and interest expense.

  Advise as to the liability of all the parties

Write a report on given case study and Advise as to the liability of ALL the parties both under common law and the Corporations Law.

  Prepare revenues budget

Prepare Revenues budget and Production budget in units

  Effect of exchange rate changes on cash and cash

Effect of exchange rate changes on cash and cash

  Corporate governance

You are to reflect on how this case of China Sky relates to what the arguments for and against allowing audit firm partners and/or employees to join audit committees.

  Cost-benefit analysis

A cost-benefit analysis of electronic medical records in primary care

  Non-annual interest rates and annuities

Theory of Interest- Non-annual interest rates and annuities

  Job costing in service organizations

How is job costing in service organizations different from job costing in manufacturing environments?

  Accounting for bad debt expense

Accounting for bad debt expense

  Accounting and partnership problems

Accounting and Partnership problems

  Development of relevant cash flows

Development of relevant cash flows - Cost estimating and financial analysis

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