Ask Financial Accounting Expert

The Blix Company makes and sells a product called Blix Bars. Below are the units to be sold and the selling price per unit. Calculate the total sales for Quarter 1: January February March Units to be sold 30,000 20,000 50,000 Selling Price per unit $5 $5 $5 Total Sales Prepare the cash collections budget based on the following information: 25% of the company's sales are for cash and 75% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 20% are collected in the second month following sale. The remainder are uncollectible. CASH COLLECTIONS BUDGET January February March Cash Sales for the month January Credit Sales February credit sales March Credit Sales Total Cash Collections Calculate purchases for each month based on the 10% of sales units at $50 per unit cost. Based on total purchases, calculate disbursements for each month based on the following breakdown: 40% of purchases are paid for in cash at the time of purchase, 30% are paid for in the following month and the remaining 30% is paid in the 2nd month after the purchase. PAYMENTS MADE FOR INVENTORY PURCHASES BUDGET January February March Units to be Purchased Purchases for the Month Disbursements for Inventory Purchases: January Disbursements February Disbursements March Disbursements Total Disbursements for Inventory Purchases Complete the cash budget with the following information: The beginning cash balance was $125,000 Employee wages are paid in cash each month and amount to 20% of sales for the month in which the sales occur. Advertising Expense – 5% of sales per month Insurance Expense – 40,000 per month Rent Expense - 10,000 per month. Office Furniture Purchases – 15,000 in January If necessary, the company will borrow cash from a bank. The Company must maintain a minimum cash balance of $5,000. In case of a deficiency, a loan is obtained at 8% interest rate where the interest is repaid on the first day of following month. January February March Beginning Cash Balance Cash Collections Total Cash Available Less Disbursements: Inventory Purchases Employee Wages Advertising Expense Insurance Expense Rent Expense Office Furniture Purchases Total Disbursements Excess or Deficiency of Cash Financing Loans Taken Loans Paid Back Cash Available Interest Expense for the Month (8%) Ending Cash Balance

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M92043409

Have any Question?


Related Questions in Financial Accounting

Case study - the athletes storerequiredonce you have read

Case Study - The Athletes Store Required: Once you have read through the assignment complete the following tasks in order and produce the following reports Part 1 i. Enter the business information including name, address ...

Scenario assume that a manufacturing company usually pays a

Scenario: Assume that a manufacturing company usually pays a waste company (by the pound to haul away manufacturing waste. Recently, a landfill gas company offered to buy a small portion of the waste for cash, saving the ...

Lease classification considering firm guidance issues

Lease Classification, Considering Firm Guidance (Issues Memo) Facts: Tech Startup Inc. ("Lessee") is entering into a contract with Developer Inc. ("Landlord") to rent Landlord's newly constructed office building located ...

A review of the ledger of oriole company at december 31

A review of the ledger of Oriole Company at December 31, 2017, produces these data pertaining to the preparation of annual adjusting entries. 1. Prepaid Insurance $19,404. The company has separate insurance policies on i ...

Chelsea is expected to pay an annual dividend of 126 a

Chelsea is expected to pay an annual dividend of $1.26 a share next year. The market price of the stock is $24.09 and the growth 2.6 percent. What is the cost of equity?

Sweet treats common stock is currently priced at 3672 a

Sweet treats common stock is currently priced at $36.72 a share. The company just paid $2.18 per share as its annual dividend. The dividends have been increasing by 2,2 percent annually and are expected to continue doing ...

Highway express has paid annual dividends of 132 133 138

Highway Express has paid annual dividends of $1.32, $1.33, $1.38, $1.40, and $1.42 over the past five years, respectively. What is the average divided growth rate?

An investment offers 6800 per year with the first payment

An investment offers $6,800 per year, with the first payment occurring one year from now. The required return is 7 percent. a. What would the value be today if the payments occurred for 20 years?  b. What would the value ...

Oil services corp reports the following eps data in its

Oil Services Corp. reports the following EPS data in its 2017 annual report (in million except per share data). Net income $1,827 Earnings per share: Basic $1.56 Diluted $1.54 Weighted average shares outstanding: Basic 1 ...

At the start of 2013 shasta corporation has 15000

At the start of 2013, Shasta Corporation has 15,000 outstanding shares of preferred stock, each with a $60 par value and a cumulative 7% annual dividend. The company also has 28,000 shares of common stock outstanding wit ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As