i need help with parts E, F, G, & H

i need help with parts E, F, G,& H

Waiton Compary is a retal company that specilizes in selling outidoor camping equpment. The compary is conaidering opening a new store on October 1 year 1 . The company president formed a plannang commitee to prepare a master budget for the first three months of operatson. As budget coordinator, you have been assigned the following tasks. Required a. October sales are estimated to be $390.000. of which 40 percent will be cash and 60 percent will be credit The compary expects sales to increase at the rate of 20 percent per month. Piepare a sales budgot. b. The company expects to collect 100 percent of the accounts receivabie generated by credit sales in the month following the sale. Prepare a schedule of cash recelpts. C. The cost of goods sold is 70 percent of salos. The company desires to maintaln a mirimum ending inveritory equal to 20 percent of the noxt month's cost of goots sold. However, ending inventory of December is expected to be $13,700. Assume that all purchases are made on account Prepare an inventory purchases budget. d. The company pays 60 percent of accounts payable in the month of purchase and the remaining 40 percent in the following month. Prepare a cash payments budget for inventory purchases. e. Budgeted selling and adiministrative expenser per month follow. -The capital expenditures budget indicates that Walton will spond $173,800 on October 1 for store fixtures. which are expected to have a $37,000 salvage value and a bwo-year (24-month) useful life. Use this information to prepare a selling and administrative expenses budget. 1. Usilites and sales commissions are paid the month aftor they are incurred; all other experses are paid in the month in which they are incurred. Prepare a cash payments budget for seling and odministrative expensec. 9. Waiton borrows funde, in increments of $1,000, and repays them on the last day of the month Repayments may be made in any amount available. The company also poys its vendors on the tast day of the month it pays interest of 2 percent per month in cash on the last day of the month. To be prudent, the company desires to mainain a 520.000 cash cushlon. Prepare a cash budget. h. Prepare a pro forma inceme statement for the quarter. i. Prepare a pro forma balance shoot at the end of the quartor. 1. Prepare a pro forme statement of cash fows for the quarter. Complete this question by entering your answers in the tabs below. Prepare a selling and administrative expenses budoere. Walton Company is a retall company that specializes in selling outdoor camping equipment. The company is considering opening a new store on October 1, year 1 . The company president formed a planning committee to prepare a master budget for the first three months of operation. As budget coordinator, you have been assigned the followng tasks. Required a. October sales are estimated to be $390.000, of which 40 percent will be cash and 60 percent will be credit. The company expects sales to increase at the rate of 20 percent per month. Prepare a sales budget. b. The company expects to collect 100 percent of the accounts recelvable generated by credit sales in the month following the sale. Prepare a schedule of cash recelpts. c. The cost of goods sold is 70 percent of sales. The compary desires to maintain a minimum ending Inventory equal to 20 percent of the next month's cost of goods sold. However, ending invertory of December is expected to be $13.700. Assume that all purchases are made on account. Prepare an imventory purchases budget. d. The company pays 60 percent of accounts payable in the month of purchase and the remaining 40 percent in the following month. Prepare a cash payments budget for inventory purchases. e. Budgeted selling and administrative expenses per morith follow. The capital expenditures budget indicates that Wahon wil spend $173,800 on October 1 for store fotures. which are expected to have a $37,000 salvage value and a two-year (24-mononh) useful If Use this information to prepare a selling and administrative expenses budget. f. Uolities and sales commissions are pald the month ather they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and adininstratve expenses. 9. Walton borrows funds. In increments of $1,000, and repays, them on the last day of the month. Repayments may be made in any amount avallable. The company also pays its vendors on the last day of the month. It pays interest of 2 percent per month in cash on the last day of the month. To be prudent the compary desires to maintain a $29,000 cash cushion. Prepare a cash budget. h. Propare a pro forma income statement for the quanter. 1. Prepare a pro forma balance sheet at the end of the quarter. 1. Prepare a pro forma statement of cash flowa for the quantes. -The capital expenditures budget Indicates that Walton will spend $173.800 on October 1 for store fixtures, which are expected to have a $37.000 salvage value and a two-year (24-month) useful life. Use this information to prepare a selling and administrative expenses budget. f. Utilties and sales commisslons are pald the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses. 9. Walton borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount avallable. The company also pays its vendors on the last day of the month. it pays interest of 2 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $29,000 cash cushion. Prepare a cash budget. h. Prepare a pro forma income statement for the quarter 1. Prepare a pro forma balance sheet at the end of the quarter. 1. Prepare a pro forma statement of cash flows for the quarter. Complete this question by entering your answers in the tabs below. Prepare a selling and administrative expenses budget. J. Prepare a pro forma statement of cash flows for the quarter. Complete this question by entering your answers in the tabs below. Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrative expenses. are incurred. Hrepare a cash payments budget tor seling and administrative expenses. 9. Walton borrows funds, In increments of $1,000, and repays them on the last day of the month. Repayments may be made amount avallable. The company also pays its vendors on the last day of the month. It pays interest of 2 percent per mont on the last day of the month. To be prudent, the company desires to malntain a $29.000 cash cushion. Prepare a cash bi h. Prepare a pro forma income statement for the quarter. 1. Prepare a pro forma balance sheet at the end of the quarter. J. Prepare a pro forma statement of cash flows for the quarter. Complete this question by entering your answers in the tabs below. Walton borrows funds, in increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount available. The company also pays its vendors on the last day of the month. It pays interest of 2 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $29,000 cash cushion. Prepare a cash budget. (Any repayments should be indicated with a minus sign.) "The capital expenditures budget indicates that Waiton will spend $173.800 on October 1 for store fixtures, which are expected to have a $37,000 salvage value and a two-year (24-month) useful life. Use this information to prepare a selling and admintstrative expenses budget. f. Utilities and sales commissions are paid the month after they are incurred; all other expenses are paid in the month in which they are incurred. Prepare a cash payments budget for selling and administrattve expenses. 9. Waiton borrows funds, in Increments of $1,000, and repays them on the last day of the month. Repayments may be made in any amount avallable. The company also pays its vendors on the last day of the month. It pays Interest of 2 percent per month in cash on the last day of the month. To be prudent, the company desires to maintain a $29,000 cash cushion. Prepare a cash budget. h. Prepare a pro forma income statement for the quarter. 1. Prepare a pro forma balance sheet at the end of the quarter. J. Prepare a pro forma statement of cash flows for the quarter. Complete this question by entering your answers in the tabs below. Prepare a pro forma income statement for the quarter