Bantam Industries has budgeted the following information for March: Cash receipts Beginning cash balance Cash payments Desired ending cash balance $351,000 25,000 400,000 45,000 of the month in had no debt before If there is a cash shortage, the company borrows money from the bank. All cash is borrowed at the beginning $1,000 increments, and interest is paid monthly at 1% on the first day of the following month. The company March 1. How much cash will the company need to borrow in March?
Q: You want to be able to withdraw $35,000 from your account each year for 20 years after you retire.…
A: Present value (PV) is calculated when future value is known but the investor wants to know the…
Q: Where does the $9,250,000 depeletion base come from
A: The depletion base is the sum of the amount paid by a company to acquire the right, plus an…
Q: ames Din has been advised that one of his customers has ceased trading and that he will not recover…
A: Accounts receivable means the customer purchased the goods from the sale but has not paid yet. It is…
Q: On January 1, 2022, A and B formed a partnership. A and B agreed to share the partnership's profit…
A: Partnership: The arrangement in which more than one entity, whether it is an individual or…
Q: Zenon, Incorporated has the following taxable income: U.S. source income. Foreign source income…
A: INTRODUCTION Income tax is calculated by applying the tax rate (21%) to the total taxable income…
Q: Wildhorse Company prepared the tabulation below at December 31, 2022. Net Income Adjustments to…
A: Cash flow from operating activities is computed by direct method or indirect method. Under indirect…
Q: Avril deposited $800 in his bank at 1.5% for five years. Use the simple interest formula to…
A: INTRODUCTION Simple interest is calculated by multiplying the interest by the Principal amount.…
Q: Sentra Sporting Company sells tennis rackets and other sporting equipment. The purchasing department…
A: Purchase budget: Purchase budget is prepared at the starting of the year to know the purchase…
Q: Barnett Brass sells economy door knobs for $15 each. Unit product costs are as follows: Direct…
A: In this question, we need to compute the minimum acceptable selling price for the special order from…
Q: Ramirez Company installs a computerized manufacturing machine in its factory at the beginning of the…
A: Units of activity method: Under units-of-activity method, depreciation is computed based on the…
Q: Zachary Publications established the following standard price and costs for a hardcover picture book…
A: The variance is the difference between the actual result and the company's standard result.…
Q: Pedro bought a new car today from Barboncito Motors. The former proposed to pay the latter the…
A: The monthly payment is the payment made every month to repay the loss or debt. The monthly payment…
Q: Caltex Products plc manufactures electric mini-lawnmowers. Its sales and costs’ budget for November…
A: A budget is a yearly statement of the projections for government revenues and expenses for the…
Q: Henry, a super salesman contemplating retirement on his fifty-fifth birthday, decides to create a…
A: Annual withdrawal from 2021 to 2024 = $ 63,000Number of withdrawals = 4Annual Interest rate = 12%
Q: Evergreen Furniture, a retailing company, is preparing the cash budget for August. The following…
A: Given, Estimated purchases for August = $2,380,000 Estimated payments in August for purchases in…
Q: (4-a) Compute days' sales in inventory. (4-b) For each ratio, determine if it improved or worsened…
A: Introduction: Days' sales in inventory ratio computes the number of days inventory are hold in the…
Q: A & B formed a partnership. A contributed cash and land with a fair value of P60,000 and a book…
A:
Q: A and B are combining their separate businesses to form a partnership. Presented here are the…
A: When two different business merge together and put their capital in a business, it is considered as…
Q: Calculate Melissa Allen’s tax liability for taxable income of $59,580. She files single and claims 3…
A: Since Melissa Allen files single, Rates given in Schedule X will be used for calculating the tax…
Q: Required information [The following information applies to the questions displayed below.] Jacob is…
A: Qualified business income refers to the deduction of tax that is allowed to small business and…
Q: Given that the Closing Work-in-Progress of a process is 400 units, which is 100% complete with…
A: The equivalent units are calculated on the basis of percentage of the work completed during the…
Q: Poston Company uses an accelerated depreciation method for tax purposes rather than straight-line…
A: There are many methods for taking depreciation it depends on the choice of company to take…
Q: Caltex Products plc manufactures electric mini-lawnmowers. Its sales and costs’ budget for November…
A: Sales Price Variance Unfavorable sales price variances occur when a company sells for less than the…
Q: Date March 1 March 5 March 9 March 17 March 22 March 27 March 30 Transactions Beginning inventory…
A: First In, First Out, sometimes known as FIFO, is a strategy of managing assets and valuing them that…
Q: List some of the differences between taxable items for NY State tax purposes and IRS tax purposes
A: The income tax means the tax charged by the government on the income earned by the taxpayer. There…
Q: i) Produce a budget statement for Caltex for November ii) Produce a profit statement for Caltex…
A: Particulars Calculation Amount Sales 3000 units x 72 216000 Less: Variable cost Direct…
Q: 2. Account Title Cash Accounts Receivable Supplies Prepaid Expenses Equipment Land Accounts Payable…
A: When a business transaction takes place, it must be recorded in the books. Journal entries records…
Q: Prepare the journal entries that were recorded by Church to record the sale of the investment and…
A: Working: Calculation of cash received on sale of investment: Carrying…
Q: Determining Cash Flows from Financing Activities Nichols Inc. reported the following amounts on its…
A: Statement of Cash flows includes: Cash flows from operating activities Cash flows from investing…
Q: Complete this question by entering your answers in the tabs below. Req 4A Req 4B X Answer is not…
A: Pension expense is the amount that a business charges to expense in relation to its liabilities for…
Q: Describes and explains the basis of variable (marginal) and absorption costing systems.
A: Variable costing is a product costing system that only includes variable manufacturing costs in the…
Q: If B is to invest sufficient cash to obtain 3/5 interest in the partnership, Compute the amount B…
A: Partnership firm is where two or more person come together to form a business. And they should share…
Q: Garcia Company produces two different types of gauges: a density gauge and a thickness gauge. The…
A: Solution:- 1)Discussion of Should Garcia Company make or buy the subassembly and If it makes the…
Q: Selected unadjusted balances and adjusting entry information of Sutherland Insurance Agency at…
A: Salaries expenses shall be debited for $ 2000 Salaries payable shall be credited for $ 2000
Q: mpute the (1) het present value, (2) pro lity Index, and ternal rate of retur option. (Hint: To…
A: Capital budgeting concepts and tools will have to be used in this case. The first task will be to…
Q: 4-a. Determine Lakeside's pension expense for 2025. 4-b. Prepare the appropriate journal entries to…
A: Particulars Calculation Amount ($) Million Amortiation of Prior service cost 4 Service…
Q: 1. Compute the velocity (number of models per hour) that the cell can theoretically achieve. If…
A: 1 .) Given Data:- Budgeted conversion costs = $8791,680 Budgeted materials =$18,616,000 Cell…
Q: Critically analyse the key characteristics of an acquiring company as far as mergers and acquisition…
A: An acquiring company is a company that purchases another company. The key characteristics of an…
Q: 4-a. Determine Lakeside's pension expense for 2025. 4-b. Prepare the appropriate journal entries to…
A: Pension refers to the amount that is paid by the company or government to the person who stopped…
Q: Operating leverage Haywood Co. reports the following data: Line Item Description Amount Sales…
A: Operating income is a measure used to evaluate the effect of change in revenues on the operating…
Q: Susan Corporation started the year expecting to produce and sell 117,000 units of its…
A: Variance analysis is the method of evaluating and studying the deviation that arises while comparing…
Q: Salaries Payable account nad a beginning balance of $ 28,000 on May 1. During the month of May…
A: The salary payable is the current liability for the business. It is the amount of salary expense…
Q: Evaluate in terms of the framework, why it is appropriate to capitalize borrowing costs under…
A: The accounting treatment of borrowing costs is governed by IFRS 9 Financial Instruments, which came…
Q: With the estimates shown below, Sarah needs to determine the trade-in (replacement) value of machine…
A: The word "replacement cost" refers to the amount of money that a company has to pay at the present…
Q: Prepare the December 31 year-end adjusting entry for uncollectibles. 2. What amount would have been…
A: Particuars Amount ($) Closing Balance of Provision 2970 (198000 x 1.5%) Less: Opening…
Q: Metlock Inc. issues $4,200,000 of 7% bonds due in 10 years with interest payable at year-end. The…
A: Bonds are the securities which are issued by the entity in the market in order to raise funds from…
Q: A partnership has the following accounting amounts: Sales Cost of Goods Sold General and…
A: Partnership refers to an agreement between two or more persons for doing business managing the…
Q: Cycle-1 is a fast-growing start-up firm that manufactures bicycles. The following income statement…
A: The budgeted income statement is a statement of the predicted amount of the organization's sales,…
Q: Jesse Brimhall is single. In 2022, his itemized deductions were $9,000 before considering any real…
A: Itemized deductions allow individuals to subtract designated expenses from their taxable income and…
Q: Prepare an income statement for the month of June. SUNLAND DESIGNS CO. Income Statement
A: Income statement is one of the basic financial statements which is prepared by the business with…
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Step by step
Solved in 2 steps
- Cash Budget The controller of Feinberg Company is gathering data to prepare the cash budget for July. He plans to develop the budget from the following information: a. Of all sales, 40% are cash sales. b. Of credit sales, 45% are collected within the month of sale. Half of the credit sales collected within the month receive a 2% cash discount (for accounts paid within 10 days). Thirty percent of credit sales are collected in the following month; remaining credit sales are collected the month thereafter. There are virtually no bad debts. c. Sales for the second two quarters of the year follow. (Note: The first 3 months are actual sales, and the last 3 months are estimated sales.) d. The company sells all that it produces each month. The cost of raw materials equals 26% of each sales dollar. The company requires a monthly ending inventory of raw materials equal to the coming months production requirements. Of raw materials purchases, 50% is paid for in the month of purchase. The remaining 50% is paid for in the following month. e. Wages total 105,000 each month and are paid in the month incurred. f. Budgeted monthly operating expenses total 376,000, of which 45,000 is depreciation and 6,000 is expiration of prepaid insurance (the annual premium of 72,000 is paid on January 1). g. Dividends of 130,000, declared on June 30, will be paid on July 15. h. Old equipment will be sold for 25,200 on July 4. i. On July 13, new equipment will be purchased for 173,000. j. The company maintains a minimum cash balance of 20,000. k. The cash balance on July 1 is 27,000. Required: Prepare a cash budget for July. Give a supporting schedule that details the cash collections from sales.Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year
- Cash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?Carmichael Corporation is in the process of preparing next years budget. The pro forma income statement for the current year is as follows: Required: 1. What is the break-even sales revenue (rounded to the nearest dollar) for Carmichael Corporation for the current year? 2. For the coming year, the management of Carmichael Corporation anticipates an 8 percent increase in variable costs and a 60,000 increase in fixed expenses. What is the break-even point in dollars for next year? (CMA adapted)A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971
- Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2014 and 2015: May 2014 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360.000 November 360,000 December 90,000 January 2015 180.000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2014 90,000 June 90,000 July 126,000 August 882.000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses arc S2,700 a month. Income tax payments of 63,000 arc due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2014. b. Prepare monthly estimates of the required financing or excess funds that is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 130 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.