Near the end of 2011, the management of Simid Sports Co., a merchandising company, prepared the...

60.1K

Verified Solution

Question

Accounting

Near the end of 2011, the management of Simid Sports Co., amerchandising company, prepared the following estimated statementof financial position for December 31, 2011.

SIMID SPORTS COMPANY
Estimated Statement of Financial position
December 31, 2011
Assets
  Cash$35,500
  Accounts receivable520,000
  Inventory157,500
  
  Total current assets713,000
  Equipment$536,000
  Lessaccumulated depreciation67,000469,000
  
  Total assets$1,182,000
  
Liabilities and Equity
  Accounts payable$375,000
  Bankloan payable16,000
  Taxpayable (due 3/15/2012)89,000
  
  Total liabilities$480,000
  Share capital—ordinary473,500
  Retained earnings228,500
  
  Total stockholders’ equity702,000
  
  Total liabilities and equity$1,182,000
  

To prepare a master budget for January, February, and March of2012, management gathers the following information.

a.

Simid Sports’ single product is purchased for $30 per unit andresold for $54 per unit. The expected inventory level of 5,250units on December 31, 2011, is more than management’s desired levelfor 2012, which is 20% of the next month’s expected sales (inunits). Expected sales are: January, 7,000 units; February, 8,750units; March, 10,500 units; and April, 9,500 units.

b.

Cash sales and credit sales represent 25% and 75%, respectively,of total sales. Of the credit sales, 63% is collected in the firstmonth after the month of sale and 37% in the second month after themonth of sale. For the December 31, 2011, accounts receivablebalance, $125,000 is collected in January and the remaining$395,000 is collected in February.

c.

Merchandise purchases are paid for as follows: 20% in the firstmonth after the month of purchase and 80% in the second month afterthe month of purchase. For the December 31, 2011, accounts payablebalance, $75,000 is paid in January and the remaining $300,000 ispaid in February.

d.

Sales commissions equal to 20% of sales are paid each month.Sales salaries (excluding commissions) are $90,000 per year.

e.

General and administrative salaries are $144,000 per year.Maintenance expense equals $2,000 per month and is paid incash.

f.

Equipment reported in the December 31, 2011, statement offinancial position was purchased in January 2011. It is beingdepreciated over eight years under the straight-line method with noresidual value. The following amounts for new equipment purchasesare planned in the coming quarter: January, $34,000; February,$95,000; and March, $28,500. This equipment will be depreciatedunder the straight-line method over eight years with no residualvalue. A full month’s depreciation is taken for the month in whichequipment is purchased.

g.

The company plans to acquire land at the end of March at a costof $145,000, which will be paid with cash on the last day of themonth.

h.

Simid Sports has a working arrangement with its bank to obtainadditional loans as needed. The interest rate is 12% per year, andinterest is paid at each month-end based on the beginning balance.Partial or full payments on these loans can be made on the last dayof the month. The company has agreed to maintain a minimum endingcash balance of $32,740 in each month.

i.

The income tax rate for the company is 37%. Income tax on thefirst quarter’s income will not be paid

Answer the following questions(5---8)

5.

Monthly capital expenditures budgets.    6.Monthlycash budgets.

7.

Budgeted income statement for the entire first quarter (not foreach month).

8.

Budgeted statement of financial position as at March 31,2012.

Answer & Explanation Solved by verified expert
4.3 Ratings (759 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students