Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 Check my work During the week al Augs, Oride Campany's proches the bank for $104,400 llamado con September 2 and repaid on November 30
1 Check my work During the week al Augs, Oride Campany's proches the bank for $104,400 llamado con September 2 and repaid on November 30 with annual interest of 4%, for an interest.cost of $3,540. The owner plans to increase the store's inventory by $60.000 during September and reeds the can to pay for inventory acquisitors the tarkku affiches mer informon bout Crick's ability as they werk was formed the ster's November 30 cash pastion. On September 1, Oncida is erpected to have a $4.500 cash balance $89,900 of net accounts receivablc. and SICO.000 of sccunts payable. Its budgeted sales.merchandise purchases, and various Cushyant forth the marih follow. Rodgeted Figures feptember October November Salus $230,000 $46,00 $40,000 Merchandise parehases 230,000 215,000 191,00 Cun peynt Payroll 19,300 22,150 24,100 Sent 9,000 9,000 9,000 Dt. He cash expenses 34,900 3.000 2., 600 Bepayment of bank Loan 104,000 IXLQEest on the bank loan 1,640 Operating in Auszus; Augu HTH $70,000 and purch www $700.000 The budgeted September merchandise purchases rude the mentory Increase. Al sales pre on account The many preditthul 23% of cut lex i bollecind in the march of the 47% in mouth Ilowing the 12% in the second month.7% in the third, and the remainder is uncollecible Asplying these perces so the August credit So, for example, chons that $79.900 of the $70.000 wll be collected in September. $32.300 in October, ond $11.900 in Neuber Alarchi purch on credit of the balance in the month following Durchase and the remaining 2016 aid in the second march For example, the $100.000 August auch $90.000 wilt paid in September and $20.000 n October Required: Prepare a cash budget for September October, and November. Complete this question by entering your answers in the tabs below. Calculat. Cach ... Budget Prepare the calculaton of cash receipts from sales and calculation of cash payments for merchandise Calculation of cash receipts from sales November -Collected in 130. Tala! Sales Uncollati August Septemb October Novemba Accounts Rec. Credil sales from AUGUS: 170.000 September 230,000 October 465,000 Novemba 480,000 S TO 1345,000 Calculation of cash payments for merchandise Carbon Check my work bank loan 3,640 Operation began ing; Aug WH $170.000 pund We $100 000 The budgeted September merchandisc purchases hclude the incntory Increasc. Al sacs are on account. The comery predicts that 23% of crudelesi ile in the marrih of the 47% in the more following the sale, 18% 19% in the second month, in the third, and the remainder la collection. Apaying the percent the Austedt sacs, for example, chons that $79.900 of the $170,000 will be collected in September, 532,300 h October and $100 in November. Al merchandises purchased on recit: 80% of the place is pole in the month follow ng . arch, and the many 20% din cand man For Himple of Sicoon Auth $80,000 wilbe paid in September and $20,000 in October Required: Prepare a cash budget for September October, and November Complete this question by entering your answers in the tabs below Cash Calculat Budget Prepare the calculation of cash receipts from sales and calculation of cash payments for merchandise Calculation of cash receipts from sales .............-Collected in --- . November SD Total Sales Uncollecti August Septemb October November Accounts Res cradisala from AUGUST 170,000 September 20,000 October 405,000 ILI Novembet 480,000 $ Totals S 1.345.000 Calculation of cash payments for marchandise .___._..Paid in November SD. Total Purchase August Septemb October November Accounts Pay Purchases TOM $ AUGUST 100.000 September 290,000 215.000 Novembet 199,000 S Totals 700.000 Calculation Cash Budget > 1 Check my work During the week al Augs, Oride Campany's proches the bank for $104,400 llamado con September 2 and repaid on November 30 with annual interest of 4%, for an interest.cost of $3,540. The owner plans to increase the store's inventory by $60.000 during September and reeds the can to pay for inventory acquisitors the tarkku affiches mer informon bout Crick's ability as they werk was formed the ster's November 30 cash pastion. On September 1, Oncida is erpected to have a $4.500 cash balance $89,900 of net accounts receivablc. and SICO.000 of sccunts payable. Its budgeted sales.merchandise purchases, and various Cushyant forth the marih follow. Rodgeted Figures feptember October November Salus $230,000 $46,00 $40,000 Merchandise parehases 230,000 215,000 191,00 Cun peynt Payroll 19,300 22,150 24,100 Sent 9,000 9,000 9,000 Dt. He cash expenses 34,900 3.000 2., 600 Bepayment of bank Loan 104,000 IXLQEest on the bank loan 1,640 Operating in Auszus; Augu HTH $70,000 and purch www $700.000 The budgeted September merchandise purchases rude the mentory Increase. Al sales pre on account The many preditthul 23% of cut lex i bollecind in the march of the 47% in mouth Ilowing the 12% in the second month.7% in the third, and the remainder is uncollecible Asplying these perces so the August credit So, for example, chons that $79.900 of the $70.000 wll be collected in September. $32.300 in October, ond $11.900 in Neuber Alarchi purch on credit of the balance in the month following Durchase and the remaining 2016 aid in the second march For example, the $100.000 August auch $90.000 wilt paid in September and $20.000 n October Required: Prepare a cash budget for September October, and November. Complete this question by entering your answers in the tabs below. Calculat. Cach ... Budget Prepare the calculaton of cash receipts from sales and calculation of cash payments for merchandise Calculation of cash receipts from sales November -Collected in 130. Tala! Sales Uncollati August Septemb October Novemba Accounts Rec. Credil sales from AUGUS: 170.000 September 230,000 October 465,000 Novemba 480,000 S TO 1345,000 Calculation of cash payments for merchandise Carbon Check my work bank loan 3,640 Operation began ing; Aug WH $170.000 pund We $100 000 The budgeted September merchandisc purchases hclude the incntory Increasc. Al sacs are on account. The comery predicts that 23% of crudelesi ile in the marrih of the 47% in the more following the sale, 18% 19% in the second month, in the third, and the remainder la collection. Apaying the percent the Austedt sacs, for example, chons that $79.900 of the $170,000 will be collected in September, 532,300 h October and $100 in November. Al merchandises purchased on recit: 80% of the place is pole in the month follow ng . arch, and the many 20% din cand man For Himple of Sicoon Auth $80,000 wilbe paid in September and $20,000 in October Required: Prepare a cash budget for September October, and November Complete this question by entering your answers in the tabs below Cash Calculat Budget Prepare the calculation of cash receipts from sales and calculation of cash payments for merchandise Calculation of cash receipts from sales .............-Collected in --- . November SD Total Sales Uncollecti August Septemb October November Accounts Res cradisala from AUGUST 170,000 September 20,000 October 405,000 ILI Novembet 480,000 $ Totals S 1.345.000 Calculation of cash payments for marchandise .___._..Paid in November SD. Total Purchase August Septemb October November Accounts Pay Purchases TOM $ AUGUST 100.000 September 290,000 215.000 Novembet 199,000 S Totals 700.000 Calculation Cash Budget >
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