N19 K M D G E B A 1 Question 5 Multiple Choice (20 Marks) - 2 Marks for Each Question 2 3 ** Please only enter your response in the blue cell (in column G). This is the only cell that will be marked. 4 1 In July, Sun Co has Total Cash Available of $100,000. The Total Cash Payments are $120,000. Sun Co has a minimum required balance of $25,000. How much will Sun Co be required to borrow? 5 a Cash balance, beg Cash Collections b 9 d $20,000 $45,000 $0 $5,000 In August, Sun Co has Total Cash Available of $200,000. The Total Cash Payments are $140,000. Sun Co has a minimum required balance of $25,000. Sun Co owes $300,000 on a loan. How much of the loan can they repay? 2. 10 Total available cash Cash Payments a 11 12 $35,000 13 b $60,000 14 $0 15 d $200,000 16 Use the following information to answer questions 3, 4, and 5: 17 Total cash payments Excess (deficiency) of available cash over cash disbursements 18 Your company has reported the following monthly sales: 19 N19 B D E F H 16 Use the following information to answer questions 3, 4, and 5: 18 Your company has reported the following monthly sales: 19 Total cash payments Excess (deficiency) of available cash over cash disbursements Financing Borrowing Repayments Total Financing Cash balance, ending a 20 September $185,000 21 October $150,000 22 November $110,000 23 December $100,000 24 25 20% of the sales are on credit, the remainder are cash sales. 26 35% of the credit sales are collected in the month of the sale. 65% are collected the following month. 27 28 3 The amount of cash sales for October are: 29 $148,000 30 $120,000 31 Ic $88,000 32 d $80,000 33 4 The amount of credit sales for November are: 34 a $37,000 35 b $30,000 36 $22,000 37 d $20,000 38 5 Assume September credit sales are $37,000. The amount of these sales that will be collected in October is: N19 JA A 29 30 b 31 C 32d 33 4 34 a 35 b 36 C 37 d 38 5 39 a B C D E G $148,000 $120,000 $88,000 $80,000 The amount of credit sales for November are: $37,000 $30,000 $22,000 $20,000 Assume September credit sales are $37,000. The amount of these sales that will be collected in October is: $10,500 $12,950 $37,000 $24,050 Phone Co is introducing a new smartphone cover to the market. Total Investment $ 2,000,000 Desired Return 25% Selling Price S 20.00 Expected Demand 250,000 Units 40 ib 41 C 42 d 43 6 44 45 46 47 48 wmwws 8 49 50 la 51 b 52 C The Target Cost is: $20.00 $2.00 $22.00 $18.00 53 d 5 Formulas D E B A 17 The Variable Cost per unit is $42. The Fixed Cost per unit is $1.00. The Desired ROI per Unit is $10. The Markup % using Variable Costing is closest to: la 16 d 18 la 1b 26% 30% 29% 24% The markup up % is 25% on Absorption (product) Costs. The Absorption Cost per unit is $38. The selling price based on Absorption Cost is closest to: $40.00 $9.50 $38.00 + $47.50 The following information is available for the July Cash budget: Beginning Balance $5,000 Cash Collections $215,000 Cash Payments $202,000 Assume no borrowing or repayments were made in July Ic 3 d + 9 5 6 7 8 9 TO 71 Ja 7 b 73c What is the August 1st beginning cash balance? Cannot be determined $5,000 $18,000 $13,000 74 d Thanks for using office! We've made some updates to the privacy settings to give you more control your organization's admin allows you to use several c tional cloud-backed services are provided to you under the Microsoft Services Agreement. 19 fx Learn more E G A 61 b 62 lc 63 d 64 19 65 66 67 68 B D $9.50 $38.00 $47.50 The following information is available for the July Cash budget: Beginning Balance $5,000 Cash Collections $215,000 Cash Payments $ 202,000 Assume no borrowing or repayments were made in July. 69 4 70 What is the August 1st beginning cash balance? 71 a Cannot be determined 72 lb $5,000 73 lc $18,000 74 d $13,000 75 10 76 Pemco Ltd is going to sell a piece of equipment for $9,000 cash. How would this be shown? 77 Ja Cash Budget - $9,000 increase to cash. (collection) 78 [b Cash Budget - $9,000 decrease to cash. (payment) 79 c Cash Budget - $9,000 increase the financing section. (borrowings) 80 d This would not be included in the cash budget. 87 82 83 84 85 Cover Sheet Q1 Q2 03 Q4 Q5 Formulas + Calculation Mode: Automatic Workbook Statistics GA