Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Mecca 4 Company, a retailer of specialty wall-papers, prepares a monthly master budget. Data for the September master budget are given below: a. The


 image

Mecca 4 Company, a retailer of specialty wall-papers, prepares a monthly master budget. Data for the September master budget are given below: a. The August 31st balance sheet (Actual): cash $25,000 accounts payable $62,016 accounts receivable 133,000 inventory 32,813 capital stock 295,372 203,500 (net) b. building and equipment Actual sales for August and budgeted sales for September, October, and November are given below: retained eamings 36,925 August-Actual $190,000 September-Projected 375,000 October-Projected 405,000 November-Projected 310,000 C. d. e. f. B h. Required: Sales are 30% for cash and 70% on credit. All credit sales are collected in the month following the sale. There are no bad debts. The gross margin percentage is 65% of sales. The desired ending inventory is equal to 25% of the following month's COGS. One fourth of the purchases are paid for in the month of the purchase and the remaining 75% are purchased on account and paid in full the following month. The monthly operating expenses are $90,000 including the monthly depreciation of $8,000 In September, Mecca Company will purchase new office equipment for $40,000 cash. The expected useful life of the new equipment is 5 years, with no salvage value. It will be depreciated using the straight-line method. Mecca will start depreciating the equipment in September (full month). Dividends of $23,500 and $30,000 will be declared and paid in September and October, respectively. The company must maintain a minimum cash balance of $32,000 starting September. A line of credit is used to maintain this balance. Borrowing will be made in increments of $1,000. All bomowing is done at the beginning of the month and repayments are made at the end of the month. The annual interest rate is 12%, paid when the loan is repaid (ignore the accrual of interest). 1. Prepare a balance sheet, income statement, and cash budget for the month of September.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray Garrison, Eric Noreen, Peter Brewer

16th edition

1259307417, 978-1260153132, 1260153134, 978-1259307416

More Books

Students also viewed these Accounting questions

Question

When is denormalization justified? AppendixLO1

Answered: 1 week ago

Question

Is there any other possible conclusion?

Answered: 1 week ago

Question

Solve the following the equation. y=192+0.04y

Answered: 1 week ago