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 April May $144,800 137,600 125,200 Depreciation, insurance, and property taxes represent $31,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will paid in June. Of the remainder of the expenses, 67% 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 Expenses For the Three Months Ending May 31 Line Item Description March April Paid in March Paid in Apri pri expenses Paid in April Paid in May May expenses Paid in May Total cash payments May

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 April May $144,800 137,600 125,200 Depreciation, insurance, and property taxes represent $31,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will paid in June. Of the remainder of the expenses, 67% 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 Expenses For the Three Months Ending May 31 Line Item Description March April Paid in March Paid in Apri pri expenses Paid in April Paid in May May expenses Paid in May Total cash payments May

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

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).
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
All sales are made on credit terms of net 30 days and are collected the following month and no bad debts are anticipated. The accounts receivable on the balance sheet at the end of September thus will be collected in October. The October sales will be collected in November, and so on. Inventory on hand represents a minimum operating level (or “safety” stock), which the company intends to maintain. Cost of goods sold average 80 percent of sales. Inventory is purchased in the month of sale and paid for in cash. Other cash expenses average 7 percent of sales. Depreciation is $10,000 per month. Assume taxes are paid monthly and the effective income tax rate is 40 percent for planning purposes. The annual interest rate on outstanding long-term debt and bank loans (notes payable) is 12%. There are no capital expenditures planned during the period, and no dividends will be paid. The company’s desired end-of-month cash balance is $80,000. The president hopes to meet any cash shortages during…
Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or sell any plant and…
Schedule of cash payments for a service company 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 $143,400 April 131,900 May 120,000 Depreciation, insurance, and property taxes represent $30,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. 63% 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.
69) Western Company expects the following credit sales for the first five months of the year: January, $43,000; February, $58,000; March, $48,000; April, $54,000, May $58,000. Experience has shown that payment for the credit sales is received as follows: 60% in the month of sale, 25% in the first month after sale, 10% in the second month after sale, and the remainder is uncollectible. How much cash can Western Company expect to collect in March as a result of credit sales (current and past)? A) $28,800. B) $42,600. C) $48,000. D) $47,600. E) $41,100.
Munoz Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Munoz expects sales in January year 1 to total $270,000 and to increase 15 percent per month in February and March. All sales are on account. Munoz expects to collect 69 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 7 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Munoz will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Determine the amount of accounts receivable as of March 31, year 1. (Do not…
Lakeside Components wishes to purchase parts in one month f although sales for June are estimated to total 11,000 parts. Total Parts are purchased at a wholesale price of $15. The supplier ha percent of the purchase price in the month when the parts are 15,000 parts in May. Required: a. Estimate purchases (in units) for June and July. b. Estimate the cash required to make purchases in June and Ju Complete this question by entering your answers in the ta Required A Required B Estimate purchases (in units) for June and July. Merchandise to be purchased in units June July 15,000
Forecasted cash receipts and expenditure for the period August to October are as follows: Cash Receipts Expenditure $ $ 60,000 58,000 July August September October 54000 68,000 90,000 30,000 44,000 Additional information provided: ✓ Expenditure for the period July to October includes monthly depreciation of $5,000. ✓ Payment for the cash related expenditure would be 40% in the month of purchase, the balance being paid the following month. The company intends to sell equipment valued at $25,000 in September. Insurance of $25,000 is payable in December. Opening cash balance as at August 1, $18,800. Required: Prepare a monthly Cash Budget for the period August to October 2021.
Miggy Co. projects the following monthly revenues for next year: 250,000 January February March 100,000 500,000 July August September October 275,000 300,000 350,000 452,000 450,000 Аpril May 557,000 300,000 November 400,000 525,000 June December Miggy's terms are net 30 days. The company typically receives payment on 80% of sales the month following the sale and 17% is collected two months after the sale. Approximately 3% of sales are deemed bad debt. What amount represents the expected cash collection in the second calendar quarter of next year? a. 1,405,540 b. 1,293,630 c. 1,320,540 d. 1,234,250
Valley's managers have made the following additional assumptions and estimates: Estimated sales for July and August are $345,000 and $315,000 respectively Each month's sales are 20% cash sales and 80% credit sales. Each month's credit sales are collected 30% in the month of the sale and 70% in the month following the sale. All of the accounts receivable at June 30 will be collected in July Each month's ending inventory must equal 20% of the cost of the next month's sales. The Cost of Goods Sold is 60% of sales. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month following the purchase. All of the accounts payable at June 30 will be paid in July Monthly selling and administrative expenses are always $75,000. Each month $10,000 of this total amount is depreciation expense and the remaining $65,000 relates to expenses that are paid in the month they are incurred The company does not plan to buy or…
Lakeside Components wishes to purchase parts in one month for sale in the next. On June 1, the company has 9,000 parts in stock, although sales for June are estimated to total 11,400 parts. Total sales of parts are expected to be 8,800 in July and 13,900 in August. Parts are purchased at a wholesale price of $15. The supplier has a financing arrangement by which Lakeside Components pays 70 percent of the purchase price in the month when the parts are delivered and 30 percent in the following month. Lakeside purchased 15,000 parts in May. Required:a. Estimate purchases (in units) for June and July.b. Estimate the cash required to make purchases in June and July. Required A Required B Estimate purchases (in units) for June and July. June July Merchandise to be purchased in units Month of Payment Total June not attempted July