Recent and forecastedsales:October$161,000February $413,000April $280,000$280,000DecemberNovember168,000January378,000March273,0001. Prepare a master budget including a budgeted income statement, balance sheet, cash budget,and supporting schedules for the months January-March 20X2.2. Explain why there is a need for a bank loan and what operating sources provide the cash for therepayment of the bank loan.CS Scanned with CamScanner Prepare Master BudgetFlying Fish Kite Company, a small Woy Woy, Australia, firm that sells kites on the Weh, wants a masterbudget for the 3 months beginning January 1, 20X2. It desires the ending minimum cash balance of$15,000 each month. Sales are forecasted at an average wholesale selling price of $14 per kite,Merchandise cost average $5 per kite. All sales are on credit, payable within 30 days, but experience hasshown that 40% of current sales are collected in the current month, 10% in the next month, and 50% inthe month thereafter. Bad debts are negligible.In January, Flying Fish Kite is beginning just-in-time (JIT) deliveries from suppliers, which meansthat purchases will equal expected sales. On January 1, purchases will cease until inventory decreases to$22,000, after which time purchases will equal sales. Purchases during any given month are paid in fullduring the following month.Monthly operating expenses are as follows:$80,000Wages and salariesInsurance expired450Depreciation900Miscellaneous4,000Rent$500/month + 5% of quarterly sales over $50,000Cash dividends of $2,400 are to be paid quarterly, beginning January 15, and are declared on thefifteenth of the previous month. All operating expenses are paid as incurred, except insurance,depreciation, and rent. Rent of $500 is paid at the beginning of each month, and the additional 5% ofsales is settled quarterly on the tenth of the month following the end of the quarter. The next rentsettlement date is January 10.The company plans to buy some new fixtures for $4,000 cash in March.Money can be borrowed and repaid in multiples of $2,000. Management wants to minimizeborrowing and repay rapidly. Simple interest of 9% per annum is computed monthly but paid when theprincipal is repaid. Assume that borrowing occurs at the beginning, and repayments at the end, of themonths in question. Compute interest to the nearest dollar.Assests as ofLiabilities and Owners' Equities asof December 31, 20X1December 31, 20X1Cash$30,000 Accounts payable (merchandise)$151,500Accounts receivable180,600Inventory*Unexpired insuranceFixed assets, net153,000 Dividends payable2,4005,400 Rent payable62,000 Owners' equity$431,00027,950249,150$431,000*November 30 inventory balance $59,000CS Scanned with CamScanner

A budget is a forecast of revenue and expenses for a certain future period of time that is generally…

Recent and forecasted sales: October $280,000 December $161,000 February $413,000 April $280,000 November 168,000 January 378,000 March 273,000 1. Prepare a master budget including a budgeted income statement, balance sheet, cash budget, and supporting schedules for the months January-March 20X2. 2. Explain why there is a need for a bank loan and what operating sources provide the cash for the repayment of the bank loan.

Recent and forecasted sales: October $280,000 December $161,000 February $413,000 April $280,000 November 168,000 January 378,000 March 273,000 1. Prepare a master budget including a budgeted income statement, balance sheet, cash budget, and supporting schedules for the months January-March 20X2. 2. Explain why there is a need for a bank loan and what operating sources provide the cash for the repayment of the bank loan.

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

Fanning Medical Clinic has budgeted the following cash flows. January $105,000 February $111,000 March Cash receipts Cash payments For inventory purchases For S&A expenses $131,000 92,500 33,500 74,500 34,500 87,500 29,500 Fanning Medical had a cash balance of $10,500 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 3 percent per month. Repayments may be made in any amount available. Fanning pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter $ 180,000 $ 260,000 Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest 2nd Quarter $ 330,000 $ 230,000 The company's beginning cash balance for the upcoming fiscal year will be $20,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for…
Bhupatbhai
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,760,000 Quarter 2 5,620,000 Quarter 3 3,060,000 Quarter 4 7,720,000 In Shalimar's 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 $5,310,000 and for the fourth quarter of the current year are $7,350,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. Quarter Cash Sales Credit Sales 3, current year 4, current year 1, next year 2, next year 3. next vear 4, next year 2. Construct a cash receipts budget for…
Baird Medical Clinic has budgeted the following cash flows. February $108,000 January March Cash receipts Cash payments For inventory purchases For S&A expenses $102,000 $128,000 91,000 73,000 33,000 86,000 28,000 32,000 Baird Medical had a cash balance of $9,000 on January 1. The company desires to maintain a cash cushion of $7,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 3 percent per month. Repayments may be made in any amount available. Baird pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign. ) Cash Budget January February March Section 1: Cash Receipts $ $ Total cash available Section 2: Cash Payments Total…
Gadubhai
Beginning cash balance as on March 1, P80,000. Cash receipts from sales P400,000 Budgeted cash disbursements for purchases 250,000. Budgeted cash disbursements for salaries 90,000. Cash repayment of bank loan 30,000. Prepare a cash budget for the month ended on March 31 for Spars Corp.
Garden Depot is a retaller that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter $ 280,000 $ 344,888 Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest 2nd Quarter $ 480,000 $ 314,000 The company's beginning cash balance for the upcoming fiscal year will be $45,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Total financing Ending cash balance Required:…
please read instructions on PR22-4A and answer on the execl sheet. Thanks for your time!
answer in text form please (without image)
Cash budgeting is critical to a company’s financial information needs. The following information was extracted from the records of A & B Manufacturing Company Limited. The opening cash balances on January 01, 2021 was expected to be $30,000. The budgeted sales were as follows: Budgeted Sales Month Year $ November 2020 80,000 December 2020 90,000 January 2021 80,000 February 2021 75,000 March 2021 60,000 April 2021 70,000 Analysis of records shows that debtors settle according to the following pattern: 70% within the month of sale 30% the following month Extracts of the purchases budget were as follows: Purchases budget Month Year $ December 2020 65,000 January 2021 50,000 February 2021 75,000 March…
Please answer with excel forumlas and step by step explanations. Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 569,000 $ 508,000 February 455,000 425,000 March 505,000 600,000 Kayak requires a minimum cash balance of $38,000 at each month-end. Loans taken to meet this requirement charge 0.7% interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $38,000 is used to repay loans at month-end. The company has a cash balance of $38,000 and a loan balance of $76,000 at January 1. Prepare monthly cash budgets for January, February, and March.