Question 3 (Mandatory) (4 points) Company :Inventory Turnover : Receivables turnover Quick ratio Net Profit Margin Debt to Equity ratio A 6 12 2 5% 4 B 7 13 1.5 12% 2 C 8 14 3 7% 12 D 9 15 1.2 20% 45 According to above data, which company is the most profitable? OA OB Oc ODThe following link displays the cash budgeting table for a company. What number should be placed in the value of Z? () $2110 () $4500 () $765 () $3290 Question 12 (Mandatory) (4 points) The following link displays the cash budgeting table for a company. What number should be placed in the value of T? () $2200 () ($700) () $2303.75 () $3200 J22 olol~voalslon s o Re s 2o 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Q Menus & @~ 100% - Viewonly - iz A B c D E F G H 1 B K L M Imagine a company has the following sales and payments over the course of a year. It also collects all its credit sales in 60 days meaning with a two month lag. The company initially has $8000 in its accounts and its desirable monthly cash holdings is $5000 at all times. Construct the firm's Cash Budget Table. January February March April May June July August September October November December Anticipated Sales $ 3,000.00 $6,000.00 $7,000.00 $8,000.00 $15,000.00 $14,000.00 $25,000.00 $40,000.00 $20,000.00 $12,000.00 $10,000.00 $ 5,000.00 Cash Sales $ 1,200.00 $2,400.00 $2,800.00 $3,200.00 $6,000.00 $ 5,600.00 $10,000.00 $16,000.00 $ 8000.00 $ 4,800.00 $ 4,000.00 $ 2,000.00 Credit Sales $ 1,800.00 $3,600.00 $4,200.00 $4,800.00 $9,000.00 $ 8,400.00 $15,000.00 $24,000.00 $12,000.00 $ 7,200.00 $ 6,000.00 $ 3,000.00 Accounts Collected two month lag) 0 0 $1,800.00 $3,600.00 $4,200.00 $ 4,800.00 $ 9,000.00 $ 8400.00 $15,000.00 $24,000.00 $12,000.00 $ 7,200.00 Total Cash receipts $ 1,200.00 $2,400.00 $4,600.00 $6,800.00 $10,200.00 $10,400.00 $19,000.00 $24,400.00 $23,000.00 $28,800.00 $16,000.00 $ 9,200.00 Variable Cash Disbursements $ 1,200.00 $1,600.00 $3,967.38 $3,800.00 $6,500.00 $11,483.75 $12,000.00 $20,000.00 $24,390.00 $ 7,500.00 $ 4,500.00 $ 5,396.25 Fixed Cash Disbursements $ 1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 Total Cash Disbursements $ 2,700.00 $3,100.00 $5,467.38 $5,300.00 $8,000.00 $12,983.75 $13,500.00 $21,500.00 $25,890.00 $ 9,000.00 $ 6,000.00 $ 6,896.25 Cash position for the month $ (1,500.00) $(700.00) $ (867.38) $1,500.00 X $(2,583.75) $ 5,500.00 $ 2,900.00 $ (2,890.00) $19,800.00 $10,000.00 $ 2,303.75 beginning Cash $ 8,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $ 500000 $ 5000.00 $ 500000 $ 5000.00 $ 500000 $ 500000 $ 5,000.00 Cash at the end of the month $ 6,500.00 $4,300.00 $4,132.63 $6,500.00 $7,200.00 $ 2,416.25 $10,500.00 $ 7,900.00 $24,800.00 $15,000.00 $ 7,303.75 Less desired Level of Cash $ 5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $ 500000 $ 5000.00 $ 5000.00 $ 5000.00 $ 500000 $ 500000 $ 5,000.00 Cumulative Excess (or shortage) of cash - BOTTOMLINE $ 1,500.00 Y $ (867.38) $1,500.00 $2,200.00 $ (2,583.75) $ 5,500.00 $ 2,900.00 $ (2,890.00) $19,800.00 $10,000.00 T Operating Profit $ 38,662.63 Total Sales $ 165,000.00 Operating Profit Margin A = QUESTION ~