26 - Short-Term Finance and Planning
26 - Short-Term Finance and Planning
26 - Short-Term Finance and Planning
b. Q1 Q2 Q3 Q4 1/3
Beginning receivables $335.00 $453.33 $513.33 $500.00
Sales $680 $770 $750 $920
Cash collections -$561.67 -$710.00 -$763.33 -$806.67
Ending receivables $453.33 $513.33 $500.00 $613.33
c. Q1 Q2 Q3 Q4 2/3
Beginning receivables $335.00 $226.67 $256.67 $250.00
Sales $680 $770 $750 $920
Cash collections -$788.33 -$740.00 -$756.67 -$863.33
Ending receivables $226.67 $256.67 $250.00 $306.67
Item Beginning Ending
Inventory $12,435 $15,615
Accounts receivable $6,120 $6,287
Accounts payable $7,930 $9,140
Net sales $143,187
Cost of goods sold $79,218
Q1 Q2 Q3 Q4
Beginning receivables $71.00 $85.00 $92.50 $100.00 1/2
Sales $170.00 $185.00 $200.00 $225.00
Collection of accounts D $156.00 $177.50 $192.50 $212.50
Ending receivables $85.00 $92.50 $100.00 $112.50
Payment of accounts C $80.55 $87.30 $96.75 $89.10
Wages, taxes, and expenses $42.50 $46.25 $50.00 $56.25
Capital expenditures $85.00
Interest & dividends $14.00 $14.00 $14.00 $14.00
Total cash disbursements $137.05 $232.55 $160.75 $159.35
Total cash collections $156.00 $177.50 $192.50 $212.50
Total cash disbursements $137.05 $232.55 $160.75 $159.35
Net cash inflow $18.95 ($55.05) $31.75 $53.15
WILDCAT, INC.
Cash Budget (in millions)
Q1 Q2 Q3 Q4
Beginning cash balance $54.00 $72.95 $17.90 $49.65
Net cash inflow $18.95 ($55.05) $31.75 $53.15
Ending cash balance $72.95 $17.90 $49.65 $102.80
Minimum cash balance ($30.00) ($30.00) ($30.00) ($30.00)
Cumulative surplus (deficit) $42.95 ($12.10) $19.65 $72.80
WILDCAT, INC.
b.
Short-Term Financial Plan (in millions)
Q1 Q2 Q3 Q4
Beginning cash balance $30.00 $30.00 $30.00 $30.00
Net cash inflow $18.95 ($55.05) $31.75 $53.15
New short-term investments ($19.43) $0.00 ($20.68) ($53.56)
Income on short-term investments $0.48 $0.87 $0.00 $0.41
Short-term investments sold $0.00 $43.43 $0.00 $0.00
New short-term borrowing $0.00 $10.75 $0.00 $0.00
Interest on short-term borrowing $0.00 $0.00 ($0.32) $0.00
Short-term borrowing repaid $0.00 $0.00 ($10.75) $0.00
Ending cash balance $30.00 $30.00 $30.00 $30.00
Minimum cash balance ($30.00) ($30.00) ($30.00) ($30.00)
Cumulative surplus (deficit) $0.00 $0.00 $0.00 $0.00
Beginning short-term investments $24.00 $43.43 $0.00 $20.68
Ending short-term investments $43.43 $0.00 $20.68 $74.24
Beginning short-term debt $0.00 $0.00 $10.75 $0.00
Ending short-term debt $0.00 $10.75 $0.00 $0.00
a.
WILDCAT, INC.
Cash Budget (in millions)
Q1 Q2 Q3 Q4
Beginning cash balance $54.00 $72.95 $17.90 $49.65
Net cash inflow $18.95 ($55.05) $31.75 $53.15
Ending cash balance $72.95 $17.90 $49.65 $102.80
Minimum cash balance ($40.00) ($40.00) ($40.00) ($40.00)
Cumulative surplus (deficit) $32.95 ($22.10) $9.65 $62.80
WILDCAT, INC.
Short-Term Financial Plan (in millions)
Q1 Q2 Q3 Q4
Beginning cash balance $40.00 $40.00 $40.00 $40.00
Net cash inflow $18.95 ($55.05) $31.75 $53.15
New short-term investments ($19.23) $0.00 $0.00 ($63.41)
Income on short-term investments $0.28 $0.66 $0.00 $0.00
Short-term investments sold $0.00 $33.23 $0.00 $0.00
New short-term borrowing $0.00 $21.16 $0.00 $0.00
Interest on short-term borrowing $0.00 $0.00 ($0.63) $0.30
Short-term borrowing repaid $0.00 $0.00 ($31.12) $9.96
Ending cash balance $40.00 $40.00 $40.00 $40.00
Minimum cash balance ($40.00) ($40.00) ($40.00) ($40.00)
b.
WILDCAT, INC.
Cash Budget (in millions)
Q1 Q2 Q3 Q4
Beginning cash balance $54.00 $72.95 $17.90 $49.65
Net cash inflow $18.95 ($55.05) $31.75 $53.15
Ending cash balance $72.95 $17.90 $49.65 $102.80
Minimum cash balance ($20.00) ($20.00) ($20.00) ($20.00)
Cumulative surplus (deficit) $52.95 ($2.10) $29.65 $82.80
WILDCAT, INC.
Short-Term Financial Plan (in millions)
Q1 Q2 Q3 Q4
Beginning cash balance $20.00 $20.00 $20.00 $20.00
Net cash inflow $18.95 ($55.05) $31.75 $53.15
New short-term investments ($19.63) $0.00 ($31.74) ($53.78)
Income on short-term investments $0.68 $1.07 ($0.01) $0.63
Short-term investments sold $0.00 $53.98 $0.00 $0.00
New short-term borrowing $0.00 $0.00 $0.00 $0.00
Interest on short-term borrowing $0.00 $0.00 $0.00 $0.00
Short-term borrowing repaid $0.00 $0.00 $0.00 $0.00
Ending cash balance $20.00 $20.00 $20.00 $20.00
Minimum cash balance ($20.00) ($20.00) ($20.00) ($20.00)
$85 mil
mil
3/5 2/5
The company currently has a cash balance of - $210,000
it plans to purchase new machinery in the third quarter at a cos $390,000
Adam wants to maintain a minimum cash bala $135,000
You’re projecting that sales will be --------------- 8% higher in each quarter next year.
Sales for the first quarter of the following year are also expected to grow at -------- 8%
Keafer currently has an accounts receivable p 57 days
Accounts receivable balance of ------------------- $675,000
Orders supplies each quarter ---------------------- 50% of the next quarter’s projected gross sales and suppliers are paid in
Wages, taxes, and other costs run about-------- 25% of gross sales.
The company has a quarterly interest payment $185,000 on its long-term debt.
Q1 Q2 Q3 Q4
Gross sales $1,102,000 $1,141,000 $1,125,000 $1,063,000
Sales next year $1,190,160 $1,232,280 $1,215,000 $1,148,040
Sales following year $1,285,373
Cash Flow
Q1 Q2 Q3 Q4
Collections from previous quarter $607,500.00 $753,768.00 $780,444.00 $769,500.00
Collections from current quarter sales 436,392.00 451,836.00 445,500.00 420,948.00
Payments to suppliers for previous quarter -350,436.00 -362,838.00 -357,750.00 -338,034.00
Cash Balance
Q1 Q2 Q3 Q4
Beginning cash balance $210,000.00 $167,614.00 $267,560.00 $21,018.00
Net cash inflow ($42,386.00) $99,946.00 ($246,542.00) $116,188.48
Ending cash balance $167,614.00 $267,560.00 $21,018.00 $137,206.48
Minimum cash balance $135,000 $135,000 $135,000 $135,000
Cumulative surplus –deficit $32,614.00 $132,560.00 -$113,982.00 $2,206.48
Cash Balance
Q1 Q2 Q3 Q4
Beginning cash balance $210,000.00 $167,614.00 $267,560.00 $21,018.00
Net cash inflow ($42,386.00) $99,946.00 ($246,542.00) $116,188.48
Ending cash balance $167,614.00 $267,560.00 $21,018.00 $137,206.48
Minimum cash balance $90,000 $90,000 $90,000 $90,000
Cumulative surplus –deficit $77,614.00 $177,560.00 -$68,982.00 $47,206.48
Q1 Q2 Q3 Q4
Gross sales $1,102,000 $1,141,000 $1,125,000 $1,063,000
Sales next year $1,223,220 $1,266,510 $1,248,750 $1,179,930
Sales following year $1,357,774
Cash Flow
Q1 Q2 Q3 Q4
Collections from previous quarter $607,500.00 $774,706.00 $802,123.00 $790,875.00
Collections from current quarter sales 448,514.00 464,387.00 457,875.00 432,641.00
Payments to suppliers for previous quarter -360,170.33 -372,916.83 -367,687.50 -347,423.83
Payments to suppliers for current quarter -260,338.17 -256,687.50 -242,541.17 -279,098.03
Expenses ($305,805.00) ($316,627.50) ($312,187.50) ($294,982.50)
Dividends and interest ($185,000) ($185,000) ($185,000) ($185,000)
Outlay ($390,000)
Net cash flow ($55,299.50) $107,861.17 ($237,418.17) $117,011.64
Cash Balance
Q1 Q2 Q3 Q4
Beginning cash balance $210,000.00 $154,700.50 $262,561.67 $25,143.50
Net cash inflow ($55,299.50) $107,861.17 ($237,418.17) $117,011.64
Ending cash balance $154,700.50 $262,561.67 $25,143.50 $142,155.14
Minimum cash balance $135,000 $135,000 $135,000 $135,000
Cumulative surplus –deficit $19,700.50 $127,561.67 -$109,856.50 $7,155.14
Q1 Q2 Q3 Q4
Gross sales $1,102,000 $1,141,000 $1,125,000 $1,063,000
Sales next year $1,157,100 $1,198,050 $1,181,250 $1,116,150
Sales following year $1,214,955
Cash Flow
Q1 Q2 Q3 Q4
Collections from previous quarter $607,500.00 $732,830.00 $758,765.00 $748,125.00
Collections from current quarter sales 424,270.00 439,285.00 433,125.00 409,255.00
Payments to suppliers for previous quarter -340,701.67 -352,759.17 -347,812.50 -328,644.17
Payments to suppliers for current quarter -246,265.83 -242,812.50 -229,430.83 -249,740.75
Expenses ($289,275.00) ($299,512.50) ($295,312.50) ($279,037.50)
Dividends and interest ($185,000) ($185,000) ($185,000) ($185,000)
Outlay ($390,000)
Net cash flow ($29,472.50) $92,030.83 ($255,665.83) $114,957.58
Cash Balance
Q1 Q2 Q3 Q4
Beginning cash balance $210,000.00 $180,527.50 $272,558.33 $16,892.50
Net cash inflow ($29,472.50) $92,030.83 ($255,665.83) $114,957.58
Ending cash balance $180,527.50 $272,558.33 $16,892.50 $131,850.08
Minimum cash balance $135,000 $135,000 $135,000 $135,000
Cumulative surplus –deficit $45,527.50 $137,558.33 -$118,107.50 -$3,149.92
Q1 Q2 Q3 Q4
Gross sales $1,102,000 $1,141,000 $1,125,000 $1,063,000
Sales next year $1,326,330 $1,373,269 $1,354,012 $1,279,391
Sales following year $1,596,325
Cash Flow
Q1 Q2 Q3 Q4
Collections from previous quarter $607,500.00 $840,008.85 $869,736.93 $857,540.80
Collections from current quarter sales 486,320.91 503,531.91 496,470.99 469,109.92
Payments to suppliers for previous quarter -390,530.43 -404,351.38 -398,681.25 -376,709.48
Cash Balance
Q1 Q2 Q3 Q4
Beginning cash balance $210,000.00 $114,425.00 $246,972.53 $38,010.39
Net cash inflow ($95,575.00) $132,547.52 ($208,962.14) $116,960.00
Ending cash balance $114,425.00 $246,972.53 $38,010.39 $154,970.39
Minimum cash balance $135,000 $135,000 $135,000 $135,000
Cumulative surplus –deficit -$20,575.00 $111,972.53 -$96,989.61 $19,970.39
3/8
5/8