Question

In: Accounting

ptimal Cash Transfer. Barenbaum Industries projects that cash outlays of $5.4 million will occur uniformly throughout...

ptimal Cash Transfer. Barenbaum Industries projects that cash outlays of $5.4 million will occur uniformly throughout the year. Barenbaum plans to meet its cash requirements by periodically selling marketable securities form its portfolio. The firm’s marketable securities are invested to earn 6%, and the cost per transaction of converting securities to cash is $15. (5 pts)

a. Use the Baumol model to determine the optimal transaction size for transfers from marketable securities to cash.

​​​​​​b. What will be Barenbaum’s average cash balance? ​​​​​​​

c. How many transfers per year will be required?

​​​​​​​d. What will be Barenbaum’s total annual cost of maintaining cash balances?

​​​​​​​​​​​​​​e. What would the total cost be if the company maintained an average cash balance of $40,000 or of $0 (it deposits funds daily to meet cash requirements, using 360 days)?

Solutions

Expert Solution

Baumol cash management model:

Baumol noted that cash balances are very similar to inventory levels and developed a model based on the Economic Order Quantity (EOQ)

C=under root of 2*T*F/RR

Where c= optimal cash level

T= demand for cash over the entire period considered (year)    =$54,00,000

F-fixed costs of cash transfer =$15

R-alternative cost of maintaining cash =6%

This formula comes from from the fact that if the level of cash is to be optimal, then following equality must exist KA=KT, the alternative cost must equal the transaction costs . These, in tum are calculated as follows

KA=C*R/2

KT=T*F/C

Computation of C at $40000 or $0

Average cash balance =c/2

Therefore C=average cash balance *2

At 40000=$40000*2=$80000

At 0, C=0

ANS particulars formula formula substitution amount
a optimal transaction size C=under root of 2*T*F/R under root of 2*5400000*15/0.06 51961.52
b. average cash balance = C/2 51961.52/2 25980.76
c Transfers per year = T/C 5400000/51961.52 103.9231
computation of total annual cost
particulars formula ans d ans e(i) ans e(ii)
C 51961.52 80000 0
a. Annual cost of transaction KA=C*R/2 1558.846 2400 0
b. Annual alternative cost KT=T*F/C 1558.846 1012.5 NA
c, Total cost c=a+b 3117.691 3412.5

notes

assumed $5.4 million is the annual cash distribution

Annual cost at $0 there will nnot be any transaction cost or alternative cost as daily funds are deposited a and when required

also $40000 can be taken as C itself or can use $80000 as defined above


Related Solutions

