PLEASE SHOW STEPS IN EXCEL SHEET MC algo 26-19 Cash Disbursements Weisbro and Sons purchases its...

PLEASE SHOW STEPS IN EXCEL SHEET

MC algo 26-19 Cash Disbursements Weisbro and Sons purchases its inventory one quarter prior to the quarter of sale. The purchase price is 60 percent of the sales price. The accounts payable period is 60 days. The accounts payable balance at the beginning of Quarter 1 is $25,800. What is the amount of the expected disbursements for Quarter 2 given the following expected quarterly sales?

Quarter 1: $ 67,000 Quarter 2: $ 108,000 Quarter 3: $ 100,000 Quarter 4: $ 109,000

Multiple Choice

A. $40,200

B. $61,600

C. $65,000

D. $63,200

E. $57,000

Solutions

Expert Solution

jeff jeffy answered 3 weeks ago

Next > < Previous

Related Solutions

PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...

PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The following are the runs scored totals for 9 players for the 2016 New York Yankees: 56,43,63,68,58,80,71,32,19 (a) Find the mean and median (b) Find the standard deviation of this population (c) Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 . (d) Considering...

PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced...

PLEASE SHOW HOW TO SOLVE IN EXCEL SHOW STEPS Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair Repairperson 2.9 2 Electrical Dave Newton 3 6 Mechanical...

PLEASE SHOW WORK ( NO EXCEL) A. Project L costs $75,000, its expected cash inflows are...

PLEASE SHOW WORK ( NO EXCEL) A. Project L costs $75,000, its expected cash inflows are $15,000 per year for 12 years, and its WACC is 12%. What is the project's NPV? Do not round intermediate calculations. Round your answer to the nearest cent. B. Project L costs $61,049.98, its expected cash inflows are $13,000 per year for 9 years, and its WACC is 9%. What is the project's IRR? Round your answer to two decimal places. C. Project L...

SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score...

SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score for six stereo headphones tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). Brand Price ($) Score A 180 76 B 150 71 C 95 61 D 70 58 E 70 40 F 35 24 (a) The estimated regression equation for this data is ŷ =...

Problem 8-27 (Algo) Cash Collections; Cash Disbursements; Budgeted Balance Sheet [LO8-2, LO8-3, LO8-4, LO8-10] Deacon Company...

Problem 8-27 (Algo) Cash Collections; Cash Disbursements; Budgeted Balance Sheet [LO8-2, LO8-3, LO8-4, LO8-10] Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 58,200 Accounts receivable 34,800 Inventory 68,500 Buildings and equipment, net of depreciation 118,000 Total assets $ 279,500 Liabilities and Stockholders’ Equity Accounts payable $ 95,000 Common stock 70,000 Retained earnings 114,500 Total liabilities and...

(PLEASE SHOW WORK) - no financial calculator - no excel 2. David Hoffman purchases a bond...

(PLEASE SHOW WORK) - no financial calculator - no excel 2. David Hoffman purchases a bond with $1,000 principal, 20-year maturity, and 8% coupon (annual payments). Yields on comparable bonds are 10%. Bob expects that two years from now, yields on comparable bonds will have declined to 9%. Find his expected yield, assuming the bond is sold in two years. 3. Calculate the duration of a $1,000, eight-year zero coupon bond using annual compounding and a current market rate of...

Please could you show full steps and no excel please Miss M had R100,000 to invest...

Please could you show full steps and no excel please Miss M had R100,000 to invest in the financial market. She chose to invest R10,000 in Asset A, which returned 12.0%; R40,000 in Asset B which returned 15.0%; R20,000 in Asset C which returned –5.0%, and the remaining in Asset D which returned 5%. The correlation between the assets are ρAB = 0.75, ρAC = 0.35, ρAD = 1, ρBC = –0.5, ρBD = 0.25, and ρCD = -1. The...

Please use Excel and show steps!! Greentrop Pharmaceutical Products are the world leader in the area...

Please use Excel and show steps!! Greentrop Pharmaceutical Products are the world leader in the area of sleep aids. Its major product is “Dozealot”. The Research-and-Development Division has defined two alternatives to improve the quality of the product. These alternatives are simple reformulations of the product to minimize the side effects and to improve the product efficacy. To conduct an analysis, management has decided to consider the possible demands for the drug under each alternative. The following payoff table shows...

can you show steps using the TI-84 plus? not using excel function. 19. Mercury in Sushi...

can you show steps using the TI-84 plus? not using excel function. 19. Mercury in Sushi An FDA guideline is that the mercury in fish should be below I part per million (ppm). Listed below are the amounts of mercury (ppm) found in tuna sushi sampled at different stores in New York City. The study was sponsored by the New York Times, and the stores (in order) are D’Agostino, Eli’s Manhattan, Fairway, Food Emporium, Gourmet Garage, Grace’s Marketplace, and Whole...

PLEASE COMPLETE IN EXCEL AND SHOW ALL STEPS AND EXCELL EQUATIONS USED In our class example,...

PLEASE COMPLETE IN EXCEL AND SHOW ALL STEPS AND EXCELL EQUATIONS USED In our class example, I simplified the “annuity” prize option by assuming level, equal annual payments. Actually, this annuity prize option us now on an annuitized prize payment schedule with 30 beginning of year payments that start at a lower amount with each successive payment being 5% higher than the previous annual payment. The sum of these 30 annuitized payments equal the announced estimated jackpot amount with a...

Subjects