Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
i want to check the answer is this corroect or not?
here is a question
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions