Help Save Exit Subs Problem 13-63 & Problem 13-64 (Algo) (LO 13-5, 6, 7, 9) The following information applies to the questions displayed below) Jeremy Slacker started the Del Fuego Surf Shop on January 1 after determining that business school classes conflicted with his preferred activity He invested $70,000 in the shop-563,400 of his own savings and $35.000 borrowed from an acquaintance. The loan is to be repaid in 5 year. Jeremy will pay the lender annual interest at a rate of 8 percent Shortly after opening, Jeremy realized that he is not the best hancial planner and has come to you for help with some prodding, you are able to establish that Jeremy plans to sell only two models of surfboard, the Zuma and the Coronado for at least the first year Data on the boards are given as follows. Coronado Expected annual sales (units) tail price (per unit) Purchase cont (per unit) 960 480 3750 $450 380 Additional information on the planned operations for the year includes the following 1 Equipment costing $60,000 was purchased for cash when the store opened. The equipment will be depreciated over five years using straight line depreciation 2. Because of the fantastic weather in Del Fuego, Jeremy expects sales to occur uniformly over the year Sales will Help Save & Exit Summit 3 "Additional Information on the planned operations for the year includes the following 1 Equipment costing $60,000 was purchased for cash when the store opened. The equipment will be depreciated over five years using straight-line depreciation 2. Because at the fantastic weather in Det Fuego. Jeremy expects sales to occur uniformly over the year. Sales will be both for cash (60 percent) and on account (40 percent). Sales on account are assumed to be collected in two months 3. Jeremy will maintain inventory equal to one-half of a month's sales. All boards will be purchased from the manufacturer on credit with payment made one month after purchase 4. Annual cash selling, general, and administrative expenses are $12.900 fluced plus 10 percent of revenues 5. Jeremy's tax rate is 40 percent Problem 13-64 (Algo) Cash Budgets and Sensitivity Analysis in a Retail Firm (LO 13-5, 6, 7, 9) Required: a. Prepare a cash budget for the year b. Jeremy wants to ensure that he has cash on hand at the end of the year equal to 150 percent of the current accounts payable balance on December 31 Will he meet that requirement? c. Consider only the assumption about the percentage of sales that will be made on account (currently 40 percent. What percentage would exactly achieve the goal set by Jeremy in requirement ? Required A Required B Required Prepare a cash budget for the year. Del Fuego Surf Shop Cash Budget For the Year Cash balance beginning of the year Receipts 0 Total receipts Lass disbursements 13 Total receipts Less disbursements 0 8 eBook Roberences Total disbursements Net cash flow 0 0 Regu Required B > - Required information 3 Complete this question by entering your answers in the tabs below. Required A Required B Required Jeremiy wants to ensure that he has cash on hand at the end of the year equal to 150 percent of the current accounts payable balance on December 31. Will he meet that requirement? Yes ONO required information Complete this question by entering your answers in the tabs below. Required a Required B Required Consider only the assumption about the percentage of sales that will be made on account (currently 40 percent). What percentage would exactly achieve the goal set by Jeremy in requirement (b)? (Round your answer to 1 decimal place) Help Save & Exit Summit 3 "Additional Information on the planned operations for the year includes the following 1 Equipment costing $60,000 was purchased for cash when the store opened. The equipment will be depreciated over five years using straight-line depreciation 2. Because at the fantastic weather in Det Fuego. Jeremy expects sales to occur uniformly over the year. Sales will be both for cash (60 percent) and on account (40 percent). Sales on account are assumed to be collected in two months 3. Jeremy will maintain inventory equal to one-half of a month's sales. All boards will be purchased from the manufacturer on credit with payment made one month after purchase 4. Annual cash selling, general, and administrative expenses are $12.900 fluced plus 10 percent of revenues 5. Jeremy's tax rate is 40 percent Problem 13-64 (Algo) Cash Budgets and Sensitivity Analysis in a Retail Firm (LO 13-5, 6, 7, 9) Required: a. Prepare a cash budget for the year b. Jeremy wants to ensure that he has cash on hand at the end of the year equal to 150 percent of the current accounts payable balance on December 31 Will he meet that requirement? c. Consider only the assumption about the percentage of sales that will be made on account (currently 40 percent. What percentage would exactly achieve the goal set by Jeremy in requirement ? Required A Required B Required Prepare a cash budget for the year. Del Fuego Surf Shop Cash Budget For the Year Cash balance beginning of the year Receipts 0 Total receipts Lass disbursements 13 Total receipts Less disbursements 0 8 eBook Roberences Total disbursements Net cash flow 0 0 Regu Required B > - Required information 3 Complete this question by entering your answers in the tabs below. Required A Required B Required Jeremiy wants to ensure that he has cash on hand at the end of the year equal to 150 percent of the current accounts payable balance on December 31. Will he meet that requirement? Yes ONO required information Complete this question by entering your answers in the tabs below. Required a Required B Required Consider only the assumption about the percentage of sales that will be made on account (currently 40 percent). What percentage would exactly achieve the goal set by Jeremy in requirement (b)? (Round your answer to 1 decimal place)