Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Those pictures should be in order sorry if not ADDITIONAL INFORMATION: Sales are budgeted at $360,000 for November, $385,000 for December, and $390,000 for January.
Those pictures should be in order sorry if not
ADDITIONAL INFORMATION: Sales are budgeted at $360,000 for November, $385,000 for December, and $390,000 for January. Collections are expected to be 70% in the month of sale, 25% in the month following the sale, and 5% uncollectible. Prepare a Schedule of Expected Cash Collections for November and December. \begin{tabular}{|l|l|l|l|} \hline & November & December & Jamuary \\ \hline Budgeted Siles & & & \\ \hline & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline Schedule of Expected Cash Collections & November & December \\ \hline & & \\ \hline Accounts Receivable & & \\ \hline November Sales & & \\ \hline December Sales & & \\ \hline Total Cash Collections (Receipts) & & \\ \hline \end{tabular} ADDITIONAL INFORMATION The cost of goods sold is 60% of snies The cumpamy desires an ending merchandise inventury equal to 60% af the cast of goads solat in the follawing manth. Prepare a Merchandise Purchases Budget for Noremlier and December. ADDITIONAL INFORYLTION Merctiandising lnventory is purchased on credit (Aocounts l'ayable) 100\% Paymet for necchandise is made ia tbe mooth following the purchase. Other montbly expenses to be paid in eash are 323,000 for Novenuber and 325,00 for December The company desires a mininum cnsh balanes of 5100,000 each month. It will finnoce or borow short term only if the minimum balance is not maintnined ench mobth. There is no interest awed or paid in Novemher and Decermber. In December the company aill repay its only Nate trom the Bank (Vates Payableiaf S100,00n. Calculate Total Cash Disbursemeuta belon: \begin{tabular}{|l|l|l|} \hline & November & December \\ \hline Cosh disbursemeots for merclondise & & \\ \hline Orher monthly ensh expenses & & \\ \hline Tatal Cash aisbursements & & \\ \hline \end{tabular} Prepare Cash Budgets for November and December. Beginniag cast balabce Add cash recipts Tornl cash nvailable Less cash dishurxements Excess (deliciency) of cash availahle over disiturements Yimanciag Bouowing - vote Repaymeats - note Interest Total Financing ADDITIONAL INFOIRLLTION 4. dantblu danmaintian in can han Instructions Master Budget + Ready PR Accessitsility: Gaad to go ADDITIONAL INFORMATION Wonthly depreciation is 530,000 . Assume Zens taxes ar simplifying assumptist. lrepare Budgeted Incomie Statements for Vovember and December l'repare a Budgeted Balance Slieet for the end of DecemberStep 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