1. Prepare a monthly cash budget for Jones Products Inc. for the first six months of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Dec Jan * Historical $340 $380 $280 Collection on sales (all sales on credit): Current month: Purchases of raw materials: Other: Feb Mar Apr 10% First month following: 70% Second month following: 19% (1% bad debt losses) Line-of-credit: 71% of projected following month sales Payment on purchases: Other expenses and disbursements Utilities: Wages and salaries: Other fixed expenses: Interest on bonds (not LOC): Quarterly tax payments: Equipment maintenance: $290 $290 $320 May Jun Jul 30 days following purchase of materials (in thousands): $8/month $45 + 2% current month's sales $6/month $380 $420 $440 $8.5 in May ($0 all other months) $12/month in Mar and Jun ($0 all other months) $35 in Feb ($0 all other months) $250,000 maximum available credit No maintenance fee 5.50% interest (annual rate, compounded monthly) on ending balance of prior month A minimum cash balance of $60K must be maintained at the end of each month A balance of $47K 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) 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 Dec Jan * Historical $340 $380 $280 Collection on sales (all sales on credit): Current month: Purchases of raw materials: Other: Feb Mar Apr 10% First month following: 70% Second month following: 19% (1% bad debt losses) Line-of-credit: 71% of projected following month sales Payment on purchases: Other expenses and disbursements Utilities: Wages and salaries: Other fixed expenses: Interest on bonds (not LOC): Quarterly tax payments: Equipment maintenance: $290 $290 $320 May Jun Jul 30 days following purchase of materials (in thousands): $8/month $45 + 2% current month's sales $6/month $380 $420 $440 $8.5 in May ($0 all other months) $12/month in Mar and Jun ($0 all other months) $35 in Feb ($0 all other months) $250,000 maximum available credit No maintenance fee 5.50% interest (annual rate, compounded monthly) on ending balance of prior month A minimum cash balance of $60K must be maintained at the end of each month A balance of $47K 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)
Expert Answer:
Answer rating: 100% (QA)
Taxes are charges levied by the state and federal governments on t... View the full answer
Related Book For
Financial Accounting
ISBN: 978-1259222139
9th edition
Authors: Robert Libby, Patricia Libby, Frank Hodge
Posted Date:
Students also viewed these accounting questions
-
During the current year ended December 31, Rank Company disposed of three different assets. On January I of the current year, prior to their disposal, the asset accounts reflected the following: The...
-
On a ship of 12,000 tonnes displacement with KG 9.0m, 200 tonnes of cargo was shifted from the upper deck Kg 12.0m to the lower hold, Kg 2.0m. Calculate the final KG of the ship.
-
During the current year Dunham Corporation expects to produce 10,000 units and has budgeted the following: net income $300,000; variable costs $1,100,000; and fixed costs $100,000. It has invested...
-
A factor used in measuring the loudness sensed by the human ear is (I/I 0 ), 0.3 where I is the intensity of the sound and I 0 is a reference intensity. Evaluate this factor for I = 3.2 10 6 W/m 2...
-
Explain how the independence assumption of the two-sample t-test is violated in a randomization model.
-
Let \(W\) be a \(\mathbb{P}\)-Brownian motion, and \(B_{t}=W_{t}+u t\) be a \(\mathbb{Q}\)-Brownian motion, under a suitable change of probability. Check that, in the case \(u>0\), the process...
-
For a small eco-tourism company keen to use life-cycle assessment for competitive reasons, is a streamlined life-cycle assessment, life-cycle review, matrix approach or comprehensive approach the...
-
New Millennium Company earned $2.5 million in net income last year. It took depreciation deductions of $300,000 and made new investments in working capital and fixed assets of $100,000 and $350,000,...
-
Let f(x) = 4-5x+8x2. Calculate the following values: f(a) = f(a + h) = f(a + h) - f(a) h = for h 0
-
Jane Company purchased merchandise . The following information is available: Terms: 15/10 n /60 Original purchase amount: $ 7,000 Return amount: $ 1,000 (2 days after purchase ) Payment of cash: Paid...
-
You are playing the game of Monopoly and you decide you wish to construct houses on one of your property groups. The rules of the game require that the number of houses on the properties within each...
-
In what ways do institutional theories inform our understanding of organizational legitimacy and adaptation to environmental pressures ?
-
Using the following product information, calculate the direct materials price variance and the direct materials quantity variance. Indicate whether each variance is favorable or unfavorable. Actual...
-
Describe the function and features of CPUs Identify features of popular CPUs from various manufacturers List the basic functions common to all file systems Use and describe the file systems used by...
-
ces Fleet Street Incorporated a manufacturer of high-fashion clothing for women, is located in South London in the UK. Its product line consists of trousers (35%), skirts (40%), dresses (15%), and...
-
Given: Four particles as shown below. Find: Determine x, y, and 7 of all the particles. WA = 16 lb WB = 24 lb Wc = 14 lb W = 36 lb B 3 ft 4 ft 5 ft
-
Figures on the next page show ICprotocol SCL and SDA line values. Here, a microcontroller is communicating with an MCP4725, a digital to analog converter. Decode the ICcommunication and answer...
-
What is a make-or-buy decision?
-
Refer to E3-10. E3-10 Stacey's Piano Rebuilding Company has been operating for one year. At the start of the second year, its income statement accounts had zero balances and its balance sheet account...
-
The following are the summary account balances from a recent balance sheet of Exxon Mobil Corporation. The accounts have normal debit or credit balances, but they are not necessarily listed in good...
-
On January 1, Biofuel Corporation had the following capital structure: Common stock ($0.10 par value)......................... $ 60,000 Additional paid-in capital....................................
-
The Excel formula to compute net income's percentage of sales in Exhibit 7-5, is a. \(=B 4 * B 2\) b. \(=B 4 / B 2\) c. \(=\mathrm{B} 2-\mathrm{B} 3\) d. \(=\mathrm{B} 4+\mathrm{B} 3\) EXHIBIT 7-5 A...
-
Match each component of a computerized accounting system with its meaning. Meaning Component Electronic linkages that allow different computers A. Server to share the same information Electronic...
-
Complete the crossword puzzle that follows. 2 3 4 5 6 Down: 1. Managers need over operations in order to authorize transactions and safeguard assets 3. Programs that drive a computer 4. Electronic...
Study smarter with the SolutionInn App