Accountancy

Question

Question

Accountancy

Calculate monthly C.O.G.S. assuming a 30% mark-up and the following 6 month’s sales figures:

$4000, $4500, $5000, $6000, $7500, $7500.
Repeat calculations assuming gross contribution margin of 40%.

Assuming average monthly sales of $50,000 and average monthly C.O.G.S. of $30,000, calculate the expected level of

Receivables if average collection period is 55 days.
Inventory if you plan on average 40 days on hand.

Assuming annual sales of $250,000 and a 50% gross (contribution) margin, calculate the following

Average collection period if ending receivables total $45,000
Ending days-on-hand of inventory if ending inventory levels are $30,000

Assuming opening equipment of $100,000 (to be depreciated at $2000/month) plus additional equipment purchase of $50,000 (to be depreciated at $1000/month) in month 6, calculate year-end book value of equipment. Record equipment at cost, accumulated depreciation, and book-value.

Calculate B.V. of ending equipment assuming you started the year with $75,000 in equipment, purchased $65,000 in new equipment during the year, and deducted $15,000 in depreciation.
Calculate ending receivables assuming opening receivables were $150,000 and sales and collections for the year were $600,000 and $580,000 respectively.
Calculate amount collected if sales were $500,000, and opening and ending receivables were $120,000 and $110,000 respectively.
Calculate ending inventory assuming opening inventory was $40,000 and purchases and COGS were $300,000 and $280,000 respectively.

Calculate ending equity if opening paid in capital was $100,000 and retaining earnings were $55,000, but during the year recorded an after-tax profit of $35,000 and paid dividends of $20,000. Record ending paid-in capital, retained earnings and total equity separately.
Calculate year- ending loan balance if you started the year with a $120,000 loan (monthly payments $2000 principal + $500 interest) and a new loan of $20,000 in month 8 to be repaid at $500 principal + $200 interest per month starting the month after the advance).

For the above, calculate annual expense.
For the above calculate total cash-in and total cash-out. Record the break-down necessary for completion of cash flow forecasts.

Add a comment Improve this question Transcribed image text

Answer 1

Similar Homework Help Questions

Calculate ending receivables assuming opening receivables were $150,000 and sales and collections for the year were...

Calculate ending receivables assuming opening receivables were $150,000 and sales and collections for the year were $600,000 and $580,000 respectively. Calculate amount collected if sales were $500,000, and opening and ending receivables were $120,000 and $110,000 respectively.
Accountancy

JC Floor Design makes ceramic tilesDecember sales were:500,000 unitsSelling price $2 per unit1,000,000 total salesThe Marketing Department, projects sales to:increase by 5% in January February sales will be 15,000 units less than JanuaryMarch sales will be 3% higher than February salesApril sales will be the 5,300 units less than marchThe price is not expected to increaseJC inventory policy is to maintain an ending inventory equals to 30% of next month sales. Actual inventory is 168,000 units Clay the material to make the tiles...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the...

Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. Estimated Balance Sheet Assets Cash $ 36,500 Accounts receivable 520,000 Inventory 105,000 Total current assets $ 661,500 Equipment 612,000 Less: Accumulated depreciation 76,500 Equipment, net 535,500 Total assets $ 1,197,000 Liabilities and Equity Accounts payable $ 375,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 89,000 Total liabilities $ 476,000 Common stock 474,500 Retained earnings 246,500...

CASH FLOW FORECAST Happy Manufacturing had sales of $65,000 in March and $75,000 in April. Forecast...

CASH FLOW FORECAST Happy Manufacturing had sales of $65,000 in March and $75,000 in April. Forecast sales for May, June and July are $85,000, $95,000, and $120,000, respectively Given the following data, calculate monthly net cash flow for the months of May, June, and July (1) The firm makes 20% of sales for cash; 30 % are collected in the next month, and the remaining 50% are collected in the second month following the sale. The firm receives other income...
Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the...

Near the end of 2019, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2019. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2019 Assets Cash $ 36,000 Accounts receivable 520,000 Inventory 135,000 Total current assets $ 691,000 Equipment 600,000 Less: Accumulated depreciation 75,000 Equipment, net 525,000 Total assets $ 1,216,000 Liabilities and Equity Accounts payable $ 340,000 Bank loan payable 12,000 Taxes payable (due 3/15/2020) 88,000 Total liabilities $ 440,000...
Accountancy

You are the new CFO for XYZ Hospital. You have asked the accounts receivable manager to review the accounts receivable information for Quarter 1, 20X1 and Quarter 20X2 and determine if the organization's collection procedure is improving.Givens (in '000)Quarter 1, 20X1TimeSepAugJulQuarterDays outstanding1-3031-6061-901-90Net accounts receivable$500$800$3,700$5,000Net patient revenue$1,000$5,000$9,000$15,000Calculations:FormulaAging schedule[a]10%16%74%Days[Given 2]30303090Average daily patient revenue[Given 4 / B]$33$167$300$167Days in accounts receivable[Given 3 / C]30Receivables as percent of revenues[Given 3 / Given 4]50%16%41%[a] [Given 3] (month) / [Given 3] (quarter)Givens (in '000)Quarter 2, 20X1TimeDecNovOctQuarterDays outstanding1-3031-6061-901-90Net...

Month 1: $2,000,000 sale of stock occurs with all cash received by the company. $3,000,000 bank...

Month 1: $2,000,000 sale of stock occurs with all cash received by the company. $3,000,000 bank loan received from the company’s bank at the end of the month – interest will start accruing next month (interest rate is 1% per month). Principal and interest cash payments will be made in a lump-sum payment at the end of the loan period. Factory is leased at the beginning of the month and prepaid for the entire year up-front at a cost of $720,000. The...
Use T-accounts to record the 4 months’ of transactions noted below for this new start-up company....

Use T-accounts to record the 4 months’ of transactions noted below for this new start-up company. Record all entries affecting the income statement into “Equity” since there are no separate T-accounts set up for the individual income statement accounts. Once all transactions have been posted, populate the net ending balance for each account for the accounts listed below. Month 1 $2,000,000 sale of stock occurs with all cash received by the company. $3,000,000 bank loan received from the company’s bank...
4. Following information is available for a merchandising company. Total merchandise cost (total merchandise purchases): 30,000,000 TL. Merchandise stay in inventory for 20 days (average days in...

4. Following information is available for a merchandising company. Total merchandise cost (total merchandise purchases): 30,000,000 TL. Merchandise stay in inventory for 20 days (average days in merchandise inventory is 20 days) 30 % of the customers pay cash directly, 70 % of the customers pay by credit card. Average collection period for credit card receivables is 35 days. 10% of the merchandise costs are paid 30 days in advance (30 days before receiving the merchandise) Calculate this merchandising company's...

Account T-Account Record

Month 1:$2,000,000 sale of stock occurs with all cash received by the company.$3,000,000 bank loan received from the company’s bank at the end of the month – interest will start accruing next month (interest rate is 1% per month). Principal and interest cash payments will be made in a lump-sum payment at the end of the loan period.Factory is leased at the beginning of the month and prepaid for the entire year up-front at a cost of $720,000. The first month of lease expense is expensed to the...

Accountancy

Homework Answers

Request Answer!