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

  What is cost accounting

What is Cost accounting - How do you interpret cost accounting and how will you use it in your life? Career?

  Calculate the cost of goods sold for the period

Calculate the cost of goods sold for the period

  Compute the break-even point

How many dollars of revenue must K-Henry's find in order to reach the break-even point? Evaluate the price be if the company expected a volume of 120,000 units and used a markup of 50%?

  Overhead that would be charged to each bouquet

Riverside Florists uses an activity-based costing system to compute the cost of making floral bouquets and delivering the bouquets to its commercial customers.

  For which it currently manufactures a fuel value

However, the space occupied by the production of the value can be used by another production group that is currently leasing space for $55,000 per year.

  Stockholders equity section for jacobsen corporation

Prepare the stockholders equity section for Jacobsen Corporation at December 31, 2012 - Journalize the treasury stock transactions

  What is the annual cash interest payment

What is the maturity value, what is the annual cash interest payment and what are the proceeds the company receives upon issuance of the bond?

  Compute days sales uncollected for these companies

Compute days sales uncollected for these companies for each of the two years shown. Comment on any trends for the companies. Which company has the largest percent change in days' sales uncollected?

  Prepare the entry to record the mortgage loan

Prepare the entry to record the mortgage loan on December 31, 2011, and the first installment payment.

  How much net income should be distributed to prince

Prince and Bernard had $20,000 and $150,000 in their January 1 capital balances, respectively. Net income for the year was $240,000. How much net income should be distributed to Prince?

  Identify at least three methods for allocating costs

Identify at least three methods for allocating costs? When is each method used? What are the pros and cons of each? How is it related to cost allocation?

  Complete the worksheet

Using information, complete the worksheet on the subsequent page for Mann's Copy Shop for the month of September you have to prepare for the month ending 30 th September, 2008:

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