Millenium corporation Cash Budget Worksheet for 1st Quarter,2018 | |||||
jan | Fen | march | Total | ||
Total Sales | 15,00,000 | 13,00,000 | 14,00,000 | 42,00,000 | |
Credit Sales | 13,50,000 | 11,70,000 | 12,60,000 | 37,80,000 | |
cash Sale | 1,50,000 | 1,30,000 | 1,40,000 | 4,20,000 | |
Collection of A.R | |||||
70% of last month sale | 7,56,000 | 9,45,000 | 8,19,000 | 25,20,000 | |
30% of current month sale | 4,05,000 | 3,51,000 | 3,78,000 | 11,34,000 | |
Total Collection | 13,11,000 | 14,26,000 | 13,37,000 | 40,74,000 | |
Estimated purchases | |||||
70%of next month sale | 9,10,000 | 9,80,000 | 7,70,000 | 26,60,000 | |
estimated payments | 10,50,000 | 9,10,000 | 7,70,000 | 27,30,000 | |
Cash Budget For the 1st qtr | |||||
jan | feb | march | tota | ||
Sales | $ 15,00,000 | $ 13,00,000 | $ 14,00,000 | $ 42,00,000 | |
Projected cash balance | $ 1,00,000 | $ 50,000 | $ 1,31,000 | ||
beginning month | |||||
Receipts: | |||||
Cash collection | $ 1,50,000 | $ 1,30,000 | $ 1,40,000 | $ 4,20,000 | |
Accounts Receivable Collection | $ 11,61,000 | $ 12,96,000 | $ 11,97,000 | $ 36,54,000 | |
Total cash Available | $ 14,11,000 | $ 14,76,000 | $ 14,68,000 | $ 40,74,000 | |
Disbursements | |||||
Payments of accoints payable | $ 10,50,000 | $ 9,10,000 | $ 7,70,000 | $ 27,30,000 | |
Wahes & Salaries | $ 3,25,000 | $ 3,00,000 | $ 3,10,000 | $ 9,35,000 | |
Rent | $ 30,000 | $ 30,000 | $ 30,000 | $ 90,000 | |
Other expenses | $ 17,000 | $ 15,000 | $ 16,000 | $ 48,000 | |
Taxes | $ 1,50,000 | $ 1,50,000 | |||
Dividend | $ 50,000 | $ 50,000 | |||
Purchase of equipment | $ 90,000 | $ 90,000 | |||
$ - | |||||
Total Disbursements | $ 15,72,000 | $ 13,45,000 | $ 11,76,000 | $ 40,93,000 | |
$ - | |||||
Excess of available cash | $ - | $ 1,31,000 | $ 2,92,000 | $ 4,23,000 | |
Cash loan needed to maintain | $ 2,11,000 | $ - | $ - | $ 2,11,000 | |
Balance of 50,000 | $ - | ||||
$ - | |||||
Projected cash balance at the ned | $ 50,000 | $ - | $ - | $ 50,000 | |
CumulativeNet borrowings | $ 2,11,000 | $ 2,11,000 | $ 2,11,000 | $ 2,11,000 | |
$ - | $ - | $ - |
CASH BUDGET WITH EXPLANATION Budget Information. December 2017 - March 2018 our bank account Assignment 5...
1 . Class Problem on Cash Receipts, Receivables, Credit Financing Month August Feb March April May July June Sales (SN) 150 100 12.0 13.0 14.0 140 140 120 Assumptions: - 15% Collected at invoicing in a given month - 45% one month after - Remainder 2 months after 5 (a) What is the cash receipt for June 5 (b) What is the receivables in August 5 (c) Would you do a loan of $9.M in July assuming a factoring of...
RULE 2. Case Budget for a Small Department Store Assumption 12 Cash balance on December 31 i $12,000 Minimum cash balance is $10.000 Sales are 75 credit and 25 cash Credit sales are collected in the following manner * 60% collected in the first month after the sale 30 collected in the second month after the sale 54 collected in the third month after the sale *5% are never collected Sales forecasts are as follows: Pessimise October (actual November (actual)...
Required Prepare a cash budget month by month for the quarter ending 31 March 2019. Student Enterprises has the following business transaction estimates relating to the first quarter of 2019. JAN. FEB March Credit Sales Cash Sales Receipts from Accounts Receivable '1. Wages Office Furniture Prepayments Administrative Expense Depreciation on Office Furniture Receipt of Loan Credit Purchases Payments of Accounts Payable 2. Accrued Expenses Notes 120000 35000 calculate 35000 5000 140000 40000 calculate 35000 7000 160000 43000 calculate 35000 0...
cash budget, income statement and balance sheet Garden Sale December 11, 2017 25.200 Account Payable Working Cane Ng Paya 112.500 53.000 12,000 5 Prepaid Rem $ Prop. Plant & top Accum Depr 900 DOO (100.000 800.000 Commons Retained tamnings 200.000 772300 5 Net PPLES Total Assets You are the Business Manager of Garden Sales, Inc and the bank has asked you to prepare a cash and carnings budget/forecast and Pro-Forma Balance Sheet and Income Statement for the next quarter. After...
prepare a cash budget/forecast for each month of jan, feb and march 2018. income statement and balance sheet 13.00 Noce vete hai Acum Depr Contact Renderings 1140 You are the Business Manager of Garden Sales, Inc and the bank has asked you to prepare a cash and carings budget/forecast and Pro-Forma Balance Sheet and Income Statement for the next quarter. After your discussion with the various departments, you have come up with the following information/assumptions: . • • • November...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: Sales budget January February March $212,000 $232,000 $255,000 Credit sales are collected as follows: 70 percent in the month of the sale 15 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $96,000 ($66,000 of which was uncollected December sales). a. Calculate the sales for November....
Use the following information:a. Beginning cash balance on March 1, $80,000.b. Cash receipts from sales, $303,000.c. Budgeted cash payments for direct materials, $135,000.d. Budgeted cash payments for direct labor $75,000.e. Other budgeted cash expenses, $36,000.f. Cash repayment of bank loan, $16,000.Prepare a cash budget for the month ended on March 31 for Gado Company. The budget should show expected cash receipts and cash disbursements for the month of March and the balance expected on March 31.
Budgeting Go Car Repair Ltd intends to prepare a cash budget for December and January. The actual revenue for October and November and projected revenue for December and January are outlined below: Actual Budgeted October November December January Cash Sales 63,000 61,000 72,000 60,000 Credit Sales 90,000 110,000 130,000 80,000 Total Sales S153,000 $171.000 S202,000 S140,000 The cash balance at the end of November is $60,000. • Analysis of records has shown that credit sales are collected over a three-month...
please show all working Q1. Cash Budget Exercise: Below are some important figures from the budget of the Sundays Limited for the next three months. Apr Mar $160,000 68,000 $140,000 64,000 May $192,000 80,000 Credit sales Credit purchases Cash disbursements: Wages, taxes, and expenses Interest Equipment purchases 7,000 8,000 3,000 50,000 3,000 8,400 3,000 4,000 The company predicts that 10% of its sales will never be collected. 50% of its sales will be collected in the month of the sale:...
1. Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2017: June April $601,900 232,850 Мay $627,300 277,900 Credit sales $693,790 317,380 Credit purchases Cash disbursements Wages, taxes, and expenses Interest 79,670 18,058 62,964 18,058 76,364 18,058 144,200 Equipment purchases 0 131,400 The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining...