Sage Learning Systems Inc. was organized on September 30, 2012. Projected selling and administrative expenses for each of the first three months of operations are as follows: October $67,500 75,200 November December 88,100 Depreciation, insurance, and property taxes represent $9,000 of the estimated monthly expenses. The annual insurance premium was paid on September 30, and property taxes for the year will be paid in June. Sixty percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for October, November, and December.

Sage Learning Systems Inc. was organized on September 30, 2012. Projected selling and administrative expenses for each of the first three months of operations are as follows: October $67,500 75,200 November December 88,100 Depreciation, insurance, and property taxes represent $9,000 of the estimated monthly expenses. The annual insurance premium was paid on September 30, and property taxes for the year will be paid in June. Sixty percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for October, November, and December.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 11EB: Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase,...

See similar textbooks

Similar questions

Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $129,300 April 119,000 May 108,300 Depreciation, insurance, and property taxes represent $27,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 70% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month.
SafeMark Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $102,200 April 96,100 May 87,500 Depreciation, insurance, and property taxes represent $22,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 59% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for March, April, and May. SafeMark Financial Inc. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March April May March expenses: Paid in March $fill in the blank 1 Paid in April $fill in the blank 2 April expenses: Paid in April fill in the…
Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $171,100 April 157,400 May 143,200 Depreciation, insurance, and property taxes represent $36,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 58% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May. Horizon Financial Inc.Schedule of Cash Payments for Selling and Administrative ExpensesFor the Three Months Ending May 31 March April May March expenses: Paid in March $fill in the blank 1 Paid in April $fill in the blank 2 April expenses: Paid in April fill in the blank 3 Paid…
Oakwood Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $107,200 April 99,700 May 90,700 Depreciation, insurance, and property taxes represent $23,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 67% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for March, April, and May. Oakwood Financial Inc. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March April May March expenses: Paid in March Paid in April April expenses: Paid in April Paid in May May expenses: Paid in May Total cash payments
Jenny Inc. has the following projected costs for the second quarter of 20YY: Projected Costs Expenses April May June Selling and marketing expenses (i) $200,000 $250,000 $300,000 Office insurance expense (ii) 800 800 800 Office depreciation expense 500 500 500 Property tax expense (iii) 700 700 700 Jenny’s payment policy for selling and administrative expenses is as follows: Of the selling and marketing expenses, 50% is paid in the month they are incurred; the remaining 50% to be paid in the following month. The selling and admin expense payable at the end of March was $70,000, which represents 50% of March’s selling expenses. Insurance expense is $800 a month; however, the insurance is paid quarterly in the first month of each quarter, (i.e., in January, April, July, and October). Property taxes are paid once a year in December. The projected total selling and admin expenses for April are: Group of answer choices None of the above $172,400 $202,000 $204,400
Aston Corporation performs year-end planning in November of each year before its calendar year ends in December. The preliminary estimated net income is $4,800,000. The CFO, Rita Warren, meets with the company president, J. B. Aston, to review the projected numbers. She presents the following projected information. Aston Corporation Projected Income Statement For the Year Ended December 31, 2020 Sales $28,995,000 Interest revenue 5,000 Cost of goods sold $14,000,000 Depreciation 2,600,000 Operating expenses 6,400,000 23,000,000 Income before income tax 6,000,000 Income tax 1,200,000 Net income $ 4,800,000 Aston Corporation Selected Balance Sheet Information At December 31, 2020 Estimated cash balance $ 5,000,000 Available-for-sale debt investments (at cost) 10,000,000 Fair value adjustment (1/1/20) —0— Estimated fair value at December 31, 2020: Security Cost…
Hillary's Health Food Store has estimated monthly current asset financing requirements for the next six months as follows: January February March April May June Current Assets Temporary Permanent $6,000 $4,000 $1,000 $4,000 $2,000 $4,000 $6,500 $4,000 $5,000 $4,000 $2,000 $4,000 Projected annual borrowing rates for the next six months are: January February 6.0% April 12.0% May 9.0% June 7.0% March 9.0% Short- Term Long- Term 5.0% 9.6% 9.6% 9.6% 9.6% 9.6% 9.6% Required: a. Assuming the company follows the hedging strategy, calculate the TOTAL dollar interest payments for the six months. b. If the company implemented a risky strategy would you expect total dollar interest payments to be higher or lower, briefly explain your answer (calculation not required).
A firm collects 25% of its credit sale in the month of sale and the remainder in the following month. The credit sale for the month of June is GHC 150,000. It expert to pay bills of GHC 22,000 in July. The depreciation for the month is GHC 1000. If the company maintains an end month cash balance of GHC 100,000, what is the external finance required?
Schedule of cash payments for a service companySafeMark Financial Inc. was organized on February 28. Projected selling andadministrative expenses for each of the first three months of operations are asfollows:March 578,400April 83,500May 96,900Depreciation, insurance, and property taxes represent $10,000 of the estimatedmonthly expenses. The annual insurance premium was paid on February 28, andproperty taxes for the year will be paid in June. Seventy percent of the remainder ofthe expenses are expected to be paid in the month in which they are incurred, withthe balance to be paid in the following month.Prepare a schedule indicating cash payments for selling and administrative expensesfor March, April, and May
Finch Company began its operations on March 31 of the current year. Finch has the following projected costs: April May $157,000 $192,000 Manufacturing costs* Insurance expense** Depreciation expense Property tax expense*** *Of the manufacturing costs, three-fourths are paid for in the month they are incurred; one-fourth is paid in the following month. **Insurance expense is $920 a month; however, the insurance is paid four times yearly in the first month of the quarter, (i.e., January, April, July, and October). ***Property tax is paid once a year in November. The cash payments for Finch Company expected in the month of June are a. $249,750 Ob. $201,750 Oc. $153,750 Od. $48,000 920 1,890 440 920 1,890 June 440 $205,000 920 1,890 440
ABC LCC sells its products on a gross profit of 20% on sales. The following information Is extracted from its annual accounts for the year ended 31st March 2020. Amount $ 40,00,000 12,00,000 9,60,000 12,00,000 Manufacturing expenses (one month in arrears) Administration expenses (one month in arrears) 4,80,000 Sales promotion expenses (Payable half yearly in advance) 200,000 Sales (3months credit) Raw materials Wages (15 days in arrears) The company enjoys one month's credit from suppliers of raw materials and maintains 2 months stock of raw materials and one and a half months finished goods. Cash balance is maintained at $100,000 as a precautionary balance. Assuming a 10%margin, find out the working capital requirements of ABC LCC.