Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i want to check the answer is this corroect or not? here is a question Januaay 207 o vin Cash Balance Budget Add seeccips Collection
i want to check the answer is this corroect or not?
Januaay 207 o vin Cash Balance Budget Add seeccips Collection Louorn custormers 02X526c00o /0 K3749o00 95 x5211000 a7 Totel Avatalle for meedls (as aoeduct Dishrrsements mershandise Pas 885211000) 4585680 Sala nieg& Pringe sengpits C1368 o00p) 114 o00 Adver tising (4860002 Property OTaxes (410o00 4) Dhers(90198012) f807,000 aere 105200 9 74400 4429350 4908950 $ 571595 0 44000 /62 500 75/65 7RO00 B4917345 in e fayment dividenols ic 5710taptsbrsmant Mininuu Casl bal desla ed CUTOTA/ cosh bel disicel Cosh erces Cor) pinanc (at begini 200000 ShELILn 998605 998605 Repagonkht Caf d7Tatal ets of finauing 999605 Oosh Balemrce Pauding a b-td 4$1797210 bala. end Shaw and MacDonald Corporation (S & M Corp.) present the following data to you: December 31, 2029, cash balance is $807,000. November sales were $5,260,000 and December sales were $3,744,000. Budgeted sales for the first quarter of 2030 are: Month January February March Sales $5,211,000 $4,500,000 $2,180,000 S & M Corp. has a fiscal year that follows the calendar year. Collections from customers are expected to be 85 % in the month of sale, 10% in the month after the sale, and 2 % in the second month after the sale. S & M Corp. expects 3 % of sales in any month will never be collected, explaining why, 85 % + 10 % + 2 % does not equal 100 %. Merchandise purchases expected to be paid in cash, in each of: January, February, and March, are anticipated to be equal to 82 % of that month's budgeted sales. General and administrative expenses are projected to be $5,713,996 in total, for 2030 fiscal year. The breakdown of these expenses (for the 2030 fiscal year) is presented below. All expenditures are paid evenly (uniformly) throughout the fiscal year 2030, except the property taxes, which are also, paid uniformly for each of the four quarters, but are paid at the end of each quarter. Fiscal Year 2030-Forecasted General & Admin. Costs Salaries & Fringe Benefits $1,368,000 $1,521,600 $432,000 $1,602,396 $790,000 $5.713,996 Advertising Property Taxes Other Depreciation Cash dividends to be paid in January, $78,000. purchase a company delivery vehicle for a cash price of $ 1 20,000 in February Plans are to S &M Corp. desires to keep a minimum cash balance of $200,000, and has the ability to borrow amounts necessary to maintain this balance. Assume that borrowings take place at the beginning of the month, and repayments occur at the end of a month when there is sufficient cash to repay. Interest on borrowed money will be ignored. Required: Prepare a cash budget for January 2030. Itemize all disbursements in the cash budget here is a question
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started