Sora Industries has 65 million outstanding​ shares, $127 million in​ debt, $51 million in​ cash, and...
Sora Industries has 65 million outstanding​ shares, $127 million in​ debt, $51 million in​ cash, and the following projected free cash flow for the next four​ years: Year 0 1 2 3 4 Earnings and FCF Forecast​ ($ million) 1 Sales 433.0 468.0 516.0 547.0 574.3 2 Growth vs. Prior Year ​8.1% ​10.3% ​6.0% ​5.0% 3 Cost of Goods Sold ​(313.6) ​(345.7) ​(366.5) ​(384.8) 4 Gross Profit 154.4 170.3 180.5 189.5 5 ​Selling, General,​ & Admin. ​(93.6) ​(103.2) ​(109.4) ​(114.9)...
Sora Industries has 63 million outstanding​ shares, $126 million in​ debt, $48 million in​ cash, and...
Sora Industries has 63 million outstanding​ shares, $126 million in​ debt, $48 million in​ cash, and the following projected free cash flow for the next four​ years: Year 0 1 2 3 4 Earnings and FCF Forecast​ ($ million) 1 Sales 433.0 468.0 516.0 547.0 574.3 2 Growth vs. Prior Year ​8.1% ​10.3% ​6.0% ​5.0% 3 Cost of Goods Sold ​(313.6) ​(345.7) ​(366.5) ​(384.8) 4 Gross Profit 154.4 170.3 180.5 189.5 5 ​Selling, General,​ & Admin. ​(93.6) ​(103.2) ​(109.4) ​(114.9)...
Sora Industries has 66 million outstanding​ shares, $130 million in​ debt, $58 million in​ cash, and...
Sora Industries has 66 million outstanding​ shares, $130 million in​ debt, $58 million in​ cash, and the following projected free cash flow for the next four years Earnings Forecast & FCF Forecast ($millions) Year 0 1 2 3 4 Sales 433.0 468.0 516.0 547.0 574.3 Growth V. Prior Yr 8.1% 10.3% 6.0% 5.0% COGS (313.6) (345.7) (366.5) (384.8) Gross Profit 154.4 170.3 180.5 189.5 Selling, General & Admin. (93.6) (103.2) (109.4) (114.9) Depreciation (7.0) (7.5) (9.0) (9.5) EBIT 53.8 59.6...
Sora Industries has 65 million outstanding​ shares,$130 million in​ debt, $50 million in​ cash, and the...
Sora Industries has 65 million outstanding​ shares,$130 million in​ debt, $50 million in​ cash, and the following projected free cash flow for the next four​ years Year 0 1 2 3 4 Earnings and FCF Forecast​ ($ million) 1 Sales 433.0 468.0 516.0 547.0 574.3 2 Growth vs. Prior Year ​8.1% ​10.3% ​6.0% ​5.0% 3 Cost of Goods Sold ​(313.6) ​(345.7) ​(366.5) ​(384.8) 4 Gross Profit 154.4 170.3 180.5 189.5 5 ​Selling, General,​ & Admin. ​(93.6) ​(103.2) ​(109.4) ​(114.9) 6...
Sora Industries has 67 million outstanding shares, $128 million in debt, $55 million in cash, and...
Sora Industries has 67 million outstanding shares, $128 million in debt, $55 million in cash, and the following projected free cash flow for the next four years: Year 0 1 2 3 4 Earnings and FCF Forecast ($ million) 1 Sales 433.0 468.0 516.0 547.0 574.3 2 Growth vs. Prior Year 8.1% 10.3% 6.0% 5.0% 3 Cost of Goods Sold (313.6) (345.7) (366.5) (384.8) 4 Gross Profit 154.4 170.3 180.5 189.5 5 Selling, General, & Admin. (93.6) (103.2) (109.4) (114.9)...
Sora Industries has 63 million outstanding​ shares, $123 million in​ debt, $59 million in​ cash, and...
Sora Industries has 63 million outstanding​ shares, $123 million in​ debt, $59 million in​ cash, and the following projected free cash flow for the next four​ years: Year 0 1 2 3 4 Earnings and FCF Forecast​ ($ million) 1 Sales 433.0 468.0 516.0 547.0 574.3 2 Growth vs. Prior Year ​8.1% ​10.3% ​6.0% ​5.0% 3 Cost of Goods Sold ​(313.6) ​(345.7) ​(366.5) ​(384.8) 4 Gross Profit 154.4 170.3 180.5 189.5 5 ​Selling, General,​ & Admin. ​(93.6) ​(103.2) ​(109.4) ​(114.9)...
Sora Industries has 63 million outstanding​ shares, $ 125 million in​ debt, $50 million in​ cash,...
Sora Industries has 63 million outstanding​ shares, $ 125 million in​ debt, $50 million in​ cash, and the following projected free cash flow for the next four​ years: Year 0 1 2 3 4 Earnings and FCF Forecast​ ($ million) 1 Sales 433.0 468.0 516.0 547.0 574.3 2 Growth vs. Prior Year ​8.1% ​10.3% ​6.0% ​5.0% 3 Cost of Goods Sold ​(313.6) ​(345.7) ​(366.5) ​(384.8) 4 Gross Profit 154.4 170.3 180.5 189.5 5 ​Selling, General,​ & Admin. ​(93.6) ​(103.2) ​(109.4)...
Sora Industries has 6060 million outstanding​ shares,$122 million in​ debt, $50 million in​ cash, and the...
Sora Industries has 6060 million outstanding​ shares,$122 million in​ debt, $50 million in​ cash, and the following projected free cash flow for the next four years:   Year   0 1 2 3 4 Earning & FCF Forecast ($millions)                           1   Sales 433.0   468.0   516.0   547.0   574.3 2   Growth vs. Prior Year           8.1%   10.3% 6.0% 5.0% 3   Cost of Goods Sold (313.6)   (345.7)   (366.5)   (384.8) 4   Gross Profit 154.4   170.3   180.5   189.5 5   Selling, General...
Sora Industries has 63 million outstanding? shares, $125 million in? debt, $44 million in? cash, and...
Sora Industries has 63 million outstanding? shares, $125 million in? debt, $44 million in? cash, and the following projected free cash flow for the next four? years: Year 0 1 2 3 4 Earnings and FCF Forecast? ($ million) 1 Sales 433.0 468.0 516.0 547.0 574.3 2 Growth vs. Prior Year ?8.1% ?10.3% ?6.0% ?5.0% 3 Cost of Goods Sold ?(313.6) ?(345.7) ?(366.5) ?(384.8) 4 Gross Profit 154.4 170.3 180.5 189.5 5 ?Selling, General,? & Admin. ?(93.6) ?(103.2) ?(109.4) ?(114.9)...
Sora Industries has 60 million outstanding​ shares, $121 million in​ debt, $51 million in​ cash, and...
Sora Industries has 60 million outstanding​ shares, $121 million in​ debt, $51 million in​ cash, and the following projected free cash flow for the next four​ years: Year 0 1 2 3 4 Earnings and FCF Forecast​ ($ million) 1 Sales 433.0 468.0 516.0 547.0 574.3 2 Growth vs. Prior Year ​8.1% ​10.3% ​6.0% ​5.0% 3 Cost of Goods Sold ​(313.6) ​(345.7) ​(366.5) ​(384.8) 4 Gross Profit 154.4 170.3 180.5 189.5 5 ​Selling, General,​ & Admin. ​(93.6) ​(103.2) ​(109.4) ​(114.9)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT