Miggy Co. projects the following monthly revenues for next year: 100,000 500,000 452,000 450,000 557,000 300,000 January February March July August September October 250,000 275,000 300,000 350,000 400,000 525,000 April May November 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.

Miggy Co. projects the following monthly revenues for next year: 100,000 500,000 452,000 450,000 557,000 300,000 January February March July August September October 250,000 275,000 300,000 350,000 400,000 525,000 April May November 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.

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter15: Managing Short-term Assets

Section: Chapter Questions

Problem 1PROB

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?
Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2018 to $9.2 million in 2019. Its assets totaled $5 million at the end of 2018. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2018, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 40%. Use the AFN equation to forecast Broussard’s additional funds needed for the coming year.
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
A company has pre-tax or operating income of $120,000. If the tax rate is 40%, what is the companys after-tax income? A. $300,000 B. $240,000 C. $48,000 D. $72,000
Company XYZ made total sales of $250,000 during the month of December. The company also incurred total expenses of $50,000. Of that amount 60% was fixed expenses. Company XYZ expects sales to increase by 16% next month. What is the expected operating profit, in (S) value, next month?
Firm B has accounts receivable of $5,000,000 and annual sales of $9,000,000. What is the firm's days sales outstanding (DSO)? Assume a 365-day year.
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 cash payments for selling and admin expenses projected in the month of April are: Group of answer choices None of the above $202,000…
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
Mazon Inc. plans to sell 7,000 units each quarter next year. During the first two quarters each unit will sell for OMR12; during the last two quarters the sales price will increase OMR1.50 per unit. What is Mazon's estimated sales revenue for next year? Select one: a. OMR 397,000 b. OMR 357,000 c. OMR 378,000 d. OMR 336,000
Anusha Berhad’s sales pattern for the first quarter 2021 and projected revenues are as follows: Additional information:i. Historically, Anusha Berhad’s sales were on cash basis.ii. Anusha purchase raw material two month before the sales month and paid in cash equal to 60 percent of its sales.iii. Fixed monthly rent of RM11,000.iv. A depreciation expense is RM400 per month.v. Dividend of RM3,000 will be received at the end of each quarter.vi. Wages and salaries are estimated RM15,000 per month.vii. Anusha decide to repay RM40,000 of their loan on April.viii. Interest on accumulated loan is at 9 percent annual interest and paid in the following month.ix. Ending cash balance for the budget period is RM20,000 and it would like to maintain minimum desired balance of RM20,000 per month. Prepare a monthly cash budget for the first quarter 2021 for Anusha Berhad.
The information provided below was taken from the records of Chotoo Projects for the financialyear ended 31 May 2020.Extract of statement of comprehensive income for the year ended 31 May 2020RRevenue 480 000Direct costs 240 000Rent income 150 000Advertising 4 800Salaries and wages 90 000Rates and taxes 1 200Other operating expenses 80 000Additional information1. Revenue is calculated as direct cost plus 25%.2. Revenue is divided equally each month. Revenue is expected to increase by 18% for thefinancial year ending 31 May 2021.POSTGRADUATE DIPLOMA IN PROJECT MANAGEMENT – ACADEMIC AND ASSESSMENT CALENDARREGENT BUSINESS SCHOOL (RBS) January 2021 173. Fifty percent (50%) of the revenue is for cash and the balance is on credit. Debtorsnormally pay their accounts as follows:• 40% in the month of the invoice, and these debtors are entitled toa 5% discount;• 55% one month after the invoice;The balance is usually written off as bad debts.4. Purchases for June and July are expected to be 30…
Company XYZ made total sales of $250,000 during the month of December. The company also incurred total expenses of $210,000. Of that amount 60% was fixed expenses. Company XYZ expects sales to increase by 13% next month. What is the expected operating profit, in ($) value, next month?Select one:a. 45,200b. 61,580c. None of the given answersd. 166,000e. 40,000