Finan 5000 Homework - Cash budgeting
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
Finan 5000
Homework - Cash budgeting
Due: Tues, Feb. 14, 2023
1. Prepare a monthly cash budget for Jones Products Inc. for the first six months of 2023
Use the following assumptions to prepare your cash budget:
Revenue estimates (in thousands):
Nov* $340 Feb $290 May $380
Dec* $380 Mar $290 Jun $420
Jan $280 Apr $320 Jul $440
* Historical
Collection on sales (all sales on credit):
Current month: 10%
First month following: 70%
Second month following: 19% (1% bad debt losses)
Purchases of raw materials:
71% of projected following month sales
Payment on purchases: 30 days following purchase of materials
Other expenses and disbursements (in thousands):
Utilities: $8/month
Wages and salaries: $45 + 2% current month’s sales
Other fixed expenses: $6/month
Interest on bonds (not LOC): $8.5 in May ($0 all other months)
Quarterly tax payments: $12/month in Mar and Jun ($0 all other months)
Equipment maintenance: $35 in Feb ($0 all other months)
Line-of-credit:
$250,000 maximum available credit
No maintenance fee
6.25% interest (annual rate, compounded monthly) on ending balance of prior month
Other:
A minimum cash balance of $60K must be maintained at the end of each month
A balance of $23K on the line-of-credit exists at the end of Dec
Quarterly dividends of $15K will be paid in Jan and Apr ($0 all other months)
Any cash in excess of $60K at the end of each month will first be used to pay down any existing balance on the LOC, then swept into money market funds. Money market funds will earn 2. 1% per annum (0. 175% per month)
2023-02-16